Page 13 of 22PREVNEXT

Audio course: Get to know Excel: Create your first workbook

Excel has a quick way to enter data in a series, such as the months of the year.

Here are two timesavers you can use to enter data in Excel:

AutoFill    Enter the months of the year, the days of the week, multiples of 2 or 3, or other data in a series. You type one or more entries, and then extend the series.

Click Play on the left to see how.

AutoComplete     If the first few letters you type in a cell match an entry you've already made in that column, Excel will fill in the remaining characters for you. Just press ENTER when you see them added. This works for text or for text with numbers. It does not work for numbers only, for dates, or for times.

You can try out these two ways to enter data in the practice. That's next.

Page 13 of 22PREVNEXT