Ask Your Question

Calc: How I can enable autoadjust lines on?

asked 2018-05-08 14:31:03 +0200

Matheus C. gravatar image

updated 2018-05-09 02:06:08 +0200

LibreTraining gravatar image

Hello I would like to know how I can format the cells without having to drag the columns with the mouse, could you help me?

How can I automatically adjust line height using a keyboard shortcut? or with a permanent configuration in the file?


edit retag flag offensive close merge delete


I feel sure many contributorts read the question intending to help you. As nobody posted an answer within 20 hours now, I would suspect they didn't understand the question. I also did not.
Are all of us just too silly, or is the question unclear?
A hint: I wouldn't try to answer how to automatize something without knowing what exactly should be achieved. Adjusting row heights will depend on parameters and/or a mode after all...
"Do what I want!" won't work.

Lupp gravatar imageLupp ( 2018-05-09 11:29:49 +0200 )edit
Lupp gravatar imageLupp ( 2018-05-09 11:32:31 +0200 )edit

Thanks for the comment, I'll try to be clearer in the next time. Sorry for the confusion, I'm still learning the language.

Matheus C. gravatar imageMatheus C. ( 2018-05-09 14:39:51 +0200 )edit

Well, fortunately @sludge7051-x obviously guessed right. I should also have thought this way.
(By the way: As far as I know 'Optimal Height...' should be enabled by default for a new spreadsheet.)

Lupp gravatar imageLupp ( 2018-05-09 14:57:52 +0200 )edit

I thought it was strange too, I thought it should be the default, but mine was not working so I had to figure out how to enable

Matheus C. gravatar imageMatheus C. ( 2018-05-11 14:32:13 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-09 14:26:57 +0200

sludge7051-x gravatar image

Click the cell in the very top left (of the row and column headers) to highlight the whole Worksheet.

Then, right-click on any row . . . "Optimal Height" will auto-adjust . . . or use "Row Height" to specify a height

edit flag offensive delete link more


thank you so much, I was looking for something exactly like this

Matheus C. gravatar imageMatheus C. ( 2018-05-09 14:36:13 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-08 14:31:03 +0200

Seen: 33 times

Last updated: May 09 '18