To allow users to edit some cells of a protected sheet you must first:

  1. hide those cells
  2. delete those cells
  3. merge those cells
  4. unlock those cells in Format Cells → Protection
Answer

D) unlock those cells in Format Cells → Protection

Untick Locked before protecting.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise