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

G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy value from the cell above to the cell below in a column 2
How to make a blank cell to automatically copy what is above 1
Copying the Cell Above 5
Fill in Blanks with immediately above cell value 8
Copy value from cell above 6
copy cell value 3
Shortcut for copying the cell above 4
copy value from cell above 4

Top