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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/set-a-cells-value.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.