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 Word Table Mania – Part 1 – Inserting Tables

Well, with the introduction of tables complete let’s get down to business.

To begin with we need to look at ways, and there are several, to insert a table into a document.

One way is to use the Insert Table button on the Standard toolbar.

When you click on the button a drop-down screen will appear. This allows you… Continue reading

MS Word Tables – What are they and why do you need them?

Remember the tables you made in math or science class? The ones full of data you collected? (And for those of you who groaned at the mention of a math class – I, the math teacher, heard that.)

Anyway, this is the same idea, except it’s better.

An MS Word table is an organizational tool that lets… Continue reading

MS Word Table Mania – Part 2 – Working With Tables

Now that we’ve covered how to insert tables and how to navigate within them, let’s cover some of the other issues that arise while working with tables.

The last issue covered the options of evenly distributing rows or columns.

So… moving on, what about the situations where you want the columns different widths? Is there an easy way to… Continue reading

Move a table in MS Word without using the mouse!

Question: In MS Word, how do I move from cell to cell in a table without using the mouse? (A cell being each “box” within the table.)

Good question.

Tuesday we discussed inserting tables. For those of you who tried you may have found that when you hit the Enter key the row height grew instead of… Continue reading

Excel Worksheet Protection

Wednesday, November 17th, 2004

Excel Worksheet Protection

So, we’re all looking to protect our worksheets from changes—changes others may make or changes we may accidentally make.

Since we’re all here for the same thing, let’s get right to it.

To protect your entire worksheet from changes you need to go to the Tools menu, Protection submenu, Protect Sheet choice.

The Protect Sheet window will open – giving you choices as to what to… Continue reading

No Touch My Cells!

Wednesday, November 17th, 2004

No Touch My Cells!

OK, so maybe that’s the way my nephew would phrase it, but isn’t that what we mean when we’re looking to keep an Excel worksheet from being changed?

You know what I mean, the file that others have to see but shouldn’t touch.

Or… maybe it’s you who is the culprit!

Ever find that you’ve changed a worksheet that you never meant to alter?

Yeah, me… Continue reading

Many Objects Into One

Wednesday, November 17th, 2004

Many Objects Into One

OK, so your drawing is all done and you’re ready to turn many objects into one—let’s get started.

The first thing you need to do is to select all the items to be grouped.

One way is to hold down the Shift key while you click on each individual item.

You should notice that all items selected will have their little “grabbers” displayed.

Another way—possibly… Continue reading

Get In The Group

Wednesday, November 17th, 2004

Get In The Group

So, you’ve just spent the last 15 minutes putting together drawn elements from the drawing toolbar and it looks great!

You’ve got it exactly right, except… well, it should really be larger and probably, now that you think about it, in a different location.

Oh no.

Can you imagine? All that work!

All those little elements to move, resize and place back together exactly as you… Continue reading

Tab It Up In MS Word Tables

Wednesday, November 17th, 2004

Tab It Up In MS Word Tables

So, you’ve created an absolutely beautiful table in MS Word and you’re trying to enter the table data. (Check out recent issues from March 30, 2004 and April 1, 2004 for more info on table creation.)

Along the way you needed to set a few tab stops within the cells. (You can revisit the… Continue reading

Quick Email Sorting

Wednesday, November 17th, 2004

Quick Email Sorting

You’re sorting through a huge list of email, wishing you knew of a quick way to find the specific one needed.

Smile :-) There is!

To get MS Outlook or Outlook Express to sort email all you have to do is click!

When you’re looking at your inbox do you see the column titles at the top? The ones that label the columns From, Subject, Received, etc…… Continue reading

Quick Keyboard Highlighting in MS Word

Wednesday, November 17th, 2004

Quick Keyboard Highlighting in MS Word

Are you the person always looking for a better way to highlight text without the mouse?

Yes? Then I bet you’re a pretty big Shift key user.

While I’m not sure about you, I know that I find it a bit annoying since I tend to change my mind about how much to highlight after I’ve released the Shift key.

So naturally I’d need… Continue reading

Vanishing Characters

Wednesday, November 17th, 2004

Vanishing Characters

So, there you are, happily editing your MS Word document. You’re in the middle of a paragraph adding in a new word here and another there… but wait. What happened to the text?

You had something like this:

MS Office & Tricks

Then realized that you forgot the “Tips” so you clicked back into the sentence to add it.

Somehow, someway, you got this…

MS Office Tipsicks

What’s… Continue reading

Merge vs. Split

Wednesday, November 17th, 2004

Merge vs. Split

Well, let’s get right to the “good stuff”, that is, how to accomplish a cell split or merge.

Let’s begin with cell merging.

How do you accomplish this magical wonder in MS Word? Believe it or not, with only 2 clicks of the mouse.

First you will need to highlight the cells to be merged. (Click, hold and drag until all cells to be merged are highlighted… Continue reading

More MS Word Table Talk

Wednesday, November 17th, 2004

More MS Word Table Talk

In a couple of recent issues (March 30, 2004 and April 1, 2004) we went over some MS Word basics.

I think it might be time to expand our knowledge just a bit…

Have you ever wanted to take several cells of a table and turn it into one?

Yes?

Yeah, me too.

That’s called a merge.

Or—have… Continue reading

Excel Drag & Drop Between Worksheets

Wednesday, November 17th, 2004

Excel Drag & Drop Between Worksheets

So, you’ve got some data in an Excel worksheet that you need to move to a new location.

Within the same sheet—no problem.

I’m positive that we all know about highlighting the data to be moved and then using the mouse arrow on the very edge of the selected cell(s) to click and drag the data to a new location.

Quick, easy—what could be… Continue reading

Click, Click – Toolbar Docked

Wednesday, November 17th, 2004

Click, Click – Toolbar Docked

As I’m sure many of you know, in an MS Office Suite program you can choose to constantly display a “floating” toolbar by dragging it into the outer edges of the program window.

The toolbar then loses its window title bar, closing box X and is what we call “docked” on either the top, bottom, left or right of the window.

Handy little feature -… Continue reading

Hyperlink No More

Wednesday, November 17th, 2004

Hyperlink No More

Have you ever been frustrated with MS Word while putting together a document that contains email or web site addresses?

Tired of the way Word continues to automatically create hyperlinks of your addresses?

You know—the change of color and underlining. If you’re creating a document to be printed then this isn’t exactly what you’re looking for.

In fact, for printed documents, it can be downright annoying!

What… Continue reading

To Update Or Not To Update

Wednesday, November 17th, 2004

To Update Or Not To Update

Did you know that there’s a choice as to how you insert the date or time into an Excel worksheet?

Did you know that you could choose to have the date or time entered as a piece of data that doesn’t change or as a field that will be updated when you open the file or press the F9 key?

Well, as you can… Continue reading

Flagging Messages In MS Outlook

Wednesday, November 17th, 2004

Flagging Messages In MS Outlook

So, we’ve all decided that flagging email messages is a good idea to keep organized and on time, and since we’re all here for the same reason, let’s get started.

The first step is to locate an email message that needs to be flagged for future attention.

If you’re using MS Outlook 97 then here’s the scoop for you:

To mark the email with a… Continue reading

Red Flag It

Wednesday, November 17th, 2004

Red Flag It

You’ve done this a hundred times.

You’ve got an email that requires a follow up action on your part and then a response but it’s not due for a couple of days.

Well… It can wait. You’ve got other things that are a higher priority right now.

You’ll leave the message in your Inbox – you’ll remember to get the job done and respond on time.

Move… Continue reading

Quick Copy Of Appointments

Wednesday, November 17th, 2004

Quick Copy Of Appointments

Do you use MS Outlook’s calendar feature to keep track of your appointments and other projects / deadlines?

Have you ever found yourself constantly entering the same or similar information over and over again?

If you’re thinking “that sounds like me” and you’re tired of all the repetition then have I got a time saver for you!

Next time, instead of retyping or even copy /… Continue reading

Extending Your Chart Data

Wednesday, November 17th, 2004

Extending Your Chart Data

So, you’ve got a beautiful Excel chart (known to some of you as a graph) and it’s the perfect thing to display your data.

It’s got all the labels, colors, titles and every other aspect any good chart would have… but of all the bad luck, now you’ve got to start over.

Why, you ask?

Well, unfortunately you’ve got more data to add to the chart.… Continue reading

Remove & Copy Toolbar Buttons

Wednesday, November 17th, 2004

Remove & Copy Toolbar Buttons

Are you an Office Suite user who likes to customize your workspace?

Specifically, do you do a lot of toolbar customizing?

Well, here’s a couple of tricks for quick, anytime customizations that may help you along your way.

  • To copy a toolbar button press Ctrl + Alt while dragging a button to a new location.
  • To remove a toolbar button press the

Have Excel Help With The Proofreading

Tuesday, November 16th, 2004

Have Excel Help With The Proofreading

So, you’ve just entered a formula into an MS Excel cell and you get this…

#NAME?

Now what’s that?

Well, it turns out that you’re looking at Excel’s way of letting you know that you’ve used a name Excel doesn’t recognize.

For me it most commonly means that I’ve entered the name of a function with a typo and now Excel is confused.

If… Continue reading

Need More Data?

Tuesday, November 16th, 2004

Need More Data?

Are you an MS Outlook user who often finds yourself wishing for more Contact fields? That is, maybe you’re looking to enter data that has no “pre-made” location?

Frustrating isn’t it?

What do you do?

I mean, you want the data recorded for future use, but where?

Let’s fact it, if you “slide” it into another field just to have a record of the information you could… Continue reading

Zoom, Inbox — Zoom, Outbox

Tuesday, November 16th, 2004

Zoom, Inbox — Zoom, Outbox

Do you work in MS Outlook and find that you seem to flip between the Inbox and the Outbox frequently?

Tired of needing the mouse to jump back and forth between the two?

Yeah, me too.

So here’s just the key combinations you need to zoom from one to the other…

Ctrl + Shift + I will take you immediately to the Inbox.

Ctrl +… Continue reading

Going To The Edge

Tuesday, November 16th, 2004

Going To The Edge

Are you an Excel user who often works with huge ranges of data?

Sort of annoying when you’re trying to move from one end of the range to the other, isn’t it?

You can scroll for what feels like an eternity (and then probably pass the end of the data up anyway) or hit the Page Up / Down key about “a million” times. But no… 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: