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

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...


"Mia" wrote:

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

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 wrote:

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

--

Dave Peterson

Hi,

Thank you so much, this solved my problem!

//
Mia




"Dave Peterson" skrev:

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 wrote:

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

--

Dave Peterson