How to Hide Formulas in Excel (Quick and Easy)

How to Hide Formulas in Excel

This tutorial offers a quick and easy way how to hide formulas in Excel. Thanks to these set of steps no one will be able to see the formulas you used in a data table.

Ready to start?

Would you rather watch this tutorial? Click the play button below!

If there are any formulas in a data table, it’s quite easy to spot them – just click into the cell containing a formula and you can see it right away. Or have a look at the formula bar here at the top. If you don’t want anyone to see the formulas, you can hide them using the following steps.

How to Hide Formulas in Excel - you can spot formula at the formula bar
How to Hide Formulas in Excel - you can spot formula at the formula bar

How to Hide Formulas in Excel

First, select the cells which contain the formulas you want to hide. Then use the right-click to select ‘Format Cells’.

How to Hide Formulas in Excel - select the cells which contain the formulas you want to hide and then use Format Cell option

You’ll see a window where you can go to the tab Protection. Select the option ‘Hidden’, which practically hides the contents of the cells, in this case, the formulas.

How to Hide Formulas in Excel - go to the tab Protection
How to Hide Formulas in Excel - Select the option ‘Hidden’

Confirm with OK and format the rest of the cells where you want to hide the formulas the same way. For example, we’re going to hide the sums here, in row 11, too.

How to Hide Formulas in Excel - Confirm with OK

Now, you might notice that the cells have been formatted, but the formulas in them are still visible. This is because the Sheet must be protected first. You can do that through the option ‘Protect Sheet’ and we’ll go through this shortly.

How to Hide Formulas in Excel - formulas in them are still visible

But before we do that, we need to identify the cells which should stay unprotected, which basically means we mark the cells which will stay editable and their contents will be accessible to everyone.

How to Hide Formulas in Excel - identify the cells which should stay unprotected

How to Protect Cells with Formulas

Let’s say we want our co-workers to be able to change the data in this table. To ensure that, we need to select the cells containing the data, right-click, select ‘Format Cells’ and in the tab ‘Protection’ unselect ‘Locked’.

How to Hide Formulas in Excel - select format cells
How to Hide Formulas in Excel - Unselect option Locked

This way the cells will stay unlocked and anyone will be able to see and edit the information stored there. Now we click on OK and move on.

How to Hide Formulas in Excel - Click on OK

Once we’ve formatted all the cells as we needed and we’ve clearly marked the cells that should be locked as well as the ones that should stay editable, we can proceed with the last step.

To put all of the settings in practice, we need to open the Review tab and click on the button ‘Protect Sheet’.

How to Hide Formulas in Excel - Click on the button Protect Sheet

If needed, you can use a password to protect the sheet. We won’t use a password now, so we only confirm by clicking on OK and that’s it!

How to Hide Formulas in Excel - If needed, you can use a password
How to Hide Formulas in Excel - Confirm by clicking on OK

The formulas in the table are not visible, because they’ve been locked.

How to Hide Formulas in Excel - The formulas in the table are not visible

If someone would like to edit the locked cells, this message pops up.

How to Hide Formulas in Excel - Message pops up

On the other hand, the cells storing the editable data can be accessed and the information inside them changed. And all the changes get reflected in the formula calculations.

How to Hide Formulas in Excel - editable data can be accessed
How to Hide Formulas in Excel - all the changes get reflected in the formula calculations

How to Unprotect Cells with Formulas

To turn the protection setting off, simply go to the Review tab and click on ‘Unprotect Sheet’. All the formulas are now visible and cells editable.

How to Hide Formulas in Excel - To turn the protection setting off, click on ‘Unprotect Sheet’
How to Hide Formulas in Excel - All the formulas are now visible and cells editable

And if you’d like to know how to show formulas in Excel and how to be able to take a good look at all the formulas used in a spreadsheet, take a moment and watch the video tutorial the link to which has been provided in the list below.

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.