View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Most efficient method in Excel? Mouse or Keyboard keys?

I'm very mouse-oriented, probably 80 mouse - 20 keyboard. If I need
something repeated again and again, I'll make a custom toolbar, put a couple
buttons on it, and drag it to where I need to use it. This makes me pretty
efficient even with the mouse. The inability to do this in Excel 2007 means
that my maximum theoretical efficiency in 2007 is substantially lower than
in Excel 2003.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ron Coderre" wrote in message
...
It depends on what (and how much) you need to accomplish.

This is my opinion:
The mouse is easier for exploring menu structures to find the commands I'm
interested in, but slow and inaccurate for speed work. Once I know where
they are....if I have to repeat the same command many times (or even a
few)...I'll generally use the keyboard shortcuts or navigate with the
keyboard using the underlined menu characters.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)

"grins" wrote in message
...
Could you tell me which method is considered the most efficient in Excel?
Obviously a combination of all are used but which is preferred? Mouse,
Keyboard or Toolbar?