> For the complete documentation index, see [llms.txt](https://docs.kognitos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-a-cells-value.md).

# Set a Cell's Value

Sets the value of a cell in a worksheet to a specified text or formula.

### 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"
```