Monday, April 29, 2024
 Popular · Latest · Hot · Upcoming
23
rated 0 times [  23] [ 0]  / answers: 1 / hits: 26452  / 2 Years ago, fri, november 26, 2021, 5:49:31

Suppose you are researching on a topic and have found something with a tabular form, now you would like to save that in your spreadsheet application to see that when offline, so you fired up OpenOffice Calc or MS Excel and pasted that table.


Now I don't know about MS Excel, but when I pasted in LibreOffice Calc then I seen something like as shown in the screenshot.


Uneven Row Size


As you can see the width of column A B and C can be resized because they are only 3 in numbers, but its hard to edit the height of 1, 2, 3, 4 etc.


Question


Any other way to resize the heights of 1, 2, 3, 4 than doing manually?


More From » libreoffice

 Answers
3

Open the file.



Ctl+a to select all.



Either:

A

Format -> Row -> Optimal Height

OK



B

Format -> Row -> Height

Set a height.

You could find the desired height by doing this same thing on the largest row and checking the value


[#38361] Saturday, November 27, 2021, 2 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
wherejuic

Total Points: 53
Total Questions: 123
Total Answers: 117

Location: Zambia
Member since Mon, Jan 23, 2023
1 Year ago
;