Jagwarman
asked on
Is it possible to make row height static in Excel 2010
I have differing row heights depending on the data contained in the rows.
Every time I insert a new row it changes other rows to the default height.
Is there a way to make row heights remain static?
Thanks
Every time I insert a new row it changes other rows to the default height.
Is there a way to make row heights remain static?
Thanks
No, it can always be adjusted. There is no "lock" option on row heights.
You can stop users formatting rows, including height, by protecting the worksheet. I don't believe this will stop any auto adjustment though.
Thanks
Rob H
Thanks
Rob H
ASKER
Hi Rob
Users need to be able to insert rows but thanks
Users need to be able to insert rows but thanks
See macro at end of this article:
http://www.techrepublic.com/forums/questions/excel-how-to-make-row-height-static/
http://www.techrepublic.com/forums/questions/excel-how-to-make-row-height-static/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In the Protect Sheet dialog, there are various options that the user can still do after protection is applied; one these is to allow users to insert rows.
Thanks
Rob H
Thanks
Rob H