Select the column.

F5SpecialBlanksOK

In active blank cell type an = sign the point or arrow to cell above/

CTRL + ENTER to fill in.

Copy/paste special(in place)valuesokesc.


Gord Dibben MS Excel MVP

On Fri, 9 Jan 2009 11:05:09 -0800, rodchar
wrote:

hey all,

i have a single column of rows

id,type
1,phone
2,
3,
4,email
5,
6,

is there an easy way to fill in the blanks with the previous non-blank type?

like this?

1,phone
2,phone
3,phone
4,email
5,email
6,email

thanks,
rodchar