[et_pb_section fb_built=\u201d1\u2033 admin_label=\u201dsection\u201d _builder_version=\u201d3.0.47\u2033][et_pb_row admin_label=\u201drow\u201d _builder_version=\u201d3.0.47\u2033 background_size=\u201dinitial\u201d background_position=\u201dtop_left\u201d background_repeat=\u201drepeat\u201d][et_pb_column type=\u201d4_4\u2033 _builder_version=\u201d3.0.47\u2033][et_pb_text admin_label=\u201dText\u201d _builder_version=\u201d3.21.1\u2033 background_size=\u201dinitial\u201d background_position=\u201dtop_left\u201d background_repeat=\u201drepeat\u201d]<\/p>\n
Did you know that you can customize the QAT (Quick Access Toolbar) and ribbon within Excel and most other Microsoft Office applications?\u00a0 Customizing the QAT and ribbon can save you time searching for commonly-used commands that don\u2019t have a keyboard shortcut available.\u00a0 You can also add many commands that may not be accessible directly from the ribbon.\u00a0 It\u2019s extremely easy to customize the ribbon and the QAT, and you can save your customizations to a backup file to share with colleagues, use on another computer, or keep as a backup in case you have to re-install Microsoft Office.<\/p>\n
To customize the QAT, just right-click on any of the icons and then click the Customize the Quick Access Toolbar option.\u00a0 From there, you can add, remove, or reorder the icons\/commands.\u00a0 You can also add commands by right-clicking on any command from the ribbon and then clicking the Add to Quick Access Toolbar option.\u00a0 See the video below for more details and instructions.<\/p>\n
To customize the ribbon, just right-click anywhere in the ribbon and click the Customize the Ribbon option.\u00a0 From there, you can add, remove, or reorder the ribbon tags, tab groups, or even the commands.\u00a0 You can also create your own ribbon tab, group, and commands using the buttons in the dialog box.\u00a0\u00a0See the video below for more details and instructions.<\/p>\n
To save a backup file, right-click anywhere on the ribbon and select the Customize the Ribbon option.\u00a0 At the bottom of the dialog box, click the Import\/Export button and follow the instructions.\u00a0\u00a0See the video below for more details and instructions.<\/p>\n
The zipped folder below contains my personal QAT and ribbon customization files for Excel, Word, and PowerPoint.\u00a0 Feel free to use these as a starting point.\u00a0 I recommend first creating backup files for your own customizations in case you want to reinstate them.<\/p>\n