Custom Toolbars and Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.comcast.net - 07 Jul 2006 15:00 GMT

I do a lot of work in Excel with adding, multiplying etc of cells. I have
always created a "math function" toolbar which contained "+", "*", "/"',
"(", ")", etc. Thereby eliminating the need to go back and forth between
the mouse and the keyboard. I can't seem to find anything similar in 2007
to add to the Quick Access toolbar or to create an addition to the ribbon.
Any ideas?

Reply to this Message

Nick Hodge - 08 Jul 2006 10:42 GMT

You can add these to the QAT. Go to the arrow ate the end of the QAT and
select Customize Quick Access Toolbar. Select 'Commands not in the ribbon'
from the 'Choose commands from' drop-down and then look for the following...
(They're in alphabetical order)

Division Sign
Equal Sign
Left Parenthesis
Minus Sign
Multiplication Sign
Percent Sign
Plus Sign
Right Parenthesis

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

>I do a lot of work in Excel with adding, multiplying etc of cells. I have
>always created a "math function" toolbar which contained "+", "*", "/"',
>"(", ")", etc. Thereby eliminating the need to go back and forth between
>the mouse and the keyboard. I can't seem to find anything similar in 2007
>to add to the Quick Access toolbar or to create an addition to the ribbon.
>Any ideas?

Reply to this Message

news.comcast.net - 08 Jul 2006 16:03 GMT

> You can add these to the QAT. Go to the arrow ate the end of the QAT and
> select Customize Quick Access Toolbar. Select 'Commands not in the ribbon'
[quoted text clipped - 16 lines]
>>to add to the Quick Access toolbar or to create an addition to the ribbon.
>>Any ideas?

Thanks, it worked.

Reply to this Message