How to Use the Fill Handle in Microsoft Excel

If your Excel data follows a pattern, you can use the Fill Handle to quickly and easily add data to multiple rows and columns.

This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.

  1. Enter enough data to establish a pattern and then select the cells containing the pattern.
    Select Cells

  2. Click on the Fill Handle, which is located in the bottom right cell of the selected cells.
    Click Fill Handle

  3. Drag the Fill Handle for as many rows or columns as desired.
    Drag Fill Handle

Examples of scenarios in which it might be useful to use the Fill Handle include:

  1. Entering a numbered list.
    Numbered List

  2. Entering days of the month.
    Days of the Month

  3. Entering months of the year.
    Months of the Year

  4. Entering yet to be named items which need to be differentiated.
    Enter Unnamed Items

  5. Copying formulas throughout a row or column.

Related Video

Author: Dave Dunn

Dave Dunn, Webucator’s CEO, joined Webucator in 2009 after serving as a CFO and COO for numerous small and medium-sized companies, including Summit Software Company, Insight Research Group, Avalon Consulting, and HealthcareOne. Dave received his Bachelor of Arts from Hamilton College and his MBA from Syracuse University. He has served as Chairman of the Board of the Montessori School of Syracuse since 2001.

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.