In MS Excel, if you select the whole spreadsheet and then hover over the column separator so you see the double-headed arrow and double-click the column separator line it will adjust all of the column widths to match the longest content for that column. Is there an equivalent function in Calc?
1 Like
Hi! Is there a way to set the width and height at once?
Works the same in Calc. Alternatively right click on a column header and from context menu choose Optimal Width.
Strange, for whatever reason it does not perform it when simply double clicking the divider bar, but it does if I use the right-click and choose Optimal Width method. Anyway, I was able to get the desired result, so thank you!