I’m a keyboard jockey and do about 80-85% of my work in Excel without using the mouse. I am constantly using the Copy and Paste Special|Values command to remove formulas from cells. In Excel 2003 or earlier, you just did Alt-ESV, which was like using the mouse to select Edit|Paste Special from the menu and the selecting the Values button and pressing OK.
Excel 2007 still supports the keyboard accelerators for Excel 2003 menu access even though the menus don’t exist anymore, but I’ve noticed that the ALT key (at least the right one) doesn’t activate the menu all of the time. This is on different computers with different keyboards, so it isn’t specific to my main setup. This means half the time I just get “ESV” entered into a cell and I have to Undo it, recopy the data and try again.
I just noticed though that the Paste Special command is on the right-click menu of a cell. Not using a mouse much means I rarely pay attention to the right-click menu for many operations. A lot of keyboards have a key just to the right of the right-ALT key that looks like a box with several lines in it. This is the keyboard version of a right-click. So if I press that key, then SV, it does the same thing as ALT-ESV – with one less keystroke.
For an Excel user, this is cool. For everyone else, just roll your eyes.
No comments:
Post a Comment
Note: Comments may be delayed for moderation just to keep the spammers out. I'll approve them as soon as possible. Thanks, and sorry for the trouble.