To this day, in most jobs Excel handling is practically mandatory when it comes to accounting, organizing tasks, or carrying out project management.
Advanced Excel Keyboard Shortcuts That People Must Know This Year 2021
When starting to use spreadsheets it is very important that you know the main formulas, shortcuts, and tricks of this Microsoft tool.
The network can become your best ally to learn how to use Excel since there are numerous Youtube channels, MOOCs and free online Excel courses, tutorials and specialized blogs in which to solve your doubts and know how to use certain functions. If you want to improve in the use of Microsoft Excel we tell you what are the best Excel shortcuts and techniques you must learn to get the most juice possible to one of the most complex and used programs on the market. Let’s go there!
Main actions and Advanced Excel Keyboard shortcuts
- Ctrl + T: Used to select all the cells in a table.
- Ctrl + A: With this shortcut, you can select all the cells of a document.
- Alt + F1: Use this formula to create a chart with a selected data group.
- Ctrl + Shift + L: This shortcut allows you to enable or disable the auto filter.
- Ctrl + “+” key : To activate or deactivate the selected cell formulas.
- F9: This key allows you to calculate all operations on all worksheets.
- F9 + part selection of a formula: You can calculate that selected operation.
- Shift + F9: Calculates all operations for the current worksheet.
- ALT + = : To make a sum of the selected cells.
- Ctrl + delete: To return to the last active cell.
If you want to know more advanced Excel shortcuts, continue reading.
Excel cheats to search the spreadsheet
- Crtl + direction keys: It leads you to the limit of each direction in the spreadsheet.
- F2: If you click on a selected cell, we edit it. It’s like double clicking.
- Shift + F2: Adds a comment to a cell.
- Ctrl + Home: return to cell A1 of the document.
- Ctrl + Page Up / Page Down: Switch between worksheets.
- Shift + F11: Adds a new worksheet to the document.
- ESC: On a selected cell, it erases everything and exits the cell.
Shortcuts for entering data into Excel
- Ctrl + “;” : Add today’s date to a cell.
- Ctrl + Shift + “:” : Adds the current time to a cell.
- Ctrl + D: add in the cell the contents of the one above.
- Ctrl + R: add the contents of the cell to the right in the cell.
- Ctrl + Spacebar: Selects the entire row and column of the cell.
- Ctrl + Enter : fills all the cells in the text “Ctrl + Enter”
- Ctrl + ALT + V : Opens a special data paste box.
Shortcuts to change formatting in Excel
- Ctrl + 1: opens the basic formatting box for the content.
- Ctrl + Shift + ~ : applies the “general” format.
- Ctrl + Shift + $: puts the data in “currency” format.
- Ctrl + Shift +%: puts the data in “percent” format.
- Ctrl + Shift + ^: puts the data in “scientific” format
- Ctrl + Shift + # : puts the data in “date” format.
- Ctrl + Shift + @ : puts the data in “hour” format.
- Ctrl + Shift +! : Puts the data in “standard” format.
- Ctrl + Shift + & : Add a border around the selection.
- ALT + R: Places a border to the right of the selection.
- ALT + L: Places a border to the left of the selection.
- ALT + B: Places a border at the bottom of the selection.
These are the incredible and advanced Excel Keyboard Shortcuts that you may not know before. I hope this article will help you to do your work in an Excellent way within less time.
If you still have any queries, let us know them in the below comment section and we will get back to you to solve all your questions as soon as possible.
Would you like to add any other keyboard shortcuts of Excel to this list? Then write them in your comments below and we will include them in this article in the next update.
Which Excel Keyboard shortcuts saves more time for you?