# Number

Plan allows you to enter and format numeric data in multiple ways. You can create a new empty series or copy values from another series.

In this article, you learn how to create and manage numeric data input columns.

### Create a data input number column

To create a data input number column:

1. Go to **Planning** > **Insert Column** and select **Number.**
2. Choose one of the following options:
   * **Insert a new empty series**
   * **Copy from another series**

<figure><img src="/files/aCW584Nle5mPSqLDspn2" alt="" width="563"><figcaption></figcaption></figure>

### Create a blank number column

The **Insert a new empty series** option inserts a blank numeric column that you can configure and populate through manual input. After selecting this option, a side panel opens as shown below.

<figure><img src="/files/38ttK7V5q6osc49OWnRP" alt="" width="375"><figcaption></figcaption></figure>

Enter a title and configure the required properties to create the column. For more information, see [configure data input column properties](/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns.md#configure-data-input-column-properties).

After configuring the properties, select **Create**. The column is then inserted into the report.

<figure><img src="/files/4T0Zu8d0yxqEytjEdmrp" alt=""><figcaption></figcaption></figure>

### Enter values

You can enter values in the following ways:

* Double-click a cell and enter values using the formula bar.

<figure><img src="/files/7S2wh9YrWiQgowoNXFcY" alt="" width="563"><figcaption></figcaption></figure>

* Enter values directly in the cell by selecting the cell and hit enter after entering value.

<figure><img src="/files/XvVY4ZZr3jiZc4Z43gqe" alt="" width="563"><figcaption></figcaption></figure>

Entered values are automatically aggregated to parent levels and distributed to child levels when applicable.

<figure><img src="/files/jid94g82DXZKf52AlOQg" alt="" width="563"><figcaption></figcaption></figure>

### Create a number column from an existing series

This option creates a numeric column by copying values from an existing series.

* You can select from available measures, forecasts, or even hidden measures.
* The copied values act as initial values only.
* Changes to the source series are not reflected in the new column.

To create a numeric input column using values from an existing series:

1. Go to **Planning** > **Insert Columns** > **Number**
2. Select the **Copy from another series** option.
3. Choose the measure or column whose data you want to use.

<figure><img src="/files/Fg2PyaDWhpBX6x3Tf1Mz" alt=""><figcaption></figcaption></figure>

4. After selecting the source series, a side panel opens for configuration. Update the title if required and select **Create**.

The column is created with pre-populated values.

<figure><img src="/files/NolCdnQ67P0Ltn8mwKhm" alt=""><figcaption></figcaption></figure>

### Modify column properties

To modify an existing data input column:

1. Go to **Planning** > **Insert Column** > **Manage Measures.**
2. Select the required option:
   * Edit (pencil icon) to modify the column
   * Delete to remove the column
   * Show/Hide to control column visibility

<figure><img src="/files/nk12V0YdTAmzRz3y1Ugt" alt=""><figcaption></figcaption></figure>

Alternatively, you can use the column gripper:

1. Hover over the column or measure header to display the column gripper.
2. Select the column gripper and choose the required action, such as **Edit Measure**, **Delete Measure**, or **Hide Column.**

<figure><img src="/files/UzU42g5uuyg3dAOHeA7C" alt="" width="563"><figcaption></figcaption></figure>

3. If you select **Edit** option, a side panel opens where you can update the required properties. After making the changes, select **Update**.

### Create a data input column from an existing column

You can create a new data input column by copying values from an existing column.

To copy as data input:

1. Hover over the required column and select the column gripper.
2. Choose **Insert** > **Copy as data input.**

<figure><img src="/files/0SMTNpsGYuBlGHxngjDU" alt="" width="563"><figcaption></figcaption></figure>

3. A side panel opens where you can update the title and configure properties if required. Select **Create**.

The new column is created with copied values. Changes to the source column are not reflected in the new column.


---

# 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.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/measures-and-columns/insert-manual-input-columns/insert-manual-input-columns.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.