Category
|
Hold
|
Press
|
Keyword
|
Result
|
Format Data
|
Ctrl
|
0
|
column
|
Hide columns
|
Format Data
|
Ctrl
|
1
|
format
|
Display the Format Cells dialog box
|
Format Data
|
Ctrl + Shift
|
2
|
time
|
Apply Time format
|
Format Data
|
Ctrl
|
5
|
strikethrough
|
Apply or remove strikethrough formatting
|
Select Cells
|
Ctrl
|
6
|
object
|
Alternate between hiding objects, displaying objects, and displaying
placeholders for objects
|
Select Cells
|
Ctrl
|
7
|
toolbar
|
Show or hide the Standard toolbar
|
Outline Data
|
Ctrl
|
8
|
outline
|
Display or hide outline symbols
|
Format Data
|
Ctrl
|
9
|
row
|
Hide rows
|
Enter Data
|
Ctrl
|
'
|
copy
|
Copy formula from cell above
|
Format Data
|
Alt
|
'
|
style
|
Style dialog box
|
Format Data
|
Ctrl + Shift
|
'
|
number
|
Apply number format
|
Edit Data
|
Ctrl
|
-
|
delete
|
Delete selection
|
Format Data
|
Ctrl + Shift
|
-
|
border
|
Remove outline borders
|
Format Data
|
Ctrl + Shift
|
!
|
number
|
Apply Number format with 2 decimal places, thousands separator
|
Enter Data
|
Ctrl + Shift
|
"
|
copy
|
Copy value from cell above
|
Format Data
|
Ctrl + Shift
|
#
|
date
|
Apply the Date format with the day, month, and year
|
Format Data
|
Ctrl + Shift
|
$
|
currency
|
Apply Currency format
|
Format Data
|
Ctrl + Shift
|
%
|
percent
|
Apply Percentage format with no decimal places
|
Format Data
|
Ctrl + Shift
|
&
|
border
|
Apply the outline border
|
Format Data
|
Ctrl + Shift
|
(
|
row
|
Unhide rows
|
Format Data
|
Ctrl + Shift
|
)
|
column
|
Unhide columns
|
Select Cells
|
Ctrl + Shift
|
*
|
region
|
Select the current region
|
Move within Selection
|
Ctrl
|
.
|
move
|
Move clockwise to the next corner of the selection
|
Select Cells
|
Ctrl
|
/
|
array
|
Select current array
|
Enter Data
|
Ctrl + Shift
|
;
|
time
|
Enter the time
|
Enter Data
|
Ctrl
|
;
|
date
|
Enter the date
|
Select Cells
|
Alt
|
;
|
cells
|
Select visible cells in current selection
|
Select Cells
|
Ctrl
|
[
|
dependent
|
Select direct dependents
|
Select Cells
|
Ctrl + Shift
|
[
|
dependent
|
Select all dependents
|
Select Cells
|
Ctrl
|
\
|
difference
|
Select differences
|
Select Cells
|
Ctrl + Shift
|
\
|
unequal
|
Select unequal cells
|
Select Cells
|
Ctrl
|
]
|
precedent
|
Select direct precedents
|
Select Cells
|
Ctrl + Shift
|
]
|
precedent
|
Select all precedents
|
Format Data
|
Ctrl + Shift
|
^
|
number
|
Apply Exponential number format
|
Enter Data
|
Ctrl
|
`
|
formula
|
Toggle formula view
|
Edit Data
|
Ctrl + Shift
|
=
|
insert
|
Insert blank cells
|
Enter Data
|
Alt
|
=
|
AutoSum
|
Insert the AutoSum formula
|
Enter Data
|
Ctrl
|
A
|
formula
|
Display Formula Palette after typing function name in formula
|
Enter Data
|
Ctrl + Shift
|
A
|
formula
|
Insert the argument names and parentheses for a function after you
type a function name in a formula
|
Select Cells
|
Ctrl
|
A
|
All
|
Select the entire worksheet
|
Enter Data
|
|
Arrow key
|
move
|
Move one character up, down, left, or right
|
Move and Scroll
|
Ctrl
|
Arrow key
|
move
|
Move to edge of current region
|
Move and Scroll
|
|
Arrow key
|
move
|
Move one cell up, down, left, or right
|
Select Cells
|
Ctrl + Shift
|
Arrow Key
|
select
|
Extend the selection to the last nonblank cell in the same column or
row as the active cell
|
Select Cells
|
Shift
|
Arrow Key
|
select
|
Extend the selection by one cell
|
Format Data
|
Ctrl
|
B
|
bold
|
Apply or remove bold formatting
|
Enter Data
|
|
Backspace
|
delete
|
Delete character to left of insertion point, or delete selection
|
Move and Scroll
|
Ctrl
|
Backspace
|
scroll
|
Scroll to display the active cell
|
Select Cells
|
Shift
|
Backspace
|
select
|
Select only the active cell when multiple cells are selected
|
Edit Data
|
Ctrl
|
C
|
copy
|
Copy the selection
|
Enter Data
|
Ctrl
|
D
|
fill
|
Fill down
|
Enter Data
|
Ctrl
|
Delete
|
delete
|
Delete text to the end of the line
|
Enter Data
|
|
Delete
|
delete
|
Delete character to right of insertion point, or delete selection
|
Enter Data
|
Alt
|
Down Arrow
|
AutoComplete
|
Display the AutoComplete list
|
Move and Scroll
|
Ctrl
|
End
|
move
|
Move to the last cell on the worksheet
|
Select Cells
|
Ctrl + Shift
|
End
|
select
|
Extend the selection to the last used cell on the worksheet (lower-right
corner)
|
Enter Data
|
Alt
|
Enter
|
line break
|
Start a new line in the same cell
|
Enter Data
|
Ctrl
|
Enter
|
fill
|
Fill the selected cell range with current entry
|
Enter Data
|
Ctrl + Shift
|
Enter
|
array
|
Enter formula as array formula
|
Enter Data
|
Shift
|
Enter
|
complete
|
Complete cell entry and move up in selection
|
Enter Data
|
|
Enter
|
complete
|
Complete cell entry and move down in selection
|
Enter Data
|
|
Esc
|
cancel
|
Cancel a cell entry
|
Menus
|
|
Esc
|
close
|
Close visible menu or submenu
|
Windows
|
Ctrl
|
Esc
|
Start
|
Show the Windows Start menu
|
Help
|
|
F1
|
Help
|
Open the Help Task pane
|
Menus
|
Shift
|
F10
|
shortcut
|
Show a shortcut menu
|
Menus
|
|
F10
|
menu
|
Make the menu bar active
|
Windows
|
Ctrl
|
F10
|
maximize
|
Maximize or restore the workbook window
|
Charts
|
|
F11
|
chart
|
Create a chart that uses the current range
|
Macros
|
Alt
|
F11
|
VBE
|
Display the Visual Basic Editor
|
Macros
|
Ctrl
|
F11
|
macro
|
Insert a Microsoft Excel 4.0 macro sheet
|
Worksheets
|
Shift
|
F11
|
worksheet
|
Insert a new worksheet
|
Workbook
|
Ctrl
|
F12
|
open
|
Display the Open dialog box
|
Workbook
|
|
F12
|
save as
|
Open the Save As dialog box
|
Workbook
|
Shift
|
F12
|
save
|
Save the file
|
Print
|
Ctrl + Shift
|
F12
|
print
|
Display the Print dialog box
|
Charts
|
Alt
|
F2
|
chart
|
Create a chart that uses the current range
|
Enter Data
|
Shift
|
F2
|
comment
|
Edit a cell comment
|
Enter Data
|
|
F2
|
edit
|
Edit the active cell and position the insertion point at the end of
the line
|
Worksheets
|
Alt + Shift
|
F2
|
worksheet
|
Insert a new worksheet
|
Enter Data
|
Ctrl
|
F3
|
name
|
Define a name
|
Enter Data
|
Ctrl + Shift
|
F3
|
name
|
Create names from row and column labels
|
Enter Data
|
Shift
|
F3
|
function
|
Paste a function into a formula
|
Enter Data
|
|
F3
|
name
|
Paste defined name into formula
|
Enter Data
|
|
F4
|
repeat
|
Repeat the last action
|
Move and Scroll
|
Shift
|
F4
|
find
|
Repeat the last Find action (Find Next)
|
Windows
|
Ctrl
|
F4
|
close
|
Close the active workbook window
|
Move and Scroll
|
Shift
|
F5
|
find
|
Display the Find dialog box
|
Move and Scroll
|
|
F5
|
go to
|
Display the Go To dialog box
|
Windows
|
Ctrl
|
F5
|
restore
|
Restore the active workbook window size
|
Dialog Box
|
|
F6
|
dialog box
|
In a range selection box, switch focus to the worksheet
|
Move and Scroll
|
Ctrl
|
F6
|
window
|
Move to the next workbook or window
|
Move and Scroll
|
Ctrl+Shift
|
F6
|
window
|
Move to the previous workbook or window
|
Move and Scroll
|
Shift
|
F6
|
pane
|
Move to previous pane in workbook that has been split
|
Move and Scroll
|
|
F6
|
pane
|
Move to next pane in split workbook
|
Edit Data
|
|
F7
|
spell
|
Display the Spelling dialog box
|
Windows
|
Ctrl
|
F7
|
move
|
Carry out Move command (workbook icon menu, menu bar), or use arrow
keys to move the window
|
Macros
|
Alt
|
F8
|
macro
|
Display the Macro dialog box
|
Select Cells
|
Shift
|
F8
|
select
|
Add another range of cells to the selection; or use the arrow keys
to move to the start of the range you want to add, and then press F8
and the arrow keys to select the next range
|
Select Cells
|
|
F8
|
select
|
Turn on extending a selection by using the arrow keys
|
Windows
|
Ctrl
|
F8
|
size
|
Carry out Size command (workbook icon menu, menu bar), or use arrow
keys to size the window
|
Enter Data
|
Ctrl + Alt
|
F9
|
calculate
|
Calculate all sheets in the active workbook
|
Enter Data
|
Shift
|
F9
|
calculate
|
Calculate the active worksheet
|
Enter Data
|
|
F9
|
calculate
|
Calculate all sheets in all open workbooks
|
Windows
|
Ctrl
|
F9
|
minimize
|
Minimize the workbook window to an icon
|
Move and Scroll
|
Ctrl
|
Home
|
move
|
Move to the beginning of the worksheet
|
Move and Scroll
|
|
Home
|
move
|
Move to the beginning of the row
|
Select Cells
|
Ctrl + Shift
|
Home
|
select
|
Extend the selection to the beginning of the worksheet
|
Select Cells
|
Shift
|
Home
|
select
|
Extend the selection to the beginning of the row
|
Format Data
|
Ctrl
|
I
|
italic
|
Apply or remove italic formatting
|
Enter Data
|
Ctrl
|
K
|
hyperlink
|
Insert a hyperlink
|
Move within Selection
|
Ctrl + Alt
|
Left Arrow
|
move
|
Move left between nonadjacent selections
|
Outline Data
|
Alt + Shift
|
Left Arrow
|
group
|
Ungroup rows or columns
|
Select Cells
|
Ctrl + Shift
|
O
|
comment
|
Select all cells with comments
|
Print
|
Ctrl
|
P
|
print
|
Display the Print dialog box
|
Move and Scroll
|
Alt
|
Page Down
|
move
|
Move one screen to the right
|
Move and Scroll
|
Ctrl
|
Page Down
|
move
|
Move to the next sheet in the workbook
|
Move and Scroll
|
|
Page Down
|
move
|
Move down one screen
|
Select Cells
|
Shift
|
Page Down
|
select
|
Extend the selection down one screen
|
Worksheets
|
Ctrl + Shift
|
Page Down
|
select
|
Select current and next sheet in workbook
|
Move and Scroll
|
Alt
|
Page Up
|
move
|
Move one screen to the left
|
Move and Scroll
|
Ctrl
|
Page Up
|
move
|
Move to the previous sheet in the workbook
|
Move and Scroll
|
|
Page Up
|
move
|
Move up one screen
|
Select Cells
|
Shift
|
Page Up
|
select
|
Extend the selection up one screen
|
Worksheets
|
Ctrl + Shift
|
Page Up
|
select
|
Select current and previous in workbook
|
Windows
|
Alt
|
Print Screen
|
copy
|
Copy the image of the active window to the Clipboard
|
Windows
|
|
Print Screen
|
copy
|
Copy the image of the screen to the Clipboard
|
Enter Data
|
Ctrl
|
R
|
fill
|
Fill to the right
|
Move within Selection
|
Ctrl + Alt
|
Right Arrow
|
move
|
Move right between nonadjacent selections
|
Outline Data
|
Alt + Shift
|
Right Arrow
|
group
|
Group rows or columns
|
Menus
|
Alt
|
Spacebar
|
menu
|
Show control menu
|
Select Cells
|
Ctrl
|
Spacebar
|
column
|
Select the entire column
|
Select Cells
|
Ctrl + Shift
|
Spacebar
|
objects
|
With an object selected, select all objects on a sheet
|
Select Cells
|
Shift
|
Spacebar
|
row
|
Select the entire row
|
Move and Scroll
|
Ctrl
|
Tab
|
window
|
Move to the next workbook or window
|
Move and Scroll
|
Ctrl+Shift
|
Tab
|
window
|
Move to the previous workbook or window
|
Move within Selection
|
Shift
|
Tab
|
left
|
Move left
|
Move within Selection
|
|
Tab
|
right
|
Move right
|
Windows
|
Alt
|
Tab
|
program
|
Switch to the next program
|
Windows
|
Alt + Shift
|
Tab
|
program
|
Switch to the previous program
|
Format Data
|
Ctrl
|
U
|
underline
|
Apply or remove an underline
|
Edit Data
|
Ctrl
|
V
|
paste
|
Paste the selection
|
Windows
|
Ctrl
|
W
|
close
|
Close the active workbook window
|
Edit Data
|
Ctrl
|
X
|
cut
|
Cut the selection
|
Enter Data
|
Ctrl
|
Y
|
repeat
|
Repeat the last action
|
Edit Data
|
Ctrl
|
Z
|
undo
|
Undo the last action
|
