Advanced Excel Keyboard Shortcuts That You Sure Do Not Know

Advanced Excel Keyboard Shortcuts That You Sure Do Not Know

To this day, in most jobs Excel handling is practically mandatory when it comes to accounting, organizing tasks or carrying out project management. 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.

14 Amazing YouTube Hidden Tricks you Probably Do Not Know

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.

21 Advanced Google Search Tricks Commands 98% people do not know

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.

57 iOS Best Hidden Tricks you Should know




Your location is: Princeton, NJ

Your current IP address is: 2001:4455:2f7:b700:f880:7bad:b46b:1768

You can stream and download anonymously through your PC, Mac, Android, and iPhone through IP Vanish.

Get 3-Months Free, 30-Day Money Back Guarantee

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.

Top 20+ Best Google Gravity Tricks That Will Astonish You

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?

Ezoicreport this ad


city view

The Evolution of Drones From Military to Hobby Commercial

Nowadays, drone applications can be found in almost every aspect of our lives. But before they became the worldwide phenom they are today, drones were …

Rainbow Six Siege

Win More Attack Rounds Rainbow Six Siege Hacks and Tips

Rainbow Six Siege is the best shooting game available in the current market. You will get first and third-person perspectives while playing this game. Either …


Best Microsoft Products for Students

The college students belong to those who seem to be always in the know regarding all the latest technology tricks, which makes them the most …

fist bumps

Reasons Why Hybrid Working Model is Gaining Popularity

Everyone is buzzing about hybrid work schedules now that companies are calling their employees back to the office, but many questions remain. Reasons Why Hybrid …

Alexa model

How to Reset Amazon Firestick

Firesticks are incredible devices designed to help users stream online content. How to Reset Amazon Firestick The tech behind Firestick enables one to upload apps …

Ezoicreport this ad