Microsoft Excel Shortcut Keys

Microsoft Excel is one of the most popular and widely used spreadsheet software around the globe, both for personal and professional use. One of the best ways to work faster and improve your efficiency in Excel is by using keyboard shortcuts. These shortcuts help you to complete tasks quickly, save time, and move around your spreadsheet easily. Not using shortcuts, can slow down your work, as tasks that could be done quickly with a few keystrokes may take longer if you are relying solely on the mouse. By using shortcuts, you can work faster and get more done in less time. here in this post i am going to explain most important Microsoft excel shortcut keys.

Below is a comprehensive list of useful Excel Specific shortcut keys that can help you work faster, more efficiently and take full advantage of Excel’s features.

Formula, Function & Data Processing Shortcuts

Shortcut Key	Function
Alt + =	Automatically sum a range of cells
Ctrl + Shift + U	Expand or collapse the formula bar
Ctrl + F3	Open the Name Manager
Shift + F3	Open the “Insert Function” dialog box
Alt + Enter	Create a new line within a cell
Alt + F1	Insert chart on the active sheet
Alt + H, D, C	Delete the column of the active cell
Alt + H, E, A	Clear the selected cell data
Ctrl + L	Open create table box
Shift + F2	Insert comment on the cell
Shift + F5	Find and replace
Shift + F10 + M	Add or delete comment from the selected cell

Cell Editing Shortcuts

Workbook and Sheet Management Shortcuts

Shortcut Key	Function
Ctrl + N	Open a new workbook
Ctrl + O	Open an existing workbook
Ctrl + S	Save the current workbook
Ctrl + W OR Alt+F4	Close the current workbook
Ctrl + P	Open the Print dialog box
Ctrl + Tab	Switch to the next open workbook
Ctrl + Shift + Tab	Go to previous workbook
Ctrl + Page Up / Page Down	Switch between sheets in the workbook.
Shift + F11	Create new worksheet
Ctrl + Page Down	Go to the next sheet
Ctrl + Page Up	Go to the previous sheet
Alt + H + O + R	Rename a sheet
Alt + H + D + S	Delete a sheet:
Ctrl + G (or F5), type the sheet name (e.g., “Sheet1”), and press Enter to directly go to that sheet.	Go to a specific Sheet

Menu and Ribbon Shortcuts

Shortcut Key	Function
Alt	Activates the ribbon and allows you to access the ribbon tabs (e.g., Alt + F for the File tab).
Alt + A	Go to the Data tab
Ctrl + F1	Show or hide the ribbon

Formatting Shortcuts

Shortcut Key	Function
Ctrl + 2	Apply bold
Ctrl + 3	Apply italic
Ctrl + 4	Apply underline
Ctrl + 5	Apply strikethrough
Ctrl + B	Bold selected content
Ctrl + I	Make the selected text italic
Ctrl + U	Underline the text
Ctrl + Shift + !	Format cell in number format
Ctrl + Shift + $	Format cell in $ currency format
Ctrl + Shift + %	Format cell in % format
Ctrl + Shift + &	Apply border around the cell
Ctrl + Shift + #	Format cell in date format
Ctrl + Shift + @	Format cell in time format
Ctrl + Shift + ^	Format cell in exponential format

Navigation Shortcuts

Shortcut Key	Function
Ctrl + Arrow Keys	Move to the end of the selected range (up, down, left, right)
Page Up / Page Down	Move one screen up/down
Ctrl + Home	Go to start of the sheet
Ctrl + End	Go to the lowest used cell in the workbook
Ctrl + G	Go to the named cell
Ctrl + Shift + Arrows	Select till the nonblank cell in the arrow direction
Ctrl + Shift + End:	Select the range from the current cell to the lowest used cell

Selection Shortcuts

Shortcut Key	Function
Ctrl + A	Select all cells in the current worksheet
Shift + Arrow Keys	Extend the selection by one cell
Ctrl + Shift + Arrow Keys	Extend the selection to the last used cell in the direction of the arrow
Ctrl + Spacebar	Select the entire column of the active cell
Shift + Spacebar	Select the entire row of the active cell.

Dialog Box Shortcuts

Shortcut Key	Function
Alt + A, M	Open Remove Duplicate dialog box
Alt + F8	Open Macro popup box
Alt + H, C, P	Open Copy Picture dialog box
Alt + T, O	Open Excel Options dialog
Ctrl + F3	Open name manager
Ctrl + F5	Open Go To popup box
Ctrl + 1	Open format cells popup box

General Shortcuts

Shortcut Key	Function
Ctrl + Shift + L	Toggle auto filter
Ctrl + F1	Show or hide the ribbon
Alt + F4	Close the Excel application
Ctrl + Shift + O	Select all cells with comments
Ctrl + Shift + Spacebar	Select the entire workbook content
Esc	Cancel the selected or current operation

These shortcut keys are unique to Excel, and are useful for completing specific tasks in Excel. By using these shortcuts, you can save time and improve your productivity in Excel.

I hope this tutorial will helps you in guiding you through Excel-specific shortcut keys. If you have any questions, suggestions, or feedback, please don’t hesitate to reach out to us.

Thank You.