MS EXCEL SHORTCUTS

Shortcut	Function
Ctrl + N	New Workbook
Ctrl + O	Open Workbook
Ctrl + S	Save Workbook
F12	Save As
Ctrl + P	Print
Ctrl + W	Close Workbook
Ctrl + F4	Close Excel
Alt + F4	Exit Excel
Ctrl + C	Copy
Ctrl + X	Cut
Ctrl + V	Paste
Ctrl + Z	Undo
Ctrl + Y	Redo
Ctrl + A	Select All
Ctrl + B	Bold
Ctrl + I	Italic
Ctrl + U	Underline
Ctrl + 1	Format Cells Dialog
Ctrl + F	Find
Ctrl + H	Replace
=	Start Formula
F2	Edit Active Cell
Shift + F3	Insert Function
Alt + =	AutoSum
F4	Repeat Last Action / Toggle Absolute/Relative
Ctrl + Shift + L	Toggle Filters
Ctrl + ;	Insert Current Date
Ctrl + Shift + :	Insert Current Time
Ctrl + D	Fill Down
Ctrl + R	Fill Right
Ctrl + T	Create Table
Ctrl + 5	Strikethrough
Ctrl + 9	Hide Rows
Ctrl + 0	Hide Columns
Ctrl + Shift + 0	Unhide Columns
Ctrl + Shift + 9	Unhide Rows
Ctrl + K	Insert Hyperlink
Alt + Enter	Insert Line Break in Cell
Ctrl + Page Down	Next Worksheet
Ctrl + Page Up	Previous Worksheet
Shift + Space	Select Entire Row
Ctrl + Space	Select Entire Column
Ctrl + Shift + Space	Select Entire Workbook
Ctrl + Shift + Arrow	Select to Edge of Data
Ctrl + Shift + End	Select to Last Used Cell
Ctrl + Shift + Home	Select from Current to Cell A1
F5	Go To
Ctrl + G	Go To
Ctrl + `	Show Formulas
Ctrl + `	Hide Formulas
Alt + F11	Open VBA Editor
Alt + F8	Macro Dialog
Ctrl + Shift + F9	Calculate Active Worksheet
Ctrl + Alt + F9	Calculate All Worksheets
F9	Calculate Selected Formulas
Shift + F9	Calculate Active Worksheet
Alt + F1	Create Default Chart
F11	Create Chart in New Sheet
Ctrl + `	Toggle Show/Hide Formulas
Ctrl + Shift + U	Expand/Collapse Formula Bar
Ctrl + Page Down	Next Worksheet
Ctrl + Page Up	Previous Worksheet
Alt + W, F	Freeze Panes
Alt + W, S	Split Window
Ctrl + Alt + F9	Recalculate All
Ctrl + Shift + F3	Create Named Range
Ctrl + Shift + L	Toggle Filters
F12	Save As
Ctrl + P	Print
Ctrl + W	Close Workbook
Ctrl + S	Save Workbook
Ctrl + O	Open Dialog
Ctrl + N	New Workbook
Ctrl + F4	Close Window
F4	Repeat Last Action
Ctrl + Shift + F3	Create Named Range
Alt + F8	Macro Dialog
Alt + F11	Open VBA Editor
Ctrl + Shift + F9	Calculate Active Worksheet
Ctrl + Alt + F9	Calculate All Worksheets
F9	Calculate Selected Formulas
Shift + F9	Calculate Active Worksheet
Alt + F1	Create Default Chart
F11	Create Chart in New Sheet
Ctrl + `	Show/Hide Formulas
Ctrl + Shift + U	Expand/Collapse Formula Bar
Ctrl + Shift + F3	Create Named Range
Ctrl + W	Close Workbook
Ctrl + P	Print Preview
F12	Save As
Alt + F4	Exit Excel
Ctrl + F1	Show/Hide Ribbon
Ctrl + Tab	Switch Open Workbooks
Ctrl + Shift + Tab	Switch to Previous Workbook
Ctrl + Page Down	Next Worksheet
Ctrl + Page Up	Previous Worksheet
Alt + W, F	Freeze Panes
Alt + W, S	Split Window
F1	Help
Ctrl + Shift + F3	Create Named Range