Instructions for hiding formulas in Excel

You must work regularly with excel spreadsheets, your work requires high security. You do not want anyone to know the calculation formulas in Excel spreadsheets, you simply want others to manipulate the results do not want them to know the details of how to calculate the results. Today's article helps you solve that problem by hiding the formula and only displaying the simple results.

The example here wants to hide the formula in the cash register.

Instructions for hiding formulas in Excel Picture 1

Step 1: Highlight the whole workbook-> right click -> Format Cells .

Instructions for hiding formulas in Excel Picture 2

Step 2: The dialog box appears, select the Protection tab -> uncheck the Loked and Hidden items -> OK .

Instructions for hiding formulas in Excel Picture 3

Step 3: Select cells that contain formulas to hide. For example, here select the values in the column of money. Right-click -> Format Cells .

Instructions for hiding formulas in Excel Picture 4

Step 4: Select the Protection tab -> select Loked and Hidden -> OK .

Instructions for hiding formulas in Excel Picture 5

Step 5: After making your selection, move the REVIEW tab -> click Protect Sheet .

Instructions for hiding formulas in Excel Picture 6

Step 6: A dialog box appears to enter a password to protect the formula.

Instructions for hiding formulas in Excel Picture 7

Step 7: Enter the password again -> OK .

Instructions for hiding formulas in Excel Picture 8

Back to the excel sheet -> click the values in the column of money, you observe only the results do not show the formula.

Instructions for hiding formulas in Excel Picture 9

In some cases you want to open edit, change the formula you do as follows:

Go to REVIEW tab -> Unprotection Sheet .

Instructions for hiding formulas in Excel Picture 10

The dialog box appears enter the password -> click OK .

Instructions for hiding formulas in Excel Picture 11

The results of the formula have shown you arbitrary editing, if you want to hide the formula, do the same operation as above.

Instructions for hiding formulas in Excel Picture 12

Above is how to hide formulas in excel hoping to help you protect your data.

Good luck!

David Pac

Update 19 May 2020

You should read it

May be interested

How to lock formulas in Excel - Protect excel formulas
when sharing excel files, if you don't want others to edit the formulas or view the formulas, you can lock the formulas.
Complete guide to Excel 2016 (Part 13): Introduction to formulas
after learning about the page format and spreadsheet printing, please join tipsmake.com to learn about the introduction article in excel 2016!
How to Copy Formulas in Excel
the excel program has a feature that makes it easy for users to copy formulas for entire rows or columns, but you don't always get the results you want. when you receive results that are not as expected or encounter #ref and /div0 errors, you will definitely feel unhappy. don't worry, though - you don't need to edit every cell in a 5,000-line spreadsheet. this article will provide some simple ways to help you copy formulas to other cells.
How to lock formulas in Excel
when sharing an excel file, you don't want other people to edit the formulas, see the formulas, then lock the formulas again.
The easiest way to Hide rows in Excel
hiding unnecessary rows and columns will make excel sheets less cluttered, especially with large sheets. hidden rows will not appear, but will still affect the formulas in the worksheet.
Notes when typing formulas to avoid typing errors in Excel
when entering the calculation formula using the functions in excel, sometimes you cannot find the error because of error. the following article gives detailed instructions on how to avoid entering corrupted formulas in excel.
Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel
when sharing excel files with others, you don't want to be edited by other formulas. the following article will help you know how to lock formulas in excel.
Instructions for creating Excel formulas using AI
if you want to find an exact excel function formula for the data table content, you can use gptexcel. below is a guide to creating excel formulas using ai on gptexcel.
Instructions for copying formulas and data between Excel tables
often you still copy and paste normally with the key combination ctrl + c and ctrl + v for each data. but if you need to copy data or formulas to different cells and not adjacent to each other, this will take a lot of time ...
How to fix formulas in Excel, fix data ranges in Excel
in excel when using a formula that refers to a range of data if you use the relative address of the formula and the range will change as you move to another cell. in this article, you can help fix formulas or ranges of data referenced in excel.

Instructions for hiding formulas in Excel

You should read it

May be interested

Office information