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?

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?

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?

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?

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