# Rows and Columns

Learn how to customize the appearance and behavior of rows and columns in Spread.NET with these essential tasks and shortcuts.

## Content

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

* [Customizing the Number of Rows or Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolnumber)
* [Adding a Row or Column](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcoladd)
* [Removing a Row or Column](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolremove)
* [Showing or Hiding a Row or Column](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolhide)
* [Setting the Row Height or Column Width](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolsize)
* [Setting Frozen and Pinned Rows/Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcol-freeze)
* [Moving Rows or Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcol-usermove)
* [Creating Alternating Rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolalt)
* [Setting up Preview Rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-previewrow)
* [Input Data in Rows or Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcol-userentry)
* [Finding Rows or Columns That Have Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolnonempty)
* [Adding a Tag to a Row or Column](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-tags-rowcol)

When you work with rows and columns, you can work with the objects using the shortcuts in code (**Row**, **Rows**, **Column**, **Columns**, **AlternatingRow**, and **AlternatingRows** classes) or you can work directly with the model. Most developers who are not creating extensive customizations find it easier to work with the shortcut objects. For information on the underlying model responsible for rows and columns, refer to the [Understanding the Axis Model](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-usemodels/spwin-model-types/spwin-model-axisstuff).

You can edit properties of the Rows and Columns classes in the **Properties** window (in Spread Designer or in Visual Studio .NET). For more information on the **Cells, Columns, and Rows Editor** that is available from the **Properties** window, refer to the explanation of this editor in the Spread Designer Guide.

Similar to other grid products you might have used, Spread does not allow in-cell editing of the cells in the row and column headers.

For more information about the appearance of rows as a result of filtering, refer to [Setting the Appearance of Filtered Rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-filtering/spwin-filter-appear).

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](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-knowobjparentage).

For more information, refer to the [Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.html), [Rows](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Rows.html), [AlternatingRow](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.AlternatingRow.html), [AlternatingRows](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.AlternatingRows.html), [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.html), and [Columns](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Columns.html) objects in the Assembly Reference.

## See Also

[Spread Designer Guide](/spreadnet/docs/latest/online-win/overview/spwin-designerguide)

[Sheets](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-sheet)

[Headers](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-header)

[Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell)

[Customizing the Sheet Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance)