Protection of certain cells or columns

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

I am trying to find out how to protect cells or columns in a sheet, without
protecting the whole sheet.

Is that possible or can you only protect the whole sheet?
 
select the whole sheet
go to Format on the menu bar
select Cells
select Protection tab
uncheck Locked
click OK
select the cells you want to protect
right click >> Format cells
select Protection tab
check Locked
click OK
go to Tool on the menu bar
select Protection >> Protect Sheet

this will protect the cells you have selected


--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis
 
Hi Thomas,
You have to protect the whole sheet , but before you have to unprotect the
cells where you want users to have access. select the cells right click in
the mouse, format cells, last tab protection and uncheck locked
 
Back
Top