Hide Formulas in Excel
How to hide a formula in Excel so that a user cannot see it, select it, or change it - this includes worksheet protection.
This is a great little security trick for your formulas in Excel.
Steps to Hide Formulas in Excel
Select the desired cell or cells > right-click > Format Cells > Protection tab > put a check next to Hidden > hit OK > go to the Review tab > click Protect sheet > hit OK.
Additional Resources
Hide Formulas in Excel (microsoft site)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Macro: This macro will hide all formulas within a workbook and not allow them to be deleted. The ...
Macro: Hide all comments in an Excel workbook. No indicators will be displayed and comments will ...
Macro: Hide comments in Excel with this macro. Comment indicators will still appear in the ce...
Tutorial: Part 1 - Regular Expression Match Formula in Excel (No VBA) Part 2 - Complete Excel Reg...
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Tutorial: 5 simple tips to evaluate any complex formula in Excel! These tips combine to give you th...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)