Shortcuts from the keyboard

Excel keyboard shortcuts are often used to speed up spreadsheets. Shortcuts allow us to perform an action in Excel instead of searching for menu options by pressing the appropriate key combination.

Universal keyboard shortcuts

Many shortcuts are universal in Windows programs such as the famous combination of Ctrl + C (Copy) to save selected content, Ctrl + V (Paste) to copy stored content to a selected location, Ctrl + X (Move) to save content to switch to the selected location or to print a document Ctrl + P (Print).   Searching for content is done by pressing CTRL + F (Find), and replacing found content using CTRL + H (Replace). Launching any of these options, selecting the  Home toolbar or the specified shortcut will open the same dialog box with two tabs:  Find and  Replace. Depending on the desired action, you need to select the tab and then fill in the parameter fields of the dialog box.

We process text with universal shortcuts: Ctrl + B – bold the selected text – bold; Ctrl + I – italic the selected italic text; Ctrl + U – underline the selected text (underline); Ctrl + 5 – cross out the selected text.

The most common keyboard shortcuts in Excel

I use these shortcuts almost always when working in excel, I have listed them according to the frequency of use.

Ctrl + A                   Select visual table data (select all);
Ctrl + T                  Create a table object;
Alt + =                     Create a formula that sums all the above cells;
Ctrl + arrows        Move to the beginning and end of rows / columns;
Ctrl + Space           Select entire column;
Shift + Space         Select entire order;
F2                             Add or change the contents of the selected cell;
F4                             Repeat last action;
Ctrl + E                    Enable the FlashFill action to populate all rows in the table;
F5                             Jump to the desired cell in the workspace;
Ctrl + K                   Option that allows you to insert a link in the selected part of the text (hyperlink);
Ctrl + Shift + L      Enable filter keys on the selected table row;
Alt + Shift + F1      This option creates a new worksheet in excel;
Shift + F3                Open the formula entry wizard;
Shift + F5                Opens a search box;
Ctrl + up / dn         Navigate between worksheets in the same excel document;

Alternative shortcuts for all speed lovers

If you are used to running the mouse over the menu and toolbars, shortcuts will allow you to speed up your work incredibly fast. Very soon you will want to use some new combinations that you often need in your business. They may not be in the basic image on the Microsoft site, where you can see the complete list at the following link. Most frequently used keyboard shortcuts.

Microsoft has made an effort to allow such Geeks to recall all actions from the keyboard by first clicking the Alt key. As illustrated in the following figure.

You will see that now each option in the program has its own letter on the keyboard and just list the order you need, repeat it several times, just to remember. Here are some great combinations.

Alt + H + O + I              Selected columns will be adjusted to the appropriate width (Autofit);
Alt + H + O + A             Selected rows will be adjusted to the appropriate height (Autofit);
Alt + H + V + T              Rotate the selected table by replacing columns in rows (Transpose);
Alt + N + V + T              Create a pivot table ;
Alt + H + F + I + S          Create ordinal number automatically;
Alt + D + F + F                Cancel filter or turn on;

Additionally, you can see all the options that the keys use by simply pressing the Alt key.

Shortcuts that are good to know

Quickly positioning a cell or selecting a group of cells is done using CTRL + G or the F5 ( Go To ) key. This is often an unfairly neglected option that, once you get used to it, significantly contributes to productivity at work. Selecting from the  Home  toolbar or the specified shortcut opens the  Go To  dialog box.