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.
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 onthe 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.
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:
Selection Shortcuts
There are also Excel keyboard shortcuts to more easily manage the selection of cells, rows or columns in a workbook:
Cell Shaping Shortcuts
To format our cells, we can also do it using the following shortcuts:
Shortcuts OFEEditing Cells
Editing cells can be much more convenient if you try to use the shortcuts shown below:
Cell Content Manipulation Shortcuts
To manipulate cell content much more fluidly, you can start by implementing the following shortcuts:
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.