The Autofit feature in Calc and other spreadsheet programs is an extremely helpful feature.
You can simply double-click on the right divider line in the column title, and the column will automatically expand to fit the longest piece of data.
But what if you don’t want to fit the longest piece of data but, instead want to use Autofit to make the column the width of a smaller piece of data?
Is it even possible?
Believe it or not, it is possible and it’s not anymore complicated than using the longest piece of data.
Start by selecting several cells that contain the width to which you want to Autofit the column.
Now double-click the right divider line.
Voila! The column width is reset but only to match the data you selected.
However, when I tried this with a single cell selected, the column was Autofit to the longest piece of data in the column.
To get around that, I selected the cell with the shorter data and a blank cell.
That did the trick…
Who knew that Autofit could be so versatile?
~ April
Pretty good, doesn’t work in Excel 2007 but you can still do it though not quite as easily. Select the cell or cells you want to autofit to, on the home tab, click format and then click autofit. It will autofit to the selected cell rather than the longest.