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



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

Moving Backwards

Ever find yourself about to hit the Enter key in MS Excel and realize you need to move up a cell to fix something?

What did you do?

Most people go ahead and use the Enter key and then use the arrow keys (or mouse) to move back to the cell above.

This works, but doesn’t it seem like there should be a more efficient

Clean It Up!

Ever copy text from the Internet or an e-mail into MS Word?

Did something come along with the text that you weren’t necessarily expecting or hoped wouldn’t?

Yeah – I hear you – all those hyperlinks are a big pain at this point, aren’t they?

I mean, you’ve got the information in Word, you’re creating a document (not a web page), you have all these

More Or Less

Find yourself either inserting or deleting a lot of rows and/or columns in MS Excel?

Tired of looking for the correct button on the Ribbon or command from the Insert menu?

Yeah, me too.

So here’s an alternative that you just might find as helpful as I do.

To begin, highlight the number of rows or columns you are looking to insert. (Be sure to highlight the… Continue reading

Copy & paste to Extend Excel Data

Wednesday, April 7th, 2010

Yep – you read it correctly… you can extend the data used to create an Excel chart using a copy / paste maneuver.

Previously we’ve discussed using the data outline to extend what is included on the chart. (Click here to view the tip using this technique.)

I’ve got to say that extending the data outline is definitely an easy route to… Continue reading

Recover Corrupt Word Files

Tuesday, April 6th, 2010

Every try to open an MS Word document only to have the program tell you that it can’t open the file because it’s corrupt?

Come on, if you use Word with any frequency then I’m betting that you’ve run into this gem a time or two.

Made your day, didn’t it?

I mean, what better way to spend your… Continue reading

Evenly Spaced Dates in MS Excel

Monday, April 5th, 2010

or two weeks… or maybe just every other day…

Ever find that you need to have a list of dates that are evenly spaced apart. Maybe Wednesday of this week and the dates of all the Wednesdays that follow?

Whatever the pattern of the dates, it sure would be nice to not need a calendar or counting day-by-day to find them all the time… Continue reading

Move Info To A New Date In Outlook

Friday, April 2nd, 2010

Have an appointment in your MS Outlook Calendar that was just rescheduled?

Looking for a quick way to move the information to the new date?

I bet you’ve already figured out that you can change the appointment time within the daily detail with a simple drag and drop to the new time, but did you know you could also change the date of the… Continue reading

Last Print Date in Word 2007

Wednesday, March 31st, 2010

I can’t speak for everyone but I know that when I’m at work I find myself constantly revising the Word documents that I use. Being a teacher, most times that a document is used I find adjustments to the lesson that need to be made for next time.

All those adjustments result in the need for revision dates so that a new version isn’t accidentally replaced with… Continue reading

Print Custom Key Shortcuts in Word 2007

Tuesday, March 30th, 2010

Have you invested quite a bit of time creating custom key combinations for various tasks in Word 2007?

If you’re anything like me then the number of key combinations can be many and I will go through phases where the newest ones are needed daily so the older ones are sometimes forgotten.

Wouldn’t it be nice to have a printout of all those key… Continue reading

Hide Menus in Powerpoint

Monday, March 29th, 2010

Show Them No Menus

How many times have you found yourself using a PowerPoint presentation and in the middle you accidentally hit the right mouse button?

I don’t know about you but the resulting menu does not exactly make my day nor does it give the smooth impression of a well-put together presentation.

In my opinion, and I know there are lots out there who do not agree, but the… Continue reading

Partial Highlight, Same Results

Friday, March 26th, 2010

Did you know that when working in MS Word, there is no need to highlight an entire paragraph to make changes to paragraph traits (such as tabs, justification, line spacing and indents?)

All you have to do is click anywhere inside the paragraph and the changes will automatically apply to the entire paragraph.

Have more than one paragraph to work with?… Continue reading

Go To Special in Excel

Thursday, March 25th, 2010

Have you ever looked at an MS Excel worksheet and wondered how long it was going to take you to select only those cells that contain text or formulas or numbers or those cells that have errors?

Plus, while you’re wondering that, you’re just dreading the old Ctrl key + click, click and click some more on all cells that meet the criteria.

Maybe… Continue reading

Draft Quality in Excel

Tuesday, March 23rd, 2010

Find yourself printing an Excel worksheet just for editing purposes? Let’s face it, not everyone does their best editing on the screen… some people just need to have it on paper with pen in hand to do quality editing work.

However, if you’re like me then it begins to feel like a waste of resources.

Ink and toner aren’t cheap so printing… Continue reading

Office 2007 Compatibility Checker

Tuesday, March 23rd, 2010

If you’re using Office 2007 and have to save files formatted for the 97-2003 versions then I’d be that at one time or another you’ve seen this little gem:

Now, since you saw this warning about compatibility issues when you went to save it could mean a lot of re-working to set everything as you want it.

For example: SmartArt… Continue reading

Turn Off Excel AutoComplete

Monday, March 22nd, 2010

I’m sure that anyone who works in MS Excel has noticed that it has a habit of trying to finish a piece of data for you.

Excel likes to think of that habit as helpful and it’s called AutoComplete.

Well… I can admit that there are select times when it can be helpful but I’ve got to say that for the Excel work I… Continue reading

Easy Outlook Calendar Change

Friday, March 19th, 2010

Over the years I’ve found that the best tricks are discovered completely by accident. Usually a stray click or two and something unexpected happens, the next thing you know you’ve actually found something that you can use.

Recently my accidental click on one of Outlook’s little calendars gave me more than I thought I’d find.

Like many of you, I always used the left… Continue reading

Okay, so you’ve used the Find/Replace function in MS Excel with a lot of success before, right?

But, let’s just say you now have a multiple worksheet file and you have to search for replacements on several (or all) of the worksheets. What do you do?

You could run the Find/Replace on the first worksheet, switch to the next sheet and start the process… Continue reading

Select One at a Time in PowerPoint

Tuesday, March 16th, 2010

If you’re anything like me then you’re PowerPoint presentation slides may contain a lot of elements. Whether they’re stacked to use with animations or just lots of little parts to make the whole thing work, there’s a lot of objects and selecting just the right one can be a bit of a pain.

You’ve got to be wondering if there’s a better way to select… Continue reading

Hide Excel Worksheets

Tuesday, March 16th, 2010

Have you ever created an absolutely beautiful Excel Workbook that needs to be shared? Well, it’s beautiful except for that one worksheet that contains all the data.

That one, not so pretty, but the data on it feeds all the others so it’s a necessity… but don’t you wish you could just hide it?

You know, like when you were a kid and had… Continue reading

Do you find yourself constantly drawing horizontal lines in MS Word? You know, using the drawing toolbar to draw lines as borders or dividers, in order to give your document a little extra pizzazz.

Are you tired of all the mouse work involved in the drawing toolbar? You know, turning on the line tool, drawing the line and then changing the style.

Wish you… Continue reading

Insert a Column Break

Friday, March 12th, 2010

If you work with Microsoft Word a lot then I’m sure that you’ve created documents containing columns at one time or another.

I know that I use them frequently when I have long lists of short items… things that could be easily put into two or three columns across the page. The columns will save on printed paper as well as give a pleasing layout that would… Continue reading

Move an Entire Row in MS Word

Thursday, March 11th, 2010

Have you ever felt the need to move an entire row in an Word table?

Maybe you’ve decided that the first row of information should really be the 5th row… so, what did you do?

Did you insert a new row below the 4th one, copy & paste the information into its new position and then go back and delete the first row? Or… Continue reading

Select an Entire Table in MS Word

Wednesday, March 10th, 2010

Working with a table in MS Word?

Finding out you need to select the entire table to oh, let’s say, change the font or format the borders or whatever? The list could go on and on.

What do you do?

Do you select the first cell, hold the mouse button down and drag, hoping not to miss anything by releasing the… 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: