Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
copy value in cell above to cell below for a whole column
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? |
#3
|
|||
|
|||
copy value in cell above to cell below for a whole column
select the name and the blankseditfillfill down
-- 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. 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? |
#4
|
|||
|
|||
copy value in cell above to cell below for a whole column
"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, without doing each one individually. copy down the whole column at the same time. Can anyone help? |
#5
|
|||
|
|||
copy value in cell above to cell below for a whole column
Debra Dalgleish can!
http://contextures.com/xlDataEntry02.html tarthur wrote: "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, without doing each one individually. copy down the whole column at the same time. Can anyone help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy the url for a list of cell with hyperlinks in another column? | New Users to Excel | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
Copy the last cell in an Excel column to another cell | Excel Discussion (Misc queries) | |||
Copy one cell to entire column | Excel Discussion (Misc queries) | |||
How do I copy every 8th cell in a column | Excel Discussion (Misc queries) |