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



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

Hide / Unhide Excel Key Combinations

Tuesday, November 16th, 2004

Hide / Unhide Excel Key Combinations

In keeping with last Thursday’s theme (July 29, 2004) involving the hiding of rows and columns in MS Excel, I thought we might take a look at how to accomplish this task with some handy key combinations.

Hiding columns or rows is a good way to make necessary data “invisible”. This allows you to organize your worksheet the way you want… Continue reading

MS Excel Formatting Without The Mouse

Tuesday, November 16th, 2004

MS Excel Formatting Without The Mouse

I thought today might be a good time for an installment of keyboard shortcuts…

In MS Excel:

  • Ctrl + Shift + ~ will apply the General Number format to the currently selected cell(s).
  • Ctrl + Shift + $ will apply the Currency format, with 2 decimal places and negative values in parentheses, to the currently selected cell(s).
  • Ctrl + Shift + % will

Outlook Startup Choices

Tuesday, November 16th, 2004

Outlook Startup Choices

Here’s a tip that comes to you courtesy of a reader’s question. She was looking for a way to force Outlook to open straight to the Inbox.

Sounds like a very relevant and legitimate concern.

I don’t know about you, but when I start up Outlook I’m looking for my email. Don’t get me wrong, there’s lots of other great stuff in Outlook, but 99.9% of the… Continue reading

One-Click Cell Addresses

Tuesday, November 16th, 2004

One-Click Cell Addresses

Did you know that there’s a faster way to enter cell references in Excel formulae… a way that doesn’t involve typing cell addresses?

Interested? (Yeah, I thought you might be.)

Here’s the scoop…

Next time you’re entering a formula and you get to a cell reference (like A5 for example), instead of typing A5 use your mouse and click on A5.

Some of you are already thinking… 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: