---
title: "Update worksheet data"
slug: "update-worksheet-data-1"
description: "Update input, related, and calculated columns, copy and paste worksheet rows."
updated: 2024-05-03T06:18:11Z
published: 2024-05-03T06:18:11Z
canonical: "docs.zilliant.com/update-worksheet-data-1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Update worksheet data

## Update input columns

Input column changes are instantly copied to the corresponding primary data source in the Zilliant cloud. These changes immediately ripple into your other Zilliant products and third-party systems that are integrated with your Zilliant data sources.

          Tip

          

If you can't edit an input column, it might be configured as non-editable. For more information, read [Define input columns](/v1/docs/define-input-columns).

Update input columns by:

- [Directly overwriting values](/v1/docs/update-worksheet-data#directly-overwrite-a-single-cell-value)
- [Making simple additive or subtractive changes](/v1/docs/update-worksheet-data#make-simple-additivesubtractive-changes-to-existing-column-values)
- [Applying a formulaic bulk update](/v1/docs/update-worksheet-data#apply-a-formulaic-bulk-update-to-existing-column-values)

### Directly overwrite a cell value

1. Double-click any cell in the input column.
2. Enter a new value.
3. Select the **Return/Enter** key or click anywhere else in the worksheet to commit the change.

### Make simple additive or subtractive changes to existing column values

1. Select one or more cells, then select **Edit**.
2. Enter the number or percentage amount to increase or decrease the existing cell value.
          Tip

          

To decrease the existing cell value, enter a **-** (minus sign) in front of the amount.
3. Select **Save**.

### Apply a formulaic bulk update to existing column values

1. Next to an input column heading, select **⌄**, then select **Update** to open the **Update column value** dialog.
2. In the **Update definition** field, enter a formula expression.
          Tip

          

You can use formula syntax described in [About formula expressions](/v1/docs/formula-expressions).
3. Decide which rows to update:
  - To update all rows in the worksheet, clear the **Use current filters** option and leave the **Filters** section empty.
  - To update only currently visible rows (if you prefiltered the worksheet), select the **Use current filters** checkbox.
  - To ignore current filters (if you preapplied any) and update rows according to a different set of filters, add at least one filter in the **Filters** section and clear the **Use current filters** checkbox.
4. Select **Update**.

## Update related columns

Related columns are read-only. You cannot update their values directly.

To update a related column, find a worksheet that uses the same column as an input column. Updates to the input column are duplicated in the related column.

## Update calculated columns

Calculated columns are read-only. You cannot update their values directly.

To update a calculated column, update the input and related columns that are used in the calculation.

## Copy and paste worksheet rows

          Tip

          

You can copy and paste only one row at a time.

1. Right-click a row, then select **Copy Record**.
          Note

          

If you don't see this option, select Properties. On the **Worksheet General Properties** page, select the **Copy Rows** checkbox.
2. In the **Insert Row** dialog, update cell values.
3. Click **Save** to paste the copied row into the worksheet.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/edit_60(1).png?sv=2026-02-06&spr=https&st=2026-11-03T15%3A25%3A42Z&se=2026-11-03T16%3A25%3A42Z&sr=c&sp=r&sig=Vm7OrOSdDbnLL2WrqRRO8Oz1%2BTJjFFQguxcNfQixbLs%3D)

Edit

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/settings_60.png?sv=2026-02-06&spr=https&st=2026-11-03T15%3A25%3A42Z&se=2026-11-03T16%3A25%3A42Z&sr=c&sp=r&sig=Vm7OrOSdDbnLL2WrqRRO8Oz1%2BTJjFFQguxcNfQixbLs%3D)

Properties