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 will recognize patterns within selected data and apply those patterns to newly created data in adjacent cells.
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.
In the animation 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.
Using autofill can help save time and prevent errors that can be caused by manually inputting incremental or sequential data. For more information about the data types supported by autofill, check out our Introduction to Data Types.