Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cells
Is there an option in Microsoft Excel 2003 to fill in blank cells with a "0"
without having to manually do it? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cells
This is manually but not cell after cell.
Select the range in question, press F5, select Special, select Blanks and press enter or click OK. Type a zero and enter it with ctrl + enter instead of enter -- Regards, Peo Sjoblom "mcp201" wrote in message ... Is there an option in Microsoft Excel 2003 to fill in blank cells with a "0" without having to manually do it? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
How to count blank cells (Rows) between Non-Blank cells in Col "A" | Excel Discussion (Misc queries) | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions |