User Guide EasyXLS Basics Cell formatting Cell formatting The following listed chapters show how to format cells, columns and rows, merge cells, set rich text format in cells, set column width and row height, apply auto-format and conditional formatting and set the formatting theme for the Excel file.
Formatting cells, columns and rows How to format cells, columns and rows in Excel worksheet Cell font settings How to set font for cells, rows and columns from Excel worksheetNumber and date format How to apply date and number format for Excel cellsCell background color and pattern How to apply background color, pattern, and gradient fill for Excel cellsCell border settings How to set borders for spreadsheet cellsCell alignment settings How to apply horizontal alignment, vertical alignment, indent, text orientation, and text direction in Excel cellsRich text format in cell How to use rich text format (RTF) in worksheet cellsMerge cells How to merge ranges of cells in Excel worksheetColumn width and row height How to set column width and row height for Excel worksheetAutoformatting How to use Excel autoformatting for ranges of cells, predefined Excel autoformat or custom autoformatConditional formatting How to use conditional formatting for cell ranges in Excel worksheetThemes How to use Excel themes, predefined theme or custom theme