Hiding formula
Closed
vishnugj
Posts
8
Registration date
Monday May 3, 2010
Status
Member
Last seen
April 14, 2015
-
Jun 16, 2010 at 12:57 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 10, 2014 at 10:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 10, 2014 at 10:54 AM
Related:
- Hiding formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
3 responses
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
Jun 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