# Format Cells

> `UiPath.Excel.Activities.Business.FormatRangeX`

`UiPath.Excel.Activities.Business.FormatRangeX`

Sets the format for all the cells in a specified range. You can format the data type, alignment, font, and fill color of the cells. The activity can be used with an Excel file selected for a parent [Use Excel File](https://docs.uipath.com/activities/other/latest/productivity/excel-application-card) activity or with the Project Notebook.

To learn how to use this activity, see [Tutorial: Extracting Table Data from a Web Page and Editing it in Excel](https://docs.uipath.com/studiox/docs/tutorial-extracting-table-data-from-a-web-page-and-editing-it-in-excel).

## Configuring the activity

#### In the body of the activity

* **Source** - Select **Plus** on the right side of the field, then, from the menu, select the file and then a sheet, table, or range to format, or select **Indicate in Excel** to indicate a range directly from the file. Alternatively, you can select **Custom Input** to enter a sheet name, table name, or range manually, or **Open in Advanced Editor** to enter a VB expression.
* **Format data as type** - Select **Set Format** to open the Format cells window and then select what to format in the cells using the options at the top: **Data Type** (number format), **Alignment** (horizontal, vertical, wrap text), **Font** (font, font style, underline style, font size, color), or **Fill** (color). Depending on your selection, other options may appear for additional configuration.

#### Properties panel

**Common**

* **DisplayName** - The name displayed for the activity in the Designer panel.

**Input**

* See **Source** in the body of the activity.

**Misc**

* **Private** - If selected, the values of variables and arguments are no longer logged at Verbose level.