Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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

Re: fill blank cells with specific value

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.