Follow Us

Your Personal and Professional Development: Plans, Tips and Lists

Powered by Bookboon, your personal eLibrary with 1,700+ eBooks on soft skills and personal development

Excel 2016: Customize The ‘Quick Access Toolbar’

Posted in Articles
Customizing your Quick Access Toolbar in Excel 2016.

3 easy ways to customize your Excel sheet

Excel, as one of the most helpful programs in ones computer or laptop, has evolved into something more powerful this year. Aside from our favorite functionalities and features, Windows added more enhancements and improvements for the benefit of their users under its new version – Excel 2016. A very useful tool, the Quick Access Toolbar, is still present in the said program. It is found not only in Excel, but also in other programs of the Office package like Word, PowerPoint and Outlook. Customizing this toolbar based on one’s need and frequent usage is a huge help in conserving time while using the platform.

The Quick Access toolbar, originally, is situated at the top left of the screen above the File menu. However, it can be moved below the Ribbon to give the user plenty of space for adding icons. It can be done by clicking the dropdown arrow found at the rightmost part of the toolbar and choosing the “Show Below the Ribbon” option.

‘Quick Acces Toolbar’ In Excel 2016.
‘Quick Acces Toolbar’ In Excel 2016.

‘Quick Acces Toolbar’ In Excel 2016.
‘Quick Acces Toolbar’ In Excel 2016.

Initially, there are only a few icons on the Quick Access Toolbar, listed below:

  • Save
  • Undo
  • Redo
  • Touch – this changes the Ribbon giving more space between icons for use with a touch device

These icons can be customized based on your own preference. There are three easy ways, listed below:

1. Clicking the Dropdown Arrow

Clicking the Dropdown Arrow.
Clicking the Dropdown Arrow.

  • Click the drop down arrow on the right of the Quick Access Toolbar.
  • Choose and select from the list of frequently used icons and it will be added to the toolbar.
  • Remove the tick from the drop down list so that the icon will be removed.

2. Right Click

  • When you find an icon that you use all the time, you can save yourself a little time by using the Right Mouse button to add it.

...using the Right Mouse button...
…using the Right Mouse button…

  • Just like adding, you can also right click to remove an icon.

Right click to remove an icon.
Right click to remove an icon.

3. Choosing the “More Commands” option
You can choose between hundreds of icons can be added to the Quick Access Toolbar, depending on your nature of work. To see them, follow the steps below:

  • Click the drop down arrow on the right of the Quick Access Toolbar
  • Select “More Commands”
  • Choose from the different selections of icons available.

Adding Icons

Adding Icons.
Adding Icons.

  1. Drop down list of icons’ different categories
  2. Available icons in the category displayed – double click to add
  3. Icons currently on the Quick Access Toolbar
  4. Move the icons up and down using spinners
  5. OK

Removing Icons

Removing Icons.
Removing Icons.

  1. Select the icon you wish to remove
  2. Click Remove

We have even more useful articles:

Excel 2016: 3 Simple Steps to Hide and Unhide Portions

“How to Format Cells and Worksheets”

“Essential Facts About Worksheets and Workbooks and How to Utilize Them”

“How to Use Excel’s Basic Functions”

Excel 2016 Core Part One

If you want to learn more, you can download the eBook “Excel 2016 Core Part One“.

Read now