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



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

Outlook Categories

Friday, May 7th, 2010

Do you use the color-coded categories in MS Outlook 2007?

I don’t know about you but I love them in conjunction with e-mail rules so that as certain messages come in they are marked for my attention as soon as they hit my Inbox.

What I’d like to discuss today is an extension of the category use.

Did you ever notice… Continue reading

AutoFit Columns in MS Word

Thursday, May 6th, 2010

Have you used a table in MS Word lately?

Find that your column is a little too narrow to fit the data?

Now, if we were working in Excel we’d just double click the right border of the column label… but this isn’t Excel so we’re out of luck, right?

Wrong. AutoFit works on Word tables too!

All… Continue reading

Set Print Area in MS Excel

Tuesday, May 4th, 2010

Have you ever noticed that MS Excel automatically tries to print everything on your worksheet?

This works wonderfully for most things we do, but what about the times when you only need part of a worksheet printed? Or, what do you do when you have a large worksheet containing many calculations that feed to one particular section of the sheet and you only want to… Continue reading

Do you have a custom logo, picture or return address set up that you really wish would just show up every time you print an envelope?

That sure would be nice. I mean, no messing with templates, copy/pastes or other methods you may dream up to get your envelopes to your liking.

Well, I have good news. That “dream come true” is easier to… Continue reading

Transfer Excel Page Settings

Monday, May 3rd, 2010

Not many things can aggravate me more than when I’ve got to transfer page setup information from one worksheet to another.

Often, I’ll set up a worksheet not realizing that later I’ll need to add another worksheet in the workbook that needs all the same settings.

Since I’ve just added the sheet it comes with the default settings

Office 2007 ScreenTip Styles

Friday, April 30th, 2010

I’m sure that we’ve all had the experience of the screen tip popping up when we pause the mouse pointer over a button on the MS Office Ribbon.

When it comes to those tips people tend to fall into 3 different categories… those who don’t need them, those who like the small tip that lists the name of the button only and those people who want to… Continue reading

Different Tab Stop Display in MS Word

Thursday, April 29th, 2010

Have you ever felt frustrated when working with MS Word’s tabs? I mean, you’re trying to set up your tab stops, but you’re finding it difficult to ensure that they are placed properly between the margins.

You’ve got the ruler displayed (View menu, Ruler choice – or – View tab on the Ribbon, check the Ruler option), but it’s still a bit of a pain to double… Continue reading

Metallic Fonts in PowerPoint

Wednesday, April 28th, 2010

When you’re working in PowerPoint there’s a whole lot you can do with font… a lot of color choices, shadowing, rotation… basically the works.

But, if you look through all those easy settings you won’t really see anything metallic…do you?

No, me either but fortunately I did run across a blog that contains a download of a PowerPoint slide that contains text with effects… Continue reading

Merge but Don’t Center in MS Excel

Tuesday, April 27th, 2010

As any regular user of MS Excel can tell you, the Merge & Center command is truly a handy feature.

It allows you to select multiple cells then by using the command the cells are merged into one large cell and the cell contents are center justified.

I love it – makes for easy table titles centered above all the columns of data and… Continue reading

Check Only My Spelling

Monday, April 26th, 2010

When you use MS Outlook 2007 to either forward or reply to a message are you ever astounded at the number of error the Spell Check finds … and most of them aren’t even yours!

I mean, it’s going through and checking absolutely everything, which means that you’re busy trying to correct the mistakes of others.

Now, maybe you don’t mind the… Continue reading

Change Ruler Units in MS Word

Friday, April 23rd, 2010

Do you use MS Word’s ruler feature with your documents? (You know… View menu / Ruler choice or View tab of the Ribbon / Ruler checkbox.)

Ever find yourself wishing it was in a different measurement unit? (Let’s say it’s in inches and you want it in centimeters). Or, maybe you weren’t even using the ruler, because the way it measured just isn’t the way… Continue reading

Alt Highlighting in MS Word

Thursday, April 22nd, 2010

Have you ever found it annoying that MS Word highlights text in lines? That is, it moves the highlight through the document one line at a time.

Ever wish you could just create a quick rectangle at any location and copy only what’s in the rectangle? You know, maybe the first half of many lines of text or the middle of a paragraph.

The… Continue reading

We all know that in MS Excel the bottom right corner of a cell selection is called the Fill Handle.

It’s an extremely useful tool. With just a drag and drop of the fill handle will copy information or continue a series of data in consecutive cells without the need for the whole copy / paste thing.

What could be… Continue reading

Do you want to use a desktop email client so that you can read and reply to Gmail emails without opening the browser all the time? Using a desktop email client has its own advantages. First, you can manage all your email accounts at one place. Second, you can read emails and write the responses when you do not have an internet connection.

The biggest… Continue reading

Sort With Two Criteria in MS Outlook

Tuesday, April 20th, 2010

I’m sure that all of you MS Outlook users know how to sort your e-mail messages by clicking the column title.

Furthermore, if you click the column title again it will begin to toggle between an ascending and descending sort.

Works great, love it, use it all the time but… did you ever need to sort by let’s say sender… Continue reading

I don’t know about you buy when I’m working with a presentation in MS PowerPoint I often find myself duplicating slides so that I can easily keep formatting consistent throughout. Content replacement and minor changes from slide to slide is then easily accomplished.

I’m sure that many of you have found the Duplicate Slide command in some menu or tab of the Ribbon but I have two… Continue reading

Double-Click Auto-Fit in Excel

Friday, April 16th, 2010

As many MS Excel users know, you can highlight a column and then through the Format menu, Column sub-menu choice (for Excel 2007 it’s the Home tab of the Ribbon, Cells section, Format button), you can choose the AutoFit Selection option. What this does is make the column just wide enough to fit the longest piece of data in the selection.

It’s a great thing, with no… Continue reading

Number your Lines in MS Word

Thursday, April 15th, 2010

Sometimes it’s just a good plan to have the lines of your Word documents numbered.

They could come in handy if you’re trying to communicate with someone about specific portions of the document or maybe they would be useful for your own editing notes.

Whatever the reason, sometimes it’s just a good idea to have them and that makes it an even better idea… Continue reading

No Snap Drawing Tool in Office

Wednesday, April 14th, 2010

Do you use MS Office’s drawing tools and the “snap to grid” feature?

If you’re like me, the whole “snap to grid” thing works out okay and it helps me keep my things a bit more organized, but sometimes there’s just that fraction of space you want to use and can’t, because the object is snapping back into place on the grid.… Continue reading

Navigating an Already Selected Range

Have a large range selected in MS Excel?

Need to move the selected cell, within the highlight, to another location to check data or functions?

I know you’re not considering the idea of simply clicking somewhere else, taking a look at your data and then reselecting the range all over again, are you?

Let’s hope there’s a better way!

Here’s a list

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: