Discussion on:

Quickly fill blank cells in Excel

I can definately use this tip and appreciate quick "how-to" posts like this one.

If PivotTables could fill in the blanks itself for columns that would be better. This tip is still a lot better than the nested if statements I use to recreate the column to fill in blanks.

And another great tip. Didn't realize the functionality about [Ctrl]+[Enter]. Certainly will save me from some extra copy-paste steps.

Thanks, Susan

I wasn't aware of the ability to select all blanks so that is a definite handy thing to keep in mind.

Elsewise however, I find it alot faster to just use CTRL-D to fill in repeated values. (The keyboard shortcut for Edit, Fill, Down.)

Thanks...Nice tip!

I always appreciate these posts. There are occasional gems. This is one of them.

thank's a lot

Great tip!

Great tip! Thanks

thnx for the info.....