Ask Your Question

Calc: How I can enable autoadjust lines on? [closed]

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

Matheus C. gravatar image

updated 2020-08-07 20:09:54 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-07 20:10:18.084105


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

Question Tools

1 follower


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

Seen: 60 times

Last updated: May 09 '18