Excel shortcuts

Excel drop-down list and print settings practice

Practice drop-down lists (Data Validation) and print settings in a virtual Excel in your browser, using the same ribbon, dialogs and shortcuts as the real thing. Use a computer for this practice.

Read "How to create a drop-down list in Excel" first →

Cleared 0 / 9

Chapter 1: Drop-down lists (Data Validation)

Practice four things: typing the choices, reading them from another table, choosing from the list and removing it.

  1. 1Create a drop-down by typing the choices
  2. 2Take the choices from another table
  3. 3Choose from a drop-down with the keyboard
  4. 4Remove a drop-down list

Chapter 2: Print settings

Set the orientation, fit all columns on one page, print titles and the print area.

  1. 5Print in landscape
  2. 6Fit all columns on one page
  3. 7Print the header row on every page
  4. 8Set the print area
  5. 9Make a long, wide table ready to print