How to Turn On AutoFill in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on July 9, 2022

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

AI Formula Generator

Try for Free

See all How-To Articles