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



MS Excel: Headers & Footers Demystified—Part 2

Let’s continue on our journey through the world of headers and footers. The train stops next at the MS Excel station.

To access headers and footers in Excel, you will go to the View menu, Header and Footer choice.

The Page Setup window will open with the Header/Footer tab already selected.

The top preview box shows the header for the worksheet(s) currently… Continue reading

MS Word: Headers & Footers Demystified – Part 1

(Yes, we accidentally ran part 2 of this Tues instead of today. Sorry about that, here’s part 1. If you want a review of part 2, click here)

So, now you know what they are, I’d bet that the next question you’re dying to ask is “How do I get to these wonderful little miracles?” (All right, I… Continue reading

MS PowerPoint: Headers and Footers Demystified – Part 3

Welcome back to our ongoing header and footer discussion! The previous two issues covered the two big MS Office Suite programs (Word & Excel). Now it’s time to wrap up our discussion by addressing PowerPoint.

You will get to the header and footer window in the same way you did in the other two programs: View menu, Header and Footer choice… Continue reading

Multiple Slide Selections In MS PowerPoint

Tuesday, November 16th, 2004

Multiple Slide Selections In MS PowerPoint

Have you ever been working in MS PowerPoint and wished you could select more than one slide at a time?

Maybe you have several slides for which you’re going to set the slide transition the same.

Wouldn’t it be nice to set these things all at once instead of over and over again, one slide at a time?

Of course it would—who wouldn’t want… Continue reading

Why Can’t They All Look That Way?

Tuesday, November 16th, 2004

Why Can’t They All Look That Way?

Ever asked yourself that question as you’re looking at your latest Excel chart masterpiece?

I mean, you’ve just spent time creating a chart and it’s just gorgeous!

You’ve got the colors, fonts, text alignment… all of it! It’s just perfect.

Too bad you’ll have to reset all those things for the next set of data.

Or… maybe not.

What if we could save… Continue reading

See More Tabs

Tuesday, November 16th, 2004

See More Tabs

Do you find yourself constantly scrolling through the tabs of your large Excel workbooks?

Tired of the old Page Up / Down thing to move through the seemingly endless sheets?

Or, maybe you’re someone who uses the “right click” trick on sheet tab scroll buttons and then selects your destination from the worksheets in the list?

All are valid ideas—I use many of them frequently, but I… Continue reading

Word’s Readability Statistics

Tuesday, November 16th, 2004

Word’s Readability Statistics

OK, so we’re all here for the same purpose, that is, to get Word to give us the scoop on a document’s stats.

The first step is to turn on the Readability Statistics feature.

Accomplishing this task is really quite easy. Go to the Tools menu, Options choice.

In the Options window you’re looking for the Spelling & Grammar tab.

At the bottom, you’re looking in… Continue reading

What’s Your Readability?

Tuesday, November 16th, 2004

What’s Your Readability?

Do you find yourself preparing MS Word documents for a specific audience?

Ever worry that it’s just too complicated? Maybe it’s just written in a way that’s above the target audience’s abilities? Maybe it’s below their abilities?

In the course of my job as a teacher I’ve prepared hundreds of documents (project instructions, memos, letters… you get the idea) and I’ve always got to keep in mind… Continue reading

Give It A Break

Tuesday, November 16th, 2004

Give It A Break

You’re in the middle of a PowerPoint presentation and you need a break in the show… maybe you’ve got this great discussion breaking out and it’s time to wander from the presentation to explore the new ideas… or maybe it’s just plain old coffee break time.

Whatever your reason, you need a break in your presentation—what do you do?

(If you’d known that you needed the… Continue reading

Rearranging PowerPoint Slides

Tuesday, November 16th, 2004

Rearranging PowerPoint Slides

Have you ever finished a PowerPoint presentation and realized that the slide order needs to be redone?

What do you do to quickly rearrange? Do you need to re-do the entire presentation?

Don’t worry, the rearrangement can be complete in just a few clicks. (Whew!)

When you realize that you need to tweak the order of your slides simply go to the Slide Sorter view. You can… Continue reading

More or Less?

Tuesday, November 16th, 2004

More or Less?

What do you do if you need another worksheet in your workbook?

Quick and easy solution: Go to the Insert menu, Worksheet choice.

Done! Worksheet inserted to the left of whatever sheet you were currently working on.

Trying to insert several worksheets at once?

Hold the Shift key down and select the tabs of several worksheets (the number you’re trying to insert). Then go to the Insert… Continue reading

Quick and Complete Worksheet Copying

Tuesday, November 16th, 2004

Quick and Complete Worksheet Copying

Ever try to copy an Excel worksheet formatting, data, header, footer and all?

Most Excel users have tried at one time or another. Often when I talk to people, I find that they have varying levels of success. Some can copy only the data. Others have a little more success and can get the data and the formatting copied to a new sheet.

The elusive… Continue reading

Copying Excel Worksheets—Including The Formatting!

Have you ever tried to copy the contents of one MS Excel worksheet to another only to find that when you’re done pasting you’ve lost all your column and row formatting (such as column width and row heights)? How much time do you lose reformatting all those worksheets?

You just know there has to be an easier way, and of course, there is :-)

To… Continue reading

Excel Word Wrap For Many Cells

Tuesday, November 16th, 2004

Excel Word Wrap For Many Cells

So, you’ve got a whole range of cells with a lot of text?

Maybe you’ve got a row or column of titles and the whole Alt + Enter thing would just take way too much time. I mean, who wants to go through cell by cell to get the word wrap set?

Not me either!

So what now?

Believe it or not, it’s as… Continue reading

MS Excel Wrapping In A Single Cell

Tuesday, November 16th, 2004

MS Excel Wrapping In A Single Cell

We’ve all had them. They’re everywhere. They’re impossible to kill and hard to shrink. What am I talking about? (Sometimes I wonder about that myself.)

I’m talking about those column or row titles in Excel that are so long they’re awkward.

If you stretch the column width to accommodate the whole title, then the two-digit number looks ridiculous in the 3-inch wide column.… Continue reading

Inserting MS Word Bookmarks

Tuesday, November 16th, 2004

Inserting MS Word Bookmarks

Ok, so we’re all here to find out how to create and use MS Word’s Bookmark feature for quick navigation through our documents. With that in mind, let’s dive right in.

The first thing would be to decide where you need a bookmark. It could be a string of text, a picture or simply a blank space somewhere. (Whatever your bookmark location, make sure you have… Continue reading

Bookmark It!

Tuesday, November 16th, 2004

Bookmark It!

Ever have a “monster” MS Word document?

Find it a bit of a pain to navigate?

Tired of the Page Up and Page Down buttons?

Yeah, me too. There’s just got to be an easier way to navigate through the entire mess, and, well, there is.

In fact there are several different ways to shortcut by all the navigational headaches—but today let’s discuss MS Word’s Bookmark feature.

First… Continue reading

Using Word’s Hyperlinks With bookmarks

Tuesday, November 16th, 2004

Using Word’s Hyperlinks With bookmarks

On Tuesday we covered MS Word’s bookmark feature—all in all, a pretty quick way to navigate through large documents.

But… wouldn’t it be wonderful to have the ability to set up links within the document so you can jump from location to location without all the Go To stuff?

You know, like a web page—you click on a marked link and poof!… Continue reading

Did you know…

Tuesday, November 16th, 2004

Did you know…

…that in “Print Preview” you can choose to display more than one page at a time?

I’m sure we all know about the benefits of Print Preview, but wouldn’t it be nice to see how the pages are flowing one after another? You know, to see where page breaks are landing, how pictures, tables and graphs are placed on the pages. Basically to make sure that it… Continue reading

Word: Sorting Data

Tuesday, November 16th, 2004

Word: Sorting Data

Have you ever found yourself wishing that the list you just typed into MS Word was alphabetized? Or, for those of you who are good with Excel, you’re probably wishing that you typed the list in Excel in the first place (where it’s so easy to sort data).

Well, stop dwelling on the “should have, could have” stuff and smile. It’s very easy to sort data in… Continue reading

Word: Double Spacing

Tuesday, November 16th, 2004

Word: Double Spacing

By default, MS Word documents are single-spaced, which is great for most of what we do. But, what about that small percentage of documents where you need things double-spaced?

Now, as I’ve said before, I’m a teacher. I have a lot of opportunities to see how people (both students and staff) are using their technology. I’m always amazed when I find someone using the enter key to… Continue reading

Word Pages With Pizzazz—The Basics

Tuesday, November 16th, 2004

Word Pages With Pizzazz—The Basics

So, you’re working in MS Word and you’re trying to create a unique, eye-catching document.

You’ve been looking for just the right touch to make it grab their attention. Something that’s not too over the top but definitely says “Read me!”.

You’ve eliminated the idea of AutoShapes and pictures. No, you’re looking for something to tie it all together.

Hmmm…

Wait, I know, what about… Continue reading

Quick Excel Copying With Keys

Tuesday, November 16th, 2004

Quick Excel Copying With Keys

If you’re looking to do some copy / paste work in Excel with adjacent cells, then here’s a quick trick for you.

If you want to copy the information in the cell immediately above use Ctrl + D.

Try it…

Whatever is in the cell above is immediately copied into the selected cell.

Need the information transferred into more that one cell?

Highlight all the… Continue reading

Page Border Printing Problems

Tuesday, November 16th, 2004

Page Border Printing Problems

By now I’m sure more than one of you have run into a problem with your page borders (from last Thursday’s tip) that is when you print the page it’s not a complete border.

No matter how thin you make the bottom line, it seems determined to be uncooperative!

In fact, I bet you’ve seen this lovely little message a few times

Custom Page Borders Demystified

Tuesday, November 16th, 2004

Custom Page Borders Demystified

So, if you worked through the tip from last Thursday (7-22-04) on Word’s Page Borders then you probably noticed the Custom Setting at the bottom of the list.

Some of you may be wondering “What’s that all about?” and I’d say that’s a very good question.

To put it simply, this is a setting that allows you to pick and choose between… Continue reading

Now You See It, Now You Don’t

Tuesday, November 16th, 2004

Now You See It, Now You Don’t

Ever have a beautiful MS Excel worksheet, I mean absolutely perfect, except that one column. You know, the one column with the necessary data for your calculations but not really a part of the presentation. We’re talking about the essential column that you must keep, but don’t want displayed for a presentation or on the hard copy.

Often, Excel users have a lot… Continue reading

Quick Table Splits

Tuesday, November 16th, 2004

Quick Table Splits

You’re working in MS Word and you’ve got a beautiful table—it’s perfect!

Well… almost perfect.

Unfortunately, for whatever reason, you’ve just come to the conclusion that it really should be two different tables.

Now what?

Are you having copy / paste nightmares?

Or, worse yet, you’re picturing a situation where you’ve got to create a whole new table and re-enter all that data!

Well worry no more.… 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: