Is it possible to leave a cell range read-only?
if you have a spreadsheet with multiple columns and rows. Can you have a single column read-only?
How???
Thanks…!!!
Is it possible to leave a cell range read-only?
if you have a spreadsheet with multiple columns and rows. Can you have a single column read-only?
How???
Thanks…!!!
Hi,
unfortunately there is no way to set readonly mode for specific cells, only for the whole spreadsheet.
Ok… thanks
Sorry, forget to mention that spreadsheet v2.0 support ability to lock/unlock cells.
To lock/unlock cells you should select cell and press right mous button, select Lock/Unlock.
But be carefull, lock/unlock doesn’t mean readonly. It just prevents from accidental editing.
But another user who can edit spreadsheet may unlock it and then edit cell.
That’s OK
Is it possible to disable right click to prevent another unauthorized user can edit locked cells?
thanks
Hi,
unfortunately there is no way to do that.