Training Guides

Microsoft Tips

Mobile Devices


Related Links


Excel Tips

Document Recovery to the Rescue:

Excel 2002 offers a new document recovery feature that can help you in the event of a computer crash because of a power failure or some sort of operating system freeze or shutdown. The AutoRecover feature saves your workbooks on regular intervals. In the event of a computer crash, Excel displays a Document Recovery task pane the next time you start Excel after rebooting your computer. When you first start using Excel 2002, the AutoRecover feature is set to automatically save changes to your workbook every ten minutes. You can shorten or lengthen this interval as you see fit. Choose Tools, Options, and then click the Save tab. Use the spinner buttons or enter a new automatic save interval into the text box marked "Save AutoRecover Info Every 10 Minutes" before clicking OK. Note that the AutoRecover feature works only on Excel workbooks that you have saved at least one time. In other words, if you build a new workbook and don't bother to save and rename it prior to experiencing a computer crash, the AutoRecover feature will not bring back any part of it. For this reason, it is very, very important that you get into the habit of saving new workbooks with File, Save very shortly after beginning work on one of its worksheets. Or, you can use the trusty keyboard shortcut Ctrl+S.

From Header to Footer:

Headers and footers are simply standard text that appears on every page of the report. The header prints in the top margin of the page, and the footer prints -- you guessed it -- in the bottom margin. Both are centered vertically in the margins. Unless you specify otherwise, Excel automatically adds a header that shows the name of the worksheet you are printing (as shown on its sheet tab) and a footer that shows the current page number. If you don't want a header or footer printed in your report, you simply open the Header/Footer tab in the Page Setup dialog box and then select the (none) option at the very top of the Header and Footer drop-down list box.

Show Your Stripes:

Here's a quick way to apply shading to every other row in your worksheet. This technique assumes that you want to shade every odd-numbered row in the range A1:f100. Start by shading A1:F1 with the color that you want. Then, select A1:F2 (row 1 is shaded and row 2 is not) and copy the range to the clipboard. Next, select A3:F100 and choose Edit, Paste Special (with the Formats option).