Topic 2 – Notes

EXPLORE THE RIBBON & QUICK ACCESS TOOLBAR

  • After completing this lesson, you should know:
  • What the ribbon is
  • How to use and collapse the ribbon
  • Where the Quick Access Toolbar is located
  • How to customize the Quick Access Toolbar
  • How to move the Quick Access Toolbar to a different location on the screen

 

THE RIBBON

The ribbon is located above the worksheet and contains buttons and icons that can be used to perform tasks in Excel. The ribbon tabs above the ribbon enables you to go to a different section of the ribbon, such as Insert, Page Layout, etc.

This is the Excel 2016 ribbon. When you open Excel, the Home tab will automatically be selected. Every ribbon tab contains several groups with related commands in each group.



This is one ribbon group – the Font group on the Home ribbon tab:

 

 

 

 

 

 

Dialog Box Launcher

 

 

 

 

Screen Tips

 

 

 



Contextual Tabs

 

 

 



Gallery

 

 

 


Live Preview

When you point to a style option, you can see the result before you click.

Collapsing the Ribbon

For more working space on the sheet, the ribbon can be collapsed.


Methods to collapse the ribbon:

  • Double-click on any ribbon tab
  • Right-click on any ribbon tab → click on: Collapse the Ribbon
  • Shortcut: Ctrl F1

Methods to bring the ribbon back to normal size:

  • Double-click on any ribbon tab
  • Right-click on any ribbon tab → click on: Collapse the Ribbon (to remove the check mark)
  • Shortcut: Ctrl F1

 

 

 

 

THE QUICK ACCESS TOOLBAR

The Quick Access Toolbar is by default placed above the ribbon in the top left corner of the Excel window. It can be customized and shows commands that are independent from the ribbon tab that is currently displayed.


 

Add commands to the Quick Access Toolbar

There are different methods to customize the Quick Access Toolbar.

Method 1:

Click on the arrow to the right of the toolbar to customize the Quick Access Toolbar and choose commands to display on the toolbar. Save, Undo and Redo will be on this toolbar by default. Click on Spelling for example to add this command to the Quick Access Toolbar.


 

 

 

 

 

 

 

 

 



Method 2:

Right-click on any command on any ribbon tab and choose “Add to Quick Access Toolbar”.


 

 

 

 

 

 

Method 3:

Click on the arrow to the right of the toolbar and choose: More Commands.

 

 

 



The Excel Options dialog box will open and you will be on the Quick Access Toolbar section already. Choose any command in the list on the left-hand side and click Add to add it to the Quick Access Toolbar (or double-click on the command to add it).

There are different lists you can choose from:

  • Popular Commands
  • Commands not in the Ribbon
  • All Commands

To remove a command from the Quick Access Toolbar, double-click on the command in the list on the right-hand side.


 

 

 

 

 

 

 

 


Note: The changes you make to the Quick Access Toolbar will still be applicable when you open another Excel file.

Remove commands from the Quick Access Toolbar

Right-click on the command → Choose “Remove from Quick Access Toolbar”


 

 

 


Show the Quick Access Toolbar below the ribbon

The toolbar can be displayed above or below the Ribbon.

Methods:

  • Click on arrow to the right of toolbar → Show Below/Above the Ribbon
  • Right-click on any Ribbon Tab → Show Quick Access Toolbar Below/Above the Ribbon











Exit



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