# Styles

Format the cells in a spreadsheet with a set of styles to format the cell appearance in individual worksheets using DsExcel.

## Content

DsExcel .NET allows you to format the cells in a spreadsheet with a set of styles that can be utilized to format cell appearance in individual worksheets for enhanced clarity and increased readability. A cell style includes characteristics such as fill (solid fill, gradient fill, pattern fill), fonts, borders, name style, and display format.
Applying style in a worksheet involves following tasks.

* [Set Sheet Styling](/document-solutions/dot-net-excel-api/docs/online/Features/ApplyStyle/SetSheetStyling)
* [Create and Set Custom Named Style](/document-solutions/dot-net-excel-api/docs/online/Features/ApplyStyle/CreateAndSetNamedStyle)

Some of the built-in styles in DsExcel .NET are listed below:

| **Category** | **Description** | **Properties** |
| -------- | ----------- | ---------- |
| Number Format | Cell number format. | [IRange.NumberFormat](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.NumberFormat.html) |
| Alignment | Horizontal and vertical alignment of cell content, indentation,text wrap, text rotation and text shrinking. | [IRange.AddIndent](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.AddIndent.html)<br>[IRange.IndentLevel](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.IndentLevel.html)<br>[IRange.WrapText](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.WrapText.html)<br>[IRange.ShrinkToFit](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.ShrinkToFit.html)<br>[IRange.MergeCells](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.MergeCells.html)<br>[IRange.ReadingOrder](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.ReadingOrder.html)<br>[IRange.Orientation](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Orientation.html) |
| Font | IRange.Font(IFont) | [IRange.Font](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Font.html)(IFont) |
| Borders | Cell border line styles and colors. | [IRange.Borders](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Borders.html)(IBorders) |
| Fill | Cell pattern fill or gradient fill. | [IRange.Interior](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Interior.html)(IInterior) |
| Protection | Cell protection options (Locked and Hidden) | [IRange.Locked](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.Locked.html)<br>[IRange.FormulaHidden](/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IRange.FormulaHidden.html) |

Apart from the built-in styles, you can also create custom styles with description for individual cells or a range of cells in a worksheet where you can define all the style attributes and properties including font, font size, number format, alignment etc.