stop row heights from changing during input?

  • Thread starter Thread starter snsyg
  • Start date Start date
S

snsyg

hello all,

i have a worksheet that is protected. text wrapping is turned on.

when i input something into a cell, the row height is increased, eve
if the text length is well short of the cell width (even one characte
at times). the text is displayed on one line, but the cell heigh
doubles.

if i unprotect the worksheet and type in the text, the rows don'
change height if the text is short enough for one line.

i am going to have multiple users using this sheet and it needs to b
protected, but i don't want the cell heights to change on a whi
(unless the input requires two lines).

in the past with other files, i've wanted the row height to increas
with multiple lines of text (text wrap was on), but it didn't...i ha
to do it manually.

what's going on and is there a way to control this?


any help will be greatly appreciated.

kare
 
Karen

Format>Row>AutoFit usually takes care of row re-sizing when wrap text is set
on.

Try selecting all rows and set to a height of 12 or so then see what happens
when you type in some text. Should not change size even with wrap text set
on.

You may have to play with this some to get what you want.

Gord Dibben Excel MVP
 
Back
Top