Rows and Columns

Row height and column width

There are many ways of setting the height of a row or width of a column.

For column width, it is possible to specify the size as a number from 0 to 255.  This represents the number of characters that can be displayed in a cell that uses the standard font.

If a column width is changed to zero, the column will be hidden.

For rows height, it is possible to specify the size as a number from 0 to 409.5.  This represents the height measured in points.  One point is approximately 1/72 inch or 0.35mm).

If the row height is changed to zero, the row will be hidden.

To set a column width

1. Right click on the column letter of the column to be changed.
2. Select “Column Width”
3. Type in the required width and click OK

Or

1. Move the cursor to the right of the column letter of the column to be changed until it becomes a crosshair.
2. Click and hold the left hand button and drag to the left or right to increase or decrease the width.

To set a row height

1. Right click on the row number of the row to be changed.
2. Select “Row Height”
3. Type in the required height and click OK

Or

1. Move the cursor to the bottom of the row number of the row to be changed until it becomes a crosshair.
2. Click and hold the left hand button and drag up or down to increase or decrease the height.

2019-03-08T10:41:01+00:00