Topic 8 – Notes

WORK WITH LISTS

 

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:













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