Ask Your Question

Column Width Set to Widest Content? [closed]

asked 2014-03-18 01:18:03 +0200

Shearer gravatar image

In Libre Calcl Is there an option to set the column width to accommodate the widest text or entry in the sheet?

I can't find it, but may have missed the setting.

Accustomed to and tired of constantly paying for updates to MS Excel.

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 2016-02-20 08:12:17.974713


Hi @Shearer, just out of curiosity, what for so much column width?

m.a.riosv gravatar imagem.a.riosv ( 2014-03-19 10:35:42 +0200 )edit

Not so much column width, I'm looking to automatically set the column width to contents i.e. small to large, entry in an already populated sheet. I got the answer from the good folks below. Thanks.

Shearer gravatar imageShearer ( 2014-03-20 19:17:41 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2014-03-18 03:35:29 +0200

Edward gravatar image

If you're asking how to set the column width to accomodate widest entry, the procedure is similar to Excel. You can double click the right column separator in the column header, or you select the column, right click, and choose optimal column width. Both methods will also work if you select multiple columns.

edit flag offensive delete link more


This is indeed also possible and leads to the same limit being in cm 100. @Edward - thanks for adding this.

ROSt52 gravatar imageROSt52 ( 2014-03-18 06:11:57 +0200 )edit

Thank you. I was looking in the Format /Column menu, and was not thinking to click on the separator. Either way; it seems like it does not offer the option of "widest entry" at least on my PC. In Excel on the top menus there is Format/Column Auto Fit Selection. This adjust any and all columns to the widest text in those columns, if already entered. In Libre, using optimal width brings up a dialogue box asking for input in cm. ?

Shearer gravatar imageShearer ( 2014-03-18 22:23:59 +0200 )edit

answered 2014-03-19 03:19:24 +0200

ROSt52 gravatar image

updated 2014-03-19 06:50:19 +0200

@Shearer - The auto-formatting is possible. It just looks a bit unusual because the little pop-up window shows possibilities to make setting.

image description

Select column > right click > optimal column width > and hit enter when the little window pops up. You don't need to make any settings for the optimal column width.

edit flag offensive delete link more


I know this is a while later, but I have a problem. I want to change my column to the widest text in the column, right now my LO changes the width to accommodate the label, or the first row.

79schultz gravatar image79schultz ( 2015-10-09 17:03:18 +0200 )edit

answered 2014-03-18 01:51:26 +0200

ROSt52 gravatar image

I made a test and found that the maximum width of a column is 100 cm. Such a cell can take almost the entire 1 paragraph of the "Lorem ipsum" text (about 10-15 characters are missing). In terms of characters and spaces such cell takes about 550 characters and spaces.
Setting: select colums, right click select width and set it to 100 cm or just click the increase button and let it run up to the maximum.

edit flag offensive delete link more


Thanks for that. I was actually looking for the function Edward mentioned.

Shearer gravatar imageShearer ( 2014-03-18 22:24:26 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-18 01:18:03 +0200

Seen: 15,590 times

Last updated: Mar 19 '14