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