OpenOffice.org videos and documentation
Plan-B for OpenOffice.org, learning office productivity software with videos


Tech Support for OpenOffice.org
Applications
Go to Open Office Writer Index
Go to Open Office Impress Index
Go to Open Office Math Index
Go to Open Office Draw Index
Go to Open Office Calc Index
Go to Open Office Base Index
Go to Open Office Online Help Index

Adjust the column width to fit contents - OpenOffice.org Calc

How-To: Adjust the column width to fit contents - OpenOffice.org Calc
  1. It is possible to quickly adjust the width of a column to fit its contents. In this example we will adjust first the column "Mar" or march.
  2. Do this by moving your mouse over the left boundary of the column like so....
  3. then, double click on it.
  4. Great! It has adjusted itself automatically to fit its contents. You can do this on all columns that you want to adjust.
  5. The maximum width of a "auto-fitted" column will always follow the longest entry in the cell. Watch the action again as we adjust this May column.
  6. In this case the $18.00 and $21.00 cells are the basis for this column's length.
  7. Now, when you type in a longer entry...
  8. ...like this January entry...
  9. ...then it would be the basis of the width. Note that you will have to re-adjust the column width again as you type in new content.
  10. Great! You have learned how to quickly fit a column's width to its contents.
powered by Plan-B screencast technology

Adjust the column width to fit contents

This screencast demonstrates how to adjust the column width to fit contents. You learn:

  • How to search for a column's right boundary.
  • How to auto adjust a column's width to fit its contents.

Advanced topics

For advanced functionality with similar results see:

OpenOffice.org™ is a trademark of OpenOffice.org.

Further questions?

*
*
*
* required fields
Get OpenOffice.org - Free!