# Auto Fill Data

## Content

SpreadJS provides you with the ability to automatically fill numbers, dates, strings, custom lists and other data in the columns of the worksheet. This allows users to save both time and effort while working with large spreadsheet applications containing bulk data.

Using auto-fill, you can quickly fill the cells with a series of data down an entire column. While carrying out the auto fill operations in the worksheet, the fill handle provides you with four different options - Copy Cells, Fill Series, Fill Formatting only and Fill Without Formatting.

You can auto fill data in the following ways :

* [Drag Fill](/spreadjs/docs/v17/features/cells/AutoFillData/dragfill)
* [Auto Fill Dates](/spreadjs/docs/v17/features/cells/AutoFillData/AutoFillDates)
* [Auto Fill Strings](/spreadjs/docs/v17/features/cells/AutoFillData/AutoFillStrings)
* [Auto Fill Lists](/spreadjs/docs/v17/features/cells/AutoFillData/AutoFillLists)
* [Using Double-click for Auto Fill](/spreadjs/docs/v17/features/cells/AutoFillData/UsingDouble-clickforAutoFill)