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

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?

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

"tarthur" wrote:

> 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?