# Cells Discover efficient ways to handle cells in the data area of the spreadsheet, including working with shortcut objects, appearance settings, and editing properties of the Cells classes. ## Content When you work with cells in the data area of the spreadsheet, you can work with the objects using the shortcut objects in code ([Cell](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cell.html) and [Cells](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Cells.html) 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. These tasks relate to working with cells in the data area of the spreadsheet: * [Working with the Active Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellactive) * [Adding Hyperlink in a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/adding-hyperlink-in-cell) * [Creating a Range of Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellrange) * [Managing Data on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata) * [Placing and Retrieving Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-dataaddreturn) * [Handling Data Using Sheet Methods](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-dataaddreturn/spwin-databymethod) * [Handling Data Using Cell Properties](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-dataaddreturn/spwin-databyprop) * [Moving Data on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-datamove) * [Copying Data on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-datacopy) * [Repeatedly Filling a Range of Cells with Copied Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-datafillrange) * [Swapping Data on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-dataswap) * [Removing Data from a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/spwin-dataremove) * [Remove Duplicates from Range](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/remove-duplicates) * [Text to Columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/text-to-columns) * [Creating Data Type for Custom Objects](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-usedata/adding-data-types) * [Displaying Cell Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-celldata) * [Resizing the Data to Fit the Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-celldata/spwin-appearshrink) * [Allowing Cell Data to Overflow](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-celldata/spwin-celloflow) * [Aligning Cell Contents](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-celldata/spwin-cellalign) * [Resizing a Cell to Fit the Data](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-celldata/spwin-cellfitdata) * [Creating a Span of Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellspan) * [Allowing Cells to Merge Automatically](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cellmerge) * [Adding a Note to a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cell-note) * [Adding a Tag to a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-tags-cell) * [Displaying Text Tips in a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cell-texttip) * [Working with Cell Format Strings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cells-format) * [Working with Pattern and Gradient Fill Effects](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-patternandgradientfill) * [Inserting Cells](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/insert-cells) * [Setting Rich Text in a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cells-richtext) * [Adding a Comment to a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cells-comment) * [Adding Image in a Cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cells-image) * [Formatting a Cell Value](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cells-formatcellvalue) > !type=note > > **Note:** The word "appearance" is used to mean the general look of the cell, not just the settings in the Appearance 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 class. 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-win/overview/spwin-devguide/spwin-ssojbects/spwin-knowobjparentage). Other cell-level appearance settings are set by the cell type. For more information on settings related to cell types, refer to [Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes). You can edit properties of the Cells 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](/spreadnet/docs/latest/online-win/overview/spwin-designerguide). ## See Also [Spread Designer Guide](/spreadnet/docs/latest/online-win/overview/spwin-designerguide) [Cell Types](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setcelltypes) [Customizing the Sheet Appearance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-setappearance)