# Cells, Columns, and Rows Editor

Customize the appearance of cells, columns, and rows with the Cells, Columns, or Rows Editor of the Spread Designer. Learn how to edit various properties associated with these objects.

## Content



You can customize the appearance of cells, columns or rows with the **Cells**, **Columns**, or **Rows Editor** of the Spread Designer. This editor is launched from the **Properties** window by selecting sheet in the drop-down box on the right side of the designer and then clicking on the button for the Cells, Columns, or Rows property. You can also access this dialog from the **Other Settings** section under the **Settings** menu. This figure shows the editor with a cell selected.

![セル、列、および行エディタ](https://cdn.mescius.io/document-site-files/images/2238e618-a1fb-45a6-9ce5-9a4157bd2931/images/sd-dialog-cellscolsrowseditor-cells.png)

This editor allows you to edit various properties associated with four objects. If a cell is selected, the properties for the [Cells](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cells.html) class are displayed in the properties window of this dialog. If a column is selected, the properties for the [Columns](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Columns.html) class are displayed in the properties window of this dialog. If a row is selected, the properties for the [Rows](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Rows.html) class are displayed in the properties window of this dialog. If the corner cell (of the sheet, in the upper right corner) is selected, the properties for the DefaultStyle class are displayed in the properties window of this dialog.

Typically, the value of the properties are kept when opening this editor. But there are some settings that are changed (in order to allow you to edit them and work with the editor in general); these include making all the headers visible, even if you have them hidden by using code, and allowing notes to be editable, even if you have that turned off. In this editor you can set several settings relating to sorting, spans, notes, and other aspects of cells, columns, and rows.

Click Apply to apply those settings to the cell or column or row, or range of any of these, in Spread Designer.

For more information on the appearance of cells, columns, and rows, refer to [Customizing the Appearance of a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-appearcell) in the Developer’s Guide.

For more information about styles and default styles, refer to [Creating and Applying a Style for Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance/spwin-cellstyle) in the Developer’s Guide.

For more information about header cells, refer to [Header Editor](/spreadnet/docs/latest/online-win/overview/spwin-designerguide/spwin-spd-editors/SDHeaderEditor).

For details about the properties of a cell, refer to the [Cell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.html) class or the [Cells](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cells.html) class. For more information about properties of a column, refer to the [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.html) class or the [Columns](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Columns.html) class. For more information about properties of a row, refer to the [Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.html) class or the [Rows](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Rows.html) class.