# Set a Cell's Value

### Overview

This procedure sets the value of a cell in a worksheet to a specified text or formula. It's useful for dynamically updating spreadsheets with new data or calculations.

{% hint style="info" %}
Only **text** values can be used to set the value of a cell for this procedure.
{% endhint %}

### Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

<details>

<summary><code>set the cell to "cell-value"</code></summary>

#### What does it do?

Sets the cell's value to the specified string.

#### Where does it go?

This phrase should be written on a **new line**.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — Replace **cell-value** with the new text value. If the value starts with '=', it will be treated as a formula.

#### Example

```
set the cell to "Updated value"
```

</details>

### Examples

#### 1. Set Cell to Text Value

Updates a cell with a new text value.

```
get the worksheet's cell where
    the cell reference is "A1"
set the cell to "Updated value"
```

#### 2. Set Cell to Formula

Sets a cell to contain a formula.

```
get the worksheet's cell where
    the cell reference is "C1"
set the cell to "=A1+B1"
```