What are the most used keyboard shortcuts for Microsoft Excel? Full list 2022

Every time we use a tool like Microsoft Excel It is very useful for us to be able to use different keyboard commands to be able to speed up our tasks, taking into account that there are different shortcuts that end up being very useful when wanting to carry out some specific actions

A shortcut is a set of keys that are pressed simultaneously and that allows us to be able to run an action it is specific to a higher speed. In the case of programs like Excel, it is very common to use key combinations as they help improve productivity and speed at the time of work.

Therefore, if you are a user who constantly uses this type of program and you do not know these types of shortcuts, here we leave you a complete list of all the functions that you can perform in it through Windows and Mac keyboards.

List of the best shortcuts and key combinations to use Excel with the keyboard on Windows and Mac

When working with Excel, Either from Windows or Mac we can use a large number of key combinations that will help us speed up certain steps when we want to carry out a specific process, either copy, paste, save, close, cut, Among other functions. That is why here we present a complete list of all combinations that you can do on your keyboard when using this program microsoft.

Function keys in Windows

These function keys consist of those found on the top of our keyboard and go from F1 to F12, where each one of them has a specific function within this program, be it to check spelling, correct, go to a specific place on the page, among others. In such a way that here we present each of its functions.

One key shortcuts in Windows

When the shortcuts are much simpler, they are easier to learn and remember when you want to apply them. That is why here we present a list of a single key that will take you to a specific action within Excel.

Using the “Control” key for Windows

In this case we will use the key “Control” accompanied by another key to be able to carry out a specific action within the document, in this way we present each of these shortcuts here.

Using the “Control” key and the function keys in Windows

Now we present you other key combinations, but this time using “Control” accompanied by each function keys and with which we can perform some actions in a more direct way than using the mouse. Here we present each of these combinations.

Using the ALT key and function keys in Windows

Using the “Shift” key and function keys in Windows

In this case we are going to show you some combinations that you can make using the Shift or uppercase along with each of the function keys within an excel sheetin order to obtain tools in a much faster and more direct way.

Shortcut using “Control” + “Shift” key in Windows

In this case, the key combinations within Excel are increasing, this is how we will now show you some shortcuts that you can get using the key “Ctrl+Shift + another key” being able to use some symbol, letter or number.

Shortcuts to be able to move within the spreadsheet in Windows

In this case we are going to teach you some combinations of keys that will allow us to move within the spreadsheet and that they are very useful when working with Excel.

Shortcuts to be able to select Excel data in Windows

With these shortcuts you have the opportunity to select rows or columns to carry out joint actions or extend a selection. For this you can use different key combinations which we show you below.

Shortcuts for entering Excel data and formulas on Windows

Another advantage that we get when using shortcuts is when we want enter formulas and data once you have selected the cells where you want to work. In this way, here we show you which are the main key combinations in order to carry this out.

Other Excel keyboard shortcuts on Windows

Now we show you others shortcuts or key combinations in Windows that you can use in Excel and that will surely be very useful when working with said program. In this case here we leave you the following list.

Most used shortcuts for Excel on Mac

In case you have a mac computer and use very often microsoftexcel, here we leave you some of the most used combinations for this program.

Keyboard shortcuts for windows and dialogs in MacOS

Shortcuts to be able to move within a spreadsheet in Mac OS

In case you are using Excel and want move or move within a spreadsheet in a much faster way you can do it through the following key combinations.

Combinations to Write Data to an Excel Sheet on MAC

In case you want to use some shortcuts when writing in a spreadsheet, you can do it using the following key combinations

Format and edit spreadsheet data on MAC

in case you want edit the data inside the document and give a format type in it you can start using the following formats.

Shortcuts to be able to work in the formula bar or cells on MAC

Shortcuts to select rows, columns or cells in Excel using keyboard on MAC

Shortcuts for working with graphics on MAC

Key Combinations for Sorting, Filtering, and Using PivotTable Reports on MAC

Shortcuts for schema data on MAC

How to change and customize shortcuts and shortcuts in Microsoft Excel?

On many occasions, being able to start using a shortcut keyboard in Excel Either for Windows or MAC ends up becoming a fundamental tool since it will allow you to work with a greater efficiency and speed. Especially for all those people who present mobility or visual disabilities.

Many times shortcuts They are very easy to use, and become an alternative to mouse handling. In addition, they are considered to be much easier to use than on the touch screen.

To be able to start with all this, it is important to first be able to access the ribbon with the keyboard. Keep in mind that this section will be the one that helps you better understand the keyboard shortcut. Is Options includes the new shortcuts for Microsoft Excelwhich have been called “Key Tips” which can make them appear without the need to press the key “Alt + letter or number”

Now you just press the “Alt” key alone and in the second the shortcut will appear, then you just have to press action letter what you want to do. For example, if you want to enter “Insert” you just have to press the key “B”, in the case of entering “formulas” The key “OR”, for tab “Start” we press the key “EITHER”, and so on with the key of the tool that we want to use.

Old shortcuts

We are usually used to shortcuts starting with the key “ctrl”, and which still continue to work with versions like Microsoft Excel 2013. That is, you can press the keys “Ctrl + V” to copy, “ctrl + z” to go back, “Ctrl + C” to copy, among other key combinations that will help us perform actions much more directly and quickly.

For shortcuts with the key “Alt” they also continue to work. However, to use these methods with either the key “Ctrl” or “Alt” it is necessary that you know all the possible combinations of keys to be able to go to a specific function. In the case of the key “Alt” you can use combinations like “Alt + E” to edit or “ALt + I” to insert, among many other functions available.

In case you don’t know all the sequences you can simply press the key “esc” and start using the badges of the “Key Tips”