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



Custom Shorcut Menus

Friday, April 28th, 2006

Custom Shortcut Menus

What’s a shortcut menu, you ask? Not sure if you use them?

I’d bet that you use them all the time. You know when you’re working and you do that quick little right click? What happens?

Yep, that’s right. A small menu will open listing a few of the more useful options that are available. This is your shortcut menu.

So, now that you know you’re using… Continue reading

And the Subtotal Is…

Friday, April 28th, 2006

And the Subtotal Is…

Have you ever found yourself working on an Excel worksheet desperately trying to group similar data, insert a row or write a formula for the group?

How was it?

What was that you said?

Did I hear you mutter under your breath something about it being a complete pain?

Yep, that’s what I figured I’d hear. (I thought the same thing too).

So, the question becomes… Continue reading

Excel Sorting Fun

Friday, April 28th, 2006

Excel Sorting Fun

Often in MS Excel, we have a database of information that needs to be ordered in a certain way. (Whether it is alphabetical, by date or whatever; we just need to get it in order).

Since today’s tip requires you to know how to sort, I thought it might be a good idea to cover the basics first.

The first step to sorting data is to tell… Continue reading

A Different Type of Tab

Friday, April 21st, 2006

A Different Type of Tab

I’m sure that we’re all very accustomed to the usual left, center, right and decimal tab stops Word has used for years. But, if you’re using a newer version of Word, you may have noticed a new addition to the family.

When flipping through your tab choices, did you ever notice this little guy?

Well, I did and had to wonder what it was… Continue reading

Slides From Files

Friday, April 21st, 2006

Slides From Files

Ever create a PowerPoint presentation and get a feeling of déjà vu? Sometimes you’re just positive you have created that slide before.

If you use MS PowerPoint frequently, I’d bet that you’re right. I’d even bet that you find yourself duplicating previous efforts by creating slides that are either identical or very similar to slides you already have in other files.

At the moment you feel the… Continue reading

Mouse Free Borders

Friday, April 21st, 2006

Mouse Free Borders

Do you use the Format Cells window to create custom cell borders in MS Excel?

Do you prefer the keyboard to the mouse?

Maybe, in an effort to combine these two things, you’d be interested in a list of keyboard shortcuts to apply and remove individual cell borders?

If it sounds like a good idea to you, then read on.

Obviously, our tip starts after you’ve highlighted

Make Word’s Page Setup Changes “Permanent”

Okay, so maybe permanent isn’t the best word to describe this, but would you settle for a default setting?

Do you find that you’re constantly making changes to the Page Setup information in MS Word?

Are these changes the same each time?

Maybe you don’t agree with the default margins or maybe you’re always making adjustments to the header / footer settings.

Whatever changes… Continue reading

More Indent, Please

Friday, April 21st, 2006

More Indent, Please

I have good news for my MS Word using keyboard enthusiasts!

I don’t know about you, but I’m thoroughly annoyed every time I have to take my hand off the keyboard to change paragraph formatting regarding indenting and hanging indents.

(Hanging indents happen when the paragraph’s first line is on the left margin and all other lines of the paragraph are indented).

Hands off keyboard, hand on… Continue reading

Randomness in MS Excel

Friday, April 14th, 2006

Randomness in MS Excel

Ever need random numbers in Excel for data analysis?

Or, maybe you just need random numbers to fill cells while you work out formatting issues. You certainly don’t want to sit and make up data for this purpose. That takes way too much time.

You just know there is and I can definitely say that you’re correct. There is a much better way to fill those… Continue reading

Formatting and Updating MS Word TOC

Friday, April 14th, 2006

Formatting and Updating MS Word TOC

Now that you have the basics of Word’s TOC (Table of Contents), you’re probably wondering about appearance, updating and other uses.

Well, it’s good if you’re wondering, because that’s what we’re going to cover today.

Let’s begin with the appearance.

You may not be thrilled with the font style or size in the TOC. Fortunately, this is absolutely no problem.

You can highlight all… Continue reading

TOC What?

Friday, April 14th, 2006

TOC What?

I’m confused. Do you mean as in “tic toc”?

Have you ever been working with MS Word’s online help and you surprisingly run into that little gem? Was it explained to you or did you file it in the back of your mind as another one of the many unexplained Microsoft mysteries?

Just in case it’s in your “unexplained” category, let me tell you they were referring simply… Continue reading

Mouseless Calendar Displays

Friday, April 14th, 2006

Mouseless Calendar Displays

I’m sure that most users of MS Outlook’s calendar feature know that they can quickly choose to display a day, work week, seven day week or a month with just a click of the mouse on either the View menu or the appropriate button.

Some of you may know that you can choose any number of days to display by highlighting them on the Date Navigator (the… Continue reading

Paste and AutoCorrect Options – the Keyboard Way

Do you love the Paste and AutoCorrect Options found throughout the newer versions of the MS Office Suite? (You know the ones I’m referring to, the little menus that pop up when you complete certain tasks. For example, when a copy / paste or an AutoCorrect is completed).

If you’ve ever taken a quick moment to look through the various options… Continue reading

Paste and AutoCorrect Options – the Keyboard Way

Do you love the Paste and AutoCorrect Options found throughout the newer versions of the MS Office Suite? (You know the ones I’m referring to, the little menus that pop up when you complete certain tasks. For example, when a copy / paste or an AutoCorrect is completed).

If you’ve ever taken a quick moment to look through the various options… Continue reading

Change the View to Change the Printout

Have you ever tried to print out your contact information from MS Outlook only to find yourself disappointed with the results?

Did it contain too much information? Too little?

Whatever the concern, I’d like to suggest a quick and easy way to adjust the printout by changing the way you view the contact list.

With the contact list open in MS Outlook, go… Continue reading

Two Days In Two Columns

Friday, April 7th, 2006

Two Days In Two Columns

Do you use MS Outlook’s calendar feature?

When using the month calendar, have you ever noticed that Saturday and Sunday are compressed into a single column? This little space saving technique gives you half the space for weekend appointments. Sometimes it’s an okay thing and sometimes it’s a bad thing.

Does it annoy you? Would it suit your needs more to have those days… Continue reading

MS Excel AutoFilter Part 2 – Top 10 and Custom Filters

As promised on Tuesday, we will finish our discussion of Excel’s AutoFilter function. Specifically, we need to cover two items in the AutoFilter pull down lists: “Top 10″ and “Custom.”

So, let’s get right to it.

To begin, I think we should discuss Top 10.

This is pretty much what the name implies. It’s a listing of the top… Continue reading

I Thought Filters Were For Things Like Fish Tanks and Coffee Makers…

Have you ever found yourself lost while working with a huge list or set of data in MS Excel?

Did you find that you were continually scrolling through data looking for a particular value?

I bet more than once you caught yourself wishing for a way to just see what you want and get rid of the rest.… Continue reading

Changing the View, Not the Selection

Friday, April 7th, 2006

Changing the View, Not the Selection

I’m sure just about everyone has used the arrow keys in MS Excel to move through their worksheet.

But, sometimes you want to quickly zip out to another part of the worksheet to see something without moving the cell selection and losing your current place. What do you do then?

I’m betting that many of you take your hands off the keyboard, use the… Continue reading

Organize It Your Way

Friday, March 31st, 2006

Organize It Your Way

If you’re like me, you find yourself saving lots of Outlook e-mails and always sorting them out into different folders for easy access later.

Does it irritate you that every time you create a new folder, Outlook asks you if it should go onto the Outlook bar, then it promptly buries it in the My Shortcuts section of the bar.

I don’t know about you, but… Continue reading

Format Painter Made More Useful

Friday, March 31st, 2006

Format Painter Made More Useful

Do you use the Format Painter in MS Excel to transfer cell formatting from one cell to another?

It’s a good use of the Format Painter function. It’s certainly much easier than starting from scratch with all of the formatting each time. I mean, if you already have cells established with the necessary formatting, why do the work twice?

So, I propose to you one… Continue reading

Linked vs. Embedded Sound

Friday, March 31st, 2006

Linked vs. Embedded Sound

Do you use a lot of music in your PowerPoint presentations? Do you then use these presentations on a different computer?

Ever had a problem with the music? Maybe the music you’ve used isn’t on the new computer and you didn’t know that you had to copy that file too. Oh no, what do you do now?

Well, you could always train yourself to copy sound… Continue reading

Quick and Spiffy Tables in MS Excel

Friday, March 31st, 2006

Quick and Spiffy Tables in MS Excel

Do you usually use MS Excel for table work? Looking for something to help give you a quick and easy visual “edge” when it comes to the presentation of your tables?

If any of that sounds like a good idea, you might be happy to know that Excel has an AutoFormat function just for such a purpose.

In other words, you can quickly… Continue reading

MS Excel Default Font Fun

Friday, March 31st, 2006

MS Excel Default Font Fun

Do you constantly find yourself changing the font size or type in Excel worksheets?

Is it getting annoying to repeat yourself time after time after time?

I bet a few of you even tried looking in the Format menu for something equivalent to the Font choice found in MS Word.

Didn’t find it, did you?

Nope, that’s because it’s not there.

You can find font… Continue reading

Worksheet or Workbook?

Friday, March 24th, 2006

Worksheet Or Workbook?

Did you know that when you do a Find / Replace in MS Excel, you can control how much of the file is searched?

Yep, that’s right. You can choose to work on a single worksheet or on the entire workbook. It’s all up to you. You just have to know where to look for the setting.

To begin, you need to run the Find / Replace… Continue reading

Drag to a New Workbook

Friday, March 24th, 2006

Drag to a New Workbook

Do you find that you’re frequently copying worksheets from an established workbook into a brand new one?

All the copying and pasting can be quite tiresome, so how about a way to drag and drop those worksheets into a workbook of their own?

I just knew that you’d like that idea, so let’s move right to the “how to.”

First, to create a new workbook… Continue reading

Only See the Document

Friday, March 24th, 2006

Only See the Document

Do you find that you are more annoyed than helped by the menus and toolbars at the top of your Word program window?

If you’re answering yes to that question, then I’d bet that you work with keyboard shortcuts a tremendous amount of the time.

Wish there was an easy way to work without looking at all the clutter?

Well, if a minimalist view in MS… 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: