> For the complete documentation index, see [llms.txt](https://interopxyz.gitbook.io/excel-plus/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://interopxyz.gitbook.io/excel-plus/components/range/populate-range.md).

# Populate Range

Creates a Range from a starting Cell and data tree of values

## Description

Creates a Range from a starting Cell and data tree of values

{% tabs %}
{% tab title="Preview" %}
![](https://2501927618-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fe08Uu2w6ybaOmfvcxkKf%2Fuploads%2FGHPq0OnVQM0MsQFaFKb0%2FRange_Populate.png?alt=media\&token=26cf8189-bc5c-48b7-847a-4a6dede9b8f6)
{% endtab %}

{% tab title="Location" %}
**Name** | Populate Range

**Nickname** | Pop Rng

**Tab** | ExcelPlus

**Panel** | Range

**Division** | 1
{% endtab %}

{% tab title="Inputs" %}
**Cel** | **Origin Cell** (*cell*) | A Cell or Address (ex. A1)

**V** | **Values** (string) | A data tree of values

**C** | **By Column** (*bool*) | If true, branches will be written to Columns, if false to Rows
{% endtab %}

{% tab title="Outputs" %}
**Rng** | **Range** (*range*) | An Excel Range Object
{% endtab %}

{% tab title="Mode" %}
*none*
{% endtab %}
{% endtabs %}

## Usage