Fill in the blanks and autofill formulas in Google Sheets

Hidden & filtered rows

At the moment, the add-on processes hidden and filtered cells as well. It fills hidden/filtered blanks with values and copies values from hidden/filtered cells to the neighboring blanks.

Multiple ranges

If you select multiple ranges (even non-adjacent ones), the add-on will fill blank cells in each range accordingly.

Start the add-on

1. Go to Extensions > Power Tools > Start to run the collection first:
   
2. Proceed to the Process group:
   
3. Once you see the Fill blank cells icon, click on it to access the add-on:
   

How to autofill blank cells in Google Sheets

Select the range in your Google Sheets where you want to fill in the blanks and pick the way to do that:

1. Choose the contents that will fill your blank cells:
   • Fill with the existing values will fill all blanks in the selection with the existing records from nearby cells:
     
   • To replace blank cells in Google Sheets with zeros (0) or any other value of your choice, pick Fill with a custom value and enter the desired record in a field right below:
     
   • Select Autofill formulas and the tool will copy existing formulas into empty cells and adjust cell references accordingly at the same:
     
2. Pick the direction in which you'd like to fill in the blanks:
   
   • downward will replace blank cells in Google Sheets with the values from cells above them:
     
   • upward will replace empty cells with the values from cells below them:
     
   • rightward will fill in the blanks on the right with records from cells on their left:
     
   • leftward, on the contrary, will copy the values and paste them into empty cells on their left: