Using the Fill Handle

Contact Us or call 1-877-932-8228
Using the Fill Handle

Using the Fill Handle

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

To use the Fill Handle:

  1. Enter enough data to establish a pattern and then select the cells containing the pattern:Selected Cells
  2. Click on the Fill Handle, which is located in the bottom right cell of the selected cells: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:Fill Handle
  2. Entering days of the month:Fill Handle
  3. Entering months of the year:Fill Handle
  4. Entering yet to be named items which need to be differentiated:Fill Handle
  5. Copying formulas throughout a row or column. This will be covered later in this course.