Adding Data to Existing Worksheets via Autofill

Autofill helps reduce manual iterative data entry by automatically inputting incremented values into adjacent cells.

Similar to traditional spreadsheets, Spreadsheet.com supports autofill functionality to help reduce manual iterative data entry by automatically inputting incremented values into adjacent rows or columns.

Autofill supports four data types: ranges of numbers (including numerical data types like Ratings), currencies, dates (including abbreviations for days and months), and strings with a sequence of numbers. Autofill recognizes patterns within selected data and apply those patterns to newly created data in adjacent cells. Autofill also recognizes patterns in formatting and applies those as well.

Using autofill can help save time and prevent errors that can be caused by manually inputting incremental or sequential data.

How to Autofill Data

First, select the data from which you would like autofill to recognize a pattern and apply that to data in new rows or columns. Then, click and hold the small blue box in the lower right corner of your selection as you drag over to adjacent rows or columns.

Autofill works for filling columns as well as rows.

Column-Autofill.gif

Row-Autofill.gif

In the example above, notice how autofill is recognizing the different increments found in each selection. In row 1, where the values are 1 and 2, autofill increments the new data by a factor of 1; in row 2, where the values are 10 and 20, autofill increments the data by a factor of 10.

For more information about the data types supported by autofill, visit our Introduction to Data Types.