height and width settings locked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can row height and column width settings be locked in an Excel document
without blocking the user from entering/editing data in the cells?
 
Only by the usual mechanism of unlocking the data entry cells, which could
be all the cells.
 
Click the button between row 1 and column A to select the entire worksheet,
then right click and go to format. Go to the protection tab and unprotect.
Then go to tools, protection, protect sheet.
 
JR said:
Click the button between row 1 and column A to select the entire worksheet,
then right click and go to format. Go to the protection tab and unprotect.
Then go to tools, protection, protect sheet.
Click to expand...
 
Back
Top