Customizing the Appearance of Rows and Columns

These tasks relate to setting the appearance of rows or columns in the sheet:

Customizing the Number of Rows or Columns
Adding a Row or Column
Removing a Row or Column
Showing or Hiding Rows or Columns
Setting the Row Height or Column Width
Setting the Top Row to Display
Creating Alternating Rows
Creating Row Templates (Multiple-Line Columns)

When you work with rows and columns, you can manipulate the objects using the shortcuts in code (Row, Rows, Column, Columns, AlternatingRow, etc.) or you can directly manipulate the model. Most developers who are not changing anything drastically find it easy to manipulate the shortcut objects.

Remember that settings applied to a particular row or column override the settings that are set at the sheet level and settings applied at a cell level override the row or column settings. Refer to Object Parentage.

For information on headers, refer to Customizing the Appearance of Headers.

For more information, refer to the Row class or Column class.

For more information about the underlying axis model, refer to Understanding the Axis Model.