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

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"tarthur" <tarthur@discussions.microsoft.com> wrote in message
news:FC22350E-35A4-4625-A1FB-A4130F90B1FC@microsoft.com...
> 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?

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?

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?

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

--
Don Guillett
SalesAid Software
donaldb@281.com
"tarthur" <tarthur@discussions.microsoft.com> wrote in message
news:FC22350E-35A4-4625-A1FB-A4130F90B1FC@microsoft.com...
> 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" 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?

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