fill blank cells with specific value


Posted by REbecca johnson on January 16, 2002 1:32 PM

is there a quick way i can fill all blank cells in a spreadsheet with a specific value? Thanks



Posted by Gary Bailey on January 16, 2002 1:40 PM

Yes. Try Edit->GoTo->Special and select "blank". You should see all the blank cells in the used part of the active worksheet selected.

Enter the value you want and press Ctrl+Enter.

If you want to enter the value into blanks for the whole spreadsheet (all 65536x256 cells of it) make an entry in cell IV65536 first. It'll take a while though.

Gary