Protecting Structure of cells

  • Thread starter Thread starter keithtrumble
  • Start date Start date
K

keithtrumble

Hi,

I need to protect the structure of an Excel sheet so that unexperienced
users can enter data but cannot change the structure of the document
such as the width, height, font size etc?

Is this possible, and if so how do I do it?

Thanks,
 
Tools - Protection - Protect worksheet. You have first to have unlocked
cells whose value is to be changeable (Format - Cells - Protection). The
protection functionality depends on your version of Excel.
 
Back
Top