Hello All
Say you were given a long (private) worksheet with a lot of formulas that use references as columns and rows like this:
F25:
=A25+C25/E24
And each of these cells/references are calling other references (imagine 200 columns and 2000 rows like that).
It quickly becomes very difficult to read/understand the formulas.
Maybe the creator forgot to build the formulas within a table so that each column have its own name/description and make them easier to read.
So you select all the data and insert a table. But the formulas are still showing the column letter instead of the table column name.
The question is: how can we automatically replace the letter for the table column name in all the formulas?
(I hope is clear enough)
Bookmarks