Excel
shortcuts keys
|
Shortcut key
|
Action
|
Menu equivalent comments
|
version
|
|
Ctrl+A
|
Select All
|
None
|
All
|
|
Ctrl+B
|
Bold
|
Format, Cells, Font, Font Style, Bold
|
All
|
|
Ctrl+C
|
Copy
|
Edit, Copy
|
All
|
|
Ctrl+D
|
Fill Down
|
Edit, Fill, Down
|
All
|
|
Ctrl+F
|
Find
|
Edit, Find
|
All
|
|
Ctrl+G
|
Goto
|
Edit, Goto
|
All
|
|
Ctrl+H
|
Replace
|
Edit, Replace
|
All
|
|
Ctrl+I
|
Italic
|
Format, Cells, Font, Font Style, Italic
|
All
|
|
Ctrl+K
|
Insert Hyperlink
|
Insert, Hyperlink
|
Excel 97/2000 +
|
|
Ctrl+N
|
New Workbook
|
File, New
|
All
|
|
Ctrl+O
|
Open
|
File, Open
|
All
|
|
Ctrl+P
|
Print
|
File, Print
|
All
|
|
Ctrl+R
|
Fill Right
|
Edit, Fill Right
|
All
|
|
Ctrl+S
|
Save
|
File, Save
|
All
|
|
Ctrl+U
|
Underline
|
Format, Cells, Font,
Underline, Single
|
All
|
|
Ctrl+V
|
Paste
|
Edit, Paste
|
All
|
|
Ctrl W
|
Close
|
File, Close
|
Excel 97/2000 +
|
|
Ctrl+X
|
Cut
|
Edit, Cut
|
All
|
|
Ctrl+Y
|
Repeat
|
Edit, Repeat
|
All
|
|
Ctrl+Z
|
Undo
|
Edit, Undo
|
All
|
|
F1
|
Help
|
Help, Contents and
Index
|
All
|
|
F2
|
Edit
|
None
|
All
|
|
F3
|
Paste Name
|
Insert, Name, Paste
|
All
|
|
F4
|
Repeat last action
|
Edit, Repeat. Works while not in Edit
mode.
|
All
|
|
F4
|
While typing a formula,
switch between absolute/relative refs
|
None
|
All
|
|
F5
|
Goto
|
Edit, Goto
|
All
|
|
F6
|
Next Pane
|
None
|
All
|
|
F7
|
Spell check
|
Tools, Spelling
|
All
|
|
F8
|
Extend mode
|
None
|
All
|
|
F9
|
Recalculate all workbooks
|
Tools, Options, Calculation, Calc Now
|
All
|
|
F10
|
Activate Menubar
|
N/A
|
All
|
|
F11
|
New Chart
|
Insert, Chart
|
All
|
|
F12
|
Save As
|
File, Save As
|
All
|
|
Ctrl+:
|
Insert Current Time
|
None
|
All
|
|
Ctrl+;
|
Insert Current Date
|
None
|
All
|
|
Ctrl+"
|
Copy Value from Cell Above
|
Edit, Paste Special, Value
|
All
|
|
Ctrl+’
|
Copy Formula from Cell
Above
|
Edit, Copy
|
All
|
|
Shift
|
Hold down shift for additional functions
in Excel’s menu
|
none
|
Excel 97/2000 +
|
|
Shift+F1
|
What’s This?
|
Help, What’s This?
|
All
|
|
Shift+F2
|
Edit cell comment
|
Insert, Edit Comments
|
All
|
|
Shift+F3
|
Paste function into
formula
|
Insert, Function
|
All
|
|
Shift+F4
|
Find Next
|
Edit, Find, Find Next
|
All
|
|
Shift+F5
|
Find
|
Edit, Find, Find Next
|
All
|
|
Shift+F6
|
Previous Pane
|
None
|
All
|
|
Shift+F8
|
Add to selection
|
None
|
All
|
|
Shift+F9
|
Calculate active worksheet
|
Tools, Options, Calculation, Calc Sheet
|
All
|
|
Ctrl+Alt+F9
|
Calculate all
worksheets in all open workbooks, regardless of whether they have changed
since the last calculation.
|
None
|
Excel 97/2000 +
|
|
Ctrl+Alt+Shift+F9
|
Rechecks dependent formulas and then
calculates all cells in all open workbooks, including cells not marked as
needing to be calculated.
|
None
|
Excel 97/2000 +
|
|
Shift+F10
|
Display shortcut menu
|
None
|
All
|
|
Shift+F11
|
New worksheet
|
Insert, Worksheet
|
All
|
|
Shift+F12
|
Save
|
File, Save
|
All
|
|
Ctrl+F3
|
Define name
|
Insert, Names, Define
|
All
|
|
Ctrl+F4
|
Close
|
File, Close
|
All
|
|
Ctrl+F5
|
XL, Restore window size
|
Restore
|
All
|
|
Ctrl+F6
|
Next workbook window
|
Window, ...
|
All
|
|
Shift+Ctrl+F6
|
Previous workbook window
|
Window, ...
|
All
|
|
Ctrl+F7
|
Move window
|
XL, Move
|
All
|
|
Ctrl+F8
|
Resize window
|
XL, Size
|
All
|
|
Ctrl+F9
|
Minimize workbook
|
XL, Minimize
|
All
|
|
Ctrl+F10
|
Maximize or restore window
|
XL, Maximize
|
All
|
|
Ctrl+F11
|
Inset 4.0 Macro sheet
|
None in Excel 97. In
versions prior to 97 - Insert, Macro, 4.0 Macro
|
All
|
|
Ctrl+F12
|
File Open
|
File, Open
|
All
|
|
Alt+F1
|
Insert Chart
|
Insert, Chart...
|
All
|
|
Alt+F2
|
Save As
|
File, Save As
|
All
|
|
Alt+F4
|
Exit
|
File, Exit
|
All
|
|
Alt+F8
|
Macro dialog box
|
Tools, Macro, Macros in Excel 97
Tools,Macros - in earlier versions
|
Excel 97/2000 +
|
|
Alt+F11
|
Visual Basic Editor
|
Tools, Macro, Visual
Basic Editor
|
Excel 97/2000 +
|
|
Ctrl+Shift+F3
|
Create name by using names of row and
column labels
|
Insert, Name, Create
|
All
|
|
Ctrl+Shift+F6
|
Previous Window
|
Window, ...
|
All
|
|
Ctrl+Shift+F12
|
Print
|
File, Print
|
All
|
|
Alt+Shift+F1
|
New worksheet
|
Insert, Worksheet
|
All
|
|
Alt+Shift+F2
|
Save
|
File, Save
|
All
|
|
Alt+=
|
AutoSum
|
No direct equivalent
|
All
|
|
Ctrl+`
|
Toggle Value/Formula display
|
Tools, Options, View, Formulas
|
All
|
|
Ctrl+Shift+A
|
Insert argument names
into formula
|
No direct equivalent
|
All
|
|
Alt+Down arrow
|
Display AutoComplete list
|
None
|
Excel 95
|
|
Alt+’
|
Format Style dialog box
|
Format, Style
|
All
|
|
Ctrl+Shift+~
|
General format
|
Format, Cells, Number, Category, General
|
All
|
|
Ctrl+Shift+!
|
Comma format
|
Format, Cells, Number,
Category, Number
|
All
|
|
Ctrl+Shift+@
|
Time format
|
Format, Cells, Number, Category, Time
|
All
|
|
Ctrl+Shift+#
|
Date format
|
Format, Cells, Number,
Category, Date
|
All
|
|
Ctrl+Shift+$
|
Currency format
|
Format, Cells, Number, Category, Currency
|
All
|
|
Ctrl+Shift+%
|
Percent format
|
Format, Cells, Number,
Category, Percentage
|
All
|
|
Ctrl+Shift+^
|
Exponential format
|
Format, Cells, Number, Category,
|
All
|
|
Ctrl+Shift+&
|
Place outline border
around selected cells
|
Format, Cells, Border
|
All
|
|
Ctrl+Shift+_
|
Remove outline border
|
Format, Cells, Border
|
All
|
|
Ctrl+Shift+*
|
Select the current
region around the active cell. In a PivotTable report, select the entire
PivotTable report.
|
Edit, Goto, Special,
Current Region
|
All
|
|
Ctrl++
|
Insert
|
Insert, (Rows, Columns, or Cells) Depends
on selection
|
All
|
|
Ctrl+-
|
Delete
|
Delete, (Rows, Columns,
or Cells) Depends on selection
|
All
|
|
Ctrl+1
|
Format cells dialog box
|
Format, Cells
|
All
|
|
Ctrl+2
|
Bold
|
Format, Cells, Font,
Font Style, Bold
|
All
|
|
Ctrl+3
|
Italic
|
Format, Cells, Font, Font Style, Italic
|
All
|
|
Ctrl+4
|
Underline
|
Format, Cells, Font,
Font Style, Underline
|
All
|
|
Ctrl+5
|
Strikethrough
|
Format, Cells, Font, Effects,
Strikethrough
|
All
|
|
Ctrl+6
|
Show/Hide objects
|
Tools, Options, View,
Objects, Show All/Hide
|
All
|
|
Ctrl+7
|
Show/Hide Standard toolbar
|
View, Toolbars, Stardard
|
All
|
|
Ctrl+8
|
Toggle Outline symbols
|
None
|
All
|
|
Ctrl+9
|
Hide rows
|
Format, Row, Hide
|
All
|
|
Ctrl+0
|
Hide columns
|
Format, Column, Hide
|
All
|
|
Ctrl+Shift+(
|
Unhide rows
|
Format, Row, Unhide
|
All
|
|
Ctrl+Shift+)
|
Unhide columns
|
Format, Column, Unhide
|
All
|
|
Alt or F10
|
Activate the menu
|
None
|
All
|
|
Ctrl+Tab
|
In toolbar: next
toolbar
In a workbook: activate next workbook |
None
|
Excel 97/2000 +
|
|
Shift+Ctrl+Tab
|
In toolbar: previous toolbar
In a workbook: activate previous workbook |
None
|
Excel 97/2000 +
|
|
Tab
|
Next tool
|
None
|
Excel 97/2000 +
|
|
Shift+Tab
|
Previous tool
|
None
|
Excel 97/2000 +
|
|
Enter
|
Do the command
|
None
|
Excel 97/2000 +
|
|
Alt+Enter
|
Start a new line in the same cell.
|
None
|
Excel 97/2000 +
|
|
Ctrl+Enter
|
Fill the selected cell
range with the current entry.
|
None
|
Excel 97/2000 +
|
|
Shift+Ctrl+F
|
Font Drop Down List
|
Format, Cells, Font
|
All
|
|
Shift+Ctrl+F+F
|
Font tab of Format Cell
Dialog box
|
Format, Cells, Font
|
Before 97/2000
|
|
Shift+Ctrl+P
|
Point size Drop Down List
|
Format, Cells, Font
|
All
|
|
Ctrl+Spacebar
|
Select the entire
column
|
None
|
Excel 97/2000 +
|
|
Shift+Spacebar
|
Select the entire row
|
None
|
Excel 97/2000 +
|
|
CTRL+/
|
Select the array
containing the active cell.
|
|
|
|
CTRL+SHIFT+O
|
Select all cells that contain comments.
|
|
|
|
CTRL+\
|
In a selected row,
select the cells that don’t match the formula or static value in the active
cell.
|
|
|
|
CTRL+SHIFT+|
|
In a selected column, select the cells
that don’t match the formula or static value in the active cell.
|
|
|
|
CTRL+[
|
Select all cells
directly referenced by formulas in the selection.
|
|
|
|
CTRL+SHIFT+{
|
Select all cells directly or indirectly
referenced by formulas in the selection.
|
|
|
|
CTRL+]
|
Select cells that
contain formulas that directly reference the active cell.
|
|
|
|
CTRL+SHIFT+}
|
Select cells that contain formulas that
directly or indirectly reference the active cell.
|
|
|
|
ALT+;
|
Select the visible
cells in the current selection.
|
|
|
|
SHIFT+BACKSPACE
|
With multiple cells selected, select only
the active cell.
|
|
|
|
CTRL+SHIFT+SPACEBAR
|
Selects the entire
worksheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet |
|
|
|
Ctrl+Alt+L
|
Reapply the filter and sort on the
current range so that changes you've made are included
|
Data, Reapply
|
Excel 2007+
|
|
Ctrl+Alt+V
|
Displays the Paste
Special dialog box. Available only after you have cut or copied an object,
text, or cell contents on a worksheet or in another program.
|
Home, Paste,
Paste Special...
|
Excel 2007+
|
No comments:
Post a Comment