It’s useful to fill blank cells with a number, symbol or value if you want to use the data set as the source for a pivot table or use other data analysis tools.
You can quickly replace blank cells in Excel with zeros, dashes or other number or text values (0, -, N/A, Null or other text).
Quickly Fill Blanks with Zeros or Other Values in Excel Worksheets (0, -, N/A, Null or Other Text)īy Avantix Learning Team | Updated August 7, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)
