Skip to main content

Replace GPT formulas with their results

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.

Prerequisites
You have opened a Google spreadsheet containing GPT formulas and selected Extensions > GPT for Sheets and Docs > Open.

Replace formulas manually​

  1. Select the cells that contain the GPT formulas.

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

    Note: 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 on active to select all cells in the current sheet that contain active GPT formulas. To adjust the selection, hold down the CTRL/CMD key while clicking on cells to deselect them.

    Warning

    Always select the full range of results for functions like GPT_LIST to prevent data loss.

  2. Choose In selection in the Replace formulas dropdown.

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

Replace formulas in current sheet​

  1. Refresh the formula status bar 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

  2. Choose In sheet in the Replace formulas dropdown.

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.

On this page