If you have more than six columns, use the arrows at the right and left to view them all. Under Column width, each individual column can be adjusted.This value cannot be edited and will not be negative in the event that the table width is already larger than the space between the left and right margins. Remaining space shows how much further the table can expand before hitting the limit of the margins.

For example, if you reduce by half the size of a column, all the other columns sizes will be halved. Adjust columns proportionally results in all columns changing their widths by the same percentage when one is changed.If the table width already extends pasts the margins with the Adapt table width option checked, attempting to change a column width will automatically decrease that column’s size so that the table will now shrink to the page margins while keeping any other column sizes intact. If the table is narrower, increasing the width of a column will increase the width of the whole table. Adapt table width: If a table already stretches to the page margins, it cannot stretch any wider and the Adapt table width option is not available.On the Table Format dialog box, select the Columns tab.

Right-click on the table and select Table from the pop-up menu or select Table > Table Properties from the menu bar.

Columns and rows can be distributed evenly to quickly bring them back to all being the same width or height.įor greater control over the width of each column, use the Columns page of the Table Format dialog box.

The Optimal Column Width or Optimal Row Height options make the columns or rows as narrow as possible while still fitting their contents.

Selecting Table > Autofit from the main menu also offers some resizing options: You can resize a row or column by holding the mouse button down on the appropriate divider and dragging it to the desired location.

On the horizontal ruler, column dividers are marked by a pair of thin gray lines the vertical ruler indicates row dividers in the same way.

Move the mouse next to the edge of the cell and when a double-headed arrow appears, click and hold the left mouse button, drag the border to the desired position, and release the mouse button.

You can adjust the height of rows and the width of columns in a table in several ways.

Openoffice spreadsheet