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



An Office Assistant That Delivers

Monday, November 22nd, 2004

An Office Assistant That Delivers

No not pizza delivery – sorry – but something you can really use.

How about a tip delivered to your desktop at program startup everyday?

If you like reading Office tips in little doses then you’ll love this. The only question is how do you arrange for this little delivery?

Well, the first thing you need to do is to get the Office Assistant running.… Continue reading

Table Headers

Monday, November 22nd, 2004

Table Headers

Here’s the scenario, you’ve made a perfect table of information in MS Word and you’re getting ready to print your document. As you’re looking things over you realize that your table prints on several pages and your column titles are on the first page but not the others.

What do you do?

Do you make extra rows at the top of every page and manually… Continue reading

Preventing The “Saved Over” Blues

Monday, November 22nd, 2004

Preventing The “Saved Over” Blues

Do you have an Excel file that you constantly change data in and then have to remember to save it under a new name?

Have you ever caught yourself yelling at the computer “STOP!” as you realize that you just saved over the old data—and darn—you needed to keep that too!

While you’re still muttering at the computer, do you then go back and try… Continue reading

What’s up with all those tabs?

Monday, November 22nd, 2004

What’s up with all those tabs?

Did you ever notice that there are several tabs in the New window when you go to open a template you’ve created?

What’s up with all those tabs?

Well, to tell the truth, the tabs are useful little creatures.

Next time you go to open a template slow down and browse through them.

You’ll find that on the tabs are other… Continue reading

Single Worksheet Templates

Friday, November 19th, 2004

Single Worksheet Templates

We’ve discussed templates in MS Excel that were entire workbooks, but… have you ever wanted just a single sheet for a template?

You know, instead of opening a workbook template, just insert a sheet into another workbook?

Sounds like a good idea to me! After all, I’m willing to bet that someone out there uses a template to copy and paste a single sheet into workbooks already… Continue reading

No More Splitting

Friday, November 19th, 2004

No More Splitting

Here’s the scenario: you’re working on a table in MS Word and suddenly a row splits in two—that is—part on one page and part on the next page.

You’re looking this new development over, all the while thinking to yourself: “this just won’t do—the topic in each row really can’t be split apart”.

At this point you’re trying to come up with a solution. You need an… Continue reading

Table Toppers

Friday, November 19th, 2004

Table Toppers

Did you know that with just a couple of clicks you could have MS Word automatically repeat your table headings at the top of each page containing the table?

If you answered “No” then you’ll want to take a quick moment to read on because here’s the trick to beautiful table headings.

First thing you’ll need to do is to select the row or rows you want repeated… Continue reading

Quick & Spiffy Tables in MS Excel

Friday, November 19th, 2004

Quick & Spiffy Tables in MS Excel

Way back in January (January 28, 2003 to be exact) we discussed using the AutoFormat feature of MS Word to give your tables a quick and easy visual “edge”.

(To take a look at the January 28 issue, visit our archives at http://www.worldstart.com/archives)

For those readers who usually use MS Excel for table work… Continue reading

MS Excel Default Font Fun

Friday, November 19th, 2004

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 choices… Continue reading

MS Excel AutoFilters Part 1—The Basics

Friday, November 19th, 2004

MS Excel AutoFilters Part 1—The Basics

Here’s the scenario: you’re working with a spreadsheet and you’re patiently trying to find certain values—maybe you’re looking for the top 3 sales amounts from the list, or all customers who live in a certain city, or all sales made by a certain sales rep.

Whatever it is you’re looking for, you need to know it now—not an hour from now after you’ve sorted… 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

MS Excel AutoFilter Part 2—Top 10 and Custom Filters

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 values or percentage of the list.

Let’s investigate further.

After you’ve opened a file and turned on the AutoFilter (Data menu, Filters submenu, AutoFilter choice) pull down one of the AutoFilter lists for a… Continue reading

Changing The View – Not The Selection

Friday, November 19th, 2004

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?

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

Word Created TOCs

Friday, November 19th, 2004

Word Created TOCs

OK. So we’re ready to discover the secrets of MS Word’s automatic table of contents feature—let’s get right to it.

The first thing you need to do is establish your document with heading styles. You need to use consistent headings for chapter / section titles and then consistent headings for the subsections below each section title.

For example, you may apply Heading 1 to each section title… Continue reading

TOC?

Friday, November 19th, 2004

TOC?

I’m confused, do you mean, as in “tic toc”?

Have you ever been working with MS Word online help and 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 to a “table of… Continue reading

Formatting & Updating MS Word TOCs

Friday, November 19th, 2004

Formatting & Updating MS Word TOCs

Now that you have the basics of Word’s TOCs you’re probably wondering about appearance, updating and other uses.

Well, it’s good that you’re wondering since 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 or part of… Continue reading

More Indent Please

Friday, November 19th, 2004

More Indent Please

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 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 mouse, find what you need… Continue reading

Setting Indents Using The Word Ruler

Friday, November 19th, 2004

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, then 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 since that’s what we’re going to cover today.

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

Making the Ruler Measure Up

Friday, November 19th, 2004

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… Continue reading

MS Word Footnote Fun

Friday, November 19th, 2004

MS Word Footnote Fun

Here’s the scenario: you’re working in MS Word, happily moving through the material, creating a complete masterpiece. Suddenly you realize you need to footnote a statement. What do you do?

Well… you could do as I’ve seen so many do—type until you’re close to the bottom of the page and simply type the text into the middle of the document. Looks ok on the first run… Continue reading

Repeating Data Super Shortcut

Friday, November 19th, 2004

Repeating Data Super 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 copy / pasting it everywhere else?

Not a bad way but what if you had a faster way?

Let’s say… a way that… Continue reading

The Leading Zero

Friday, November 19th, 2004

The Leading Zero

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.

Convenient when you’re actually dealing with numbers, but a pain when it’s a… Continue reading

View It Your Way

Friday, November 19th, 2004

View It Your Way

Now that we know some of the possible “whys” for the Custom View feature—let’s get right to the “hows” of the process.

The first thing you need to do is to open your workbook and go to the location you want to work with.

At this point make the necessary changes to settings and other things at this location.

Now we’re ready to create the view.… Continue reading

MS Excel Custom Views

Friday, November 19th, 2004

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 then it quickly becomes impossible to remember cell locations. That means the Go To feature is out!

In addition to all… Continue reading

Big Mistakes

Friday, November 19th, 2004

Q:
I was working on a document the other day and made a big mistake. I messed up the entire document and it took forever to get it back to the way it was. Is there a better way?

A:
Yes. First, if you make a mistake, hit Ctrl+Z . In most programs, that will undo whatever it

MS Word Themes

Friday, November 19th, 2004

MS Word Themes

OK, so you’ve decided a theme might be the way to go and you’re ready to take a look at all the choices.

Yeah :-)

Let’s dive right in.

To find the themes you need to go to the Format menu, Theme choice. (Alt then O then H works too.)

The Theme window will open.

On the left you have a list of themes to choose… Continue reading

Quick MS Tabs And “Stuff”

Friday, November 19th, 2004

Quick MS Tabs And “Stuff”

A couple of weeks ago (back on October 2nd ) we discussed using the MS Word ruler to set indents—but, as you may or may not know, there are other uses for the Word ruler.

One major, easy to do, item on the ruler is the ability to set tabs with just a click.

Yep, that’s right—you can set a tab stop with just a… 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: