Before you go about deleting rows and columns helter-skelter, it is a good idea to determine if there is anything in the row or column you are going to delete. Here's the quick way to figure out whether a row or column is empty.
When creating an e-mail address hyperlink using the Insert Hyperlink dialog box, Excel allows you to enter a subject for the message to be created by the link. If you want to also specify some body text, you need to use the techniques described in this tip.
If you ever open a workbook and always see two workbooks instead of one, chances are good the reason is because of the number of windows you've saved in the workbook. Here's how to get back to only a single window being visible.
Some symbols can be easily changed in Excel or in Windows, such as the symbols used for currency and to separate thousands in numbers. Other symbols are more difficult to change. It is this latter group into which the percent symbol falls, as illustrated in this tip.
When you construct a formula and click on a cell in a different workbook, an absolute reference to that cell is placed in the formula. There is no way to tell Excel you want the references to be relative, but there are some things you can try to change the references.
Place an ampersand into the text of a page header or footer, and you might be surprised to see it missing in your printout. This is due to the way in which Excel interprets the ampersand. Here's how to get around the problem.