How to hide formulas in excel
#MsExcel #Exceltips&tutorials #Exceltips&tricks
Don’t you want your clients to see what formulas you have used? You don’t want to the client to change the formula? Then this video is for you.
In this video, you will learn how to hide formulas in excel.
Step 1 : Set up your table.Select the column or rows which you want to hide.
Step 2 : Hit the key stroke ,CTRL + 1. It prompts you to format cell dialog box. Choose the last tab named ‘Protection’.
Step 3 : Uncheck the box ‘Locked’. Check the box ‘Locked’ and ‘Hidden’
Step 4: Go to review tab, navigate to changes group and then click on Protect sheet.
Step 5 : It prompts you to enter the password. After you have entered the password, renter it again.
Step 6 : You are good to go. The formula is hidden.
Keep Watching, Keep Learning