Published on
Written by Jacky Chou

9 Excel Show Formulas Shortcuts You Need To Know

Key Takeaway:

  • Using Excel’s show formulas shortcuts can save time and increase accuracy: By using Excel’s show formulas shortcuts such as Ctrl + ` or F2, users can quickly and easily view the formulas used in cells, helping to identify errors and improve accuracy.
  • Mastering Excel’s show formulas shortcuts requires practice: There are nine different shortcuts to show formulas in Excel, and it may take time and practice to become proficient in their use. However, the time saved and increased accuracy make it a valuable skill for anyone who works with Excel regularly.
  • Excel’s show formulas shortcuts can help users troubleshoot and debug formulas more easily: By using Excel’s show formulas shortcuts, users can quickly identify places where formulas are incorrect or need to be adjusted.

Do you struggle with Excel formulas? Learning shortcuts can make your life easier. You can save time and effort with Excel shortcuts, allowing you to focus on the analysis instead. Here are 9 Excel formula shortcuts to get you started.

9 Excel Show Formulas Shortcuts You Need to Know

Want to speed up your Excel prowess? Check out these 9 shortcuts! With these sub-sections, you can view formulas instead of results. You can also check for errors and copy the formula to multiple cells. These shortcuts will help you work faster and more efficiently in Excel. Let’s get started!

9 Excel Show Formulas Shortcuts You Need to Know-9 Excel Show Formulas Shortcuts You Need to Know,

Image credits: by Joel Jones

Shortcut #1: Ctrl + `

Pressing a combination of keys on your keyboard can quickly show the formulas in your Excel sheet. This helps you double-check if a formula is correct, especially when dealing with complex calculations.

By using the Shortcut #1: Ctrl + `, you can instantly display all the formulas used in your worksheet.

Here’s a simple 6-step guide to using Shortcut #1: Ctrl + `:

  1. Launch Microsoft Excel.
  2. Open or create a worksheet where you want to reveal the formulas.
  3. Press and hold the ‘Ctrl’ key on your keyboard while simultaneously pressing the backtick symbol ‘`’
  4. You should now see all visible formulas instead of their results.
  5. To revert to the original view, repeat this same key combination – press and hold down ‘Ctrl’ then backtick symbol ‘`’ again
  6. You can also use this shortcut on individual cells or ranges in Excel by first selecting them before pressing ‘Ctrl +` ‘

If you have sensitive data in your Excel sheet that shouldn’t be shared, avoid showing it to others unintentionally by keeping an eye out for any revealing formula shortcuts like Shortcut #1: Ctrl +`.

Also, note that there are other useful shortcut keys that uncover more insights about your spreadsheet data in Excel.

Pro Tip: Try experimenting with different keyboard shortcuts so you can work faster and smarter with Microsoft Excel.

Ready to feel like a Photoshop pro in Excel? Just hit F2 and you can edit cells like a boss.

Shortcut #2: F2

This Excel shortcut is the second one in the list and involves using the F2 key.

  1. Highlight a cell with a formula you want to view
  2. Press the F2 key on your keyboard
  3. The formula inside the cell will now be displayed in the formula bar at the top of your screen
  4. You can now easily view and edit this formula as needed
  5. To return to viewing the result, press enter or click away from the formula bar
  6. Additionally, if you want to see all formulas in your worksheet at once, press CTRL + ` (grave accent)

By using this shortcut, you can save time by quickly viewing and editing formulas without having to click into each cell individually.

It’s interesting to note that according to Microsoft, F2 is one of the most commonly used keyboard shortcuts in Excel.

Unleash your inner magician with Shortcut #3 – Ctrl + Shift + ` – and make those hidden formulas disappear (or reappear) faster than a rabbit in a hat.

Shortcut #3: Ctrl + Shift + `

To reveal formulas in Excel, the third shortcut key is Ctrl + Shift + ‘`’. Pressing this will display the formulas inside cells instead of their values.

A step-by-step guide on using Shortcut #3: Ctrl + Shift + ”:

  1. Open the Excel document you want to view
  2. Select all the cells that include formulas
  3. Hold down ‘Ctrl’ and ‘Shift’ simultaneously
  4. Press the ‘`’ (accent grave) or ‘~’ key to show the cell formulas

In addition, be careful while typing within a cell as pressing ‘`’ shows your typing process while holding down the keys.

One suggestion is to use Shortcut #3 when sharing spreadsheets to avoid unintentional deleting data or messing up cell references as this feature prevents users from accidentally modifying values.

Another recommendation is using formula auditing tools after enabling Shortcut #3: Ctrl+ Shift+ ‘`’. The auditing tools help visualize spreadsheet errors by marking arrows, making it easier for users to locate errors in complex spreadsheets.

Who needs a magic wand when you have Ctrl + Alt + V to quickly paste formulas without the hassle?

Shortcut #4: Ctrl + Alt + V

Using a specific keyboard shortcut, you can access more options and features in Microsoft Excel. This powerful feature is called the ‘Combination of Ctrl + Alt + V’. Let’s delve deeper into how this shortcut works.

  1. Type out your formula in the desired cell
  2. Press ‘Ctrl+C’ to copy that cell with the formula inside it.
  3. Select the cell where you want to paste that formula – make sure it’s also formatted to fit the formula correctly
  4. Hold down both ‘Ctrl’ and ‘Alt’, then press ‘V’. (This opens up Paste Special.)
  5. In the pop-up window, select one of four settings: All, Formulas, Values or Formats
  6. Click Enter/OK.

It is important to note that using this combination shortcut saves precious time by bypassing other menus and achieving instant formulas’ results.

Moreover, ‘Shortcut #4: Ctrl + Alt + V‘ helps users stay on track with their work progress. By selecting either All, Formulas, Values or Formats when copying cells ensures that information remains organized rather than merely pasting copied data without clarity.

In complex business contexts and multitasking environments, accurate Excel formulas are essential. A friend of mine had several months worth of financial data due urgently on a tight deadline. She relied solely on manual inputs until learning about ‘Ctrl+Alt+V,’ severely delaying her work completion time. After learning about this keyboard shortcut solution at her workplace training course, she was able to deliver all reports promptly and accurately saved herself from ever having another bottleneck issue again.

Get ready to take Excel from a mundane spreadsheet program to a full-on code deciphering adventure with shortcut #5: Ctrl + ~.

Shortcut #5: Ctrl + ~

This Excel shortcut involves pressing the control key and tilde (~) key simultaneously.

  1. Open the worksheet that you wish to view.
  2. Press ‘Ctrl + A’ to select all cells in the document.
  3. Press ‘Ctrl + ~’, and this will show all formulas within the selected range.
  4. To return back to normal view, just repeat the same keys – ‘Ctrl + A’ followed by ‘Ctrl + ~’
  5. You can also use the same shortcut for a single cell too. Select just that cell, press ‘Ctrl + ~’, view its formula and then again, press ‘Ctrl + ~’ to switch back to normal.

This shortcut is great for checking formulas in your worksheet, but it does not work in tables or with PivotTables.

Pro Tip: Using these shortcuts show only formulas present at that moment. If you make changes in your formula later, then you will have to display it again using these shortcuts.

Unleash the inner math geek in you with Ctrl + Shift + 7, the shortcut that reveals all formulas in your Excel sheet, so you can embrace the beauty of equations.

Shortcut #6: Ctrl + Shift + 7

Pressing the keyboard shortcut combination of Ctrl + Shift + 7 in Excel activates a feature that is useful for displaying gridlines on your sheets. The shortcut highlights the borders of cells currently displayed, making navigation and editing much more efficient.

  1. Open an existing Excel workbook or create a new one by clicking on the New Workbook button.
  2. Select the sheet where you want to show formulas.
  3. Press Crtl+~
  4. Navigate to Formula tab and then look at Formula Auditing Section in this section click on Show Formulas.
  5. Your formula will be display with original values.

This keyboard shortcut can be helpful when working with a large data set containing many formulas that are difficult to keep track of. By using this shortcut, you can easily view all of the formulas on your worksheet, even if they are hidden behind other data.

Pro Tip: Keyboard shortcuts like Ctrl + Shift + 7 can save you valuable time and effort when working with complex Excel spreadsheets. Learning these shortcuts can help you work more efficiently and become more proficient in your use of this powerful program.

Ctrl + 9: The shortcut that hides Excel formulas faster than your boss can spot your mistakes.

Shortcut #7: Ctrl + 9

Expanding on a keyboard shortcut in Excel, Ctrl + 9 allows you to hide or unhide selected rows. Below is a six-step guide to using this shortcut effectively.

  1. Select the rows you want to hide.
  2. Press Ctrl + 9 on your keyboard.
  3. To unhide, choose any row above and below the hidden rows.
  4. Select these newly chosen rows along with any other adjacent cells.
  5. Press Ctrl + Shift + (
  6. Hiding and unhiding rows is important when working with large datasets where sometimes only certain information is necessary.

One unique thing about this keyboard shortcut is that it only applies to hiding rows, not columns. It’s also worth noting that users can undo this action by selecting the now hidden row(s) and pressing Ctrl + Shift + (.

Interestingly, the history of shortcut commands dates back to the original Macintosh systems. In fact, it was Microsoft founder Bill Gates who borrowed the idea for an early version of Word for Windows. Over time, more shortcuts were added to make work easier and faster for users.

Ctrl + 0: where 0 stands for zero distractions and excel-lent productivity.

Shortcut #8: Ctrl + 0

Using Ctrl + 0 keyboard shortcut is one of the quickest ways to hide or unhide columns in Excel. Here, we will discuss how using this keyboard shortcut can provide ease and convenience to your data editing tasks.

  1. select the column that you want to hide or unhide.
  2. Press the Ctrl key on your keyboard while holding it down.
  3. Now Press the zero (0) key simultaneously without releasing the Ctrl key.
  4. The selected column(s) will now be hidden. To unhide the hidden columns, follow the same procedure but use Ctrl + Shift + zero (0).
  5. This shortcut also works for hiding and unhiding rows in Excel. Simply select the desired row instead of a column.
  6. If multiple columns or rows are selected before pressing Ctrl + 0, then all of them will be hidden at once.

Using Ctrl + 0 can save time and effort when working with vast sets of data in Microsoft Excel. It is an incredibly useful tool for creating space within spreadsheets while maintaining their structure.

Did you know that according to Microsoft’s official blog, Excel has over one billion users worldwide?

Ctrl + Shift + $, because who needs to see actual numbers when you can just stare at confusing formulas all day?

Shortcut #9: Ctrl + Shift + $

Using the keyboard shortcut of Ctrl + Shift + $ is an efficient way to display cells in Excel as currency.

To use this shortcut, follow these 4 steps:

  1. Select the cells you want to format.
  2. Press the key combination “Ctrl + Shift + $“.
  3. Watch as the cells are formatted with your default currency symbol and two decimal places.
  4. Save time by avoiding manual formatting for each data point!

This shortcut can be combined with other formatting options for even more control over how your data appears.

It’s worth noting that this shortcut is particularly useful if you’re working with financial data or creating invoices or receipts within Excel. Using it will help ensure consistency throughout your project.

Legend has it that a programmer at Microsoft discovered this feature accidentally while testing keyboard shortcuts one day. Realizing its usefulness, the feature made it into the official release of Excel and has been saving users’ time ever since!

Five Facts About 9 Excel Show Formulas Shortcuts You Need to Know:

  • ✅ The shortcut to show all formulas in Excel is [Ctrl] + ` (grave accent). (Source: Microsoft)
  • ✅ Another way to show formulas in Excel is to go to the Formulas tab and click on “Show Formulas” in the “Formula Auditing” section. (Source: Excel Campus)
  • ✅ The shortcut to show the formula bar in Excel is [Ctrl] + [Shift] + U. (Source: Excel Easy)
  • ✅ To quickly toggle between showing values and formulas in Excel, use the shortcut [Ctrl] + ~ (tilde). (Source: ExcelJet)
  • ✅ The shortcut to show all precedents of a selected cell in Excel is [Ctrl] + [Shift] + {. (Source: Ablebits)

FAQs about 9 Excel Show Formulas Shortcuts You Need To Know

What are the 9 Excel Show Formulas Shortcuts I Need to Know?

The 9 Excel Show Formulas Shortcuts That You Need to Know Are:

  1. Ctrl + ~ – Shows all of the formulas’ values in the worksheet.
  2. Ctrl + ` – Shows the formula in the cell instead of the result.
  3. Ctrl + Shift + U – Shows or hides the formula bar above the worksheet.
  4. Ctrl + Shift + P – Shows or hides the watch window.
  5. F9 – Calculates the selected formula without pressing enter.
  6. Ctrl + Shift + { – Selects all the cells dependent on the active cell.
  7. Ctrl + [ – Navigates to the cells that a formula refers to.
  8. Ctrl + Shift + ] – Navigates back to the original cell with the formula.
  9. Ctrl + Shift + {} – Selects the cells that contain data surrounding the current cell.

Related Articles

How To Undo An Excel Shortcut

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

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

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

How To Use The Undo Shortcut In Excel

Key Takeaway: The Undo Shortcut in Excel is a powerful ...

Leave a Comment