Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Archive for the ‘MS Office Help’ Category



MS Excel: Headers & Footers Demystified

Tuesday, November 16th, 2004

MS Excel: Headers & Footers Demystified

Let’s continue on our journey through the world of headers and footers. The train stops next at the MS Excel station.

To access headers and footers in Excel, you will go to the View menu, Header and Footer choice.

The Page Setup window will open with the Header/Footer tab already selected. (You can also get to this location via the File menu, Page Setup… Continue reading

Selecting Multiple Worksheets in an MS Excel Workbook

We all know that to select one sheet you simply click on the sheet tab. The next logical question might be “How do I select several consecutive sheets at once?”

Easy enough answer. First, you’ll need to locate the worksheet tabs in order to select the ones you want.

Then, simply select the first sheet by clicking on its tab then… Continue reading

Text Highlighting Tips

Tuesday, November 16th, 2004

I’m having a hard time with my word processor. When I go to highlight a large section of text with my mouse (more than what’s currently shown on the screen), I zip right past the point where I want to stop. So, I keep my mouse button down and go back up – only to zip by my stopping point again. This can go

Have you ever been working in MS PowerPoint and wish you could select more than one of the slides at a time? Maybe you have several slides for which you’re going to set the slide transition the same? Wouldn’t it be nice to set these things all at once instead of over and over again, one slide at a time?

Of course it would, who wouldn’t want to save the… Continue reading

Paste Options?

Monday, November 15th, 2004

Paste Options?

You just completed a copy / paste in MS Word XP and you happen to notice this little button appear at the end of you pasted text.

What’s that you ask? Hmmm…

Good question.

And here’s a good answer.

The little button offers you the Paste Options.

(Now I know a few of you just had the Paste Special thing pop into your mind, but just keep… Continue reading

Next Text Please

Monday, November 15th, 2004

Next Text Please

Ever find yourself frustrated while working in MS PowerPoint as you jump back and forth between the keyboard and the mouse to move from text box to text box?

Let me clarify… you’re working on a slide with a couple of text boxes and a title box and you’re tired of jumping between the mouse and the keyboard every time you want to move to the next… Continue reading

Cut vs. Copy in MS Excel

Monday, November 15th, 2004

Cut vs. Copy in MS Excel

So we all know the difference between a cut / paste and a copy / paste.

I mean, it’s pretty obvious, one actually moves the cell contents and the other makes a duplicates.

But, did you know that there’s a difference in the way each of them treats formulas with relative cell references?

(Relative Cell References are formula references to other cells based on… Continue reading

The Word Font Window On Demand

Monday, November 15th, 2004

The Word Font Window On Demand

OK, so when working in MS Word we all know about the usual toolbar buttons and lists that allow us quick access to things like font type, size, bold, Italics, underline, color, etc.

But did you know that there are even more aspects of your fonts that can be manipulated?

There are things like character spacing and text effects to be explored along with… Continue reading

Changing Directions

Monday, November 15th, 2004

Changing Directions

Have you ever wished that you could change the direction of text? I mean literally have it read in another direction.

Maybe you want to change the look of the documents or maybe you need to maximize the space you have to work with in the horizontal direction. (Change direction, get more space… If only that would work in my living room. Change the direction of the couch… Continue reading

Click, Click — Text Formatting Trick

Monday, November 15th, 2004

Click, Click — Text Formatting Trick

Many of you may be aware of the Change Case text options in the Format menu of MS Word. This wonderful feature will allow you to take text and, in one quick swoop, change the case of every letter to match your needs.

From the Change Case options, you can make text all lower case, all upper case, sentence case, toggle case or… Continue reading

Changing Directions – Part 2 – MS Excel

Well, now that we’ve looked at the options for turning text in MS Word, let’s move on to MS Excel.

Excel allows for a lot of flex in text direction. You’re actually allowed to set the text angle as opposed to the limited choices of vertical and horizontal offered by Word.

So, let’s get started.

The first thing you need to do… Continue reading

Quick Email Sorting

Monday, November 15th, 2004

Quick Email Sorting

You’re sorting through a huge list of email, wishing you knew of a quick way to find the specific one needed.

Smile :-)

There is!

To get MS Outlook or Outlook Express to sort email all you have to do is click!

When you’re looking at your inbox do you see the column titles at the top? The ones that label the columns at From, Subject, Received… Continue reading

Add A Little Color To Your Life

Monday, November 15th, 2004

Add A Little Color To Your Life

Ok, so maybe not exactly to “your life”, but would you settle for a little color added to your Excel worksheet tabs?

Yes?

Good.

Of course I’ve got to mention one small catch… this one wasn’t in Excel 97 or 2000. It seems to be an additional feature of the newer versions.

So, anyway, here’s the deal—you can now turn this…

Into… Continue reading

The Four Direction “Zoom” Scroll

Monday, November 15th, 2004

The Four Direction “Zoom” Scroll

Tired of the scroll bars in MS Excel?

Looking for a quicker way to move through the worksheet—one that doesn’t involve you dragging around the horizontal or vertical scroll bars?

If this sounds like it might be a handy thing to know then you’re in the right place, that is, if you have a scroll wheel on your mouse.

Click down on the scroll wheel.… Continue reading

Navigation Shortcuts for MS Word

Monday, November 15th, 2004

Navigation Shortcuts for MS Word

Here’s the picture: you’re working on the ultimate document, it’s a masterpiece! Too bad the masterpiece is also a nightmare. It’s easily the longest document you’ve ever edited and the navigation through all those pages is a huge headache. (Not to mention the back and forth, back and forth between the keyboard and the mouse.) Help!

Never fear, help is on the way. While these… Continue reading

MS Excel: A Quick AutoFit Solution.

Monday, November 15th, 2004

MS Excel: A Quick AutoFit Solution.

Have you ever been working in MS Excel and found yourself spending all kinds of extra time trying to manually adjust column width or row heights? Or are you one of the many people who simply skip a column whenever text gets too long?

Well, here’s one of the many solutions to these time-consuming problems.

AutoFit.

What’s AutoFit, you ask?

Well, it’s exactly what… Continue reading

Brrrr… It’s Cold in the Freeze Pane Zone

OK, so it’s not really that cold here, but the real question is, “What’s Freeze Pane?”

Well, to answer a question with questions, have you ever been frustrated while working in an MS Excel worksheet because you were so far down the columns that you no longer could see the column titles? Did you find yourself constantly scrolling up to make sure… Continue reading

Tear It Up

Monday, November 15th, 2004

Tear It Up

Have you ever been working in an MS Office application and realized that you kept accessing the same menu or palette of choices over and over and over again?

Ever wonder if there was a way to keep the choices open for a while (or maybe permanently)?

One quick way to tell is by taking a good look at the menu or palette when you open it.… Continue reading

Say it with Pizzazz!

Monday, November 15th, 2004

Have you ever needed a quick way to really make a statement stand out on a flyer, presentation, worksheet or some other document? (You know, a way to really catch their attention.) Are you tired of the plain old text boxes in MS Excel? Want a way to make text more interesting?

Do you want to turn this…

into this?

(Sorry, beginning to sound like an infomercial… Continue reading

Toobar Sizes

Monday, November 15th, 2004

Ever find yourself squinting at the buttons on the toolbars? Wish they were bigger?

Your wish is my command… Relief is just a few clicks away.

To begin you need to go to the Tools menu, Customize choice. (Or right click over any toolbar and choose Customize from the toolbar list.)

On the Options tab you should see the Large Icons choice. Check this box. Instantly you should see the… Continue reading

Taking Control of Your Menus

Monday, November 15th, 2004

Taking Control of Your Menus

Here’s the scenario:

You’re cruising through the menus in an MS Office program (version 2000 or newer). Maybe you’ve even upgraded recently. Anyway, you’re looking for that really cool thing you did a few months ago. Unfortunately, you can’t seem to find the right menu choice and you can’t remember exactly what you did the last time.

Suddenly you realize that your menus seem to… Continue reading

Just “Cruising” Through The Day

Monday, November 15th, 2004

Just “Cruising” Through The Day

Have you ever heard anyone refer to “cruising” when working in a program?

Were you wondering what in the world they were talking about? (I’m sure you figured it out that it had nothing to do with cars.)

Well, for many people, “cruising” on the computer means to slide through the menus in a program looking at the choices listed.

There are some people who… Continue reading

Give Me A Break!

Monday, November 15th, 2004

Give Me A Break!

Since we’re all here for the same reason—to find out all about MS Word’s section breaks—I’ll get right to the “how to”.

The most obvious step is to have a Word file open that would benefit from having different sections.

Once your file is open you’ll need to place your cursor at the point where you want to create a section break.

Now use the Insert… Continue reading

Paragraphs, Pages And Now There’s Sections?

OK, so we all have experience with paragraphs and pages in MS Word… but did you know you have further options for sub-dividing your documents?

No?

Well, let me fill you in.

According to Word’s online help, Sections are “a portion of a document in which you set certain page formatting options. You create a new section when you want to change such properties… Continue reading

Breaking the Connection of Word’s Headers and Footers

Here’s the scenario: you’re working in MS Word and it’s time to set up your header or footer information.

Everything is going well except there’s one small catch. (Isn’t there just always “one small catch”?)

Anyway… the document you’re working on requires different header or footer information at different locations. (Maybe you need the first few pages numbered with Roman Numerals and… Continue reading

White Space Be Gone In Word XP

Monday, November 15th, 2004

White Space Be Gone In Word XP

If you’re like me then you like to work in MS Word using the Print Layout view.

I simply like to be able to see my whole page—margins and all. I like to keep an eye on the layout of the document without always jumping to Print Preview.

Anyway, once in a while I find myself working on documents that have a lot… Continue reading

Stop the Open/Close Madness

Monday, November 15th, 2004

Stop the Open/Close Madness

You’re working in, oh, let’s say, MS Word and you need to switch to a new document.

Tell me. Do you close MS Word, saving the current file, and then open Word all over again? Are you one of the many people I see everyday who spends an unbelievable amount of time opening and closing the same files and programs over and over again?

Hopefully that’s… Continue reading

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: