Row Height

You can change the row height of selected cells by choosing Data Tools | 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.

Row Height Dialog

To set row heights or to hide rows, select the entire row or individual cells within the rows, and then select Data Tools | 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.

 

Row Height Dialog
Change the row height by selecting rows,

clicking the Row Height command, and then

entering a number into the Row Height dialog.

 

Changing Row Heights with the Mouse

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.

 

Changing Row Height
This example shows the cursor
being used to change the
height of row 3.

 

Hide a Row

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.

Display Hidden Rows

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

Column Width

Format Cells

Displaying Hidden Columns or Rows

Hiding Columns or Rows

Selecting a Column or Row Dividing Line