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 worksheet
• Number and date format
  How to apply date and number format for Excel cells
• Cell background color and pattern
  How to apply background color, pattern, and gradient fill for Excel cells
• Cell border settings
  How to set borders for spreadsheet cells
• Cell alignment settings
  How to apply horizontal alignment, vertical alignment, indent, text orientation, and text direction in Excel cells
• Rich text format in cell
  How to use rich text format (RTF) in worksheet cells
• Merge cells
  How to merge ranges of cells in Excel worksheet
• Column width and row height
  How to set column width and row height for Excel worksheet
• Autoformatting
  How to use Excel autoformatting for ranges of cells, predefined Excel autoformat or custom autoformat
• Conditional formatting
  How to use conditional formatting for cell ranges in Excel worksheet
• Themes
  How to use Excel themes, predefined theme or custom theme