Universal shortcuts

Excel shortcuts are often unfairly neglected, although their daily use achieves a higher speed in operation, which makes us much more productive. Experienced users make use of shortcuts. The good news is that most of the shortcuts are of universal nature and can be applied in most Windows programs. If you teach them, you will become much more effective working with any of them! Here we will mention some of those most commonly used in practice.

00001-1As soon as you start Excel, you are offered the option to open a previously saved file or create a new one. If you opt for this second option, after creating it, you need to assign a name to the file, which we do by storing it. The file shortcut is a combination of CTRL + S or SHIFT + F12. For recording under another name, you need to press the F12 key, but if it’s a new file, no matter which option to choose, the Save As dialog box opens. We open the previously recorded file with a combination of CTRL + O (Open), we close it with the combination of CTRL + F4 (Close) and exit the program by pressing ALT + F4 (Exit). We create a new file using the CTRL + N (New) key combination, and the document is printed using CTRL + P (Print).

Changing the contents of the cell begins by positioning to the cell and pressing the F2 key. After making all the necessary changes, we can accept them by pressing ENTER or cancel them by pressing ESC. If we have made a mistake and want to return to the back, we will press the combination of the CTRL + Z (Undo) key, and if we change our mind and want to repeat the action, we will press the combination of the CTRL + Y (Redo) key. We repeat the last performed action by pressing the F4 key. For example, if we chose the background colour of a cell to be yellow, positioning it on another cell and pressing the F4 key will make it have a yellow background.

By combining the CTRL + C (Copy) keys, you copy the selected cell, group of cells, or object to Clipboard. If you remember working with other Windows applications, this term means the temporary memory that we use to make it easier to copy content. By combining the CTRL + X (Cut) key, you trim them, and by combining CTRL + V (Paste), paste the selection to the previously selected destination. It can be a cell or a group of selected cells.