Create Groups in Quick Access Toolbar in Excel

If you are addicted to using the Excel Quick Access toolbar (QAT), this tip is for you.

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:

Trump Excel 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..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 <Separator> and then click Add. You can then set the position of the Separator by using the up and down arrow keys.Quick Access Toolbar Adding Separator
  • Click Ok. That’s it. Now your QAT icons would be separated by a grey vertical line (which gives an illusion that you have created groups).

You May Also like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

  • My age I’m trying to make it thru life with all the new systems. That video open my eyes a little I must keep going.

  • Padmanathan says:

    Great job we all thanks for yours Wonderful effort to tach others

  • Kajal chaudhary says:

    Learn something new from online

  • Sarbast Juma says:

    thanks for the free training

  • I wound like one of your followers

  • Very happy to be your followers on Youtube thanks a lot for your tireless efforts for making us excel Gurus.

  • Aakash Singhal says:

    Thank you for free training course

  • >
    shares