Published on
Written by Jacky Chou

The Best Shortcut To Show Formulas In Excel

Key Takeaway:

  • Showing formulas in Excel can be done using three shortcuts – keyboard shortcut, Excel Options menu, and Ribbon. Knowing all three methods can help save time and make it easier to navigate through large Excel sheets.
  • The keyboard shortcut for showing formulas in Excel is “Ctrl” + “`”. This shortcut works in all versions of Excel and can easily switch between showing formulas and showing cell values.
  • Using the Excel Options menu is also a quick way to show formulas in Excel. Go to the “File” tab, click “Options”, select “Advanced” from the menu, and under “Display options for this workbook”, check the box for “Show formulas in cells instead of their calculated results”.

Are you looking for a quicker way to show formulas in Excel? You no longer have to manually trace out all the cells influencing your data. This article will show you the best shortcuts to quickly reveal all Excel formulas.

Shortcut for showing formulas in Excel

Show formulas in Excel quickly! Three options: use Keyboard Shortcut, Excel Options Menu or Ribbon. All are doable!

Shortcut for showing formulas in Excel-The Best Shortcut to Show Formulas in Excel,

Image credits: chouprojects.com by Joel Arnold

Using the keyboard shortcut

To reveal the formulas in Excel without clicking on each cell individually, there is a keyboard shortcut you can use.

To show formulas in Excel using the keyboard shortcut, follow these 5 steps:

  1. Press “Ctrl” and “A” to highlight all cells.
  2. Press “Ctrl” and “~” simultaneously.
  3. The formula bar will appear where you can view all of the formulas for the selected cells.
  4. To go back to normal viewing mode, press “Ctrl” and “~” again.

It’s important to note that this shortcut will only work if there are formulas present in the selected cells.

Another useful tip is to use a filter to display only cells with formulas. To do this, click on the filter button in your Excel toolbar and select “Formulas.” This will allow you to easily see which cells contain formulas without having to manually search through your spreadsheet.

Recently, a friend of mine who works as an accountant shared how this keyboard shortcut saved her hours of time while working on a massive spreadsheet. She was able to quickly and easily double-check all of her calculations by simply pressing a few keys. It’s amazing how much time and effort can be saved with just a simple shortcut!

Who needs an online degree in Excel when you can just use the Excel Options menu to unlock all the secrets?

Using the Excel Options menu

Excel provides various shortcuts for its users to perform tasks efficiently. Among them, using the excel options can help reveal formulas hidden behind the resulting values in a worksheet, making it easier to troubleshoot an issue or revise errors.

Here’s a quick 6-Step guide to using Excel Options menu:

  1. Open Microsoft Excel on your computer.
  2. Click on the “File” tab located at the upper left corner of your screen
  3. Select “Options” from the menu list that appears.
  4. Select “Formulas” from the list on the left-hand side of the page.
  5. Scroll down to “Working with formulas” under which mark the box alongside “Formula auditing” and check “Show Formulas”. Then click “OK” button.
  6. The cells in your worksheet containing formulas should instantly display their respective formulae instead of showing calculated values alone.

While this is a straightforward method for revealing formulas in Excel, by default, you can also use Ctrl+` (grave accent) shortcut keys to switch between displaying cell values and showing the corresponding formula.

Interestingly, Microsoft Office has been around for more than three decades now. Shortly after its release, it became apparent that spreadsheets were more than just repetitive number crunching programs but could be powerful application tools used in finance and accounting. Looking back, it’s safe to say that Excel has transformed data analysis forever.

Why waste time memorizing countless menus? The Ribbon is Excel’s way of saying ‘let’s make things easy’.

Using the Ribbon

Excel users can effortlessly access various features to organize their worksheets through a series of commands on the screen known as ‘Using the Ribbon.’

To utilize Excel’s Ribbon, follow these steps:

  1. Launch the Excel Worksheet.
  2. Look for and select the tab corresponding to where you want to make changes.
  3. Select the Command group responsible for executing those changes.

By using ‘Using the Ribbon’, Microsoft Excel emphasizes that all essential and frequently used features are easily accessible on display; therefore, there is no need to navigate through several dialog boxes.

It is essential to note that all options in each ribbon vary based on your computer screen size. Therefore, it is recommended that you thoroughly familiarize yourself with every tab and group featured within its sub-menus.

Do not miss out on the conveniences of Excel Tool by learning how to use various ribbons efficiently.

Take advantage of Excel’s vast range of features by exploring more Ribbon groups and monitoring your convenience level when working.

Five Facts About The Best Shortcut to Show Formulas in Excel:

  • ✅ The shortcut to show formulas in Excel is Ctrl + ` (grave accent). (Source: ExcelJet)
  • ✅ This shortcut can toggle between displaying cell values and cell formulas. (Source: Excel Campus)
  • ✅ Excel can also display all formulas in the worksheet at once using the Show Formulas option. (Source: AbleBits)
  • ✅ The Show Formulas option can be accessed through the Formulas tab in the Ribbon or by using the keyboard shortcut Ctrl + ~ (tilde). (Source: Excel Easy)
  • ✅ Displaying formulas in Excel can help with troubleshooting errors and auditing spreadsheets. (Source: Business News Daily)

FAQs about The Best Shortcut To Show Formulas In Excel

What is the best shortcut to show formulas in Excel?

The best shortcut to show formulas in Excel is to press “Ctrl + ` (grave accent)” on your keyboard.

Can I use the shortcut to show formulas in Excel for selected cells only?

Yes, you can use the shortcut to show formulas in Excel for selected cells only. Just select the cells that you want to view the formulas for and then press “Ctrl + ` (grave accent)”.

What if my keyboard does not have a grave accent key?

If your keyboard does not have a grave accent key, you can use the “Ctrl + Shift + 6” shortcut to show formulas in Excel.

Can I customize the shortcut to show formulas in Excel?

Yes, you can customize the shortcut to show formulas in Excel by going to “File > Options > Quick Access Toolbar” and selecting “All Commands” from the drop-down menu. Look for the “Show Formulas” command and add it to your Quick Access Toolbar. Then, to use the shortcut, simply click on the button you created.

How do I switch back to viewing the values of my cells instead of formulas in Excel?

To switch back to viewing the values of your cells instead of formulas in Excel, simply press “Ctrl + ` (grave accent)” on your keyboard again.

Is there a way to show formulas in Excel without using any shortcut?

Yes, there is a way to show formulas in Excel without using any shortcut. Simply go to the “Formulas” tab and click on the “Show Formulas” button.

Related Articles

15 Keyboard Shortcuts For Hiding And Unhiding Columns And Rows In Excel

Key Takeaway: Keyboard shortcuts for hiding and unhiding columns and ...

How To Undo An Excel Shortcut

\n Key Takeaway: \n \n Knowing Excel shortcuts is important ...

How To Use The Undo Shortcut In Excel

Key Takeaway: Using the Undo Shortcut in Excel provides a ...

Leave a Comment