Format an Excel
Formats cells in an Excel worksheet.
Overview
This procedure formats cells in an Excel worksheet by applying various formatting options such as background color, font color, font weight, and font size to specified cell ranges.
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Format Header Row with Background and Bold Font
Formats header cells with yellow background and bold text.
format the excel
the worksheet name is "Sheet1"
the cell range is "A1:C5"
the bg color is "FFFF00"
the font color is "000000"
the font weight is "bold"
2. Format Data Column with Font Size and Color
Formats a data column with larger font size and blue color.
format the excel
the worksheet name is "Sheet1"
the cell range is "A1:A10"
the font size is 14
the font color is "0000FF"
Last updated
Was this helpful?