Do you long for a way to reset Word to a "factory default" condition? It is almost impossible to get things to the way they were the day you installed, but there are a few things you can do, as described in this tip.
Read this WordTip: Factory Default Settings for Word
Microsoft Word Tips -
Learn Word Faster!
Functions are at the heart of Excel's power in working with data. One of the most misunderstood functions provided by Excel is VLOOKUP. Here's a brief overview of how to use the function.
Read this ExcelTip: Understanding the VLOOKUP Function
Microsoft Excel Tips -
Learn Excel Faster!
When you spend a lot of time creating footnotes, how can you convert all of them to endnotes without entering them all again? It's easy to do if you follow the steps in this tip.
Read this WordTip: Converting Footnotes to Endnotes
Microsoft Word Tips -
Learn Word Faster!
Wouldn't it be great to have your huge charts print out on multiple pieces of paper that you could then piece together? While Excel doesn't provide this capability directly, this tip looks at some ways that you can get the multi-page printout you want.
Read this ExcelTip: Printing a Chart Across Multiple Pages
Microsoft Excel Tips -
Learn Excel Faster!
Have you ever had problems with a document because you accidentally pressed a keyboard shortcut? The good news is that you can disable individual shortcuts. Here's how.
Read this WordTip: Disabling Track Changes Completely
Microsoft Word Tips -
Learn Word Faster!
Sorting information in a worksheet can be confusing when Excel applies sorting rules of which you are unaware. This is especially true when you are sorting a mixture of letters and numbers.
Read this ExcelTip: Sorting Letters and Numbers
Microsoft Excel Tips -
Learn Excel Faster!
Using the comment capabilities of Word is a common occurrence when developing a document. What do you do, however, if the dates associated with the comments periodically change?
Read this WordTip: Comment Dates Updated Inappropriately
Microsoft Word Tips -
Learn Word Faster!
Excel provides a couple of different ways that you can quickly duplicate drawing objects in a worksheet. Committing these shortcuts to memory will help make your work with drawing objects easier than ever.
Read this ExcelTip: Quickly Duplicating Drawing Objects
Microsoft Excel Tips -
Learn Excel Faster!
Part of the helpful information that Word provides on the status bar is designated by the labels "At" and "Ln." Here's what those designations mean.
Read this WordTip: Understanding the At and Ln Indicators
Microsoft Word Tips -
Learn Word Faster!
If your company closes out its accounting months at the end of each calendar quarter, figuring out the proper closing dates is a snap. It can be more challenging to figure out other closing dates, but it can be done by applying the techniques in this tip.
Read this ExcelTip: Monthly Close-Out Dates
Microsoft Excel Tips -
Learn Excel Faster!
The Equation Editor makes it easy to create and add equations to your documents. Here's how to adjust where the equation's superscripts appear in relation to the other equation elements.
Read this WordTip: Setting Superscript Height in the Equation Editor
Microsoft Word Tips -
Learn Word Faster!
When entering dates into a worksheet, you may want the dates to default to last year instead of this year. Here's a way you can accomplish this type of data input.
Read this ExcelTip: Modifying Default Year for Dates
Microsoft Excel Tips -
Learn Excel Faster!
WordPerfect users coming to Word may miss a feature called QuickWords. This tip examines some ways you can get around the lack of this feature in Word.
Read this WordTip: QuickWords in Word
Microsoft Word Tips -
Learn Word Faster!
If you have a worksheet protected, it may not be immediately evident that it really is protected. This tip explains some of the tell-tale signs you can use to determine if protection is in play.
Read this ExcelTip: Using a Protected Worksheet
Microsoft Excel Tips -
Learn Excel Faster!
If you need to move a graphic just a little bit in one direction or another, you can do so by using the techniques in this tip. (Hint: Using the keyboard to nudge a graphic is easiest.)
Read this WordTip: Nudging a Graphic
Microsoft Word Tips -
Learn Word Faster!
