Notice: Undefined index: jqZoomEnabled in /home/mo/prod/old.dpk/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code on line 72

Notice: Trying to get property of non-object in /home/mo/prod/old.dpk/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code on line 72
href="/modules//smartblog/images/153.jpg" data-fancybox-group="other-views" class="fancybox shown" title="
Notice: Undefined index: imageTitle in /home/mo/prod/old.dpk/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code on line 76

Notice: Trying to get property of non-object in /home/mo/prod/old.dpk/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code on line 76
">

How to customize the Quick Access Toolbar in Excel

  190993 Monday, December 4, 2017

1. Introduction
2. Steps to customize the Quick Access Toolbar
3. Read also

Introduction


By default, the Quick Access Toolbar, located above the ribbon, contains the Save, Undo, and Redo buttons. If you frequently use an Excel command, you can add it to the Quick Access Toolbar.
You can even add commands to the Quick Access Toolbar that are not in the ribbon. There are several commands available as predefined or built-in options.

Steps to Customize the Quick Access Toolbar

In this article, we will show you how to customize the Quick Access Toolbar in Excel and add commands to this bar. This procedure is applicable for Excel 2010, Excel 2013 and Excel 2016
1. Right-click anywhere on the ribbon, and then click Customize Quick Access Toolbar.

customize-quick-access-toolbar

2. Under Choose Orders in the following categories, select Commands not in the Ribbon.

commands-not-in-the-ribbon-outlook

3. Select the desired command from the list, then click Add.

add-command-to-the-quick-access-toolbar-outlook

Note: By default, Excel customizes the Quick Access Toolbar for all documents. Under Customize Quick Access Toolbar, select the current saved workbook to customize only the Quick Access Toolbar for this workbook.

quick-access-toolbar-for-all-documents-excel

4. Click OK.

5. To remove a command from the Quick Access Toolbar, right-click the command, and then click Remove on the Quick Access Toolbar.
Or select the command to delete, then click delete

remove-quick-access-toolbar-excel

6. Finally, click OK to save the changes.

Read also

How to disable automatic updates - Windows 7

How to Enable Power Saving in Windows 7 or Windows 8.1