Hide Formula In Excel

Показать описание

In this video Guru teaches how to hide a formula in Excel, The steps to Hide Formula in Excel are 1) Right click on the cells containing the formula 2) Click on the Protection Tab 3) click on the Hidden Button 4) Uncheck the Locked Tab 5) Click OK 6) Click on the Review Tab 7) Click on Protect sheet 8) enter a password 9) reenter the password 10 ) You are done :)

Learn Basic Excel Skills For Beginners || Part 1

10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel

5 Excel Questions Asked in Job Interviews

Create Speedometer Chart In Excel

Learn the Basic of Excel for Beginners || Part 2

Create Pareto Chart In Excel

How to Create Dashboard in Excel

Excel Interview Questions & Answers

Рекомендации по теме

Комментарии

Great tips! I'd learned that years ago but I'd forgotten how to do it. Thanks for posting!

beafull-timemusician

Learn MS #Excel | Advanced Level Course | Class 5 | Hide Formula In Excel, Awesome ! MS Excel : Hide Formula In Excel (English)

GuruJii

Thank you for a video!
If it has Macro in it, will it work? I tried, it doesn't work. What can be a reason? and a solution?

ekaterinakuragina

Hey, do you know if this can be done in Google Sheets as well?

leandrikos

Dear Sir Guru,

The hiding of the formulas is great. But after having the formulated cell protected, all the other cells (without any formula) will become also protected and unable to make any editing on its value. How could it possible to edit these other cells and keeping the formulated hidden? Thank you.

mariofar

But entire sheet is not working by this method! Can you hide only cells with Formulas.?

CarCraze-VimalKumar

Dear Sir,

The hiding of the formulas is great. But after having the formulated cell protected, all the other cells (without any formula) will become also protected and unable to make any editing. How could it possible to edit these other cells and keeping the formulated hidden? Thank you.

mariofar