Can I lock Row heights?

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?
 
G

Gord Dibben

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
 
B

Brian Withun

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
How to clear areas of a locked Doc after each use-- 0
Finding the height of a row in a word table from Excel 0
MS Project 2013: Adjusting Printed Row Heights 0
rows height 3
Format column widths from one table to a separate table on same page 1
Can I auto format row height according to requirements of largest cell in row? 7
Excel wrapping incorrectly 1

Top