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.
- Select one or more cells you want to use as a basis for filling additional cells.
- Drag a corner handle vertically or horizontally.