List all formulas used on a spreadsheet

[chaliseyp]

Hello everyone,

Is it possible to list all the formulas - including custom formulas - on a given spreadsheet ?

[jolivanes]

Toggle on and off?

Please Login or Register  to view this content.

or go to the Formulas tab and click on Show Formulas.

[chaliseyp]

Thanks jolivanes.

But, this is not what I was after

I want to list the formulas in the spreadsheet rather then display / view the formulas.

So, the list should have the list of cells where there is formulas and the formulas used on those cells.

[jolivanes]

Change references as required. Maybe put the result into an empty sheet instead.

Please Login or Register  to view this content.