Want to show formulas in Excel?
Want to hide formulas in Excel?
It is not difficult to do these jobs.MiniTool Softwarecollects some useful methods and shows them in this post.
Show or Hide Formulas in Excel
you might useformulas in Excelto quickly make some calculations.
However, it is easy to show or hide formulas in Excel.
In this post, we will show you some easy methods for different situations.
Then, you’re free to see that the formula is displayed.
To hide that formula, you oughta press theEnterkey on your keyboard.
you’ve got the option to find it in the top ribbon menu.
This feature will display all formulas in your Excel.
Step 2: Click theShow Formulasbutton in theFormula Auditinggroup.
All cells that use formulas will show up the formulas.
Well then, how to hide formulas in Excel?
You just need to click theShow Formulasbutton again, then the cells will only show the results.
Do you know how to merge or unmerge cells in Excel without losing data?
In this article, we will show you some useful guides.
But you should know that this way will also prevent the cells that contain the formula from being edited.
Step 1: pick the range of the cells whose formulas you want to hide.
In this step, you’re free to select nonadjacent ranges or the entire worksheet.
Step 2: Go toHome > Format > Format Cells.
Step 3: Switch to theProtectiontab, then selectHidden.
Step 4: ClickOKto save the change.
Step 5: Go toReview > Protect Sheet.
Step 6: double-check theProtect worksheet and contents of locked cells checkbox is selected, then clickOK.
After these steps, the formulas in cells are hidden and protected.
You cannot edit them now.
To make a change, unprotect the sheet.
You might be requested to enter a password.
If you want to edit the cell, it’s crucial that you click theUnprotect Sheetbutton.
Then switch to theProtectiontab and clear theHiddencheck box.
you should probably do this when the cells are not under protection.
If the cells are protected, you should probably first click theUnprotect Sheetbutton underReview.
Recover Your Missing Excel Files
You may delete or lose your Excel files by mistake.
If you want to get them back, you might try MiniTool Power Data Recovery.
This is afree file recovery tool.
With it, you could recover all kinds of files from different types of data storage devices.
MiniTool Power Data Recovery FreeClick to Download100%Clean & Safe
