How to Fill Blank Cells in an Excel Worksheet
- First, select the range that contains blanks you need to fill. Choose Go To Special from the Find dropdown list in the Editing group on the Home tab. ...
- Select Blanks. ...
- When you click OK, Excel will select all the blank cells in the selected range.
How do I fill blanks with 0 in Excel?
Alternatively, you can click the Home tab in the Ribbon and then select Go to Special from the Find & Select drop-down menu. Select Blanks in the Go To Special dialog box and click OK. Excel will select all of the blank cells within the range. Type the value you want to enter in the blanks (such as 0, – or text).