in this video I will show you how to hide formulas in Microsoft Excel or once we click it we can see formula so to hide this formula
firstly select it
now right click on it format cells
and in protection select hidden unselect block
then click on OK
now click anyway
now once we click on it still it will appear now next step select these cells now right click on it
format cells now select unlocked then click on OK
now third step select review
protect sheet
enter the password if you need then click on OK
now once you click on this formula bar so formula will not appear
and once we change the value so it will reflect here but formula is hidden so this area is editable
user and people can change value here but they are not able to see the formula which is used here
like this to remove this setting again click here review and click on unplotted sheet it will ask password so enter the password now once you click on it so formula will appear
so thanks for watching this is the way to hide formulas in Microsoft Excel.