The Fill handle

My Courses Data Visualization in Excel Excel Navigation 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