TOP 50 Most Convenient Excel Keyboard Shortcuts To Use

Knowing and using Excel keyboard shortcuts is one of the best ways to optimize your working time and stay focused on your goals without getting lost in the different menus. It is in this context that I wrote this article.

Excel Keyboard Shortcuts
Excel Keyboard Shortcuts

TOP 50 Most Convenient Excel Keyboard Shortcuts To Use

I present the list of the most effective Excel keyboard shortcuts and the most apt to  boost your productivity. (Especially the ones I use). They are sorted by category and function, so you won’t have a hard time assimilating them.

Why Use Excel Keyboard Shortcuts?

Certainly, for someone who does not master shortcuts or who has not gotten into the habit of using them, it is quite normal to wonder what is the real use.

Well, we use them for the following reasons:

  • An ergonomic and practical way: Working while keeping both hands on the keyboard gives much more fluidity and maneuverability.
  • Speed ​​and ease of handling:  Shortcuts allow us to perform complex operations more easily and in less time.
  • Work more efficiently:  This working method guarantees us more efficiency.

To put it simply, using Excel keyboard shortcuts is especially effective in boosting your speed and productivity.

The Best Excel Keyboard Shortcuts

There are many Excel shortcuts, more or less practical depending on your use and your needs.

You might not be able to learn them all, but you can start by noting and applying the ones that interest you the most. And once you get more comfortable with these manipulations, you can learn more.

The shortcuts in this list have been tested on the Excel 2019 version (they are also compatible with earlier versions)

General Shortcuts

In the following, you will discover general shortcuts allowing you to perform simple actions and navigate the various Excel tabs and menus:

  • CTRL + N: This shortcut allows you to create a new workbook
  • CTRL + O or CTRL + F12:  You can use these two shortcuts to open a workbook.
  • CTRL + P: To print the workbook just use this shortcut.
  • F12:  This function is used to execute the “Save as” command.
  • CTRL + S: This shortcut is used to save your changes to a workbook.
  • CTRL + W or CTRL + F4: To close the workbook in 2 clicks, just use one of these 2 shortcuts.
  • Alt + F: This shortcut opens the “File” tab.
  • Alt + S: To access the “Insert” tab and insert pivot tables, graphics, images, shapes, headers or text boxes.
  • Alt + P : To open the “Layout” tab and choose themes, set the layout, scale and alignment.
  • Alt + U: This shortcut is used to open the “Formulas” tab and insert, track and customize functions and calculations. By pressing a little longer the formula window is displayed.
  • Alt + A: Open the “Data” tab to sort, filter, or analyze your data.
  • Alt + R Open the “Review” tab and check spelling, add notes and comments, and protect sheets.
  • Alt + N: This Excel shortcut is used to open the “View” tab to preview page breaks and layouts, etc.
  • Alt or F10: These 2 shortcuts can display the shortcuts of all the menus.
  • Tab or Shift + Tab: To move through the cells of the sheet.
  • The arrow keys: To navigate through the elements of the ribbon and menus down, up, left or right.
  • Space or Enter: These 2 keys are used to activate a selected button or a menu command.
  • Ctrl + F1: If you want to expand or collapse the ribbon.

Navigation Shortcuts In A Sheet

To navigate easily in a sheet without having to use the mouse each time, many shortcuts are practical and interesting to adopt:

  • CTRL + HOME: To go to the first cell of your worksheet.
  • CTRL + END: To go to the last cell of your worksheet.
  • ENTER: Once you have finished making changes to the current cell, click this button to move to the cell below.
  • TAB: This key is used to validate a cell and go to the right cell.
  • SHIFT + TAB: Validate a cell and go to the left cell.
  • F5: This function displays the Go To dialog box.
  • CTRL + DOWN: Go directly to the last non-empty cell in the column (down).
  • CTRL + UP: This shortcut is used to go directly to the last non-empty cell of the column (up).
  • CTRL + LEFT: To go directly to the first non-empty cell of the row (to the left).
  • CTRL + RIGHT: To go directly to the last non-empty cell of the row (to the right).
  • SHIFT + F5 or CTRL + F:  To display the search function.

Selection Shortcuts

There are also Excel keyboard shortcuts to more easily manage the selection of cells, rows or columns in a workbook:

  • CTRL + A: This shortcut allows you to select everything.
  • CTRL + SPACE: To select the current column.
  • SHIFT + SPACE: To select the current line.
  • ALT + (:  To hide the columns from the selection.
  • ALT +):  To display the columns of the selection.
  • ALT + “: To hide the lines of the selection
  • SHIFT + direction arrow: If we need to extend the selection in a chosen direction we use this shortcut.
  • CTRL + SHIFT + direction arrow:  This shortcut extends the selection to the last non-empty cell in a chosen direction
  • CTRL + SHIFT + END: If you want to extend the selection to the last used cell of the tab, you can use this shortcut.
  • ESC: To deselect the selection, just click on this button.

Cell Shaping Shortcuts

To format our cells, we can also do it using the following shortcuts:

  • CTRL + I  : To apply the Italic format, we use this shortcut.
  • CTRL + U: We use this shortcut to apply the Underlined format on our cell.
  • CTRL + G: To make the cell bold.
  • CTRL + SHIFT + 1: This shortcut displays the “Format Cells” dialog box.

Shortcuts OF E Editing Cells

Editing cells can be much more convenient if you try to use the shortcuts shown below:

  • Alt + Enter: Start a new line in the same cell.
  • Ctrl + Enter  : Copy the active entry into the selected cell range.
  • Shift + Enter: Validate the entry in the cell and select the cell above.
  • F2:  This function allows you to edit the content of a cell directly without going through the edit bar.
  • Ctrl + mouse button pressed  : This shortcut allows you to copy the contents of a cell by moving the mouse cursor to another cell.

Cell Content Manipulation Shortcuts

To manipulate cell content much more fluidly, you can start by implementing the following shortcuts:

  • CTRL + H: This shortcut opens the Replace function window
  • SHIFT + F2: You just have to click on these 2 keys to add or modify the comment on a cell.
  • F11:  This function is used to add a graph in a new tab. However, you have to check the settings or even change them as needed.
  • ALT + F1  : This shortcut allows you to add a chart in the same sheet.
  • CTRL + D: To duplicate the selected element (graphic, shape).
  • CTRL + +: To add a line at the level of the selected line.
  • CTRL + -: You click on these 2 keys if you need to delete the selected line.
  • CTRL + K: This shortcut is used to add a link to a website in the selected cell.

Conclusion

While the vast majority of Excel keyboard shortcuts go unrecognized by most people, I think the ones I use are really time-savers.

For my part, I cannot do without it. The trick is to find the right balance between your habits and the news to be more efficient and above all faster.

Leave a Reply

Your email address will not be published.