Assume A1 has a name.
Select column A.
Hit F5 and SpecialBlanks.
Enter an = sign in the active cell then point to cell above and hit CRTL +
ENTER.
With column A still selected, copy and in place Paste SpecialValuesOKEsc.
Gord Dibben Excel MVP
On Wed, 24 Nov 2004 11:09:07 -0800, "S. Kissing" <S.
wrote:
I have a large spreadsheet, it has names and blanks in column A. I want to
fill in the blanks with the name above the blanks with out having to do it
manually. Any ides???