How to Use the Fill Handle in Microsoft Excel

See Microsoft Excel: Tips and Tricks for similar articles.

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.