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 KeyDescription
Ctrl + AUsed to select all the data on the worksheet.
Ctrl + BUsed to bold selected text on the worksheet.
Ctrl + CUsed to copy texts or cells on worksheets.
Ctrl + FUsed to open the find dialog box.
Ctrl + IUsed to change the text into italics.
Ctrl + NUsed to create a new workbook.
Ctrl + OUsed to open a file or workbook.
Ctrl + PUsed to print your data.
Ctrl + SUsed to save the data input.
Ctrl + UUsed to underline text.
Ctrl + VUsed to paste copied texts or cells.
Ctrl + WUsed to close a file or workbook.
Ctrl + XUsed to cut or move the selected texts or cells.
Ctrl + YUsed to redo or repeat the last action.
Ctrl + ZUsed 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 KeyDescription
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.
TabUsed to move one cell to the right.
Shift + TabUsed to move to the previous cell.
Ctrl + EndUsed to move to the last cell of the worksheet that contains data.
Ctrl + HomeUsed 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:

Ribbon Keyboard Shortcuts
See the shortcut keys below to understand further.
Shortcut KeyDescription
Alt + FUsed to open the File Menu.
Alt + HUsed to open the Home tab.
Alt + NUsed to open the Insert tab.
Alt + PUsed to open the Page Layout tab.
Alt + MUsed to open the Formulas tab.
Alt + AUsed to open the Data tab.
Alt + RUsed to open the review tab.
Alt + WUsed to open the View tab.
Alt + LUsed to open the developer tab.
Alt + YUsed to open the Help tab.
Alt + QUsed to move to the search field.

See also the keyboard shortcuts upon clicking the following:

  1. Alt + H or the Home tab.
Shortcuts in Home tab - Enhance Productivity With Excel Keyboard Shortcuts
  1. Alt + N or the Insert tab.
Insert tab
  1. Alt + P or the Page Layout tab.
Shortcuts in Page Layout tab - Enhance Productivity With Excel Keyboard Shortcuts
  1. Alt + M or the Formulas tab.
Formulas tab
  1. Alt + A or the Data tab.
Shortcuts in Data tab - Enhance Productivity With Excel Keyboard Shortcuts
  1. Alt + R or the Review tab.
Review tab
  1. Alt + W or the View tab.
View tab - Enhance Productivity With Excel Keyboard Shortcuts
  1. Alt + L or the Developer tab.
Developer tab
  1. Alt + Y or the Help tab.
Help tab - Enhance Productivity With Excel Keyboard Shortcuts

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 KeyDescription
Alt + F1Used to insert a chart.
Ctrl + Shift + (+)Used to insert a cell, row, or column.
Alt + I + CUsed to insert a column.
Alt + I + RUsed to insert a row.
Alt + N + PUsed to insert a picture.
Alt + N + S + HUsed to insert a shape.
Alt + N + UUsed to insert a symbol.
Alt + N + VUsed to insert a pivot table.
Alt + N + XUsed to insert a textbox.
Ctrl + 5Used to insert a strikethrough into text.
Ctrl + (;)Used to insert the current date.
Ctrl + Shift + (;)Used to insert the current time.
Ctrl + KUsed to insert hyperlinks in texts.
Ctrl + TUsed to insert a table.
Shift + F2Used to insert a cell comment.
Shift + F11Used to insert a new worksheet.

Formatting Cells

The following are some keyboard shortcut keys for formatting cells.

Shortcut KeyDescription
Ctrl + 1Used to open the Format Cells dialog box.
Ctrl + TUsed to change or convert selected cells to a table.
Ctrl + QUsed to show the quick analysis tool.
Ctrl + Shift + FUsed to format fonts in the format cells dialog box.
Ctrl + Shift + GUsed 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 + FGUsed to increase the font size.
Alt + H + FKUsed to decrease the font size.
Alt + H + M + CUsed to merge cells.
Alt + H + M + UUsed to unmerge cells.
Alt + H + HUsed 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 KeyDescription
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.


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.

Leave a Comment