LOCKING row Height in Excel

Copper Contributor

Hi.  My Excel experience is probably intermediate.  I am creating a massive worksheet for an engineering maintenance company.  To make the boxes to be completed look better, we are leaving a blank line between each complete line at a row height of 4.  Everything I double click on the rows the row resets itself to the standard height.  I can't lock the worksheet, people need to access most of the information.

 

I have tried changing the row height (simple), checking the "Locked" box under protection and Googling for an answer.  Most of them seem to rely on the protection tab.  The other rows need to be able to auto adjust for wrapped text.

 

Is this at all possible?  If so, grateful for a response that is in "layman's" terms.

 

Thanks everyone.

1 Reply
I would strongly consider to avoid the blank rows in-between, Excel does not play well with that. Imagine you need to sort your data for example. Perhaps an alternative is to format your range as a table?