Change multiple formulas in Google Sheets

Before you start

The Formulas tool also processes cells in filtered & hidden rows & columns.

How to convert formulas and auto apply functions to all selected columns

1. Go to Extensions > Power Tools > Start in the Google Sheets menu:
   
2. Click on the Formulas icon on the add-on sidebar:
   
3. Select the range of cells you want to work within and pick one of the following options:
   
   • Convert relative to absolute
     Select this radio button to change the type of formulas in the selected range. The drop-down list lets you choose between three kinds of absolute references to convert formulas to:
     • Absolute cell reference — $A$1
     • Absolute column reference — $A1
     • Absolute row reference — A$1
   • Convert absolute to relative
     Choose this option to convert absolute references in the formulas to relative.
   • Convert formulas to values
     Get the calculation results or values instead of the formulas used in the selected range.
   • AutoSum
     This one will automatically add formulas under each selected column with numbers.

     Choose cells under all columns where you want to insert totaling formulas and pick the necessary function from the list.

     Tip. If you select a blank column to the right of your table with numbers, the tool will calculate all values in each row.
     Tip. The add-on offers the most common functions to choose from: Sum, Count, Counta, Average, Averagea, Min, Max, Product, Mode, Stdev, Var, Median.
   • Modify all selected formulas
     Pick this option to transform your calculations but keep all formulas where they are.

     Simply enter additional calculations before or after the formula in the edit field, where %formula% stands for your current formulas in the selected range:
     

Click Run to change all formulas in the selected range at once according to the option you select.

Related pages

• Change data format in Google Sheets
• Count and sum by color in Google Sheets
• Find and replace data in values, formulas, errors, links, and notes
• Filter by multiple criteria and extract results