Can I lock Row heights?

  • Thread starter Thread starter Chris Mitchell
  • Start date Start date
C

Chris Mitchell

Can I lock Row heights so that inexperienced users don't inadvertently change them, losing site of some of the content, then thinking something is wrong?
 
Select all cells and Format>Cells>Protection. Uncheck "locked" and OK

Select the rows to keep unchanged and Format>Cells>Protection. Check "locked"

Tools>Protection"Protect Worksheet.

Make sure that allow users to "Format Rows" is not checked.


Gord Dibben MS Excel MVP
 
Can I lock Row heights so that inexperienced users don't inadvertently change them, losing site of some of the content, then thinking something is wrong?
Click to expand...

You can hide the row and/or column headers so that the heights/widths
cannot be changed with a mouse.

Tools->Options: [View] tab: [ ] Rows & column headers.

OR

You can protect the sheet contents using Tools->Protection->Protect
Sheet...
There are caveats to protecting the sheet, though. You'll have to
"unlock" (Format->Cells: [Protection] tab) the cells if you want them
to be editable after the sheet is protected.

Brian Herbert Withun
 
Back
Top