- Reduce formula complexity by converting to direct cell references
- Save time, e.g. by using INDEX-MATCH is used temporarily
- Select a cell with a formula to convert to a direct cell reference
- Click ‘Convert formula’
This website uses cookies in order to improve the user experience. When you continue to use this site, you accept the use of cookies. Read more about our cookie policy here.
Ok, close this message