• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell Styles


New Member
I use Cell Style a lot. I've seen some people that have the cell styles already open (or locked you might say) in their ribbon.

For me, in order to access cell style I have to press the scroll down arrow and then access the chosen style.

I thought this feature was suppose to be a smart one and with time, after realizing I use it so much, it will become a fixed feature...but well, it's not.

Any ideas how to make fix, locked on the ribbon?

I have Excel 2007


Excel Ninja
Staff member

If you Right click on any of the style buttons/colors you can "Add Gallery to Quick Access Toolbar"

This will give you access to the entire Gallery with 1 click