When doing a pivot table, the data in a column might have the initial
cell inditifer, such as a date and the remaining cells if they have
the same date will be blank. I know there is a process that you can
highlight the cells in a range and have copied the initial cell into
the next suceeding blank cells, I just don't remember the sequence of
steps to get there. can anybod help?

Select the column with data.

F5>Special>Blanks>OK

Type an = sign in active blank cell.

Arrow or point to cell above.

CTRL + Enter to fill all blanks with value from above.


Gord Dibben MS Excel MVP

On Mon, 24 Aug 2009 14:11:55 -0700 (PDT), freeriderxlt <(E-Mail Removed)>
wrote:

>When doing a pivot table, the data in a column might have the initial
>cell inditifer, such as a date and the remaining cells if they have
>the same date will be blank. I know there is a process that you can
>highlight the cells in a range and have copied the initial cell into
>the next suceeding blank cells, I just don't remember the sequence of
>steps to get there. can anybod help?

There is also a very usefull macro here:

http://www.ozgrid.com/Excel/excel-fill-blank-cells.htm