Hyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a hyperlink, you may wonder why the link doesn't act the same as the original hyperlink. Here's why.
Programmers know that a staple of any language is the ability to create conditional statements. Excel understands this, as well, so it provides the IF worksheet function that allows you to evaluate an expression and thereby conditionally choose a result.
The Organizer is a great tool for, well, organizing the information stored in your templates. This tip introduces the Organizer, gives an overview of what it can do, and provides information on how to display this handy tool.
The advanced filtering feature in Excel allows you to quickly copy unique information from one data list to another. If you want to copy the comments associated with that information, you are out of luck; advanced filtering won't do it. There are workarounds you can use to get the same result, however.
If you decide to create a master document, it is easy to do by just adding one or more subdocuments to an existing document. This tip shows how you can use the outlining capabilities of Word to accomplish the task.
Read this WordTip: Creating a Master Document Using Existing Subdocuments
Microsoft Word Tips - Learn Word Faster!
Your laser printer probably does a great job in putting black type on the paper. If you want to print gray tones, the results might not be so great. Here is a tip on a way you might be able to get even better looking gray tones from that printer.