Excel short-cut keys

Excel S hortCuts Keys

Action
--------
Menu equivalent
------------------
comments
--------
Version
----------

Following tips are in above order.....

Ctrl+A
Select All
None
All

Ctrl+B
Bold
Format, Cells, Font, Font S tyle, 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 S tyle, 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, S ave
All

Ctrl+U
Underline
Format, Cells, Font, Underline, S ingle
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, S pelling
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, S ave As
All

Ctrl+:
Insert Current Time
None
All

Ctrl+;
Insert Current Date
None
All

Ctrl+"
Copy Value from Cell Above
Edit, Paste S pecial, Value
All

Ctrl+'
Copy Fromula 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
Calc S heet
All

Shift+F10
Display shortcut menu
None
All

Shift+F11
New worksheet
Insert, Worksheet
All

Shift+F12
Save
File, S ave
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, S ize
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, S ave 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+ S hift+F3
Create name by using names of row and column labels
Insert, Name, Create
All

Ctrl+ S hift+F6
Previous Window
Window, ...
All

Ctrl+ S hift+F12
Print
File, Print
All

Alt+ S hift+F1
New worksheet
Insert, Worksheet
All

Alt+ S hift+F2
Save
File, S ave
All

Alt+=
Auto S um
No direct equivalent
All

Ctrl+`
Toggle Value/Formula display
Tools, Options, View, Formulas
All

Ctrl+ S hift+A
Insert argument names into formula
No direct equivalent
All

Alt+Down arrow
Display AutoComplete list
None
Excel 95

Alt+'
Format S tyle dialog box
Format, S tyle
All

Ctrl+ S hift+~
General format
Format, Cells, Number, Category, General
All

Ctrl+ S hift+!
Comma format
Format, Cells, Number, Category, Number
All

Ctrl+ S hift+@
Time format
Format, Cells, Number, Category, Time
All

Ctrl+ S hift+#
Date format
Format, Cells, Number, Category, Date
All

Ctrl+ S hift+$
Currency format
Format, Cells, Number, Category, Currency
All

Ctrl+ S hift+%
Percent format
Format, Cells, Number, Category, Percentage
All

Ctrl+ S hift+^
Exponential format
Format, Cells, Number, Category,
All

Ctrl+ S hift+&
Place outline border around selected cells
Format, Cells, Border
All

Ctrl+ S hift+_
Remove outline border
Format, Cells, Border
All

Ctrl+ S hift+*
Select current region
Edit, Goto, S pecial, 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 S tyle, Bold
All

Ctrl+3
Italic
Format, Cells, Font, Font S tyle, Italic
All

Ctrl+4
Underline
Format, Cells, Font, Font S tyle, Underline
All

Ctrl+5
Strikethrough
Format, Cells, Font, Effects, S trikethrough
All

Ctrl+6
Show/Hide objects
Tools, Options, View, Objects, S how All/Hide
All

Ctrl+7
Show/Hide S tandard toolbar
View, Toolbars, S tardard
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+ S hift+(
Unhide rows
Format, Row, Unhide
All

Ctrl+ S hift+)
Unhide columns
Format, Column, Unhide
All

Alt or F10
Activate the menu
None
All

Ctrl+Tab
In toolbar: next toolbar
None
Excel 97/2000

Shift+Ctrl+Tab
In toolbar: previous toolbar
None
Excel 97/2000

Ctrl+Tab
In a workbook: activate next workbook
None


Comments

Author: Deepika Haridas19 Dec 2008 Member Level: Gold   Points : 1

Good one...

Thanks for posting it..
Informative one..

Thanks & Regards,
Deepika

Author: Vijay19 Dec 2008 Member Level: Gold   Points : 0

Thanks Deepika!!!



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: