See all How-To Articles

How to Turn On AutoFill in Excel

This tutorial demonstrates how to enable and turn on the AutoFill option in Excel.

 

disable turn off autofill option excel

 

Enable AutoFill

If the AutoFill option is disabled in Excel and you want to enable it, you’ll need to change Excel settings.

  1. First, open Excel and select Options at the end of the menu.

 

excel ruler unit

 

Note: If you are already in an Excel workbook, select File > Options.

  1. Now, select Advanced and go to the Editing options section. Here, ensure that the option Enable fill handle and cell drag-and-drop is checked and click OK.

 

enable autofill option excel

 

If you try to use the fill handle now by dragging down on the values in cells A1 and A2, you’ll see that the cells are populated, and AutoFill is working.

 

autofill option turn on