copy value in cell above to cell below for a whole column

T

tarthur

I have a spreadsheet that was saved from a report. this report only lists
the employee name once. There is a way to copy the value of the cell above
to the cell below. I can get as far as highlighting the blank cells with the
Go To function, then I can not remember the steps to tell excel to copy the
data into the blank cells.

Can anyone help?
 
V

vonpookie

Ctrl+D will copydown the value of the top cell to the highlighted cells below.
 
T

tarthur

tarthur said:
I have a spreadsheet that was saved from a report. this report only lists
the employee name once. There is a way to copy the value of the cell above
to the cell below. I can get as far as highlighting the blank cells with the
Go To function, then I can not remember the steps to tell excel to copy the
data into the blank cells, without doing each one individually. copy down the whole column at the same time.

Can anyone help?
Click to expand...
 
Top