Adjusting Column Width and Row Height

You can narrow or widen the width of columns, and narrow or widen the height of rows. If your spreadsheet contains numbers with many digits or very long labels that do not fit completely in the cells, you may want to adjust column width or row height.

To adjust column width:

  1. Select the column(s) you want to adjust. (See Selecting Columns and Rows.)

  2. Go to the Format drop-down menu, and put your cursor over Column. Click Width.

  3. A Column Width window will appear.

  4. Type the new column width in the Width box. You can select a unit of measurement from the Units box. To use the default setting, check off Use Default. EasySpreadsheet's default width is 9 characters.

  5. Click OK. The width of your selected column will be adjusted.

 

To adjust row height:

  1. Select the row(s) you want to adjust. (See Selecting Columns and Rows.)

  2. Go to the Format drop-down menu, and put your cursor over Row. Click Height.

  3. A Row Height window will appear.

  4. The default setting is Auto; row height will automatically be adjusted to fit the text. To enter your own row height, click Custom, and then type the new height in the text box. You can select a unit of measurement from the Units box.

  5. Click OK. The height of your selected column will be adjusted.

 

To change the column width or row height manually:

  1. Move the cursor to the border between column or row header buttons (these appear above, and to the left of your sheet). The cursor will change to a double-headed arrow.

  2. Click and hold down the left mouse button, and move the cursor. Drag the entire column or row border to a new position.

  3. When you are done adjusting the size, release the mouse button.

 

AutoFit

By default, rows height will automatically be adjusted to fit text. It is also possible to adjust the width of columns according the text they contain.

To AutoFit column width:

  1. Select the column(s) you want to adjust. (See Selecting Columns and Rows.)

  2. Go to the Format menu, and put your cursor over Column. Click AutoFit Selection

  3. The width of your selected column will be adjusted to fit the length of the text it contains. This way, all values in the cells will be visible.