Automatically Fill Empty Cells in a Column

D

Deignan

Is it possible to automatically fill empty cells in a column with the data in the cell above it?
 
A

Andy B

Hi

Select the column / range. Then Edit / Go to / Special / Blanks. This will
select all of the blank cells in the range. Type = and hit the up arrow and
then type Ctrl Enter. To fix these values use Copy then Paste Special /
Values.

--
Andy.


Deignan said:
Is it possible to automatically fill empty cells in a column with the data
Click to expand...
in the cell above it?
 
Top