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.

Return to the appearance overview at Customizing the Appearance.