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

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Archive for the ‘MS Office Help’ Category



Set It Up Only Once

Friday, July 21st, 2006

Set It Up Only Once

By now, I’m sure most of you are aware that in MS Excel, you have different page setups for each worksheet.

How frustrated are you when you realize you’re in the Page Setup window, yet again, making the same changes you’ve made over and over for each worksheet in the book?

Or, what about the occasions when you insert a new worksheet into an established… Continue reading

More Emphasis in PowerPoint

Friday, July 21st, 2006

More Emphasis in PowerPoint

When giving an MS PowerPoint presentation, do you find yourself looking for a “big splash” to get the audience focused? I mean, something that stands out a bit more than a simple mouse pointer?

If you are, then this tip’s for you!

Instead of a simple mouse pointer, let’s get the pen cursor into the show. Basically, the pen will allow you to “write” freehand on… Continue reading

Checking Spaces Too

Friday, July 14th, 2006

Checking Spaces Too

Have you ever found yourself looking at a printout of a document only to wonder just how many spaces are at the end of that sentence?

I mean, you’re looking at the paper and it certainly looks like there are either too many or not enough spaces. Too bad you didn’t notice the problem before you printed, right?!

How would you like MS Word to give you… Continue reading

Starting Over

Friday, July 14th, 2006

Starting Over

So, you’re looking through your Excel workbook and you realize that you’ve got way too many different formats. You’ve got different fonts, font sizes and things like bold and underline effects everywhere. Nothing seems consistent with anything else.

Looking for a way to start over without manually removing it all or building the worksheet again from scratch?

Never fear, because I’ve got just the thing to strip your… Continue reading

The Express Lane to Bullet Modification

Friday, July 14th, 2006

The Express Lane to Bullet Modification

I’m sure that many of you know that the appearance of numbered or bulleted lists can be changed through either the Format menu or a right click over the list.

I don’t know about you, but when I’m making repeated changes, the constant accessing of a menu or all of the right click menus gets down right annoying. And yet, if you want to… Continue reading

Word Tables That Measure Up

Friday, July 14th, 2006

Word Tables That Measure Up

When you use tables in MS Word, do you ever find yourself frustrated as you try to get column widths or row heights to exact measurements?

I know you probably have the ruler open (View menu, Ruler choice) and you’re sliding the cell boundary lines around trying to get it all set, but it sure would be nice if you could verify the widths and… Continue reading

See It In Color

Friday, July 14th, 2006

See It In Color!

So, you’re an MS Outlook user, huh? Think adding color to your e-mail is limited to Outlook Express users? Nope, you can do it too! :-)

The first thing you need to do is select a message from the person you want to be color highlighted.

Next, you’re looking for the Organize button located on the Standard toolbar. (You can also find Organize under the Tools

Quick Sheet Selection in MS Excel

Friday, July 7th, 2006

Quick Sheet Selection in MS Excel

Do you have a big Excel file?

One that contains lots of worksheets?

Are you irritated with the constant scrolling back and forth to move between the sheets?

Or, maybe you like to use the Ctrl + Page Up / Down option. That works well, but it gets old after awhile. Finally, maybe you just prefer to use your mouse. So, now what?

Want… Continue reading

Microsoft Office 2007

Friday, July 7th, 2006

Microsoft Office 2007

Well, here’s an extra feature for all you MS Office fans out there!

With the release of Microsoft’s new operating system called Vista, they are also making public a new version of their Office suite, which will of course be called Microsoft Office 2007. It is still in the beta version (a test), but it is available for download. I decided to grab a copy… Continue reading

To Hyperlink Or Not To Hyperlink

Friday, July 7th, 2006

To Hyperlink Or Not To Hyperlink

Question: What good is a hyperlink on a printed document?

Answer: It’s no good!

I mean, what good is it to have MS Word automatically turn every e-mail and Web address into a hyperlink if all you’re going to do is print the document?

We all know the answer and it’s just a wasted effort on Word’s part. In fact, if you don’t like… Continue reading

DATEDIF

Friday, July 7th, 2006

DATEDIF

Have you ever found yourself trying to find the time difference between two dates?

That is, how many days, months or years have passed between the two?

What did you do?

For some things, it’s a matter of a calendar and a lot of counting.

Not very efficient, is it?

No, I didn’t think so either.

Want a quicker way to find the time difference between dates?

Yes? I… Continue reading

The Case of the Missing Pointer

Friday, July 7th, 2006

The Case of the Missing Pointer

Have you ever found yourself giving a presentation using MS PowerPoint and wishing for a mouse pointer?

We all know that a click of the mouse will advance the action on a slide or move to the next slide, but where does that pointer go?

It sure would be nice at times to have it to really focus the audience’s attention somewhere on the… Continue reading

Which Version Do You Want?

Friday, July 7th, 2006

Which Version Do You Want?

Do you have an MS Word document that you’re constantly revising?

Do you find yourself wishing you still had an earlier draft of the document somewhere?

Maybe, at one time you did, so now your solution is to continually save the file under a different name each time you revise.

This is a solution that certainly provides you with the ability to return to an… Continue reading

One Click Insert

Friday, June 30th, 2006

One Click Insert

Have you ever seen this?

Well, you probably have if you’re using a newer version of MS PowerPoint. The question is, do you know what to do with it?

If you fall into the “I don’t have a clue category,” then it’s you that I’d like to address today.

The most common thing I see when working with people is the instinct that drives them to… Continue reading

What’s the #### in My Worksheet?

Friday, June 30th, 2006

What’s the #### in My Worksheet?

Have you ever found yourself happily working in MS Excel only to be befuddled by the sudden appearance of #### in a cell where there should be a number?

Or maybe something along the lines of 2E+15 appeared?

Now, what is that?

Good question, and believe it or not, there’s a good answer. (You may not like the answer, but it’s a valid one… Continue reading

Did You Know…

Friday, June 30th, 2006

Did You Know…

…that you can set the vertical alignment of a Word document just the way you want it?

That is, you can tell Word whether to align the text at the top of the page, the bottom of the page, the center of the page or to justify the text on the page.

This one sure could come in handy if you’re trying to accommodate some weird spacing… Continue reading

One Task Pane, Many Uses

Friday, June 30th, 2006

One Task Pane, Many Uses

Have you seen this Task Pane from MS PowerPoint?

Yep, that’s right! It’s the Slide Layout Task Pane. (Format menu, Slide Layout choice).

Did you know that with this one Task Pane, you can both insert slides with the specified layout and alter the layout of already created slides?

Well, if you didn’t know this one before, you do now!

So, here’s the deal.… Continue reading

Drop Cap

Friday, June 30th, 2006

Drop Cap

What is a drop cap? Well, it is that ever so small, yet beautiful addition to a document. You may be amazed at how easy it is to put such a great touch on your documents.

To put a Drop Cap on your publication, you should first decide where the drop should happen.

Once the decision is made, the rest is quick and easy.

You begin by… Continue reading

Left, Right, Up or Down

Friday, June 23rd, 2006

Left, Right, Up or Down?

Default settings in MS Excel use the Enter key to move your cell selection one cell down.

Okay, so that covers the downward movement, but what if you want to move the selection up, right or left?

Well, one way is to move your fingers from their usual positions on the keyboard and then use the arrow keys.

Certainly not a bad plan and it… Continue reading

Relocate in Seconds

Friday, June 23rd, 2006

Relocate In Seconds

If you recall, during the creation of an MS Excel chart, we have to pick a location for the chart creation. In other words, where do you want Excel to put the graph?

You have two choices: you could embed it as an object in a worksheet or you could put it on its own chart sheet.

Ever find yourself wishing you’d made a different choice?

Maybe… Continue reading

Give the Assistant a Vacation

Friday, June 23rd, 2006

Give the Assistant a Vacation

Tired of the office assistant popping up every time you turn around?

Want to access the online help directly with no “middle man” needed?

Well, then you’re in luck!

Here’s the scoop on getting the little guy to take a semi-permanent vacation!

First, you need to get to the assistant’s options. You can right click on him and choose Options from the menu or you… Continue reading

Bits and Pieces

Friday, June 23rd, 2006

Bits and Pieces

Did you know that you can choose to format only part of what’s in an MS Excel cell?

Maybe you’ve got some text in a cell and need a couple of words bolded? Maybe a different font style or size is required for just a portion of the cell contents.

Either way, what do you do?

Can it even be done?

The answer you’re looking to hear… Continue reading

Quick “Flipping” Through Your Presentation

I’ve noticed that many users of MS PowerPoint always seem to use the scroll bar to move from slide to slide while editing in the Normal view.

It’s not a bad way to work and PowerPoint will even update you as to which slide you’re at while you scroll through the presentation.

But, what if you’re not sure exactly which slide you need?

Then… Continue reading

Reveal and Compare Formatting

Friday, June 16th, 2006

Reveal and Compare Formatting

Ever find yourself wondering exactly what formatting it is that you’re seeing in your Word document?

Now, if you want a truly complete picture of the text formatting, then we’re talking about more than just the basic font name and size. To get that complete picture we would also be discussing margins, indenting, alignment, tabs and all the rest.

To get that information, we’d have to… Continue reading

Zig or Zag?

Friday, June 16th, 2006

Zig or Zag?

So, you’ve got this huge worksheet in MS Excel that you’re trying to print and it seems that the pages are coming out completely scrambled.

Now, what’s wrong with this stubborn machine that’s causing this to happen?

Honestly, nothing.

It’s all in the Page Setup choices you make.

What was that I heard you say?

You didn’t make any choices in Page Setup that would cause this… Continue reading

Vanishing Gridlines

Friday, June 16th, 2006

Vanishing Gridlines

Here’s a good tip that comes from a reader’s question regarding those pesky vanishing gridlines.

We all know that in MS Excel you can go into the Page Setup window (File menu, Page Setup choice) on the Sheet tab and check the box to have Excel print the gridlines with your data.

But, what’s going on when those gridlines just aren’t showing up?

Another computer glitch?

Probably not.… Continue reading

Printing Formula Errors

Friday, June 16th, 2006

Printing Formula Errors

Did you know that you have options as to how Excel prints formula errors for you?

I mean, if you’ve got a worksheet you’re still editing, it’s possible that you’re still working out all the “bugs.” So, maybe you’ve got a few formulas displaying the “Oh-So-Wonderful” error messages.

You know you’ve got to fix them, but maybe you don’t want the error messages cluttering up the printout… 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: