Stop cell changing

[Mia]

Hello,

I have a large spreedsheet i wich i don't want the cells to change rows.
For exampel i write i one cell

Kalle Kula
Kalle kula

And i use Alt+ return between.

The problem I have is that the cell is changing, the row is getting from 12
to 24.
And I don´t want to rows to change. Can I lock it?

I hope you can understand what I meen.

Thank you in advance!



BR
Mia

 

[Sam Wilson]

Hi,

Do you mean that your row height automatically increases when you use text
with a carriage return?

I don't know how you can lock the row height. You can select all and untick
"Wrap Text" in "format" afterwards to force the rows back to height 12, or
you could write a macro to do this whenever the sheet is changed, but I've
never seen a way to lock the height.

I think it is assumed that if you use Alt + Enter you want to have text on
two lines in one cell...

 

[Dave Peterson]

If you set the rowheight to what you want, then it shouldn't change until you
autofit that rowheight.

Select the row or cell
Format|Row|height
(or use the row header and drag it where you want it)

 

[Mia]

Hi,

Thank you so much, this solved my problem!

//
Mia




"Dave Peterson" skrev: