Want to see how your document will look before it's printed? Or, do you want to see what things will look like if you put your document on the web? Word allows you to easily view your document in a few different ways. Here's how.
Read this WordTip: Understanding Views
Microsoft Word Tips -
Learn Word Faster!
When you check the spelling of worksheet data, you may want to spell checker to either ignore or check Internet addresses such as URLs and e-mail addresses. This tip shows how you can make a configuration change that will enforce your desires.
Read this ExcelTip: Adjusting Spell Check for Internet Addresses
Microsoft Excel Tips -
Learn Excel Faster!
Word includes the ability to display toolbar icons in two sizes: regular and large. You can turn on the large icons by using the Customize dialog box, or you can turn them on in a macro, as described in this tip.
Read this WordTip: Turning on Large Icons in a Macro
Microsoft Word Tips -
Learn Word Faster!
Want information in a worksheet to be formatted and displayed as rounded to a power of ten? You may be out of luck, unless you want to round to either the nearest thousand or million. Here's why.
Read this ExcelTip: Altering the Displayed Format of Numbers to the Nearest 100
Microsoft Excel Tips -
Learn Excel Faster!
You get a document from a colleague and you notice that each paragraph starts with a tab character. Here are a couple of ways to get rid of those extraneous tabs very easily.
Read this WordTip: Removing Tabs Used to Indent a Paragraph
Microsoft Word Tips -
Learn Word Faster!
If you need to input humongous times into a worksheet, you may run into a problem if you need to enter times greater than 10,000 hours. This tip explains the full problem and provides some ideas on getting around the problem.
Read this ExcelTip: Entering Large Time Values
Microsoft Excel Tips -
Learn Excel Faster!
What do you do if, one day, one of your Word menus suddenly stops working and actually crashes the program? Here's the details of what one Word user did to solve the problem.
Read this WordTip: Problem with Menus Crashing Word
Microsoft Word Tips -
Learn Word Faster!
When you use Excel to input and store information, you need to be concerned with whether the information meets your expectations. For instance, you may want to make sure that each row has a value in only one of two columns, and not in both columns. This tip examines ways you can find where the data doesn't meet this expectation.
Read this ExcelTip: Finding Rows with Values in Two Columns
Microsoft Excel Tips -
Learn Excel Faster!
If you do a spelling check and notice that Word doesn't catch a word that you know is misspelled, it is easy to get frustrated. The reasons for the misses could be many, as explored in this tip.
Read this WordTip: Spell Check Misses Misspelled Words
Microsoft Word Tips -
Learn Word Faster!
Need to keep different areas of the same worksheet in view at the same time? Excel makes this relatively easy through the use of panes, as described in this tip.
Read this ExcelTip: Splitting Your Spreadsheet Window Into Panes
Microsoft Excel Tips -
Learn Excel Faster!
Word is a program designed to work in and with multiple languages. This can lead to some problems, however, for those users who end up with documents formatted for multiple languages. This tip explains some of the ways you can force a document to pay attention to a single language rather than multiple languages.
Read this WordTip: Stubborn Foreign Languages
Microsoft Word Tips -
Learn Word Faster!
Want to convert an elapsed time, such as 8:37, to a decimal time, such as 8.62? If you know how Excel stores times internally, coming up with the conversion formula is a snap.
Read this ExcelTip: Converting Time Notation to Decimal Notation
Microsoft Excel Tips -
Learn Excel Faster!
For some documents, you may not want spell checking turned on. There are two ways that you can turn it off, depending on whether you want to affect the entire document or only a portion of one. This tip covers both methods.
Read this WordTip: Turning Off Spell Checking
Microsoft Word Tips -
Learn Word Faster!
You can configure images in Excel so that if someone clicks on them, a macro is executed. You cannot, however, have a macro and a traditional ScreenTip tied to the same object. This tip explains how you can get around this limitation using two separate techniques.
Read this ExcelTip: ScreenTip for an Image
Microsoft Excel Tips -
Learn Excel Faster!
The Outlining toolbar contains tools that are helpful to use, even if you aren't working on your document's outline. This tip explains how you can ensure that the Outlining toolbar is always displayed, as well as a way to access the desired tools even without the toolbar visible.
Read this WordTip: Displaying the Outlining Toolbar by Default
Microsoft Word Tips -
Learn Word Faster!
Need to get rid of all the hyperlinks in a worksheet? It's easy when you use this single-line macro.
Read this ExcelTip: Getting Rid of All Hyperlinks
Microsoft Excel Tips -
Learn Excel Faster!
When you add a comment to a document, Word presents that comment in a very specific way. If you want to change the way in which the comment is displayed, you are, unfortunately, out of luck.
Read this WordTip: Getting Rid of "Comment" in Comments
Microsoft Word Tips -
Learn Word Faster!
Want to add some spice to the graphics in your worksheets? There are many colors and effects in Excel that allow you take the outline of an object and add a little extra punch to your project.
Read this ExcelTip: Filling a Drawing Object
Microsoft Excel Tips -
Learn Excel Faster!
