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