Follow these steps to fill blank cells in an Excel 2003 worksheet.
Start by selecting the empty cells:
- Select the cells in the column, starting in the row below the column heading.
- Choose Edit | Go To
- Click the Special button
- Select Blanks, click OK
Enter the formula to copy the value:
- Type an equal sign
- Press the up arrow on the keyboard — this will enter a reference to the cell above — cell A2 in this example
- Hold the Ctrl key and press Enter — this enters the formula in all selected cells
Change the formulas to values:
In order to sort or filter the data, the formulas must be changed to values.
- Select the entire column
- Choose Edit | Copy
- With the column still selected, choose Edit | Paste Special
- Select Values, click OK
Note: Do this carefully if there are other cells in the range which contain formulas.