Excel Ribbon

[RobMatthews]

Is anyone else feeling really hamstrung by the inability to change standard panels? For instance, i want Strike-Through on the Font panel of the Home tab. Nuh. Cain't do that. Gotta be on a custom panel. FFFUUUuuuu.

Can I change the panels programmatically?

 

[Smitty]

You can modify the Ribbon in Excel 2010, but not 2007.

Ken Puls wrote a large book on Ribbon Customization: http://www.excelguru.ca/list.php?category/84-Excel-User-Interface-Customization

HTH,

 

[xenou]

I do the following:

1) add a ton of QAT buttons and generally leave the ribbon minimized while working unless doing a lot of new design on a workbook.
2) use a combination of keyboard shorts and custom shortcuts I've created and learned over the years
3) use right click menus and custom right click items
4) customize the ribbon to make it *exactly* how I want it to be (more or less)

So I actually rarely see the ribbon except when I need to, in which case I find it's big menus somewhat useful since this is when I'm using the menus a lot. It took me about 2 weeks to get used to it and since then I've really found I like Excel 2007 quite a lot -- though I stuck it out until (almost) everyone I worked with had upgraded long before me.

Edit: this is a good intro:
http://www.rondebruin.nl/ribbon.htm
Easy Menu for macros on the QAT:
http://www.rondebruin.nl/qat.htm
Changing built in groups:
http://www.rondebruin.nl/xmlribbongroups.htm

 

[PaddyD]

For what it's worth, I find the thing truly hateful.

 

[daniels012]

I know all the new ways around. We have 3 different versions of the software at work so I was just saying changing shortcuts is a pain. Trevor, I certainly learned the Crtl+F2 since I use it a lot. I just hate that when changing machines you have to remember the other.

Michael D

 

[litrelord]

I definitely got the ESV lag on 2007 but it's fixed for me on 2010. I'm slowly learning the 07/10 shortcuts though and now use Alt + H > V > V for paste values.

As for whether the ribbon is better or worse, the only thing I've found better is due to not being able to easily change the ribbon in 2007 I now know where everything is on a standard installation. in 2003 and those prior I'd customised the toolbars and menus so much I couldn't find anything on anyone else's machine. Not sure that's entirely positive of course :-/

Nick

 

[Firefly2012]

Nick

i definitely get no lag with Alt+h,v,v so thanks for that!

 

[MrKowz]

Another paste-special shourtcut I have found that is handy is to hit the right-click-menu-button on the keyboard (looks like http://www.lytebyte.com/wp-content/uploads/2008/05/right-click-keyboard-key.jpg) and press v. No alt-shortcuts.

 

[daniels012]

MrKowz,
I love the right click menu button!
I NEVER knew that existed!!

Mcihael

 

[xenou]

Me either - funny I never even pressed that key to see what it does...
My right click menu has only 5 built in items on it and otherwise my custom items (I use it quite extensively but in a targeted way so only what I want is on it). I wrote up an article on this if anyone is interested:
http://www.mrexcel.com/forum/showthread.php?t=579938