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



Partial Word Selections

Friday, August 4th, 2006

Partial Word Selections

While highlighting parts of more than one word in either MS Word or PowerPoint, have you ever noticed that the program will automatically highlight all affected words completely?

I mean, it’s a good thing if you actually want complete words highlighted, but what if you don’t? What if you truly wanted to highlight a strange segment? Now what?

Well, I can think of several options, but the… Continue reading

Keep It Blank

Friday, August 4th, 2006

Keep It Blank

Here’s another tip that stems from my file of reader questions. Ever have MS Excel data filling every other row? You know, with a row of data, blank row then another row of data?

Ever try using the fill handle to drag data down a column? What happened?

Yep, that’s right. To your complete horror, you filled every row!

So, now what? Do you add data by… Continue reading

Replace What’s Missing

Friday, August 4th, 2006

Replace What’s Missing

Today’s tip stems from a question a reader sent in not too long ago. It concerns a missing menu in an MS Office Suite program, which is a very frustrating situation to find yourself stuck in.

Have you ever experienced this phenomenon?

Who knows how it happened?! I’m sure there are more possible ways than I’d ever care to consider, but the end result was that you’re… Continue reading

Special Data Formatting – The Easy Way

Friday, August 4th, 2006

Special Data Formatting – The Easy Way

Do you enter a lot of special data into MS Excel, such as zip codes, phone numbers or social security numbers?

Ever find yourself wishing that the parenthesis and / or dashes would just fill themselves into the correct locations? I mean, wouldn’t it be faster if you could just key 5551234567 in for a phone number and have (555) 123-4567 appear in… Continue reading

View the Vertical Too

Friday, August 4th, 2006

View the Vertical Too

Have you ever read one of my references to the vertical ruler in MS Word and thought to yourself, “Now where do I find that”?

I mean, you’ve gone to the View menu and turned the Ruler option on and off about a million times and you’ve still never seen a vertical ruler.

It’s a good question and one that’s easily answered, so I thought today… Continue reading

Which One Is It?

Friday, July 28th, 2006

Which One Is It?

Ever ask yourself that question while you’re looking for a particular file?

Let’s say you’re in MS Word (or maybe Excel or PowerPoint) and you’ve got a whole list of files. Unfortunately, the names aren’t giving you enough information to decide which one you’re actually looking for.

What do you do?

You could systematically open each suspect file until you find the right one.

Or, you… Continue reading

Quick View Changes in Word

Friday, July 28th, 2006

Quick View Changes in Word

It seems that everyone has a preference for the way they view their MS Word documents.

Some people prefer the Normal View, some prefer the Page/Print Layout View.

Whatever your preference, it’s always a good thing to know how to get to a different view. Sometimes you’re trying to accomplish a task that lends itself to a view different from your usual way of seeing… Continue reading

Shrinky Dink Your Word Documents

Friday, July 28th, 2006

“Shrinky Dink” Your Word Documents

Have you ever needed to print an MS Word document on a smaller paper size?

What did you do?

Did you print it as normal and then use the handy-dandy copier to shrink it down to the right size?

It works, but if you’ve had the experiences I’ve had with copiers, it probably took a bit of trial and error to get what you need.… Continue reading

Grouping Menu Items

Friday, July 28th, 2006

Grouping Menu Items

If you liked last week’s tip on creating vertical break lines between toolbar buttons, then this one should be of some help too!

You may have noticed that menus have horizontal lines to separate similar items into groups.

Want to know how to insert or remove the lines? In other words, set up the groups so that they make sense to you?

If you’re thinking that… Continue reading

Thumbnails for MS Word

Friday, July 28th, 2006

Thumbnails For MS Word

Have you ever found yourself frustrated while working on the layout of a complicated Word document?

Where were you?

In the Print Preview, right?

Print Preview is an awesome tool. It helps you to catch a lot of layout problems without ever wasting one sheet of paper or one drop of ink.

But, what happens in Print Preview with a large, complicated document?

Do you find… Continue reading

One Change = Many Changes

Friday, July 21st, 2006

One Change = Many Changes

Have you ever had an MS Excel workbook in which you find yourself constantly making the same changes to several different worksheets?

What did you do?

Did you go to the first sheet, make changes, move to the next sheet, make the same changes, move to the next sheet, again make the same changes, etc. (You get the idea, right?)

How tiresome was that?

Want… Continue reading

Breaking Up Isn’t So Hard After All

Friday, July 21st, 2006

Breaking Up Isn’t So Hard After All

If you’re like me (a fan of customizing my Microsoft toolbars), you’re going to want to know about this one!

Have you ever noticed the little vertical bars between button groups on toolbars?

I don’t know about you, but I like them. The separations help me use the toolbars more efficiently. I don’t feel like I’m “hunting” for the right button all… Continue reading

Tear It Off

Friday, July 21st, 2006

Tear It Off

Many of us know that with certain toolbar buttons in the MS Office Suite, we have the ability to “tear off” the choices to create a floating toolbar.

If you didn’t know about “tear offs,” you’re probably wondering which ones behave this way and how you can tell.

Well, let me show you!

Here’s what I get when I click the down arrow for my line spacing… Continue reading

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

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: