Category Archives: Basic Excel Tutorials

Tutorials on the basics of Microsoft Excel

How to use Auto Fill in Excel

How to use Auto Fill in Microsoft Excel

A tutorial showing how to automatically copy or increment data in Excel spreadsheet cells using Auto Fill.


Data in a spreadsheet cell can be filled into other cells just by dragging the cell down or double-clicking on the last row in a series.

The Auto Fill can either repeat the contents of cells or increment the contents of cells and formulas. Sometimes the autofill will increment when you wish to repeat. You have the option to correct this after the Auto Fill takes place by clicking on the autofill options.
Continue reading How to use Auto Fill in Excel