Enhance Productivity With Excel Keyboard Shortcuts

What is Excel Keyboard Shortcuts?

Excel keyboard shortcuts are key combinations that accomplish a particular purpose.

They are created to help Excel users quickly access the features that they want without clicking multiple buttons or going to multiple menus.

Aside from its benefits and helping us a lot, learning keyboard shortcuts is also fun.

Many people have already benefited from this, particularly students and employees. It is an advantage to learn shortcuts, as it makes our work more efficient.

Basic Keyboard Shortcuts in Excel

The following are the primary or well-known keyboard shortcuts in Excel that we must master: Through these shortcuts, our work with Excel may become more efficient and hassle-free.

So, without further ado, here are the basic keyboard shortcuts.

Shortcut Key	Description
Ctrl + A	Used to select all the data on the worksheet.
Ctrl + B	Used to bold selected text on the worksheet.
Ctrl + C	Used to copy texts or cells on worksheets.
Ctrl + F	Used to open the find dialog box.
Ctrl + I	Used to change the text into italics.
Ctrl + N	Used to create a new workbook.
Ctrl + O	Used to open a file or workbook.
Ctrl + P	Used to print your data.
Ctrl + S	Used to save the data input.
Ctrl + U	Used to underline text.
Ctrl + V	Used to paste copied texts or cells.
Ctrl + W	Used to close a file or workbook.
Ctrl + X	Used to cut or move the selected texts or cells.
Ctrl + Y	Used to redo or repeat the last action.
Ctrl + Z	Used to undo recent action.

Navigation Shortcuts

Since we already know the basic keyboard shortcuts, let’s also learn Excel’s navigation shortcuts. Here are some:

Shortcut Key	Description
Arrow Keys (←↓↑→)	Used to move the cursor left, down, up, or right.
Ctrl + Left Arrow Key (←)	Used to move to the left end of the worksheet.
Ctrl + Right Arrow Key (→)	Used to move to the right end of the worksheet.
Ctrl + Up Arrow Key (↑)	Used to move to the top of the worksheet.
Ctrl + Down Arrow Key (↓)	Used to move to the bottom of the worksheet.
Tab	Used to move one cell to the right.
Shift + Tab	Used to move to the previous cell.
Ctrl + End	Used to move to the last cell of the worksheet that contains data.
Ctrl + Home	Used to move to the beginning of the worksheet.

Ribbon Keyboard Shortcuts

The following are the ribbon keyboard shortcuts we must know.

Hold the Alt key to show shortcut keys for the ribbon commands in Excel. Upon pressing the Alt key, this will show up:

See the shortcut keys below to understand further.

Shortcut Key	Description
Alt + F	Used to open the File Menu.
Alt + H	Used to open the Home tab.
Alt + N	Used to open the Insert tab.
Alt + P	Used to open the Page Layout tab.
Alt + M	Used to open the Formulas tab.
Alt + A	Used to open the Data tab.
Alt + R	Used to open the review tab.
Alt + W	Used to open the View tab.
Alt + L	Used to open the developer tab.
Alt + Y	Used to open the Help tab.
Alt + Q	Used to move to the search field.

See also the keyboard shortcuts upon clicking the following:

1. Alt + H or the Home tab.

2. Alt + N or the Insert tab.

3. Alt + P or the Page Layout tab.

4. Alt + M or the Formulas tab.

5. Alt + A or the Data tab.

6. Alt + R or the Review tab.

7. Alt + W or the View tab.

8. Alt + L or the Developer tab.

9. Alt + Y or the Help tab.

Insert Keyboard Shortcuts

The following are the insert keyboard shortcuts. Learn some shortcut keys for inserting features into our Excel files or worksheets. Here are some:

Shortcut Key	Description
Alt + F1	Used to insert a chart.
Ctrl + Shift + (+)	Used to insert a cell, row, or column.
Alt + I + C	Used to insert a column.
Alt + I + R	Used to insert a row.
Alt + N + P	Used to insert a picture.
Alt + N + S + H	Used to insert a shape.
Alt + N + U	Used to insert a symbol.
Alt + N + V	Used to insert a pivot table.
Alt + N + X	Used to insert a textbox.
Ctrl + 5	Used to insert a strikethrough into text.
Ctrl + (;)	Used to insert the current date.
Ctrl + Shift + (;)	Used to insert the current time.
Ctrl + K	Used to insert hyperlinks in texts.
Ctrl + T	Used to insert a table.
Shift + F2	Used to insert a cell comment.
Shift + F11	Used to insert a new worksheet.

Formatting Cells

The following are some keyboard shortcut keys for formatting cells.

Shortcut Key	Description
Ctrl + 1	Used to open the Format Cells dialog box.
Ctrl + T	Used to change or convert selected cells to a table.
Ctrl + Q	Used to show the quick analysis tool.
Ctrl + Shift + F	Used to format fonts in the format cells dialog box.
Ctrl + Shift + G	Used to display the workbook statistics dialog box.
Ctrl + Shift + (&)	Used to apply an outline border to selected cells.
Ctrl + Shift + (_)	Used to remove the outline border from selected cells.
Ctrl + Shift + (~)	Used to apply the general number format.
Alt + H + FG	Used to increase the font size.
Alt + H + FK	Used to decrease the font size.
Alt + H + M + C	Used to merge cells.
Alt + H + M + U	Used to unmerge cells.
Alt + H + H	Used to change cell color.

Symbols Keyboard Shortcuts

The following are keyboard shortcuts for commonly used symbols in Excel that are not found on the keyboard itself.

Shortcut Key	Description
Alt + 24	(↑) Up arrow symbol
Alt + 25	(↓) Down arrow symbol
Alt + 26	(→) Right arrow symbol
Alt + 27	(←) Left arrow symbol
Alt + 251	(√) Check symbol
Alt + 0128	(€) Euro symbol
Alt + 0162	(¢) Cent symbol
Alt + 0163	(£) Pound symbol
Alt + 0169	(©) Copyright symbol
Alt + 0176	(°) Degree symbol
Alt + 0247	(÷) Division symbol
Alt + 0215	(×) Multiplication symbol

Keyboard Shortcuts Advantages

The following are some of the advantages of using keyboard shortcuts:

• IMPROVES PRODUCTIVITY. Using keyboard shortcuts improves user productivity as it allows users to have quick access to Excel’s features.
• SAVES USER TIME. Using keyboard shortcuts saves users time as it allows them to work quickly and efficiently.
• LESSEN STRESS. Using keyboard shortcuts lessens users’ stress as it makes their work easier and more uncomplicated.

Conclusion

In conclusion, keyboard shortcuts in Excel are essential for anyone who’s working with Excel. These shortcuts not only save users’ time but also help them improve their productivity.

All in all, Excel’s keyboard shortcuts make the user’s work simple and more productive.

I hope you’ve learned something from this. Do not forget to share this with your friends.

Thank you for reading! If you have any questions or suggestions, please leave a comment below.

New Excel shortcuts added in 2026

The 2026 Excel channel update introduced Copilot voice shortcuts. Hold Alt + V (Windows) or Cmd + V + Shift (Mac) to open a voice-command pane where you can dictate actions like Sort by column B descending or Insert a PivotTable summarizing sales by region. Copilot converts speech to the appropriate Excel action.

New keyboard shortcuts added to the 2026 build:

• Ctrl + Shift + K :Open Copilot side panel
• Alt + JT F :Toggle PivotTable Field List
• Ctrl + Alt + V :Paste Special dialog (unchanged, still works)
• Alt + H + F + D + F :Format as currency

Common mistakes with Excel shortcuts

• Using F4 wrong. F4 in edit mode toggles absolute references ($A$1 → A$1 → $A1 → A1). F4 outside edit mode repeats the last action. Different key context, different behavior.
• Ctrl + Z limit reached. Excel remembers only the last 100 actions by default. Set File > Options > Advanced > General > Undo levels to 500 or higher if you need deeper undo history.
• Shortcut fights AutoCorrect. Some shortcuts clash with AutoCorrect entries. If Ctrl + Shift + K opens a browser bookmark manager instead of Copilot, disable the browser shortcut in browser settings.
• Locale differences. The European keyboard layout uses semicolons where the US layout uses commas in function arguments. Adjust your shortcut memory for local Excel install.

Shortcut cheat sheet by category

Print or bookmark this sheet as your daily reference:

• Navigation: Ctrl + Arrow, Ctrl + Home, Ctrl + End, Ctrl + PgUp / PgDn (switch sheets)
• Selection: Ctrl + Shift + Arrow, Ctrl + A, Shift + Click
• Editing: F2 (edit), F5 (Go To), Ctrl + F (Find), Ctrl + H (Replace)
• Formatting: Ctrl + B/I/U, Ctrl + 1 (Format Cells), Ctrl + 5 (strikethrough)
• Data: Alt + = (AutoSum), Ctrl + T (Table), Ctrl + Q (Quick Analysis)
• Copilot (2026 new): Ctrl + Shift + K (panel), Alt + V (voice)

Quick step-by-step summary (click to expand)

1. Start with navigation shortcuts Ctrl + Arrow keys jumps to the edge of the current data region. Ctrl + Home jumps to A1. Ctrl + End jumps to the last used cell.
2. Learn selection shortcuts Ctrl + Shift + Arrow selects to the data edge. Ctrl + Space selects the entire column. Shift + Space selects the entire row.
3. Speed up formatting Ctrl + B for bold, Ctrl + I for italic, Ctrl + U for underline, Ctrl + 1 opens the Format Cells dialog.
4. Master formula shortcuts F2 edits the active cell. F4 toggles absolute references. Alt + = auto-sums the range above. Ctrl + Shift + Enter used to enter array formulas (no longer needed for dynamic arrays).
5. Learn data entry shortcuts Tab moves right, Shift + Tab moves left. Enter moves down. Ctrl + D fills down from the cell above. Ctrl + R fills right.