excel data entry help

Question

Hi all,

i have a column like the following:

1 red
2 blue
3 red
4 
5 blue
6
7
8 white

the blanks refer to the record above it. so #4 would be associated with red and 6 and 7 would be blue. is there an easy way to fill in the blanks for entire column?

thanks,

rod.

Answer 1

Select A1:A8. Press F5 to show the Goto dialog. Click Special. Select Blanks and click OK. That will select a noncontiguous range of blank cells. Then, without selecting anything else, type =A3 and press Control+Enter. That will enter an array formula in all the blank cells referring to the cell above it. Reselect A1:A8, and Edit - Copy. Then Edit - Paste Special - Values. And you're all set.

Note that the =A3 refers to the cell above the first blank cell.