Search

How to use Auto Fill in Sheets?

 

How to use Auto Fill in Sheets? Windows

Instead of entering all your data manually, you can use the AutoFill feature to fill cells with data that follows a pattern. Note that AutoFill works with numeric data, but not text. 

  1. Select one or more cells you want to use as a basis for filling additional cells.
  2. Drag a corner handle vertically or horizontally. 

 

How to use Auto Fill in Sheets? Android

Instead of entering all your data manually, you can use the AutoFill feature to fill cells with data that follows a pattern. Note that AutoFill works with numeric data, but not text. 

  1. Select one or more cells you want to use as a basis for filling additional cells.

  2. Tap on the selection, tap Auto fill on the floating toolbar. 

  3. Drag the handle vertically or horizontally. 
 
 

 

How to use Auto Fill in Sheets? iOS

Instead of entering all your data manually, you can use the AutoFill feature to fill cells with data that follows a pattern. Note that AutoFill works with numeric data, but not text. 

  1. Select one or more cells you want to use as a basis for filling additional cells.
  2. Tap Fill on the floating toolbar. 
  3. Drag the handle vertically or horizontally.