You can change the row height of selected cells by choosing Data | Format | Row Height or by using the mouse to size the row. The Excel XLS, Excel XLSX, or SYLK SLK file format must be used to save the row height and numeric format information with the file since ASCII file formats (.CSV, .TXT, .DAT, .BNA, .BLN) do not preserve file format information.
To set row heights or to hide rows, select the entire row or individual cells within the rows, and then select Data | Format | Row Height. Enter the width for the selected row or cells in the Row Height dialog. Rows can range from zero to 512 characters in height.
Change the row height by selecting
rows, choosing
Data
| Format | Row Height,
and then entering a number into
the Row
Height dialog.
Row height can also be changed using the mouse. When the cursor is moved to the line that defines the lower boundary of the row header, the cursor changes to a line with two arrows . Press and hold the left mouse button, move the cursor up or down to change the height of the row.
This example shows the cursor
being used to change the
height of row 3.
You can hide a row by moving the cursor up until the next dividing line is reached. In the Row Height dialog, a Row Height value of zero (0) hides the row.
To display hidden rows, press and hold the left mouse button at the bottom of the hidden row and move the cursor down to stretch the row height.
See Also