As you add many icons to the Excel QAT, there is also a way to group related icons together. Here is a snapshot of my Quick Access Toolbar:
These vertical line separators can be used to group similar icons together. For example, here I have all the object alignment icons together. Similarly, I have the data related icons (data validation and sorting) together at the end.
Creating Groups in Quick Access Toolbar
Right-click on the QAT icons and select Customize Quick Access Toolbar.. In the Excel Option dialogue box, there are 2 sections. On the left, you have all the icons that can be added to QAT, and on the right, you have existing QAT icons. To add a separator, click on
You May Also like the Following Excel Tutorials:
Free Excel Templates. 200+ Excel Keyboard Shortcuts. 70+ Excel Functions (Examples and Videos). 100+ Excel Interview Questions + Answers Excel Text to Speech How to Customize the Ribbon in Excel (Step-by-Step) How to Show or Hide the Ribbon in Excel? How to Group Columns in Excel?