If you have ever used or use Excel, you know that it has a multitude of features. There are so many functions and possibilities that you're probably wasting more time than you'd like to make a well-made spreadsheet. If this is your case, a good way to save your time in Excel is through keyboard shortcuts.
They represent a great "hand on the wheel" for you that uses Excel on a daily or daily basis, since the shortcuts will facilitate and speed up the "boring" search and selection work. Just so you have an idea, let's take a look at an empty Excel screen:
Only on this screen can we visualize:
- 3 tabs
- 7 Tabs in the Home Menu
- 7 Groups with Various Functions in Each Guide
- File menu with more 10 function groups
- 1 Quick Access Toolbar
Summarizing: It's a lot for you to decorate where you are and look every time you have to perform one of these functions. It may seem that not, but you spend time moving the mouse to and fro.
So using the keyboard shortcuts can help you spend a lot less time in your day-to-day life with Excel. Personally I use the keyboard as much as I can and I have my 10 favorite keyboard shortcuts. Here's how you can use it too:
1 - Quick keyboard operation:
– CTRL + Direction Arrows: When using this command, you moves your strokes to the last filled cell of the table. If there are empty cells in the middle, it will go to the last filled cell that is before it is empty. If no more cells are filled, it goes to the last row or column depending on the command.
- CTRL + Home: Moves your cursor to the first cell of the A1 worksheet. If you use only the home command, it moves your cursor to column A, but at the time of the line you were already selected. See below the example of the shortcut that goes to the beginning of the worksheet.
- CTRL + End: Moves your cursor to the last filled cell in your worksheet. If you do not use Control, only End will activate or deactivate "End Mode". This function is similar to the CTRL + Direction command, moving the cursor to the last filled cell.
2 - Change Tab:
- CTRL + Page Down: If you need to change from one tab to another in the same spreadsheet, there is no quick way to do this with the mouse. You need to go down there and pick the flap. With this command this task becomes incredibly easy and automatically you go to the next tab.
- CTRL + Page Up: This is a command similar to the previous one, but instead of going to the right tab, you "back" to the left tab as shown below in the comparison. However, by executing it you change to the previous worksheet.
3 - Change spreadsheet:
- CTRL + TAB or CTRL + F6: It is likely that in some cases you have more than one worksheet open and this is the best way to move from one worksheet to another quickly.
4 - Copy, Cut and Paste:
- CTRL + C (Copy): These should be one of the top commands that any Excel user will ever move. At all times you may want to replicate formatting, values, texts, etc. To do this, simply select the cells you want to replicate and use this function.
- CTRL + V (Paste): After copying, just use the paste function and you will have all the selected content duplicate. Below is a simple image of what should happen when using this field.
- CTRL + X (Cut): Another way to take content from somewhere on your spreadsheet in another space is by using the cut function. In that case, all content will be "transported" from one location to another. So if you do not want to get information from the original location, do not use this function.
5 - Undo or Redo:
- CTRL + Z (Undo) and CTRL + Y (Redo): Anyone who has never made a mistake in Excel probably has not even bothered to open our beloved program. The truth is simple, if you mess with Excel, you make mistakes, either unintentionally or something that runs away from your knowledge and you only discover later when the result was not completely correct. In these cases you can use the undo and redo shortcut to reduce the damage of the errors.
6 - Save and Save As:
- CTRL + B and F12: Another thing, if you messed long enough in Excel, you know that time and again it may present minor flaws and close. Nothing more annoying than losing all your work because you forgot to save. The first command (CTRL + B) is for you to save directly where the worksheet is already saved. If you want to use another folder or even create a new version of your spreadsheet, use Save As (F12)
7 - Cell Formatting:
- CTRL +!: To embellish your worksheet use this shortcut and change formatting to have your spreadsheet with a more user-friendly and explanatory layout. Here you can make simple changes like type of number and source until protection of cells and changes in borders.
8 - Printing:
- CTRL + P: Use this shortcut to grab those charts and tables you've developed, print and show for colleagues, clients, or superiors. Simply open the print window, where you can view your printout, choose which printer to use, and exactly what it will print.
9 - Selection Shortcuts:
- CTRL + SPACE: Use this shortcut if you want to select the entire column where the cursor is. In our case, we had the cursor in the F7 cell and after using the shortcut, the entire F column was selected.
SHIFT + SPACE: Much like the shortcut above, but instead of selecting the column, it will select the corresponding row.
10 - Help:
- F1: Last but not least, with the help function you can learn almost anything in excel and get away from difficulties quickly and easily. Type in the text field the name of the function you want to analyze that will have several links to read all the details that you do not know.
Want to know more about Excel? Follow our Blog!
If you have any questions about using it, leave your comment that will help you get the most out of Excel.