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

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I copied Visible Cells Only, but it pastes only the first cell 1
how to return "summary" of all non-blank cells plus their headers 10
Macro to loop through a named range, ignoring empty cells 1
Pivot Table (blank) Cells 3
MACRO RUN random percentage and copy of column values 1
Macro for Copying 3
Concat a three column range into one cell Then Next... 2
Unmerging and populating merged cells by column 3

Top