How can I display more than 1 QUick Access Toolbar ribbon?

Previous versions of Excel allowed the user to display more than 1 toolbar, for example,  Formatting and a Standard toolbars.  Using 2 rows I had quick access to many features and functions.  

In Excel 2007, it appears that there is only 1 toolbar,  the Quick Access Toolbar, and the user is allowed only 1 ribbon on row to be displayed without clicking on a drop-down button to display a second ribbon or row. After 1 item is selected from the drop-down ribbon it disappears.   How can I continuously display 2 Quick Access toolbars or ribbons?

Thx,

Jeremy
Jeremy-MAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

theodorejsalvoCommented:
Not sure if I follow, but...

Right click on one of the tabs (File, Home, etc.) and uncheck "minimize the ribbon".  That will at least make the big ribbon always show up.
0
Rory ArchibaldCommented:
You can't. It's one ribbon and 1 QAT. You can get add-ins that mimic the old style 2003 toolbars though.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
theodorejsalvoCommented:
Follow Up: In "File -> Options -> Customize Ribbon" you can make your own tabs, similar to making custom toolbars in excel 2003.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Rory ArchibaldCommented:
Not in 2007 you can't. I assume you are using the 2010 beta?
0
theodorejsalvoCommented:
I am, but I thought you could make ribbon tabs in 2007, or was that an add-in?
0
Jeremy-MAuthor Commented:
Thanks for the responses.

I think I need to clarify what I am looking do.   I'm trying to reduce the time I waste clicking on the various tabs and sorting through the options.  In Excel 2003, I had three rows of shortcuts, formatting, standard and another whose name I forget.  

I added many additional icons to each of these toolbars that were displayed on 3 rows below the menu bar.    Is there a way to do something similar in Excel 2007?

0
theodorejsalvoCommented:
rorya's right then...look for an add-in.
0
TracyVBA DeveloperCommented:
0
Rory ArchibaldCommented:
You can alter the Ribbon in 2007 but it's nowhere near as easy - you have to edit the XML yourself using an editor. There's no option within Excel itself to do it.
0
Jeremy-MAuthor Commented:
I know how to edit the Quick Access Toolbar, but can I have more than 1 row, the answer seems to be "NO."   It appears that the RibbonX Visual Designer does not allow sers to have more than 1 row. It that correct, what are the other add-ins I might consider?
0
Jeremy-MAuthor Commented:
This is NOT, repeat NOT a question about adding an icon to the Quick Access Toolbar,  this is question of adding another row of icons to the Quick Access toolbar.  I guess rorya had it right in his first response, you can only have 1 QAT.

Thanks, for the effort.
0
TracyVBA DeveloperCommented:
I guess you didn't read the last thread I posted, because they also said you can only have 1 QAT in Office 2007 and in Office 2010 also.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.