Microsoft Office Tutorials and References
In Depth Information
When you import data, you can end up with a worksheet that looks something like the one in the accompanying
figure. In this example, an entry in column A applies to several rows of data. If you sort such a range, you can end
up with a mess, and you won't be able to tell who sold what.
When you have a small range, you can type the missing cell values manually. If your list has hundreds of rows,
though, you need a better way of filling in those cell values. Here's how:
1. Select the range (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.
4. Click OK to close the Go To Special dialog box.
5. In the Formula bar, type = , followed by the address of the first cell with an entry in the column ( =A3 in this ex-
ample), and then press Ctrl+Enter to copy that formula to all selected cells.
6. Reselect the range from step #1 and press Ctrl+C.
7. Choose Home⇒Clipboard⇒Paste Values (V).
Each blank cell in the column is filled with data from above.
Converting a table to a list
In some cases, you may need to convert a table back to a normal list. For example, you may need to share your
workbook with someone who uses an older version of Excel. Or, maybe you'd like the use the Custom Views
feature (which is disabled when the workbook contains a table). To convert a table to a normal list, just select a