Every time we use a tool like Microsoft Excel it is very useful to be able to use different commands with the keyboard in order to speed up our tasks, taking into account that there are different shortcuts which end up being very useful when you want to perform some specific actions
A shortcut is a set of keys that are pressed simultaneously and that allows us to execute an action is specific at a faster speed. In the case of programs like Excel, it is very common to use key combinations since they help improve productivity and speed when working.
Therefore, if you are a user who constantly uses this type of programs 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 .
Index:
List of the best Excel shortcuts and key combinations 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 to streamline certain steps when you want to perform a specific process, whether copy, paste, save, close, cut, among other functions. That is why here we present a complete list of all the combinations that you can perform on your keyboard when using this Microsoft program.
Function keys in Windows
These function keys consist of those found in the top of our keyboard and range from F1 to F12 , where each of them has a specific function within this program, either to check the spelling, correct, go somewhere specific on the sheet, among others. So here we present each of its functions.
One-key shortcuts in Windows
When 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 “Control” key accompanied by another key to be able to take a specific action within the document, so here we present each of these shortcuts.
Using the “Control” key and the function keys on Windows
Now we present other key combinations, but this time using “Control” accompanied by each of the function keys and with which we can perform some actions of 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 the function keys on Windows
In this case we are going to show you some combinations that you can do using the Shift or uppercase key together with each of the function keys within an Excel sheet >, in order to obtain tools in a much faster and more direct way.
Shortcut using the “Control” key + “Uppercase” ”On Windows
In this case the combinations of keys within Excel are increasing, this is how we will now show you some shortcuts that you can get using the “Ctrl + Shift + another key” being able to use some symbol , letter or number.
Shortcuts to move inside the spreadsheet in Windows
In this case we are going to show you some key combinations that will allow us to move inside the spreadsheet and that are very useful when working with Excel.
Shortcuts to select Excel data in Windows
With these shortcuts you have the opportunity to select rows or columns to perform joint actions or extend a selection. For this you can use different key combinations which we show you below.
Shortcuts to enter data and Excel formulas in Windows
Another advantage we get when using shortcuts is when you want to enter formulas and data once you have selected the cells where you want to work. In this way, here we show you what are the main key combinations to be able to do this.
Other Excel keyboard shortcuts in Windows
Now we show you other shortcuts or key combinations in Windows that you can use in Excel and that will surely be very useful to you Time to work with this program. In this case here we leave you the following list.
Key combinations for Excel on Mac most commonly used
In case you have a Mac computer and you use Microsoft Excel, very often, here are some of the most used combinations for this program.
Key combinations for windows and dialog boxes in MacOS
Shortcuts to move within a spreadsheet in Mac OS
If you are using Excel and want to move or move inside a spreadsheet in a much faster way you can do through the following key combinations.
Combinations to write data to an Excel sheet in 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 the case that you want to edit the data within the document and give a type of format in it you can start using the following formats.
Shortcuts to work in the formula or cell bar on MAC
Shortcuts to select rows, columns or cells in Excel using the keyboard in MAC
Shortcuts for working with MAC graphics
Key combinations to sort, filter and use reports pivot tables in MAC
Shortcuts for schema data in MAC
How to change and customize shortcuts and shortcuts in Microsoft Excel ?
On many occasions you can start using a keyboard shortcut of keyboard in Excel for either Windows or MAC > It ends up becoming a fundamental tool since it will allow working with greater efficiency and speed . Especially for all those who have mobility or visual disabilities.
In many cases the shortcuts are very simple to use, and they become an alternative for what is the mouse handling. In addition, they are considered to be much easier to use than on the touch screen.
In order to start with all this it is important to be able to access the ribbon with the keyboard first. Keep in mind that this section will help you better understand the keyboard shortcut. This ribbon includes the new shortcuts of Microsoft Excel , which have been called “KeyTips” which can cause them to appear without the need to press the “Alt + letter or number”
key
Now, just press the “Alt” key alone and in second the shortcut will appear, then you just have to press the letter of the action you want to perform. For example, if you want to enter “Insert” you just have to press the “B” key, if you enter “formulas” the “U” key, for the “Start” tab press the “O” key, and so on with the tool key that we want to use.
Old shortcuts
We are usually used to shortcuts starting with the “Ctrl” key, and which still continue to work with versions like Microsoft Excel 2013. That is, you can press the “Ctrl + V” keys to copy, “Ctrl + z” to go back, “Ctrl + C” to copy, among other key combinations that will help us perform actions in a much more direct and fast way.
In the case of shortcuts with the “Alt” key, they also continue to work. However, to use these methods with either the “Ctrl” or “Alt” key you need to know all the possible key combinations to be able to go to a specific function. In the case of the “Alt” key 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 “Esc” key and start using the distinctiveKeyTipsrd