# Replace GPT formulas with results in Excel

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 Microsoft workbook.

## 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 with active GPT formulas in the current sheet, ensuring all cells generated by formulas like [GPT_LIST](https://autosheet.com/docs/gpt-for-excel/gpt-functions/reference#gpt_list--gpt_hlist-function) are included to prevent data loss.

2. In the sidebar, select **GPT functions**.

   ![GPT functions in the sidebar](https://autosheet.com/docs/article-images/gpt-for-excel/gpt-functions-in-sidebar.png)

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

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

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

## Replace formulas in entire sheet

1. In the sidebar, select **GPT functions**.

   ![GPT functions in the sidebar](https://autosheet.com/docs/article-images/gpt-for-excel/gpt-functions-in-sidebar.png)

2. 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-excel/formula-status-bar.png)

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

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

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