Customize Ribbon

(File > Options)(Customize Ribbon)
In Excel 2007 you could customise the QAT but it wasn't possible to create your own tabs or groups.
Now you can create custom tabs and groups and rename or change the built-in tabs and groups.

microsoft excel docs

Definitive command - These are commands that automatically take you back to the Ribbon when invoked, examples are Save, Save As, Close
Fast commands - These are commands that appear on the left hand side
Tab - These are pages within the backstage view. The first tab is the default, if no location is specified, custom tabs are added to the bottom.
Groups - used to organise functionlaity within a tab


You can create your own tabs and groups and add whichever commands you want
Use the Add button to bring commands across
Use the Remove button to remove commands


Main Tabs




Tool Tabs





New Tabs




New Groups




Using Customisation Files

Importing and exporting




© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext