Complete List of Excel Shortcut Keys

Master these Excel shortcut keys to boost your productivity and work efficiently with spreadsheets.

Basic Excel Shortcut Keys

Shortcut Key	Function
Ctrl + A	Select all contents of the worksheet
Ctrl + B	Bold
Ctrl + C	Copy
Ctrl + V	Paste
Ctrl + X	Cut
Ctrl + F	Search
Ctrl + H	Find and Replace
Ctrl + N	Create a new workbook
Ctrl + O	Open an existing workbook
Ctrl + S	Save
Ctrl + W	Close a workbook
Ctrl + K	Insert a hyperlink
Ctrl + Y	Redo
Ctrl + Z	Undo
Ctrl + I	Italicize text
Ctrl + U	Underline

Workbook & Worksheet Navigation Shortcuts

Shortcut Key	Function
Ctrl + F1	Show or hide the ribbon
Ctrl + F2	Open Print Preview
Ctrl + F4	Close Excel
Ctrl + F9	Minimize workbook
Ctrl + F10	Restore workbook
Ctrl + 9	Hide row
Ctrl + 0	Hide column
Ctrl + Shift + (	Unhide hidden rows
Ctrl + Shift + )	Unhide hidden columns

Formatting & Selection Shortcuts

Shortcut Key	Function
Ctrl + Space	Select the entire column
Shift + Space	Select the entire row
Ctrl + Shift + $	Apply Currency format
Ctrl + Shift + %	Apply Percentage format
Ctrl + Shift + &	Apply outline border
Ctrl + Shift + _	Remove outline border
Alt + H + I + S	Insert new worksheet
Alt + H + H	Change cell color
Alt + H + F + C	Change font color

Advanced Shortcuts for Data & Charts

Shortcut Key	Function
Alt + N + V	Insert Pivot Table
Alt + H + O + S	Hide a worksheet
Alt + H + O + U	Unhide a worksheet
Alt + F8	Open Macros
Alt + M + D	Formula Tracing
Alt + A + E + F	Convert Text to Columns
Alt + W + F + F	Freeze/Unfreeze Panes
Alt + F1	Insert a chart
Ctrl + Shift + L	Apply Data Filter
Alt + N + G	Insert Column Chart
Alt + P	Open Page Layout

Conclusion

These Excel shortcut keys will help you become more productive and efficient while working on spreadsheets. Save this page for future reference and start mastering these shortcuts today!