Quick Access Toolbar

Excel allows you to customize a toolbar with the commands you use most often. The Quick Access Toolbar allows you to carry out your most common tasks quickly and easily.

    1. StepsActions
    2. In the top left of your screen, click the File tab.
    3. Click the Excel Options button. The Excel Options dialog box will open.
    4. In the left sidebar, click Customize. The options for customizing your Quick Access Toolbar will open.

custom

To add a command to your toolbar:

  1. StepsActions
  2. Select a command from the scroll down menu on the left.
  3. Click Add. The command will now be added to the list on the right. You can reorder the position of the commands on the toolbar using the up and down arrows on the right of the window.
  4. Select the Show Quick Access Toolbar below the Ribbon box.
  5. Click OK. Your Quick Access Toolbar will now appear below the Ribbon.

Last modified: April 20, 2014