Skip to content
Guides
Sheets Mega ToolsGoogle Workspace add-on

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.

Not currently available

This URL is retained for existing links, but the feature is not available in the production add-on. Use the related shipped tools below, or return to the documentation index.

Browse available guides

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