|
Spreadsheet Actions
|
|
|
Action
|
Keystroke
|
|
Open a
workbook
|
CTRL+O
|
|
New
workbook
|
CTRL+N
|
|
Close a
workbook
|
CTRL+W
|
|
Open the
Save As dialog box
|
F12
|
|
Save a
workbook
|
CTRL+S
|
|
Print a
workbook
|
CTRL+P
|
|
Help
|
F1
|
|
Open the
Find tab of the Find and Replace dialog box
|
CTRL+F
|
|
Open the
Replace tab of the Find and Replace dialog box
|
CTRL+H
|
|
Go to
|
CTRL+G /
F5
|
|
Quit/Exit
Excel
|
ALT+F4
|
|
Insert a
new worksheet
|
SHIFT +
F11
|
|
Hide
selected columns
|
CTRL + 0
|
|
Display
hidden columns
|
CTRL +
SHIFT + 0
|
|
Hide
selected rows
|
CTRL + 9
|
|
Display
hidden rows
|
CTRL +
SHIFT + 9
|
|
Selecting & Navigating
|
||||
|
Action
|
Keystroke
|
|||
|
All cells
left of current cell
|
|
SHIFT+Left
arrow
|
||
|
All cells
right of current cell
|
|
SHIFT+Right
arrow
|
||
|
Entire
column
|
|
CTRL+Spacebar
|
||
|
Entire row
|
|
SHIFT+Spacebar
|
||
|
Entire
worksheet
|
|
CTRL+A
|
||
|
One cell
up
|
|
Up arrow
|
||
|
One cell
down
|
|
Down arrow
|
||
|
One cell
right
|
|
Tab
|
||
|
One cell
left
|
|
SHIFT+Tab
|
||
|
Top of
worksheet (cell A1)
|
|
CTRL+Home
|
||
|
End of
worksheet (last cell with data)
|
|
CTRL+End
|
||
|
End of row
|
|
Home
|
||
|
End of
column
|
|
CTRL+Left
arrow
|
||
|
Move to
next worksheet
|
|
CTRL+PageDown
|
||
|
Move to
previous worksheet
|
|
CTRL+PageUp
|
||
|
Cycle
between open workbooks
|
|
CTRL+F6
|
||
|
Move
between panes in a split worksheet
|
F6
|
|
|
Display
the active cell
|
CTRL +
Backspace
|
|
|
Move up a
cell in a selected range
|
SHIFT +
Enter
|
|
|
Move one
cell left in a selected range
|
SHIFT + Tab
|
|
|
Move from
corner cell to corner cell in a selected range
|
CTRL and. (period)
|
|
|
Select the
current cell(s) to the beginning of the row
|
SHIFT +
Home
|
|
|
Select the
current cell(s) to the beginning of the worksheet
|
CTRL +
SHIFT + Home
|
|
|
Select all
cells that contain a comment
|
CTRL +
SHIFT + O
|
|
|
Select the
data region surrounding the active cell
|
CTRL and *
|
|
|
Formatting
|
||
|
Action
|
Keystroke
|
|
|
Edit
within an active cell
|
|
F2
|
|
Format as
currency with 2 decimal places
|
|
CTRL +
SHIFT +$
|
|
Format as
percent with no decimal places
|
|
CTRL +
SHIFT +%
|
|
Apply
number format
|
|
CTRL +
SHIFT +!
|
|
Apply date
format
|
|
CTRL +
SHIFT + #
|
|
Apply time
format
|
|
CTRL +
SHIFT + @
|
|
Apply
general format
|
|
CTRL +
SHIFT + ~
|
|
Apply
exponential number format
|
|
CTRL + SHIFT
+ ^
|
|
Apply
outline border to selection
|
|
CTRL +
SHIFT + &
|
|
Remove
outline border to selection
|
|
CTRL +
SHIFT and _
|
|
Cut
|
|
CTRL + X
|
|
Copy
|
|
CTRL + C
|
|
Paste
|
|
CTRL + V
|
|
Undo
|
|
CTRL + Z
|
|
Redo
|
|
CTRL + Y
|
|
Bold
|
|
CTRL + B
|
|
Italics
|
|
CTRL + I
|
|
Underline
|
|
CTRL + U
|
|
Strikethrough
|
|
CTRL + 5
|
|
Left
alignment
|
|
CTRL + L
|
|
Center
alignment
|
|
CTRL + E
|
|
Right
alignment
|
|
CTRL + R
|
|
Change
font type
|
CTRL +
SHIFT + F + Up/down arrow – Enter
|
|
Change
font size
|
CTRL +
SHIFT + P + Up/down arrow – Enter
|
|
Open
Format Cells
dialog box
|
CTRL + 1
|
|
Data & Formulas
|
|
|
Action
|
Keystroke
|
|
Begin a
formula
|
=
|
|
Enter a
formula as an array
|
CTRL +
SHIFT + Enter
|
|
Display
Insert Function dialog box
|
SHIFT + F3
|
|
Paste a
defined name into a formula
|
F3
|
|
Insert a
AutoSum formula
|
ALT + =
|
|
Copy a
formula from the cell above the current cell into the current cell
|
CTRL and ‘
|
|
Calculate
values for sheets in all open workbooks
|
F9
|
|
Calculate
values for current worksheet
|
SHIFT + F9
|
|
Fill data
down through selected cells
|
CTRL + D
|
|
Fill data
through selected cells to the right
|
CTRL + R
|
|
Insert
current date in the worksheet
|
CTRL + ;
|
|
Insert
current time in the worksheet
|
CTRL + :
|
|
Run a
Spelling Check
|
F7
|
|
Run the
Macros
|
ALT + F8
|
No comments:
Post a Comment