Convert Formulas to Values
The Convert tool allows you to quickly convert formulas to values. This is especially effective for converting Seotools Dump() formulas because they sometimes recalculate when performing a "regular" paste as values. The red Dump() formula comments are also removed (see example GIF above).
- Selection - Converts all formulas within the selected range. The range must be entirely outside pivot tables and tables or inside a table.
- Active Sheet - Converts all formulas in the active sheet. No tables or pivot tables can exist on the sheet.
Get help with this function in the community →