FILL BLANK CELLS IN EXCEL

CLICK HERE FOR SOURCE
How to Fill Blank Cells in a Data Table in MS Excel

Daily users of Excel often work with large tables of data. Excel’s functionality can be impaired or limited by blank cells within data. The solution is to fill blank cells with zeros. If the table is small, typing zeros in blank cells is easy to do, but if you’re dealing with thousands of rows of data, manually filling blank cells can take a while. Here’s a quick, easy way to fill blank cells.



1.
Step 1

Highlight your row, column, or table of data containing the blank cells. Click on the Edit menu across the top of the screen and choose Go To.
2.
Step 2

When the Go To window appears, click on the Special button in the lower left corner.
3.
Step 3

Click the radio button to the left of Blanks in the first column, then click the OK button.
4.
Step 4

Notice that all your blank cells have been highlighted.
5.
Step 5

Again, click on the Edit menu across the top of the screen. This time, choose Replace.
6.
Step 6

When the Replace window appears, leave the Find What box blank and enter 0 in the Replace With box. Click the Replace All button.
7.
Step 7

Voila! All blank cells now contain zeros.