• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

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
0
Jeremy-M
Asked:
Jeremy-M
  • 4
  • 3
  • 3
  • +1
1 Solution
 
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
 
theodorejsalvoCommented:
Follow Up: In "File -> Options -> Customize Ribbon" you can make your own tabs, similar to making custom toolbars in excel 2003.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 4
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now