Forum Discussion

SuzanH's avatar
SuzanH
Copper Contributor
Jun 25, 2020

LOCKING row Height in Excel

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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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?

Resources