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

[tarthur]

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?

[Don Guillett]

select the name and the blanks>edit>fill>fill down

--
Don Guillett
SalesAid Software
[email protected]
"tarthur" <[email protected]> wrote in message
news:[email protected]...
> 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?

[vonpookie]

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?

[Don Guillett]

select the name and the blanks>edit>fill>fill down

--
Don Guillett
SalesAid Software
[email protected]
"tarthur" <[email protected]> wrote in message
news:[email protected]...
> 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?

[tarthur]

"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]

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