View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xlmate xlmate is offline
external usenet poster
 
Posts: 144
Default Protection of certain cells or columns

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










"Thomas" wrote:

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?
--
Thomas