Excel TutorialLesson 7Free preview

Excel Fill

This lesson is part of Excel · All levels

Summary

Fill is the ability of Excel to copy the contents or continue the pattern of an array by simply dragging the fill handle. Excel recognizes patterns like 1, 2, 3 or Monday, Tuesday, Wednesday and then proceeds to it intelligently. You can also set through the Fill > Series menu to create a series with a certain step, date, or minimum-maximum number.

Key points

Fill handle is a small dot in the bottom right corner of the selection
Drag two cells containing 1 and 2 will continue the sequence 3, 4, 5, and so on.
Fill options: Copy Cells, Fill Series, Fill Formatting Only, Fill Without Formatting
Home > Fill > Series used for a sequence with precise steps and date ranges

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.