Most Excel spreadsheets contain formulas. When you need only the fixed values or want to replace all relative cell references with absolute or vice versa, use the Convert Formulas tool.
First, select a range with the formulas you'd like to update. Then click the Convert Formulas icon in the Utilities group on the Ablebits Tools tab in Excel and choose from the three possible ways to convert the records:
HOWconvert cell references to absolute WITH A FUNCTION
Feel free to search for a solution on our blog:
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!