In this article we will teach you shortcuts due to the complexity of the program, so that you can get the most out of it and work with ease. What are some tricks to save time in Excel? Learn to put it into practice and have fun working; This trick that we will explain is as useful as the one to highlight weekends with conditional formatting and many others that we have in our blog.
To manage you inside the spreadsheet and main menu
It is very practical if you have a large database in your worksheet, and it is difficult for you to locate the data throughout the work area. Well, you just have to press the key (CTRL + “directional arrow”). If you are going to navigate down it would be CTRL and “arrow down” at the same time. And so on.
Insert rows and columns. With this simple command. Combine CTRL and the “+” key at the same time. A window will appear in which you will indicate in which ways you will insert the row or column. To delete a row, select it and press CTRL and the “-” key.
We have a section that explains cell range selection. Here we will show you a series of keyboard shortcuts, so you can navigate within Excel like a professional and not depend much on the mouse.
- Combine the CTRL + A keys. It will show you the window to open Excel file.
- By combining the CTRL + U keys, you can create a new Excel workbook.
- Press the CTRL + B keys. This command will allow you to display the “Search” window. To search for data within the spreadsheet.
- The CTRL + T keys open the window to create a table.
- With the keys ALT + F11 you open the Visual Basic editor.
- The F12 command opens the “Save As…” window.
- By pressing the CTRL + F2 keys, you invoke the command to print
- To move to another workbook or Excel file, just combine CTRL + F4.
To handle cells and formatting
- By combining the CTRL + C keys, you manage to copy the selected cells
- With the CTRL + K keys, you give the selected cell the italic text format.
- With CTRL+N, you apply bold formatting to the text.
- CTRL + S, with this command underlines the text inside the cell.
-
CTRL + Z, allows you to undo the last action.
- With the command CTRL + 1, it will show you the cell formatting window. It should be noted that when using numbers, use the alphanumeric keys for the cheat to work. If you use the block of number keys located on your right side, it will not work.
- By combining CTRL + F1, it makes it easy for you to insert a chart.
- To navigate between active spreadsheets, apply the commands CTRL + Page Down to move to the next sheet, and CTRL + Page Up to move to the previous sheet.
Replacing words using automatic corrector
If you are working with a large volume of data, and you are asked to replace a piece of data several times. Oh! this is a very tedious job. Well, we recommend that you follow these simple steps, so that the automatic corrector does that job for you!
- To activate it go to the menu and click on File.
- Go to Options and then Review.
- Click AutoCorrect Options.
- It will show you a window with the field “Replace” and “With”. In the 1st field place the data to replace and the 2nd field for the data you want to place. With those instructions it will do your job, then you will have to disable it.
We left this last command because we found it very interesting. It’s FlashFill. The option consists of automatically filling in your data, if it detects a pattern to follow. To do this, you must activate the Flash Fill option. In “File Options – Advanced”.
There you can set the pattern to follow. Example: 0001 in the first cell and start typing the next number in the cell below, the Flash Fill command will automatically detect the pattern, and fill in the numbers for you.
It is incredible how with these tricks you will save time in Excel and make your work easier. We only collect a few here, there are more Excel keyboard shortcuts.