restrict access to a column of a spreadsheet

[James]

Hello,

Is it possible to restrict access to only one column of a spreadsheet?

 

[Gord Dibben]

Yes.

Select all columns and Format>Cells>Protection. Select the "Locked" option.

Select the one column and Format>Cells>Protection. De-select the "locked"
option.

Tools>Protection>Protect Worksheet.


Gord Dibben MS Excel MVP