Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Archive for the ‘MS Office Help’ Category

Ever have an Excel column or row that is designed to continually expand with additional data?

Do you have calculations – may a sum or average or whatever – from the set of data?

And when the amount of data increases what do you do with your formulas?

If you’re changing the cell range each time then I know… Continue reading

Flag Messages Fast in Outlook 2007

Friday, June 11th, 2010

When using Outlook 2007 do you frequently flag messages?

If so, would you like a one-key way to flag them?

If you’re thinking that this might be a good idea then here’s what you need to know.

– First, select the message(s) to be flagged. (Yes, it works with multiple messages highlighted as well as it does for a… Continue reading

Pick Your Outlook 2007 Signature

Thursday, June 10th, 2010

If you’re like me then you use a variety of different signatures in your e-mail… a signature for every occasion or mood?

Well, not exactly that many but one for messages to friends, one for business communications – even a few that are basically a template of text for frequently repeated / similar messages.

But, as we all know, no many how many different… Continue reading

Ribbon Hero

Thursday, June 10th, 2010

No, this has nothing to do with ribbon dancing or professional present wrapping – Ribbon Hero is actually and add-in for Microsoft Office 2007 that helps to increase your Office proficiency. Office Labs describes it as:

[Ribbon Hero provides] “online training in the nature of tutorials and “how to” demonstrations in the field of business application software; educational services, providing training and educational materials in

Rearrange Mailbox Fields in Outlook

Wednesday, June 9th, 2010

By default your e-mail messages are listed with the “From” information before the message subject.

For many people that arrangement is just fine with them – it’s how they operate.

But if you find yourself looking for the subject first then maybe that’s the way you’d like the information listed… with the message subject first.

If this is you then here’s… Continue reading

Count Rows and Columns in Excel

Tuesday, June 8th, 2010

When you’re highlighting entire rows or columns in MS Excel the program will let you know how many have been selected as you go.

But, have you ever noticed that you can’t get that same information when you’re highlighting a range of cells?

I mean, we often need just a partial row and column and that handy-dandy little counter doesn’t… Continue reading

Directly to the CAPS

Monday, June 7th, 2010

Shift + F3. How often do you use that one?

Remember its little gem? It takes the highlighted text and rotates it between the Title Case of lowercase and UPPERCASE letters.

But, what if you’re tired of rotating through the choices and just want to jump straight to UPPERCASE?

Can we find a quick

Copy As Picture in Excel 2007

Friday, June 4th, 2010

Ever find that you have part of an Excel 2007 worksheet that you need others to see. That is, they need to see the information displayed but in no way, shape or form do they need to actually possess the worksheet itself?

Basically – they need an “electronic print out” of a portion of a worksheet – in other words, you need so show them a picture… Continue reading

Excel Ranges

Thursday, June 3rd, 2010

Do you find that referring to cell ranges in Excel formulas is a difficult task? Confused by the use of the colons, commas and spaces?

These characters are definitely a part of formula writing and if they aren’t used correctly, you’ll probably run into some problems.

So, here’s the information that can make formula writing with ranges a much more manageable task… Continue reading

Reset PowerPoint Slides

Wednesday, June 2nd, 2010

I know that my PowerPoint users can identify with this one… You’ve spent a lot of time putting together the perfect presentation and now it’s time to do a quick run through to see how it looks.

Well – you thought that it was “perfect” but now you see that content holders (such as the title, main text, etc…) are all slightly different. Some titles ended up… Continue reading

If you’re an MS Word table user then it’s quite possible that you’ve spent some time trying figure out how to wrap the text of your document around the table.

There isn’t an overly obvious answer so I’m sure that many of you have just given up on truly wrapping the text around the table.

For those of you who have unsuccessfully searched here’s… Continue reading

Interactive Office Guide

Friday, May 28th, 2010

Are you still finding it difficult to locate things in the newest Office programs – you know, all the things that were so easily at your fingertips and are now “lost” somewhere on the Ribbon?

Well I ran across something the other day that just may help you to complete the transition from the menus to the Ribbon.

I was on Microsoft’s sight and… Continue reading

When you’re working with Microsoft Office 2007 SmartArt graphics do you ever think to yourself how nice it would be if all the shapes in the graphic didn’t have to be the same?

Maybe your basic SmartArt graphic like this one:

Would make more sense or be more useful to you if it looked something like this:… Continue reading

Extended Word Underline Options

Thursday, May 27th, 2010

For years we’ve all used Microsoft Word and have come to rely upon our handy little underline button.

Assuming that you’ve made the transition to Word 2007, then I’m sure you were happy to see the Underline button safe and sound (not to mention easy to find) on the Home tab of the Ribbon.

But, have you really looked at the new Underline button?… Continue reading

Navigate Excel Worksheets Using Tabs

Wednesday, May 26th, 2010

Have a lot of sheets in your Excel workbooks?

Tired of scrolling left and right to find the right tab?

Or maybe you do the whole Ctrl + Page Up / Ctrl + Page Down thing, but that can be tedious too and let’s face it, it’s pretty easy to blow right by the sheet you need.

So, you’ve got to… Continue reading

Office 97-2003 Default Save Format

Tuesday, May 25th, 2010

Working with Office 2007?

Everyone you share files with need them saved for an older version?

Maybe you have 07 at work and some other version at home…

Whatever the situation how many times do you find yourself saving a new file in an Office 2007 program as an Office 2007 file when it should have been in the 97-2003 file… Continue reading

Ms Word Emoticons

Monday, May 24th, 2010

Here’s a quick Word tip for all of you who are attached to your emoticons… you know, the little :) and :( we’re so fond of using in text and e-mail?

Well, if you like these little guys and haven’t tried one in Word lately then you really should!

As part of the AutoCorrect list there are three emoticons set to be replaced by… Continue reading

Ctrl + Z Does More!

Friday, May 21st, 2010

When we think of using Ctrl + Z we’re all thinking “undo” – which is true but in our minds that means removing the last character entered, putting text back that we just deleted or removing formatting that we tried but just didn’t like.

All of these things are exactly what Ctrl + Z is for but there’s more.

More you ask?… Continue reading

Color Code Excel Comments

Thursday, May 20th, 2010

If you use comments in MS Excel then you might find yourself wishing that there was a way to color code them.

Maybe some comments are notes you’ve made to yourself about double checking a formula, maybe others pertain to something entirely different.

Whatever your needs it might interest you to know that you can change the color of your comments with just a… Continue reading

Spell Check in MS Excel

Wednesday, May 19th, 2010

Yeah, I know. Excel is primarily for numeric data , but let’s face it, we tend to use a lot of words in our Excel worksheets. Given all those words, it’s only reasonable to find that typos and misspelled words are occurring in Excel too.

So, it makes sense to me to understand (not just assume) what cells the spell check feature is actually checking. Did you… Continue reading

Change Case Function in MS Excel

Tuesday, May 18th, 2010

We all know that Word and PowerPoint have the Change Case feature. It’s an extremely useful tool, so much so that there are times when working in Excel I find myself wishing it was there too.

I realize that Excel really isn’t meant for a lot of text but there are times when you just can’t get around it.

At any rate, if you’ve… Continue reading

Outlook Items as Attachments

Monday, May 17th, 2010

I’m sure that we all know how to attach a file to a message in MS Outlook, but did you know that you also attach an Outlook item?

Yep – that’s right, you can easily attach a calendar item, contact information, note, etc…

All those things you have in Outlook and aren’t sure how to share them are just as easily shared as any… Continue reading

MS Office Template Site

Friday, May 14th, 2010

How many times have you found yourself working in one of the MS Office programs and creating something that you just know probably already exsist out there somewhere?

If you’re anything like me then the answer is a simple “too many times to count”.

And… right on the heels of that thought is the realization of just how much time you’ve wasted over the… Continue reading

When you’re editing a complicated slide in PowerPoint and you’ve got a lot of animations to set it’s sometimes difficult to know that it’s all going together as you have it pictured in your mind.

To be sure that it’s coming along as you hoped you’ll want to preview it… so what do you do?

Most people leave the Normal view and actually begin… Continue reading

OK – So by now I’m sure that you’ve found the Search box in Outlook 2007.

This is a quick and handy way to locate a message with a quick key word or phrase.

However, sometimes the results are so numerous that it’s no help at all…

Logically you might take the next step to expand the… Continue reading

Set MS Excel Default Font

Tuesday, May 11th, 2010

For many of us the font used in our documents, presentations and workbooks is a choice we actively make. When I’m creating something for others to see – which is most of the time – then I want it to look a certain way.

The easiest way to create something that I’ll like is to have my default font set to my

I obviously can’t speak for you but I do know that there are times when I’m working in Excel and find myself in need of a calculator.

I know, I know, there are quite a few of you wondering why I’d want a calculator when Excel can basically do all that for me.

Well, sometimes I just feel that it’s easier 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.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive