copy an intial cells contents into the next series of blank cells ina column

  • Thread starter Thread starter freeriderxlt
  • Start date Start date
F

freeriderxlt

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
 
Back
Top