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.
- Enter enough data to establish a pattern and then select the cells containing the pattern.
- Click on the Fill Handle, which is located in the bottom right cell of the selected cells.
- Drag the Fill Handle for as many rows or columns as desired.
Examples of scenarios in which it might be useful to use the Fill Handle include:
- Entering a numbered list.
- Entering days of the month.
- Entering months of the year.
- Entering yet to be named items which need to be differentiated.
- Copying formulas throughout a row or column.
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.