The Fill handle

Lesson map

The last topic we covered the Formula Bar and Navigator – something you’ll always use in Excel. 

This topic, we will learn about the Autofill Handle – and what it can do.  

The AutoFill handle is a feature that enables you to auto-complete cells/columns/rows by dragging from the active cell. Let’s find out how we can use it with numbers and words when loading data into our Excel sheet.

Keep an eye out for the questions in the video!

The Auto fill handle is used to:

  • Copy items across cells
  • Extend numerical values following a pattern
  • Incrementing days, numbers and dates
  • Copying formulas