Fill in a series of data

(uplifting background music) - [Instructor] You can use your mouse to create patterns of data to very quickly fill Excel rows or columns. Enter a value in a cell, and hover your mouse over the bottom right-hand side of the cell. When the cursor changes to a crosshair icon, drag through all the rows you want to fill with that value. To work with a series, start the series, select both cells, but only drag down on the last one.

You can count by odd numbers, even numbers, you can even count by fives. This also works for columns, and you don't have to use numbers. Let's do it one more time with the months of the year. (uplifting background music)