This was VERY helpful and a lot easier to use than a 'special marco toolbar'
I use to have installed. Also, in excel 2007 go to Home, Find & Select, Go
To... then follow the instructions below " Special Blanks OK, then type =,
press the up arrow key once, then press Ctrl-Enter. Then copy the entire
column and pastespecial as values."


"Bernie Deitrick" wrote:

Peter,

Select the cells, use Edit / Go To... Special Blanks OK, then type =, press the up arrow key
once, then press Ctrl-Enter. Then copy the entire column and pastespecial as values.

HTH,
Bernie
MS Excel MVP


"Peter Langdon" wrote in message
...
How do I automatically copy a cell into all blank cells beneath it without
having to repeat for each range? I need to autofill all blanks beneath each
entry in order to populate a pivot table.

current desired

TEXT1 TEXT1
TEXT1
TEXT1
TEXT2 TEXT2
TEXT2
TEXT2
TEXT2
TEXT3 TEXT3
TEXT3
--
pl