Version 1.0
April 24, 2006
85 keyboard shortcuts
for moving faster in Microsoft Excel
By Jody Gilbert
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
Move to the next
worksheet in a workbook
[Ctrl][Page Down]
Move to the previous
worksheet in a workbook
[Ctrl][Page Up]
Cycle between open
workbooks
[Ctrl][F6]
Page 1
Copyright ©2006 CNET Networks, Inc. All rights reserved.
For more downloads and a free TechRepublic membership, please visit http://techrepublic.com.com/2001-6240-0.html
85 keyboard shortcuts for moving faster in Microsoft Excel
Move one cell up, down,
left, or right
Arrow keys
Move to the edge of the
data region
[Ctrl] and an arrow key
Move to the beginning of
a row
[Home]
Move to the beginning of
a worksheet
[Ctrl][Home]
Move to the end of the
used portion of a
worksheet
[Ctrl][End]
Move between panes in a
split worksheet
[F6]
Display the active cell
[Ctrl][Backspace]
Move down a cell in a
selected range
[Enter]
Move up a cell in a
selected range
[Shift][Enter]
Move one cell to the left
in a selected range
[Shift][Tab]
Move from corner cell to
corner cell in a selected
range
[Ctrl] and . (period)
Selection techniques
Select a row
[Shift][Spacebar]
Select a column
[Ctrl][Spacebar]
Select an entire
worksheet
[Ctrl]A
Select from current cell(s)
to the beginning of the
row
[Shift][Home]
Select from current cell(s)
to last used cell in row
[Shift][