Topic 8 – Notes



After completing this lesson, you should know:

  • The built-in lists that are available in Excel
  • How to use the fill handle
  • How to autofill a list


There are four ready-to-use lists in Excel:

How to autofill these lists:

  • Type the first entry, e.g Monday
  • Move the mouse cursor to the bottom right corner of the active cell
  • The fill handle will appear
  • Use the mouse to drag the fill handle down to display the rest of the list

Fill options:

If you don’t want the series Monday, Tuesday etc, use the Option Box to change the list to Monday, Monday etc by choosing Copy Cells.

Fill numbers and dates:

Excel can also fill numbers and dates. The default will be:

Use the Option Box to change the default values to suit your needs:

Last modified: Friday, 30 April 2021, 3:19 PM