How to make a blank cell to automatically copy what is above

[Guest]

I have an excel report in which if the value of cell or a number of cells
below are the same as above, then it is left blank.

I want to know if there is formula I can apply to the whole column so that
if there is no value in any cell, it automatically enters the value from the
cell above, but do not alter if a cell has any values

 

[Ron Coderre]

Try this

Select the range to be impacted (from the column heading through the last
blank cell that *should* have a value)
<edit><go to>
......Click [special]
......Check: Blanks
......Click [OK]

Now only the blank cells are selected.

WHILE THEY ARE SELECTED....
Type =.....press the UP ARROW key........Hold down the [Ctrl] key and
press [Enter]

Now every blank cell will reference the cell above it.

If you need values instead of formulas...
Select the range
<edit><copy>
<edit><paste special>....Check: Values........Press [enter]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)