Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Autofit a Column Using Selected Cells in OpenOffice Calc

Wednesday, April 6th, 2011 by | Filed Under: OpenOffice

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

Tags: ,

One Response to “Autofit a Column Using Selected Cells in OpenOffice Calc”

  1. Mark says:

    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.

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive