How to Enable the Fill Handle in Excel 2013

Manually entering a series of numbers into an Excel row or column can be tedious. It’s easy to start typing too quickly and enter an incorrect character, or even to enter the wrong number entirely. Excel 2013 has a tool called the fill handle, however, which can make it much simpler to fill a series of cells with numbers.

But the option for the fill handle in Excel 2013 can be turned on or off, so you might find that it is not working as you would expect. Our guide below will point you to the fill handle setting so that you can turn it back on and start taking advantage of this very useful feature.

If you would like to be able to use cursive or script fonts in Word and Excel, then our signature font in Word tutorial can show you how.

Turning on the Excel 2013 Fill Handle

The steps below assume that you are currently unable to use the fill handle in Excel 2013. If you are using Excel 2010 then the method for enabling the fill handle is very similar, but you can click here to read the directions for that Excel version instead.

Step 1: Open Excel 2013.

Step 2: Click the File tab at the top-left corner of the window.

click the file tab

Step 3: Click Options at the bottom of the column on the left side of the window. This opens a window titled Excel Options.

click options in the left column

Step 4: Click the Advanced button in the column at the left side of the Excel Options window.

click the advanced tab

Step 5: Check the box to the left of Enable fill handle and cell drag-and-drop. You can also select whether or not you would like Excel to alert you if you are about to overwrite a cell. Once you are finished, click the OK button at the bottom of the window.

enable the fill handle in excel 2013

Would you like to make repeated data entry in Excel 2013 a little faster? Learn about the AutoComplete option and see if it is something that will improve your experience with the program.

Additional Sources

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy