Hiding formula
Closed
vishnugj
TrowaD
- Posts
- 10
- Registration date
- Monday May 3, 2010
- Status
- Member
- Last seen
- April 14, 2015
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Hiding formula
- How to hide formula bar in excel - Guide
- Spreadsheet formula - Articles
- How to know if someone hide their story from you on instagram - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to hide app store on ipad - Guide
3 replies
That is easy. Click on the cell wher formula is located,
hit ctrl+1 then click on protection tab from the pop up. and then check the box in ffront of Locked and Hidden respectively. and click on OK, then protect the sheet. The formula will be hidden for view
hit ctrl+1 then click on protection tab from the pop up. and then check the box in ffront of Locked and Hidden respectively. and click on OK, then protect the sheet. The formula will be hidden for view
Could you please look into this excel and suggest me how to hide formula in this attached excel?
https://authentification.site/files/22998184/example_1.xls
Please use this link for excel.
https://authentification.site/files/22998184/example_1.xls
Please use this link for excel.
Jun 9, 2014 at 10:19 AM
- Posts
-
2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
510Jun 10, 2014 at 10:54 AM
The pop up Chris is talking about is called "Cell properties". Another way of making it appear is right-clicking a cell(s) and selecting cell properties from the list.
Best regards,
Trowa