Version 2
February 27, 2007
Formatting
Keystroke
Function
[Ctrl]B
Bold the selection
[Ctrl]I
Italicize the selection
[Ctrl]U
Underline the selection
[Ctrl]5
Strike through the selection
[Alt] and '
Open the Style dialog box
[Ctrl]1
Open the Format Cells dialog box
[Ctrl][Shift]~
Apply General format
[Ctrl][Shift]$
Apply Currency format
[Ctrl][Shift]%
Apply percentage format
[Ctrl][Shift]#
Apply Date format
[Ctrl][Shift]@
Apply Time format
[Ctrl][Shift]!
Apply Number format
[Ctrl][Shift]^
Apply Exponential number format
[Ctrl][Shift]&
Apply an outline border to selection
[Ctrl][Shift] and _
Remove outline border from selection
Navigation
Keystroke
Function
[Ctrl][Page Down]
Move to the next worksheet in a workbook
[Ctrl][Page Up]
Move to the previous worksheet in a workbook
85+ Keyboard Shortcuts for Microsoft Excel
Page 1
Copyright ©2007 CNET Networks, Inc. All rights reserved.
For a free BNET membership, please visit http://jobfunctions.bnet.com/register.aspx
85 Keyboard Shortcuts for Microsoft Excel
Page 2
Copyright ©2007CNET Networks, Inc. All rights reserved.
For a free BNET membership, please visit www.bnet.com
[Ctrl][F6]
Cycle between open workbooks
Arrow keys
Move one cell up, down, left, or right
Navigation (continued)
[Ctrl] and an arrow key
Move to the edge of the data region
[Home]
Move to the beginning of a row
[Ctrl][Home]
Move to the beginning of a worksheet
[Ctrl][End]
Move to the end of the used portion of a worksheet
[F6]
Move between panes in a split worksheet
[Ctrl][Backspace]
Display the active cell
[Enter]
Move down a cell in a selected range
[Shift][Enter]
Move up a cell in a selected range
[Shift][Tab]
Move one cell to the left in a selected range
[Ctrl] and . (period)
Move from corner cell to corner cell in a selected range
Selection techniques
Keystroke
Function
[Shift][Spacebar]
Select a row
[Ctrl][Spacebar]
Select a column