How to Hide Formula In Excel

The most powerful feature that Excel offers are functionsand formulas. It's like a text editor without the functions, or even less. We can use functions to create our own formulas and use them wherever we desire. However, there are situations when we don't want people to see our formula. If this is the case, the excel formula can be readily hidden. You can use this method to hide formulas in excel cells with or without a password. In this video, I'll show you both alternatives.

1^st step: You must select the full worksheet to show or conceal formulas. You can either press CTRL+A or click the button in the top left corner to select the entire worksheet. Above the first Row and before the first column.

2^nd step: Right-click and click "Format Cell" after you've selected the entire worksheet.

3^rd step: Next, go to "Protection" and uncheck the "Locked" checkbox. Click the OK button.

4^th step: Now you must pick all of the cells that contain the formula. It's quite simple.

Select "Find and Select" from the "Home tab." Then select "Go to Special" and then "Formulas" from the dialogue box. After that, click "Ok." This will select all of the cells on that worksheet that have a formula.

5^th step: After you've selected all of the cells with formulas, right-click on one of them. Select Format Cells now.

6^th step: Select the "Protection" option and then "Hidden."

7^th step: Now the last part. Click on the “Review” tab and then “Protect Sheet”. Now a popup will open and you’ll be asked to enter your password. If you want to hide formulas in an Excel spreadsheet with a password, enter the password twice and click OK. If you just want to hide and to unhide without a password, then do not enter the password here. Just click “Ok” twice. Done.

This is how you can hide formulas in Excel and show values without using any VBA. Now if you want to reveal the formula, you need to click on the review tab. Then click on the unprotected sheet. If it is password protected, then enter the password to unprotect it. If it is not, then a simple click on unprotect sheet will do.

Some things to consider:

1. This method conceals the formula in Excel while allowing input.

2. Unless you unprotect your worksheet, you won't be able to see any formulas.

3. Although the formula will be concealed, it can still be used.

As a result, if someone accidentally alters your formula, it will be lost. You may, however, simply overcome this. In Excel, here's how to lock a formula. Your formulas will be locked, and no one will be able to alter or delete them without your password.

Thank you so much for taking the time to read this. For more fantastic video tutorials, please subscribe to our YouTube channel. Once again, many thanks.