how to protect a column in a spreadsheet
yes! thank you - that did it!
"Peo Sjoblom" wrote:
I think you misunderstood, first select the whole sheet, then do
formatcellsprotection, then deselect locked, now select your column, do
the same but check locked. Finally password protect the sheet
--
Regards,
Peo Sjoblom
"andi" wrote in message
...
I could not get this to work. When I leave the sheet unprotected, the
column
remains unprotected (even after formatcells protection) and it tells me
that locking cells has no effect unless the worksheet is protected. So
then I protected the worksheet, no password required, can't edit any
cells.
Any other ideas?
"Gary''s Student" wrote:
Just as you would protect individual cells:
Format Cells... Protection
but first select the column rather than just a cell.
--
Gary''s Student - gsnu200720
"andi" wrote:
I know you can hide columns and I know you can password protect a
spreadsheet. But is there a way to just protect one column in a
spreadsheet?
I want the user to be able to see the values in, say, column B but not
be
able to change anything in that column. Its a simple spreadsheet.
Take
what's in column A, multiply by value in column B (don't want users to
be
able to change this number) and put the final number in column C.
Thank you!
|