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

What’s included with Open Office

Wednesday, June 30th, 2010

Since we regularly discuss OpenOffice and why you might want to use it, today I thought that it might be a good idea to go over what comes with your free OpenOffice download.

Once you’ve run the setup wizard and launched OpenOffice, you should bump into this:

From this

Many of us know that when you run a slide show with timings (meant to progress automatically based on the timings) you can exit the presentation using the Esc key.

This works great if you’re ready to close it up for the day but not so great if you simply needed to stop it or maybe you need to move back or forward in the presentation…… Continue reading

As many of you may have caught in one of last week’s newsletters, it was announced that this particular portion of Computer Tips is taking on a new look starting today.

If you’ll notice the section is no longer entitled “MS Office Tips” – but instead is now called simply “Office Tips”.

The reason for the change is that now I will be including… Continue reading

MS Outlook: Move It With No Drag or Drop!

Thursday, June 24th, 2010

When you use Microsoft Outlook do you find yourself moving messages from place to place with the old drag and drop?

For many people that process works just great – but what about all those people who would prefer to use a key combination over the mouse?

Is there any help for them?

Well, of course there is… you just have… Continue reading

How many times have you found that you’ve put very important information buried in the center of an Excel worksheet?

Whatever the information is, it’s important and you need to present it well.

Is it information that can, or maybe should, be presented so that it stands out – font, text size, color, whatever you deem appropriate.

But all… Continue reading

Link Text Boxes in MS Word

Monday, June 21st, 2010

If you’ve ever used MS Publisher then you’ve probably have run across the “phenomena” of linked text boxes.

Not being a regular user of such things you probably don’t know what’s going on when you bump into such things…

Well, it’s just what it sounds like – the boxes are linked and when the first one fills up with text it will overflow into… Continue reading

Find Fonts with the First Letter

Friday, June 18th, 2010

These days we all have a whole lot of fonts in our computer systems – which is nice on the side of creativity and giving things your own personal touch – but not so nice on the side of changing from font to font.

We’ve all done it… select some text then go to the Font drop-down list and scroll, scroll and scroll some more to get… Continue reading

Paint More Than One Format in MS Excel

Thursday, June 17th, 2010

I’m sure that we all know about the wonders of the format painter in all of the Microsoft Office Programs but did you know that in Excel you can get it to paint more than one format type at a time?

No, probably not – but it’s definitely worth the time to take a look.

How many times have you had multiple formats within… Continue reading

Clear Word Formatting

Wednesday, June 16th, 2010

We’ve all had this moment… the one where we realize that so much mismatched and random formatting has been done to our document that it’s time to just start over.

Well, not start completely over – I certainly don’t mean that we would want to delete all the document content – just the formatting.

As many of you

Scroll Between Slides in Powerpoint

Tuesday, June 15th, 2010

Give a lot of PowerPoint presentations?

Tired of all the click, click, click required to give your presentation?

What about the hassle to move back a step, once you’ve made that extra click?

Do you have a scroll wheel on your mouse?

Yes? Well, good, because I just might have a suggestion you may take a liking to.

While giving a presentation, try scrolling the mouse wheel down.

Scroll… Continue reading

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

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