ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/184957-blank-cells.html)

mcp201

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.

Peo Sjoblom

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.





All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com