If Cells are Blank I want it to Automatically fill

[bigmacneb]

Hello,
I have a spreadsheet with data in very sporadic numbers in cells with many cells which are blank. Is there a way to fill only the blank cells with the number 1?

Many, many thanks

 

[barry houdini]

You could use Edit > Replace to replace nothing with 1

make sure that you choose the "match entire cell contents" option

 

[bigmacneb]

Excellent tip, didn't even think of that, however is there then a way to exclude certain columns?

 

[bigmacneb]

Nevermind, I figure I'll just select the proper columns, many thanks!

 

[Dsuperc]

Highlite the area with the cells you want to fill,Edit, go to, Special, Blanks, in the formula bar enter =1, hit Ctrl + Enter. Then copy and paste special, values.