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

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?



Top 5 Ways RFID Is Changing Entertainment Sector For Better In 2021

RFID or Radio Frequency Identification is an advanced technology to remove the barcodes in library applications. Top 5 Ways RFID Is Changing Entertainment Sector For …

email marketing
B2B Technology

Want to Improvise Email Marketing Campaign? 7 Tricks to Consider

With COVID-19 halting the marketing scenario, email marketing remains an affordable and practical part of reaching your existing customers and new prospects. Many people find …

make money through affiliate marketing
Featured Post

Top 10 Affiliate Marketing Programs for Blogs in 2021

Suppose you are a blogger running a small or medium-sized blog and seeking a blog revenue program. Affiliate marketing programs are some of the most …

Product Reviews

Poshmark: A Guide to Safe Buying and Profit Selling

The iconic French designer icon, Yves Saint Laurent, once said, “I have always believed that fashion was not only to make women more beautiful but …

business of former athletes

Life after Sports: Businesses Common for Athletes after their Careers

Many athletes, after finishing their careers, find themselves very successful in other areas and often even begin to earn more income than earlier. The qualities …

girl using his cellphone
Tech Tips

5 Most Effective Content Writing Tips for Small Businesses

There are over 409 million users visiting blogs on WordPress every month. If you are not writing and publishing content about your business online, you’re …