Partial Protection Excel Sheet

  • Thread starter Thread starter Gette
  • Start date Start date
G

Gette

Is there a possibility to protect a full sheet except one
row (title row).

The title row contains some drop down boxes. The intention
is that the users can only use the drop down boxes and
that they can not alter the data. But when I protect the
sheet, the drop down boxes can not be used
 
Hi

Before protecting the sheet, uncheck the Locked checkbox in Protection tab
of 'Format Cells' window for cells, you want to be editable.
 
Back
Top