×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel - Quick Access Toolbar - customise with a drop-down menu

Excel - Quick Access Toolbar - customise with a drop-down menu

Excel - Quick Access Toolbar - customise with a drop-down menu

(OP)
Hello there,

I have a lot of useful shortcuts and macros on my QAT in Excel.

Some of them I'd like to group into a sub-menu. Just like the regular ribbon has groups and sub-menus.

I can't see how to do this, but I'm guessing it's not an option, but has anyone found how to do this? Or are there any suggestions on managing groups of macros?

thanks!

thank you for helping

____________
Pendle

RE: Excel - Quick Access Toolbar - customise with a drop-down menu

(OP)
*** solved it****

So what I did was

create a new custom tab with my items in groups

Then right-clicked the group and added to quick access toolbar and there is a blue blob with the items underneath.

Haven't worked out how to change the icon - but that's fine with me.

thank you for helping

____________
Pendle

RE: Excel - Quick Access Toolbar - customise with a drop-down menu

MS info how to sustomize QAT here.

One of blogs here.

To add menus to QAT: you can create your own ribbon with groups of macros, customize items (in the designer select icon and 'change name...' option), and hide it. Next, when customizing QAT, it is possible to add ribbon's group to QAT. Items in QAT are displayed only as icons, but with tooltips.

combo

RE: Excel - Quick Access Toolbar - customise with a drop-down menu

To change icon, modify the source group in the ribbon: 'change name' command allow to change icon too. The change will be transferred to QAT.

combo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close