Spread Designer

To display a specified number of columns and rows

In the Spread Designer,

1. From the Sheet menu, choose Columns and Rows or press the Columns and Rows button ( ) on the Sheet toolbar.
2. In the Column and Row Settings dialog box,
   1. Do either or both of the following:
      • Specify the number of columns to display on the Columns tab by clicking the arrows or typing a value in the Visible Cols spin box under Settings.
      • Specify the number of rows to display on the Rows tab by clicking the arrows or typing a value in the Visible Rows spin box under Settings.
   2. Choose the OK or Apply button.
3. If you want to prevent partial display of columns and rows,
   1. From the Book menu, choose Environment or press the Environment button ( ) on the Book toolbar.
   2. On the Environment tab in the Book Settings dialog box,
      1. Select the Autosize On check box under Settings.
      2. Choose the OK or Apply button