# Fill Range

> `UiPath.Excel.Activities.Business.FillRangeX`

`UiPath.Excel.Activities.Business.FillRangeX`

Enters a formula or a text in all the cells in a range. 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.

If you enter a formula using the Text Builder, Excel's auto-increment functionality updates the given formula for all rows and columns. For example, the following activity will write the formula `=A3+B3` to `C3`, `=A4+B4` to `C4`, and so on.

![docs image](https://dev-assets.cms.uipath.com/assets/images/activities/activities-docs-image-180808-455739ce.webp)

## Configuring the activity

#### In the body of the activity

* **Where to write** - Select **Plus** on the right side of the field and then, from the menu, select a named range or table to fill with data, or select **Indicate in Excel** to indicate a range directly from the file. Alternatively, you can select **Custom Input** to enter a range or table name manually, or **Open in Advanced Editor** to enter a VB expression.
* **What to write** - Select **Plus** on the right side of the field, and then use one of the options in the menu to indicate the data to add to the cells in the range:

  + Data from the Project Notebook, a parent Excel file or Outlook account. For example, select a cell in an Excel file to copy the value from that cell to every cell in the range.
  + **Use Saved Value** - Select a value that you previously saved for later use in the project.
  + **Text** - Enter data in the Text Builder. Entering an Excel formula updates the formula for each cell in the range.
  + **Number** - Enter a numeric value.
  + **Ask when run** - Prompt for data to enter when the project is executed.
  + **Open in Advanced Editor** - Enter a VB expression.

#### Properties panel

**Common**

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

#### Destination

* See **Where to write** in the body of the activity.

**Input**

* See **What to write** in the body of the activity.

**Misc**

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