Skip to main content

Replace GEMINI formulas with their results

Convert Gemini 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 sheets

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

Replace formulas manually​

  1. Select the cells that contain the Gemini formulas.

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

    Note: For Gemini 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).

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

Replace formulas in selection​

  1. Select cells with active Gemini formulas in the current sheet, ensuring all cells generated by formulas like Gemini_LIST are included to prevent data loss.

  2. Open the Gemini functions tab in the Gemini for Google sheet sidebar.

  3. Choose In selection in the Replace formulas dropdown.

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

Replace formulas in entire sheet​

  1. Open the Gemini functions tab in the Gemini for Google sheet sidebar.

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

  3. Choose In sheet in the Replace formulas dropdown.

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