Extremely simple instructions on how to fill in blank cells with 0 in Excel

For example, we have a spreadsheet as shown below. Requires entering zero in all blank cells to make the spreadsheet look better.

Extremely simple instructions on how to fill in blank cells with 0 in Excel Picture 1

Simple way to fill in blank cells with 0 in Excel

Step 1: First we need to select all of those cells by highlighting the entire spreadsheet. Then you select the Home tab on the Ribbon. Next, select the Find & Select magnifying glass icon . The scroll bar appears, select Go To Special. Or you can also use the keyboard shortcut Ctrl + G to quickly open the Go To Special window .

Step 2: At this point, the Go To window appears. Click on the Special section .

Step 3: The Go To Special window appears, select the Blanks section. Then click OK to complete

Step 4: At this point, all blank cells in the spreadsheet have been selected. To fill the value 0 into these cells, you just need to press F2 or click on the formula bar and enter the value 0. Then press Ctrl + Enter to copy all selected blank cells.

The result we get is that all blank cells have been filled with 0. The spreadsheet will no longer be as empty as before.

Extremely simple instructions on how to fill in blank cells with 0 in Excel Picture 2

Jessica Tanner

Update 04 April 2024