Convert formulas to direct cell references to improve readability

  • Reduce formula complexity by converting to direct cell references
  • Save time, e.g. by using INDEX-MATCH is used temporarily

  1. Select a cell with a formula to convert to a direct cell reference
  2. Click ‘Convert formula’
Try free