Excel is extensively menu and right-click menu driven. However, everything found on a menu can be done by keyboard. This is particularly helpful when your mousing hand begins to suffer from carpal tunnel or deQuervain's tendonitis. I find certain shortcuts also quicker, and I've reached a balance between mousing and keying with the shortcuts below. At the bottom of the post you'll find links to two long lists of shortcuts.
With one exception, the ones I'll list are all CTRL plus a key. For the CTRL key plus the A key, you might see CTRL/A, CTRL+A, or CtrlA in various tutorials. For this list, cA means CTRL plus the A key.
c1 = Format cells dialog
cA = Select All
cB = Bold
cC = Copy selected cells
cF = Find
cG = GoTo dialog
cH = Find & Replace
cI = Italic
cV = Paste (The ENTER key pastes and empties the clipboard)
c~ (CTRL plus tilde) = reset format to General format
F2 = Edit mode (toggles Edit and Enter modes)
One of the free offerings at ASAP Utilities is their list of a great many keyboard shortcuts.
And of course Microsoft publishes this list of all possible shortcuts, including ALT sequences for accessing all menu items.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment