Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to change default column width

In LibreOffice Calc, I can double click on the separator right of an empty column, and the column will change it's width to the default of 2.26 cm. This is annoying and unhelpful.

In almost all of my sheets I have small empty columns between several tables. So if I want to adjust it in Excel or Google Docs, I can make it so that all of the columns are 1 cm (or it's equivalent) and then mark the whole sheet and double click any column separator What I need to do in LibreOffice Calc is to go through all of the columns, one by one, and adjust them individually.

Either one of those two things will solve this problem - 1. Clicking the column separator won't do anything if the column is empty (like in excel or google doc sheets) 2. Clicking the column separator will do the exact same thing it does now, but to a default of 1 cm. instead of 2.26

Before anyone answers - yes, I did search this question in here and found no answer. And yes, I did read this - https://ask.libreoffice.org/en/question/4619/how-does-one-change-default-value-of-column-width/ This answer doesn't help me, it just make the columns width be what I want when I first open a new LibreOffice Calc sheet, not when I want to adjust columns in an existing one.

All of the help that I could find until now was explorations about how to change a single column's width (which I know) and about the function of double-clicking the columns separator (which I know of and currently having an issue with)

How to change default column width

In LibreOffice Calc, I can double click on the separator right of an empty column, and the column will change it's width to the default of 2.26 cm. This is annoying and unhelpful.

In almost all of my sheets I have small empty columns between several tables. So if I want to adjust it in Excel or Google Docs, I can make it so that all of the columns are 1 cm (or it's equivalent) and then mark the whole sheet and double click any column separator What I need to do in LibreOffice Calc is to go through all of the columns, one by one, and adjust them individually.

Either one of those two things will solve this problem - 1.

  1. Clicking the column separator won't do anything if the column is empty (like in excel or google doc sheets) 2. sheets)

  2. Clicking the column separator will do the exact same thing it does now, but to a default of 1 cm. instead of 2.26

Before anyone answers - yes, I did search this question in here and found no answer. And yes, I did read this - https://ask.libreoffice.org/en/question/4619/how-does-one-change-default-value-of-column-width/ This answer doesn't help me, it just make the columns width be what I want when I first open a new LibreOffice Calc sheet, not when I want to adjust columns in an existing one.

All of the help that I could find until now was explorations about how to change a single column's width (which I know) and about the function of double-clicking the columns separator (which I know of and currently having an issue with)