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



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

Picture Perfect Lists

Friday, May 5th, 2006

Picture Perfect Lists

Do you use bulleted lists frequently? Ever find that you wish you had a little something new to spice up your list? I mean, those same old plain Jane bullets can get a little boring.

May I suggest that we take the bulleted list into our control and give them a face lift?

Yeah, I like the idea too, so let’s get right to business.

If the… Continue reading

Starting Over At One

Friday, May 5th, 2006

Starting Over At One

Do you have a Word document with several chapters or sections that need page numbers?

Did you know that you have a choice? Besides choosing where and what type of numbering, did you know that you can pick to have all the pages of the document numbered consecutively, or to have each chapter start the numbering over? Or maybe you need a combination of the two?… Continue reading

Setting Indents Using the Word Ruler

Have you ever wondered what all the little triangle looking things are on the Word ruler?

If you haven’t noticed them, take a quick look. See them now? They must be there for a good reason. Want to know what it is?

Yes? Good, you’re in the right place, because that’s what we’re going to cover today.

The “triangles” are actually markers for different… Continue reading

Make the Rule Measure Up

Friday, May 5th, 2006

Making the Ruler Measure Up

Did you know that MS Word comes with a built-in ruler?

No?

Well, it does if you’re using the Page / Print Layout view or the Normal view and it’s pretty easy to access.

I find the Word ruler very helpful with layout decisions, setting tab stops and for making quick changes to paragraph settings.

To display Word’s ruler, simply use the View menu, Ruler

Quick Outlook Folder Access

Friday, April 28th, 2006

Quick Outlook Folder Access

Have you ever wished for a quick access button to your Inbox, a feature or some other folder you keep in MS Outlook?

Maybe you’d like a quick click into your Journal or Calendar, straight from the desktop?

If this sounds like a good plan, here’s the thing you need to know to make this one a reality for you.

What we need to do is… Continue reading

Choose Your Task Pane

Friday, April 28th, 2006

Choose Your Task Pane

Do you use and like the Task Pane found in the newer versions of MS Office?

Ever find that you’re not sure which features of the program have a Task Pane? For example, you’re working and it’s doing a nice job of switching at appropriate times to help you with different features. That’s all good and fine, but when you, let’s say go to the Insert… Continue reading

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

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: