copy value from the cell above to the cell below in a 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, all the way down the column at once. 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.

Ctrl-D or edit-fill-fill down, works one at a time. But there is a way of
copying each employee's name to the blank cell below all at once, without
doing it individually.

can anyon help?

thanks

copy value from the cell above to the cell below in a column
 

See answers to your previous post

--
Don Guillett
SalesAid Software

"tarthur" wrote in message
...
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, all the way down the column at once. 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.

Ctrl-D or edit-fill-fill down, works one at a time. But there is a way of
copying each employee's name to the blank cell below all at once, without
doing it individually.

can anyon help?

thanks

copy value from the cell above to the cell below in a column
 

Hi tarthur. The following site - Contextures.com - has a way to do what you
want. http://www.contextures.com/xlDataEntry02.html
--
Sincerely, Michael Colvin


"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, all the way down the column at once. 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.

Ctrl-D or edit-fill-fill down, works one at a time. But there is a way of
copying each employee's name to the blank cell below all at once, without
doing it individually.

can anyon help?

thanks