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



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

Wait — That’s Not What I Want!

Tuesday, November 16th, 2004

Wait — That’s Not What I Want!

Have you ever found yourself frustrated with the AutoCorrect feature found in the MS Office suite programs?

Yeah, I’m sure you have.

Most of the time they’re helpful little changes in spelling or things like capitalization and we’re thankful to have the program looking out for us.

But… what about the times when AutoCorrect is making changes that we really don’t want or… Continue reading

MS Excel Worksheets on Demand

Tuesday, November 16th, 2004

MS Excel Worksheets on Demand

Ever notice that an Excel workbook opens with many worksheets? (I believe my program was initially set somewhere around 10 sheets.)

Have you ever wished that a new workbook would open with more worksheets? Less?

Yep, you’ve got it. There’s a way to change the default number of worksheets. Another one of those “That was so easy, why didn’t I know about that before?” items.… Continue reading

Question: I hear the terms “workbook” and “worksheet” used frequently when people discuss MS Excel. What exactly is a workbook? A worksheet? Is there a difference?

Well, to begin with, there is definitely a difference. (But you knew that, didn’t you?)

A workbook is the MS Excel file in which you enter and store related data.

A worksheet (also known as a spreadsheet) is a collection of cells on a… Continue reading

Navigate Cells Without Deselecting

Tuesday, November 16th, 2004

Navigate Cells Without Deselecting

So… you’ve got a fairly large range of cells selected in MS Excel and you’re just about to move them, or copy, or print—whatever—but, oh no!

Right there, in the middle of the data, you’ve noticed something that needs to be changed.

Rats!

You know that this means you’ve got to lose the data selection in order to get into that cell and make the changes.… Continue reading

Selection Direction

Tuesday, November 16th, 2004

Selection Direction

Have you ever been working in MS Excel and found yourself wishing that the cell selection would go in some other direction after you hit the Enter key?

Let’s face it, sometimes the data needs to be entered in rows, not columns.

Never fear! A couple of clicks and bingo, you’ve changed the direction the Enter key moves the cell selection.

Wanna know how?

Sure you do.

To… Continue reading

Faster File Access

Tuesday, November 16th, 2004

Faster File Access

Do you have a file or two that you find yourself opening constantly? Maybe a template that is used almost daily?

Tired of waiting for a program to load so that you can finally use File / Open to get to the file? You know what I’m talking about—the file or template that you’re forever opening and closing.

The fastest way I know to open templates and… Continue reading

So what’s a shortcut?

Tuesday, November 16th, 2004

Q:
I often see and hear references to shortcuts. I know this has nothing to do with a map and my car—so what’s a shortcut?

A:
A shortcut is an icon that is linked to a specific file or program. When the shortcut is double-clicked it starts a program or opens a file and the program needed to view the file (it all depends on what it’s linked… Continue reading

Pictures In MS Word On Demand

Tuesday, November 16th, 2004

Pictures In MS Word On Demand

Do you have a picture or logo that is frequently used in your MS Word documents?

Are you tired of the constant routine involved with the insertion of the picture into document after document?

I know I get pretty tired of it. (I can’t stand to repeat myself unnecessarily! :- )

Anyway, if you’re in this situation where you have a logo or other… Continue reading

Seeing The Roots

Tuesday, November 16th, 2004

Seeing The Roots

Have you ever found yourself working on a complicated Excel formula and trying to decipher where it all comes from?

I mean, this formula references another cell but when you get there you find another formula that references yet another cell. And so it goes… on and on. (These endless cells are the “roots” of the formula in question.)

Frustrated?

You bet.

Looking for a way to… 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: