Excel shortcut key

76. Alt + P: To go to the Page Layout tab in Ribbon.
77. Alt + M: To go to the Formulas tab in Ribbon.
78. Alt + A: To go to the Data tab in Ribbon.
79. Alt + R: To go to the Review tab in Ribbon.
80. Alt + W: To go to the View tab in Ribbon.
81. Alt + Y: To open the Help tab in Ribbon.
82. Alt + Q: To quickly jump to search.
83. Alt + Enter: To start a new line in a current cell.
84. Shift + F3: To open the Insert function dialog box.
85. F9: To calculate workbooks.
86. Shift + F9: To calculate an active workbook.
87. Ctrl + Alt + F9: To force calculate all workbooks.
88. Ctrl + F3: To open the name manager.
89. Ctrl + Shift + F3: To create names from values in rows and columns.
90. Ctrl + Alt + +: To zoom in inside a workbook.
91. Ctrl + Alt +: To zoom out inside a workbook.
92. Alt + 1: To turn on Autosave.
93. Alt + 2: To save a workbook.
94. Alt + F + E: To export your workbook.
95. Alt + F + Z: To share your workbook.
96. Alt + F + C: To close and save your workbook.
97. Alt or F11: To turn key tips on or off.
98. Alt + Y + W: To know what's new in Microsoft Excel.
99. F1: To open Microsoft Excel help.
100. Ctrl + F4: To close Microsoft Excel.

1. Ctrl + N: To create a new workbook.
2. Ctrl + O: To open a saved workbook.
3. Ctrl + S: To save a workbook.
4. Ctrl + A: To select all the contents in a workbook.
5. Ctrl + B: To turn highlighted cells bold.
6. Ctrl + C: To copy cells that are highlighted.
7. Ctrl + D: To fill the selected cell with the content of the cell right above.
8. Ctrl + F: To search for anything in a workbook.
9. Ctrl + G: To jump to a certain area with a single command.
10. Ctrl + H: To find and replace cell contents.
11. Ctrl + I: To italicise cell contents.
12. Ctrl + K: To insert a hyperlink in a cell.
13. Ctrl + L: To open the create table dialog box.
14. Ctrl + P: To print a workbook.
15. Ctrl + R: To fill the selected cell with the content of the cell on the left.
16. Ctrl + U: To underline highlighted cells.
17. Ctrl + V: To paste anything that was copied.
18. Ctrl + W: To close your current workbook.
19. Ctrl + Z: To undo the last action.
20. Ctrl + 1: To format the cell contents.
21. Ctrl + 5: To put a strikethrough in a cell.
22. Ctrl + 8: To show the outline symbols.
23. Ctrl + 9: To hide a row.
24. Ctrl + 0: To hide a column.
25. Ctrl + Shift + :: To enter the current time in a cell.
26. Ctrl + ;: To enter the current date in a cell.
27. Ctrl + `: To change the view from displaying cell values to formulas.
28. Ctrl + ‘: To copy the formula from the cell above.
29. Ctrl + -: To delete columns or rows.
30. Ctrl + Shift + =: To insert columns and rows.
31. Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell.
32. Ctrl + Shift + @: To apply time formatting.
33. Ctrl + Shift + !: To apply comma formatting.
34. Ctrl + Shift + $: To apply currency formatting.
35. Ctrl + Shift + #: To apply date formatting.
36. Ctrl + Shift + %: To apply percentage formatting.
37. Ctrl + Shift + &: To place borders around the selected cells.
38. Ctrl + Shift + _: To remove a border.
39. Ctrl + -: To delete a selected row or column.
40. Ctrl + Spacebar: To select an entire column.
41. Ctrl + Shift + Spacebar: To select an entire workbook.
42. Ctrl + Home: To redirect to cell A1.
43. Ctrl + Shift + Tab: To switch to the previous workbook.
44. Ctrl + Shift + F: To open the fonts menu under format cells.
45. Ctrl + Shift + O: To select the cells containing comments.
46. Ctrl + Drag: To drag and copy a cell or to a duplicate worksheet.
47. Ctrl + Shift + Drag: To drag and insert copy.
48. Ctrl + Up arrow: To go to the top most cell in a current column.
49. Ctrl + Down arrow: To jump to the last cell in a current column.
50. Ctrl + Right arrow: To go to the last cell in a selected row.
51. Ctrl + Left arrow: To jump back to the first cell in a selected row.
52. Ctrl + End: To go to the last cell in a workbook.
53. Alt + Page down: To move the screen towards the right.
54. Alt + Page Up: To move the screen towards the left.
55. Ctrl + F2: To open the print preview window.
56. Ctrl + F1: To expand or collapse the ribbon.
57. Alt: To open the access keys.
58. Tab: Move to the next cell.
59. Alt + F + T: To open the options.
60. Alt + Down arrow: To activate filters for cells.
61. F2: To edit a cell.
62. F3: To paste a cell name if the cells have been named.
63. Shift + F2: To add or edit a cell comment.
64. Alt + H + H: To select a fill colour.
65. Alt + H + B: To add a border.
66. Ctrl + 9: To hide the selected rows.
67. Ctrl + 0: To hide the selected columns.
68. Esc: To cancel an entry.
69. Enter: To complete the entry in a cell and move to the next one.
70. Shift + Right arrow: To extend the cell selection to the right.
71. Shift + Left arrow: To extend the cell selection to the left.
72. Shift + Space: To select the entire row.
73. Page up/ down: To move the screen up or down.
74. Alt + H: To go to the Home tab in Ribbon.
75. Alt + N: To go to the Insert tab in Ribbon.

Shortcut Action Menu
Ctrl+A
Ctrl
A
Select All None
Ctrl+B
Ctrl
B
Bold FormatCellsFontFont StyleBold
Ctrl+C
Ctrl
C
Copy EditCopy
Ctrl+D
Ctrl
D
Fill Down EditFillDown
Ctrl+F
Ctrl
F
Find EditFind
Ctrl+G
Ctrl
G
Goto EditGoto
Ctrl+H
Ctrl
H
Replace EditReplace
Ctrl+I
Ctrl
I
Italic FormatCellsFontFont StyleItalic
Ctrl+K
Ctrl
K
Insert Hyperlink InsertHyperlink
Ctrl+N
Ctrl
N
New Workbook FileNew
Ctrl+O
Ctrl
O
Open FileOpen
Ctrl+P
Ctrl
P
Print FilePrint
Ctrl+R
Ctrl
R
Fill Right EditFill Right
Ctrl+S
Ctrl
S
Save FileSave
Ctrl+U
Ctrl
U
Underline FormatCellsFontUnderlineSingle
Ctrl+V
Ctrl
V
Paste EditPaste
Ctrl W
Ctrl
W
Close FileClose
Ctrl+X
Ctrl
X
Cut EditCut
Ctrl+Y
Ctrl
Y
Repeat EditRepeat
Ctrl+Z
Ctrl
Z
Undo EditUndo
F1
F1
Help HelpContents and Index
F2
F2
Edit None
F3
F3
Paste Name InsertNamePaste
F4
F4
Repeat last action EditRepeat. Works while not in Edit mode.
F4
F4
While typing a formulaswitch between absolute/relative refs None
F5
F5
Goto EditGoto
F6
F6
Next Pane None
F7
F7
Spell check ToolsSpelling
F8
F8
Extend mode None
F9
F9
Recalculate all workbooks ToolsOptionsCalculationCalc,Now
F10
F10
Activate Menubar N/A
F11
F11
New Chart InsertChart
F12
F12
Save As FileSave As
Ctrl+:
Ctrl
:
Insert Current Time None
Ctrl+;
Ctrl
;
Insert Current Date None
Ctrl+"
Ctrl
"
Copy Value from Cell Above EditPaste SpecialValue
Ctrl+'
Ctrl
'
Copy Fromula from Cell Above EditCopy
Shift
Shift
Hold down shift for additional functions in Excel's menu none
Shift+F1
Shift
F1
What's This? HelpWhat's This?
Shift+F2
Shift
F2
Edit cell comment InsertEdit Comments
Shift+F3
Shift
F3
Paste function into formula InsertFunction
Shift+F4
Shift
F4
Find Next EditFindFind Next
Shift+F5
Shift
F5
Find EditFindFind Next
Shift+F6
Shift
F6
Previous Pane None
Shift+F8
Shift
F8
Add to selection None
Shift+F9
Shift
F9
Calculate active worksheet Calc Sheet
Shift+F10
Shift
F10
Display shortcut menu None
Shift+F11
Shift
F11
New worksheet InsertWorksheet
Shift+F12
Shift
F12
Save FileSave
Ctrl+F3
Ctrl
F3
Define name InsertNamesDefine
Ctrl+F4
Ctrl
F4
Close FileClose
Ctrl+F5
Ctrl
F5
XLRestore window size Restore
Ctrl+F6
Ctrl
F6
Next workbook window Window...
Shift+Ctrl+F6
Shift
Ctrl
F6
Previous workbook window Window...
Ctrl+F7
Ctrl
F7
Move window XLMove
Ctrl+F8
Ctrl
F8
Resize window XLSize
Ctrl+F9
Ctrl
F9
Minimize workbook XLMinimize
Ctrl+F10
Ctrl
F10
Maximize or restore window XLMaximize
Ctrl+F11
Ctrl
F11
Inset 4.0 Macro sheet None in Excel 97. In versions prior to 97 - InsertMacro4.0 Macro
Ctrl+F12
Ctrl
F12
File Open FileOpen
Alt+F1
Alt
F1
Insert Chart InsertChart...
Alt+F2
Alt
F2
Save As FileSave As
Alt+F4
Alt
F4
Exit FileExit
Alt+F8
Alt
F8
Macro dialog box ToolsMacroMacros in Excel 97 ToolsMacros - in earlier versions
Alt+F11
Alt
F11
Visual Basic Editor ToolsMacroVisual Basic Editor
Ctrl+Shift+F3
Ctrl
Shift
F3
Create name by using names of row and column labels InsertNameCreate
Ctrl+Shift+F6
Ctrl
Shift
F6
Previous Window Window...
Ctrl+Shift+F12
Ctrl
Shift
F12
Print FilePrint
Alt+Shift+F1
Alt
Shift
F1
New worksheet InsertWorksheet
Alt+Shift+F2
Alt
Shift
F2
Save FileSave
Alt+=
Alt
=
AutoSum No direct equivalent
Ctrl+
Ctrl

Toggle Value/Formula display ToolsOptionsViewFormulas
Ctrl+Shift+A
Ctrl
Shift
A
Insert argument names into formula No direct equivalent
Alt+Down arrow
Alt
Display AutoComplete list None
Alt+'
Alt
'
Format Style dialog box FormatStyle
Ctrl+Shift+~
Ctrl
Shift
~
General format FormatCellsNumberCategoryGeneral
Ctrl+Shift+!
Ctrl
Shift
!
Comma format FormatCellsNumberCategoryNumber
Ctrl+Shift+@
Ctrl
Shift
@
Time format FormatCellsNumberCategoryTime
Ctrl+Shift+#
Ctrl
Shift
#
Date format FormatCellsNumberCategoryDate
Ctrl+Shift+$
Ctrl
Shift
$
Currency format FormatCellsNumberCategoryCurrency

Ctrl+Shift+%
Ctrl
Shift
%
Percent format FormatCellsNumberCategoryPercentage
Ctrl+Shift+^
Ctrl
Shift
^
Exponential format FormatCellsNumberCategory,
Ctrl+Shift+&
Ctrl
Shift
&
Place outline border around selected cells FormatCellsBorder
Ctrl+Shift+_
Ctrl
Shift
_
Remove outline border FormatCellsBorder
Ctrl+Shift+*
Ctrl
Shift
*
Select current region EditGotoSpecialCurrent Region
Ctrl++
Ctrl
+
Insert Insert(Rows, Columns, or Cells) Depends on selection
Ctrl+-
Ctrl
-
Delete Delete(Rows, Columns, or Cells) Depends on selection
Ctrl+1
Ctrl
1
Format cells dialog box FormatCells
Ctrl+2
Ctrl
2
Bold FormatCellsFontFont StyleBold
Ctrl+3
Ctrl
3
Italic FormatCellsFontFont StyleItalic
Ctrl+4
Ctrl
4
Underline FormatCellsFontFont StyleUnderline
Ctrl+5
Ctrl
5
Strikethrough FormatCellsFontEffectsStrikethrough
Ctrl+6
Ctrl
6
Show/Hide objects ToolsOptionsViewObjectsShow All/Hide
Ctrl+7
Ctrl
7
Show/Hide Standard toolbar ViewToolbarsStardard
Ctrl+8
Ctrl
8
Toggle Outline symbols None
Ctrl+9
Ctrl
9
Hide rows FormatRowHide
Ctrl+0
Ctrl
0
Hide columns FormatColumnHide
Ctrl+Shift+(
Ctrl
Shift
(
Unhide rows FormatRowUnhide
Ctrl+Shift+)
Ctrl
Shift
)
Unhide columns FormatColumnUnhide
Alt or F10
Alt
/
F10
Activate the menu None
Ctrl+Tab
Ctrl
Tab
In toolbar: next toolbar None
Ctrl+Tab
Ctrl
Tab
In a workbook: activate next workbook None
Shift+Ctrl+Tab
Shift
Ctrl
Tab
In toolbar: previous toolbar None
Shift+Ctrl+Tab
Shift
Ctrl
Tab
In a workbook: activate previous workbook None
Tab
Tab
Next tool None
Shift+Tab
Shift
Tab
Previous tool None
Enter
Enter
Do the command None
Shift+Ctrl+F
Shift
Ctrl
F
Font Drop Down List FormatCellsFont
Shift+Ctrl+F+F
Shift
Ctrl
F
F
Font tab of Format Cell Dialog box FormatCellsFont
Shift+Ctrl+P
Shift
Ctrl
P
Point size Drop Down List

Ctrl+N: Create a new workbook.

Ctrl+O: Open an existing workbook.

Ctrl+S: Save a workbook.

F12: Open the Save As dialog box.

Ctrl+W: Close a workbook.

Ctrl+F4: Close Excel.

F4: Repeat the last command or action. ...

Shift+F11: Insert a new worksheet.

Channel created