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



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

Print the Headings Too

Friday, June 9th, 2006

Print the Headings Too

Do you print Excel worksheets for proofing reasons?

Do you find yourself frustrated that the row numbers and column letter headings aren’t on the paper? Would it make your job easier if they were?

If you’re looking for this type of assistance from Excel, there’s good news for you today! With one simple checkbox, you can get the printout exactly as you need it.

We’re looking… Continue reading

MS Excel Charts Done Your Way

Friday, June 9th, 2006

MS Excel Charts Done Your Way

Okay, so you’ve made an absolutely beautiful Excel chart, but after some consideration, you’re seeing a few things that you’d like to change.

Maybe you’d prefer a different font for the text.

Maybe you need a smaller font on some of the labeling so Excel will display all of the category names.

Maybe you have money amounts graphed and all of the “.00″ on… Continue reading

Fix It With a Click, Click

Friday, June 9th, 2006

Fix It With A Click, Click

Use MS Excel charts frequently? Ever find yourself in a situation where you’ve gone completely through the charting process, had a beautiful graph and realized that you spelled a word wrong?

What now?

Do you have to start all over?

Oh, I hope not! There must be a quick and easy solution somewhere.

Breathe easy, there is!

Mistakes in an Excel chart are often… Continue reading

Banish the Blank Slide Jitters

Friday, June 9th, 2006

Banish the Blank Slide Jitters

When you start a new PowerPoint presentation, do you stare at that first blank slide and freeze? Do you have problems figuring out just how to start when that blank white slide just stares back at you?

If you have this type of reaction to a blank slide, you may be happy to learn that PowerPoint has some built in help, and I mean a… Continue reading

One, Two, Three…

Friday, June 9th, 2006

One, Two, Three…

Ever wish that you could get MS Word to display your page numbers as words? You know, actually write out One, Two or Three?

Since page numbers expressed as words is not a choice listed in the page number format list, it sounded like a unique trick to know. Therefore, I thought we’d take a look at it today.

The basic idea of what we’ll do is… Continue reading

Lost in Worksheets

Friday, June 2nd, 2006

Lost in Worksheets

Have you ever found yourself feeling lost while trying to move a worksheet inside a huge workbook?

I mean, you’ve got 20 or 30 worksheets and you’re trying to click on the sheet tab and drag it to its new home. So, now you’re just patiently waiting for the tabs to scroll by while you continue to hold that mouse button.

Oops, you just flew by the… Continue reading

Moving Right Next Door

Friday, June 2nd, 2006

Moving Right Next Door

As I’m sure we all know, you can rearrange worksheets in an MS Excel file with a simple click-hold-and-drag of the sheet tab.

But, did you know that you can also move worksheets from one workbook to another using the same method?

No?

Well, good news, you can, and it’s really as easy as it sounds.

First, open both workbooks. (The one with the worksheet… Continue reading

Pick and Choose Displayed Formatting Marks

When you use MS Word, do you frequently display the non-printing formatting marks such as the paragraph mark, spaces and tabs?

I know that I have found them useful, but at the same time, they drive me a little bit crazy, because there is just too much going on in my document.

Ever feel that way?

I think the more pressing question for today’s… Continue reading

Excel Dates Done Your Way

Friday, June 2nd, 2006

Excel Dates Done Your Way

Okay, so you’re frustrated with the standard Excel date formats and you’re looking for a way to meet your needs.

Well, don’t be frustrated any longer!

Today, I’ve got just the information you need to make Excel do things your way.

First, you need to select the cells that should be in the date format.

Now, go to the Format menu, Cells choice. (Both Ctrl

Dating in Excel

Friday, May 26th, 2006

Dating in Excel

I’m sure by now you’ve realized that when you type a date into MS Excel, the program seems to magically know what it is and treats it as such.

Cool, less work for us, right?

But, have you ever wished the date was in a different format?

I mean, maybe you want just the month and day (5/26) for example. Or, maybe you’re looking to have something… Continue reading

Forward/Reply Formatting

Friday, May 26th, 2006

Forward / Reply Formatting

Have you ever noticed how forwarded e-mails can be so different from one person to the next? I mean, Sue forwards you a message where the original text has a “>” at the beginning of each line and Uncle Jeff forwards you something and the original e-mail comes as an attachment.

Whatever configuration you’ve seen or preferred, the big question is what does MS Outlook do… Continue reading

One More Way To Select It All

Friday, May 26th, 2006

One More Way To Select It All

Last Wednesday, we discussed quick tricks for selecting an entire Word document using keys and a combination of the mouse and keys.

Unfortunately, I left an important trick out: the 100 percent key free mouse way to select an entire document.

So let’s recap:

  • Ctrl + A will select the whole document.
  • Ctrl + a mouse click in the left margin

To the Letter

Friday, May 26th, 2006

To the Letter

Do you possess one of those extremely large contact lists in MS Outlook? Do you use the address card view in Outlook when you go to the Contacts area?

If you answered “yes” to both of those questions, I’m sure you also know the frustration of searching through all those cards looking for just the one you need.

With this time consuming task in mind, I’ve got… Continue reading

Clearly, We’ve Got Some Options

Friday, May 26th, 2006

Clearly, We’ve Got Some Options

So, you’re working in MS Excel with some data and you’ve got some changes to make.

If you needed to delete some data, you would simply highlight the cells and hit the Delete key.

But, let’s suppose you don’t want the data deleted, but instead you want the formatting removed. What do you do then?

You could spend time reformatting the cells or undoing whatever… Continue reading

Undo/Redo Many Steps At Once

Friday, May 19th, 2006

Undo / Redo Many Steps At Once

Many of us know about the Undo and Redo buttons located on the Standard toolbar. (The left arrow is Undo and the right arrow is Redo).

What do you do if you’ve got a lot of steps to undo?

Do you click the button again and again until you are finally returned to the place you’re looking for, or do you hit… Continue reading

Click and Type

Friday, May 19th, 2006

Click And Type

So, you’re working in a newer version of MS Word and you’re trying to make a title page for your latest masterpiece. What do you do?

Do you adjust the top margin to about five inches to get the title in the middle of the page?

Well, you could, but then you would have to go back into the page settings and change the margins back for… Continue reading

An MS Alternative

Friday, May 19th, 2006

An MS Word Alternative

We all know that Ctrl + A in MS Word selects the entire document. It works great and for everyone who likes to keep their hands on the keyboard, it’s a necessary tool.

But what about people who are more “mouse oriented”?

You know, people who have duties that require regular or constant mouse contact? It’s a bit annoying to keep removing your hand from the… Continue reading

Today’s Theme Is…

Friday, May 19th, 2006

Today’s Theme Is…

Well, today’s theme is actually (drum roll, please) THEMES. Who knew!?

MS Word Themes to be exact.

If you’re running at least Word 2000, you may not know it, but there are some pretty cool setups for Web pages, e-mails (for those who use Word for e-mails) and documents that are to be viewed.

This is a great way to create exciting looks for any document that… Continue reading

MS Excel Custom Views

Friday, May 19th, 2006

MS Excel Custom Views

Do you work in huge MS Excel files and constantly find yourself scrolling this way and that, trying to get to the right place?

And then again to another location?

And so on.

If you have enough of these locations you need to go to, it quickly becomes impossible to remember cell locations. That means the “Go To” feature is out!

In addition to all that… Continue reading

Super Repeating Data Shortcut

Friday, May 12th, 2006

Super Repeating Data Shortcut

When working in MS Excel, do you ever find yourself repeatedly entering the same formula or data?

What do you do?

Do you type it again and again and again into each cell?

Maybe you save some time by entering it once then copying and pasting it everywhere else?

That’s not a bad way to do it, but what if you had a faster way?

Let’s… Continue reading

Snap to It

Friday, May 12th, 2006

Snap to It!

So, if you took a look at yesterday’s tip, you probably noticed the “Snap to” section at the top of the Grids and Guides window. (Ctrl + G or View menu, Grid and Guides choice).

Some of you may have been wondering what that was all about and I’d have to say that it’s a very good question. In response, I thought today might be a… Continue reading

On the Grid

Friday, May 12th, 2006

On the Grid

When using MS PowerPoint, do you find that you’re frequently trying to align objects?

I bet you know the Format menu, Alignment trick after selecting all the objects to be aligned. (Use the Shift key to select multiple items simultaneously).

That’s a good trick, but I sometimes find myself selecting things and then accidentally unselecting everything with a stray click I never intended. After that, it’s back… Continue reading

Creating Custom PowerPoint Handouts in MS Word

Have you ever found yourself trying to create handouts to a PowerPoint presentation and wish you had a way to add questions or extra information next to the slide picture?

Maybe it’s a presentation for a seminar or a class you’re teaching and the handout with the complete slide pictures is great, but you still need a place to ask the important questions… Continue reading

Changing Up the Order

Friday, May 12th, 2006

Changing Up the Order

Do you use MS Outlook’s Task feature?

You know, the one that resembles a big “To Do” list? Maybe you’ve used it to replace all those tasks you would have formerly written on post-its and left all over your desk?

Anyway, if you use the task feature to keep track of everything, I’m sure you’ve looked for ways to organize your list.

I mean, with the… Continue reading

The Leading Zero

Friday, May 5th, 2006

The Leading Zero

Are you constantly frustrated with MS Excel, because it keeps removing that leading zero from your inventory number? (Or any leading zero on any piece of data?)

Yeah, me too.

The problem is that Excel automatically sees the data as a number and leading zeros have no value in numbers, so it gets rid of them.

It’s convenient when you’re actually dealing with numbers, but a pain… 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: