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 Formatting Without The Mouse

Tuesday, November 16th, 2004

MS Excel Formatting Without The Mouse

I thought today might be a good time for an installment of keyboard shortcuts…

In MS Excel:

  • Ctrl + Shift + ~ will apply the General Number format to the currently selected cell(s).
  • Ctrl + Shift + $ will apply the Currency format, with 2 decimal places and negative values in parentheses, to the currently selected cell(s).
  • Ctrl + Shift + % will

Outlook Startup Choices

Tuesday, November 16th, 2004

Outlook Startup Choices

Here’s a tip that comes to you courtesy of a reader’s question. She was looking for a way to force Outlook to open straight to the Inbox.

Sounds like a very relevant and legitimate concern.

I don’t know about you, but when I start up Outlook I’m looking for my email. Don’t get me wrong, there’s lots of other great stuff in Outlook, but 99.9% of the… Continue reading

One-Click Cell Addresses

Tuesday, November 16th, 2004

One-Click Cell Addresses

Did you know that there’s a faster way to enter cell references in Excel formulae… a way that doesn’t involve typing cell addresses?

Interested? (Yeah, I thought you might be.)

Here’s the scoop…

Next time you’re entering a formula and you get to a cell reference (like A5 for example), instead of typing A5 use your mouse and click on A5.

Some of you are already thinking… Continue reading

Formatted Text in AutoCorrect

Tuesday, November 16th, 2004

Formatted Text in AutoCorrect

I’m sure we’re all aware of MS Word’s AutoCorrect feature—that little gem secretly working in the background replacing many of our common typos with the correct spelling.

And, for you more advanced users, I’m sure you’ve already modified the list to be used as an automatic replacement tool for complex or long text strings.

My question is: do you find that you’re constantly going back to… Continue reading

To The Bottom Right Now

Tuesday, November 16th, 2004

To The Bottom Right Now

As I’m sure most of you know that when working in MS Excel Ctrl + Home will take you to the upper left corner of your worksheet (cell A1).

Do you know where Ctrl + End will land you?

Let’s all hope that it’s not in the bottom most corner of a worksheet! Have you ever scrolled out right or down to find out just… Continue reading

The Word Highlighter

Tuesday, November 16th, 2004

The Word Highlighter

Have you ever been working on a Word document and come to a point where you need to enter a fact that you’re not sure of? Do you really want to stop this very minute to look up the information?

I’m not sure about you, but I hate to stop every few minutes to look something up. I’d rather keep going with the typing part, look information… Continue reading

Slide Hunting Simplified

Tuesday, November 16th, 2004

Slide Hunting Simplified

Here’s the situation… you’re in the middle of your PowerPoint presentation and suddenly there’s a question regarding a different slide.

Of course it’s a question that’s not about the previous or the next slide. As luck would have it, you’ve got to go “hunting” for the right place. So now what?

Fortunately, while there are lots of ways you could get to your new destination, there’s a… Continue reading

WordArt Designed By You

Tuesday, November 16th, 2004

WordArt Designed By You

Are you a person who likes and frequently uses Microsoft’s WordArt?

Yeah, me too.

But don’t you sometimes find yourself wishing there was a way to have a “toned down” version?

You know, a way to pick and choose a few elements of the whole WordArt feature?

If this is you then here’s a tip that’s sure to add to your ability to jazz up your… Continue reading

The Spaces Too?

Tuesday, November 16th, 2004

The Spaces Too?

In MS Word, what’s the difference between Ctrl + U and Ctrl + Shift + W?

Give up?

The answer is one little word: “spaces”.

Let me explain.

I’m sure we all know that Ctrl + U will underline text, spaces and all like this.

In contrast, the Ctrl + Shift + W will underline only the text.

See how the spaces are not underlined?… Continue reading

Fast And Efficient Envelope Addressing Using MS Word

You just finished a letter. It’s beautifully written, printed, and ready to go. Now all you need is an envelope.

For this next step I’m sure most of us are aware of the nifty little function in the Tools menu of MS Word that allows you to go in and address envelopes for printing.

You go to Tools menu, Envelopes and Labels… Continue reading

Keyboard Menu Magic

Tuesday, November 16th, 2004

Keyboard Menu Magic

Here’s one for those of you who prefer the keyboard to the mouse, but don’t really know many of the “tricks of the keyboard trade”.

Have you ever noticed the underlined letter in the title of each menu at the top of your screen? (You know – the F, E, V, etc..)

Ever wonder what that was all about? I mean, there has to be a… Continue reading

Click, Click – Auto Fill It

Tuesday, November 16th, 2004

Click, Click – Auto Fill It

OK, so you’ve got a long column of data in MS Excel and… in an adjacent column you’re going to apply the same formula to each and every item in the list.

What do you do?

For many of us we simply write the formula in the first cell and then use either copy / paste or the fill handle to drag the formula… Continue reading

Cell Formatting Trick

Tuesday, November 16th, 2004

Cell Formatting Trick

Do you constantly find yourself going to the Format menu, Cells choice to make changes in MS Excel? (You know, for things like data format, text direction, borders, fill color, etc.)

Do you hate using the mouse for all this?

Looking for a faster, keyboard-driven method to access the Format Cells window?

Yes?

Good, then you’re in the right place.

Next time skip the menu and highlight… Continue reading

Finding Excel Record Lengths

Tuesday, November 16th, 2004

Finding Excel Record Lengths

Here’s a tip I received from a reader who finds Excel’s function for determining data length (number of characters in the data) to be a useful tool.

Maybe you too have data sets in Excel through which you must search to find the longest or shortest element.

At any rate, I thought it might be a good idea to pass this one along so let’s get… Continue reading

Get Right to Business in MS PowerPoint

Tuesday, November 16th, 2004

Get Right to Business in MS PowerPoint

Are you using PowerPoint 97 or 2000 and find yourself tired of seeing this screen every time you start the program?

Looking for a way to bypass this altogether and just get right to business?

If this is you then here’s the scoop.

Take another look at that Startup Screen… maybe take a look way at the bottom?

See it?

Yep… Continue reading

AutoFit in MS PowerPoint XP

Tuesday, November 16th, 2004

AutoFit in MS PowerPoint XP

OK, so we’re all here for the same reason—to learn to control PowerPoint’s AutoFit feature. With that in mind, let’s get right down to business.

You actually have two types of control over this feature.

One type is when you choose to turn the AutoFit feature on or off globally (at the overall program level so it affects all presentation elements).

Another point of control… Continue reading

Why Does That Text Keep Shrinking?

Tuesday, November 16th, 2004

Why Does That Text Keep Shrinking?

Is this a question you’ve asked yourself while working in PowerPoint XP?

Have you ever noticed that when working in a title or text placeholder that the font will just shrink as the text fills the box?

A good thing if you want PowerPoint to help take care of the “making it fit” issue, but, not so good if you want text to be… Continue reading

I choose Blue… No, Orange! Wait, maybe Lime Green?

Have you ever found the perfect clipart for your presentation, document or worksheet only to find that it seems to clash with other elements (maybe the background or other clipart)?

Did you find yourself wishing you could change the clipart color scheme so everything would look “right?”

Well, you can… if you have MS PowerPoint.

When you insert clipart into an… Continue reading

Keyboard Font Size Shortcuts

Tuesday, November 16th, 2004

Keyboard Font Size Shortcuts

Over the years I’ve run into a couple of different keyboard shortcuts for changing font size and I thought it might be of interest to my readers who love a good keyboard shortcut.

To be exact, I have two different sets of key combinations for increasing and decreasing font size.

This first set will increase or decrease font by the increments listed in the font size… Continue reading

Headers and Footers?

Tuesday, November 16th, 2004

Headers and Footers?

What exactly is a header or footer?

I think that the MS Office Assistant gives the best definition for headers and footers. According to that cute little guy in the help window:

“A header or footer is text or graphics—such as a page number, the date, or a company logo—that is usually printed at the top or bottom of each page in a document. A header is… Continue reading

MS Word: Headers & Footers Demystified

Tuesday, November 16th, 2004

MS Word: Headers & Footers Demystified

So, now you know what they are, I’d bet that the next question you’re dying to ask is “How do I get to these wonderful little miracles?” (All right, I can hear the groans and moans from here. Maybe they’re not little miracles but they’re pretty useful little gadgets anyway.)

The way to access headers and footers is to go to the View menu… Continue reading

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

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: