Microsoft Office Tutorials and References
In Depth Information
If the report is small, you can enter the missing cell values manually or by using a series of Home ⇒ Editin-
g ⇒ Fill ⇒ Down commands (or its Ctrl+D shortcut). If you have a large list that's in this format, here's a better
1. Select the range that has the gaps (A3:A14, in this example).
2. Choose Home ⇒ Editing ⇒ Find & Select ⇒ Go to Special to display the Go to Special dialog box.
3. In the Go to Special dialog box, select the Blanks option and click OK. This action selects the blank cells in
the original selection.
4. In the formula bar, type an equal sign ( = ) followed by the address of the first cell with an entry in the
column ( =A3, in this example), and then press Ctrl+Enter.
5. Reselect the original range and press Ctrl+C to copy the selection.
6. Choose Home ⇒ Clipboard ⇒ Paste ⇒ Paste Values to convert the formulas to values.
After you complete these steps, the gaps are filled in with the correct information, and your worksheet looks
similar to the one shown in Figure 16-21.
Figure 16-21: The gaps are gone, and this list can now be sorted.
If you use a word processing program, you probably take advantage of its spelling checker feature. Spelling
mistakes can be embarrassing when they appear in a text document, but they can cause serious problems when