Excel: Lock Cells But Allow Row Height Adjustment

[Hildegoat15]

Hi,

I'm trying to lock-up cells in a spreadsheet that contain formulas, only I'm running into a bit of a problem. In the comments section of the spreadsheet, sometimes the comments go past the width of the cell. I showed them that if they change the height of that row (just dragging it from the left grey margin) it'll wrap the text and show in the new, taller row. But when I lock the spreadsheet, I'm not able to adjust row heights. The only way know how to lock cells is to highlight them, go to Format, Cells and uncheck the Locked checkbox. Then I go Tools, Protect Sheet. I guess the rows are part of the sheet, so unlocking only does the cells and the Protect Sheet locks the row. Do you know of any way to lock cells that also allows the user to adjust row heights?

-Matt

http://www.ranamedical.com

 

[ETID]

Have you tried to resize the comment text box to fit inside the row width?

I.E. right click on the comment box and drag the dimension tabs to reshape the box.

 

[Hildegoat15]

It's actually just a cell that's been merged to go across the width of the page (actually about 4 or 5 of those rows). I've just shown them how to re-size the height of the row if need be.

-Matt

http://www.ranamedical.com