Ian has attended:
Excel Intermediate course
Protecting cells
How do you protect a single cell's info from being changed by somebody else accessing your file?
RE: protecting cells
Hello Ian
Thank you for your question and welcome to the forum.
First you would need to select your whole spreadsheet, by using Ctrl+A. Then hold down the Ctrl key and click on the cell that you want to protect - this deselects that particular cell.
Then unlock all the selected cells (Format - Cells - Protection - uncheck the Locked box.
Then apply protection (Tools - Protection - Protect Sheet).
This should apply protection only to the cell you deselected earlier, as all other cells in the spreadsheet are unlocked and therefore protection is not applied to these cells.
Kind regards
Amanda