F5SpecialBlanksOK

Type an = sign in active blank cell.

Point or arrow up to cell above.

Hit CTRL + Enter

Copy then paste special(in place)valuesOKesc


Gord Dibben MS Excel MVP

On Tue, 3 Mar 2009 07:12:01 -0800, PAF
wrote:

I have a spreadsheet exported from a report file that has blank cells for
grouped data. There are 5 columns in the worksheet and 2 of these are group
fields. Is there a quick way that I can fill down to fill in the blanks for a
variable number of rows.