Select the column and F5SpecialBlanksOK

Type an = sign in active blank cell then point or arrow to cell above.

CTRL + ENTER to fill the blank cells.

Copy/paste special.values/ok/esc


Gord Dibben MS Excel MVP

On Wed, 29 Oct 2008 08:40:06 -0700, khuff
wrote:

I have a list of names in alphabetical order that occur in one column with
about 20 blank lines between each consecutive name.

Is there a tool in excel that will auto populate the cells directly below
each name with out having to copy/paste each. (there can be up to 500 names)
I tried to set up a macro but no luck.