Do you ever have problems with Excel formulas? Maybe you're getting unexpected results, or you're not sure how a formula works. If so, you can use the Excel shortcut to show formulas to help you troubleshoot the problem.
Part 1: What is the shortcut to show formulas in Excel?
Before we go into the topic, there are a few things we have to know. First, why do people want to show formulas in Excel and how to show all the formulas in Excel?
In Excel, people often use formulas to perform tasks or to make data update automatically. To view the formula, some people will double-click the cell. However, this only allows you to view the formula for one cell at a time, which can be time-consuming and make the task more complex.
There are a few more reasons why you might want to show all formulas in Excel:
To troubleshoot errors: If you're getting unexpected results from a formula, you can show the formula to see if there is an error in the formula.
To understand how a formula works: If you're not sure how a formula works, you can show the formula to see how the formulas are being calculated.
To share formulas with others: If you want to share a formula with someone else, you can show the formula so that they can see how it works.
Part 2: How to use the Excel shortcut to show formulas
Now you already know the use of showing all the formulas. It is time to know and learn the ways to show all the formulas in Excel . There are several ways to show all the formulas in excel. These are the easiest ways to show all the formulas.
Use the Excel shortcut to show formulas:
Open the Excel spreadsheet that contains the formulas you want to show
Press Ctrl+` (backtick) on your keyboard
All the formulas in the cells will now be displayed
Additional Tips: To hide the formulas again, press Ctrl+` (backtick) again.
Use the Excel Formulas tab:
Open the Excel spreadsheet that contains the formulas you want to show
Select the formulas tab in the ribbon of Excel
Select “Show Formulas” option in the workbook formulas group
The formulas in the selected cells will now be displayed
Additional Tips: To hide the formulas again, press the “Show Formulas” option again.
After trying all the ways mentioned above, but still unable to show all the formulas in the excel. Maybe your spreadsheet is in protected status. Excel has the feature for people to use on protecting the sheet or the whole workbook. This is to avoid accidentally pressing the wrong button and causing the previous work to be wasted. This may also cause you not to be able to show the formulas.
Here is the step to close the protect sheet or protect workbook feature:
Step 1: Click on the review tab on the ribbon in Excel
Step 2: Find and click on the protect sheet and protect workbook option
Step 3: Insert the password if Excel is required.
Step 4: The protected sheet or workbook will be disable
Additional Information:
In the step 3 of disabling the protect sheet, there is a chance that the password window did not pop out. In this situation, it means that the user who activates the protect sheet did not set up a password for it. You may directly proceed to the next step.
In my opinion, using Excel shortcuts to show all the formulas in Excel is the easiest way to do it. You only need to press one or two buttons on your keyboard to show the formulas in Excel. Of course, if you don't remember the shortcut key for performing the action, you can still use the Excel Formulas tab, which is also another good and effective way to show all the formulas in Excel.
Part 3: Best Free Alternative to Microsoft Office - WPS Office
Still looking for a free and powerful alternative to Microsoft Office?
Try WPS Office, its main functions are word processing, spreadsheeting, presentation, and PDF editing. It is an alternative to Microsoft Word, Excel, PowerPoint, and Adobe Acrobat. WPS Office has all the features you need to create and manage complex spreadsheets. You can also learn advanced usage of other functions online. The most important thing is WPS Office FREE TO DOWNLOAD AND USE! ! !
In addition to being free, WPS office also has several advantages over Microsoft Excel, including:
Multiple functions: WPS Office can do many things, like word processing, spreadsheeting, presentation, and PDF editing.
Learn advanced usage online: You can learn how to use all of WPS Office's features online.
Compatible with Microsoft Excel: WPS Excel can open, edit, and save Microsoft Excel files.
User-friendly interface: WPS Excel is easy to learn and use because it has a similar interface to Microsoft Excel.
Regularly updated: WPS Office is updated with new features and bug fixes regularly.
How to download WPS Excel:
Go to the WPS Office website: https://www.wps.com/download/.
Download and Install:
Once you've selected the correct version, click on the download link. The installer file will be downloaded to your device. Run the installer and follow the on-screen instructions to install WPS Office, including WPS Excel.
Open WPS Excel:
After the installation is complete, you can launch WPS Office from your applications or programs list. Within WPS Office, you'll find WPS Excel for all
your spreadsheet needs.
FAQs
Q: How do I show formulas in Excel instead of value?
In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.
Q: What are the Ctrl shortcuts in Excel?
50 Excel Shortcuts Key That You Should Know in 2023
Ctrl+C - Copy.
Ctrl+V - Paste.
Ctrl+Z - Undo.
Ctrl+Y - Redo.
F2 - Edit cell.
Ctrl+A - Select all.
Home - Move to the beginning of the worksheet.
End - Move to the end of the worksheet.
https://www.simplilearn.com/tutorials/excel-tutorial/excel-shortcuts
Q: How to unprotect the sheet if I forget the password?
Unprotect Excel Sheet with VBA If Forgot Password
Use Zip Option to Unprotect Excel Sheet
Unprotect Excel Sheet Using Google Sheet
https://www.exceldemy.com/unprotect-excel-sheet-forgot-password/
Q: What are the system requirements for WPS Office?
The system requirements for WPS Office are very low. You can run WPS Office on a computer with Windows XP or later, or macOS 10.10 or later. You also need at least 100MB of free disk space and 512MB of RAM.
Q: Is WPS Office compatible with other office suites?
Yes, WPS Office is compatible with other office suites, such as Microsoft Office and Google Sheets. You can import and export files from other office suites, so you can easily share your documents with others.
Q: Is WPS Office safe to use?
Yes, WPS Office is safe to use. It has been scanned by multiple antivirus and anti-malware programs and has been found to be clean. WPS Office is also open-source, so you can review the code yourself to ensure that it is safe.
Q: How do I get help with WPS Office?
WPS Office offers a variety of resources to help you get help. You can visit the WPS Office website for online tutorials, forums, and a knowledge base. You can also contact WPS Office support for help.
Summary
In this article, we have shown you the ways on how to use the Excel shortcut to show formulas and why people want to show the formulas in excel. You have also learned about WPS Office, a free and open-source office suite that includes a word processor, spreadsheet, presentation, and PDF reader. WPS Office has all the features you need to create and manage complex spreadsheets. It is compatible with Microsoft files, has a user-friendly interface, and is regularly updated with new features and bug fixes
Try WPS Office today and see for yourself why it's a great alternative to Microsoft Excel.
I hope this article has been helpful to you.
