# Replace GPT formulas with results in Sheets

Convert GPT formulas to static values and prevent any further recalculation, either on a selected number of cells or across an entire sheet. If you need to recover the original formulas later, you can use the version history of your Google spreadsheet.

## Replace formulas manually

1. Select the cells that contain the GPT formulas.

2. Copy them by pressing **Ctrl+C** (or **Cmd+C** on Mac).

   > **Info**
   >
   > For GPT formulas with multi-row results, copy all rows with results, not just the formula row.

3. Paste the results as values by pressing **Ctrl+Shift+V** (or **Cmd+Shift+V** on Mac).

GPT formulas within the manually selected cells are replaced by their respective results.

## Replace formulas in selection

1. Select cells manually or click **active** to select all cells with active GPT formulas. Ensure all cells generated by formulas like [GPT_LIST](https://autosheet.com/docs/gpt-for-sheets/gpt-functions/reference#gpt_list--gpt_hlist-function) are selected to prevent data loss. Hold CTRL/CMD to adjust the selection.

   ![](https://autosheet.com/docs/article-images/gpt-for-sheets/select-active.png)

2. Choose **In selection** in the *Replace formulas* dropdown.

   ![](https://autosheet.com/docs/article-images/gpt-for-sheets/replace-in-selection-sidebar.png)

GPT formulas within the selected cells are replaced by their respective results.

## Replace formulas in current sheet

1. Refresh the formula count to see the number of active GPT formulas in the current sheet. Formulas on error won't be replaced.

   ![Click the refresh icon in the status bar](https://autosheet.com/docs/article-images/gpt-for-sheets/formula-status-bar.png)

2. Choose **In sheet** in the *Replace formulas* dropdown.

   ![](https://autosheet.com/docs/article-images/gpt-for-sheets/replace-in-sheet-sidebar.png)

All GPT formulas within the current sheet are replaced by their corresponding results.

## Limitations

Working with selections larger than 10,000 cells may negatively impact performance. For best results, keep the number of GPT formulas on one sheet under 10,000.