QAT Need More Room

[DH995]

I'd like to have my QAT give me 2 rows--a word wrap sort of view. If I add more buttons than there is room I get the >> symbol saying there are more controls---this becomes multi clicks to get to the macro buttons

Is there anyway to force excel to add another row and keep showing the buttons---this would be the equivalent of the former tool bar were I could add an addtional tool bar if I went over the visual limit.

Thanks

Dave

 

[xenou]

Nope. But keyboard shortcuts will lessen your dependence on the QAT.
ξ

 

[DH995]

Thought so...thanks, and most of my QAT are macros I use all the time, but youa re right short cut keys could remove a few

Dave

 

[xenou]

Another option if you have a lot of macros is a menu on the QAT which ron debruin devised for this purpose:
Menu for favorite macros in Excel 2007-2010 (for all workbooks)