Fill Blank Cells With Zero In Excel

Let’s see how to fill the blank cells in a sheet with 0 in excel.

We often come across a situation where we have to fill the blanks with 0 or with any value that serves our purpose.

We will see an easy example as to how to fill the blank cell with 0 in excel.

Below is the sample data in which we want to fill blank with 0.

Capture




Step 1

Select the data part in the table and press keyboard shortcut Ctrl+G to open the Go to option in excel.

Capture

Step 2

Click on “Special” option at the bottom left corner and select the blank, press OK.

Capture

Step 3

It will show you all the cells in your selection with blank.

Capture

Step 4




Now press F2, enter “0” and press Ctrl+Enter to populate all the blank cells with 0.

Capture

Capture

Hope this helped.

 

Share The Knowledge

Random Posts

Leave a Reply