I’m doing a spreadsheet and have made an entry into a cell but wish to hide it from view. I know there is way in Excel but I can’t find any here, can anyone help me?
to hide the content of a cell you need to perform two things:
- Set Hide all in
Right click -> Format Cells...-> Tab: Cell Protection -> [x] Hide all
- Protect your sheet using
Tools -> Protect Sheet
Note: Cells have Protected property by default, so you may need to set all cells to unprotected in advance and to only set Protected / Hide all for the cell you want to hide (Deactivate option
[ ] Protected in cell style Default)
Hope that helps.
If the answer helped to solve your problem, please click the check mark () next to the answer.