#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Missing buttons!?

How can I show the basic math operators in a toolbar?

I find it tedious to switch betwwen the mouse (to select cells with
the mouse) and the keyboard (to enter operators) when im writing
simple formulas. For simple formula entering I would like to only work
with the mouse.

I miss = ,+ ,- ,* ,/ ,^, (, ) and : as clickable in a toolbar.

I will be thankful for help,

Regards

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default Missing buttons!?

Assuming you are not using XL2007, click View/Toolbars/Customize on Excel's
menu bar. In the dialog box that appears, select Insert from the (left hand)
Categories list, scroll down on the (right hand) Commands list until you
find the symbols you want... you can click/drag each one of them onto any
toolbar and drop it there thus adding a button you can later click with your
mouse. Watch the icon when you are dragging... an X in the icon says you
can't drop it at the mouse's location whereas a + in the icon says you can
drop it at the mouse's location (also watch for the vertical bar on the
toolbar itself as that tells you where the new button will be placed).

--
Rick (MVP - Excel)


wrote in message
...
How can I show the basic math operators in a toolbar?

I find it tedious to switch betwwen the mouse (to select cells with
the mouse) and the keyboard (to enter operators) when im writing
simple formulas. For simple formula entering I would like to only work
with the mouse.

I miss = ,+ ,- ,* ,/ ,^, (, ) and : as clickable in a toolbar.

I will be thankful for help,

Regards


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Missing buttons!?

On May 9, 9:17*pm, "Rick Rothstein"
wrote:
Assuming you are not using XL2007, click View/Toolbars/Customize on Excel's
menu bar. In the dialog box that appears, select Insert from the (left hand)
Categories list, scroll down on the (right hand) Commands list until you
find the symbols you want... you can click/drag each one of them onto any
toolbar and drop it there thus adding a button you can later click with your
mouse. Watch the icon when you are dragging... an X in the icon says you
can't drop it at the mouse's location whereas a + in the icon says you can
drop it at the mouse's location (also watch for the vertical bar on the
toolbar itself as that tells you where the new button will be placed).

--
Rick (MVP - Excel)

wrote in message

...



How can I show the basic math operators in a toolbar?


I find it tedious to switch betwwen the mouse (to select cells with
the mouse) and the keyboard (to enter operators) when im writing
simple formulas. For simple formula entering I would like to only work
with the mouse.


I miss = ,+ ,- ,* ,/ ,^, (, ) and : as clickable in a toolbar.


I will be thankful for help,


Regards- Hide quoted text -


- Show quoted text -


Great help! Thanks!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pictures on Buttons missing iceboy Excel Discussion (Misc queries) 0 August 22nd 08 10:05 AM
Missing Buttons jjr Excel Discussion (Misc queries) 2 June 4th 07 09:46 PM
tab scrolling buttons missing TomG New Users to Excel 1 April 11th 07 12:44 PM
subtotal +/- buttons missing! Jason Excel Discussion (Misc queries) 0 April 4th 06 02:16 PM
Missing toolbar buttons scottie Excel Discussion (Misc queries) 2 October 17th 05 08:59 PM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"