Guides

Sheets Mega Tools

Fill Blank Cells

Intelligently fill blank cells in Google Sheets™ using nearby patterns, values from above or below, or custom defaults to clean up your data instantly.

Fill Blank Cells will help you populate blanks using surrounding context or default values.

Coming soon: This feature is under development. This page will be expanded with screenshots and detailed steps once the feature ships.

Planned workflow

  • Select a range with blanks you want to fill
  • Pick a fill strategy: propagate nearest value, average, or custom default
  • Preview suggested fills and accept or undo