![]() |
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. |
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