# Customizing the Appearance of a Cell

This topic lists the various tasks that relate to setting the appearance of individual cells. Learn more in documentation.

## Content



You can set the appearance of individual cells in the data area of the spreadsheet. These tasks relate to setting the appearance of individual cells:

*   [Working with the Active Cell](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellactive)
*   [Customizing the Colors of a Cell](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellcolor)
*   [Aligning Cell Contents](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellalign)
*   [Customizing Cell Borders](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellborder)
*   [Customizing the Margins and Spacing of the Cell](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellspace)
*   [Creating and Applying a Custom Style for Cells](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellstyle)
*   [Assigning a Cascading Style Sheet to a Cell](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-appearCSS)
*   [Creating a Range of Cells](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellrange)
*   [Spanning Cells](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellspan)
*   [Allowing Cells to Merge Automatically](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-cellautomerge)
*   [Using Sparklines](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearCell/spweb-sparklines)

When you work with cells, you can manipulate the objects using the short cuts in code ([Cell](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Cell.html) and [Cells](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Cells.html) classes) or you can directly manipulate the model. Most developers who are not changing anything drastically find it easy to manipulate the shortcut objects.


> !type=note
>
> **Note:** We use the word "appearance" in the general sense of the look and feel of the cell, not simply the settings in the [Appearance](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Appearance.html) class, which contains only a few settings and is used for the appearance of several parts of the interface. Most of the appearance settings for a cell are in the [StyleInfo](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.StyleInfo.html) class.

Remember that settings applied to a particular cell override the settings that are set at the column or row level. Refer to [Object Parentage](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-concepts/spweb-oviewconcepts/spweb-knowObjParentage).

Other cell-level appearance settings are set by the cell type. For more information on settings related to cell types, refer to [Customizing with Cell Types](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-setCellTypes).

For information on header cells, refer to [Customizing the Appearance of Headers](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-appearSet/spweb-appearHeader).

For tasks that relate to setting the user interaction at the cell level, refer to [Customizing Interaction with Cells](/spreadnet/docs/latest/online-asp/overview/spweb-devguide/spweb-interaction/spweb-interact-cell).

For more information, refer to the [Cell](/spreadnet/api/latest/online-asp/FarPoint.Web.Spread/FarPoint.Web.Spread.Cell.html) class.