A better way to print the formulas from an Excel spreadsheet

Hi,

I thought I saw a spreadsheet printout with the formulas listed BELOW the sheet. Or maybe it was just the formulas by themselves with a reference to the cell location they're at.

Either way, what's not working is the Show Formulas method that places the formulas into the cells themselves. I'm looking for a better way than :

• placing the formulas into the cells
• having to word-wrap and/or reformat the column widths to accommodate the formula displays, cause then I have to fix it when I go back to viewing results, which isnt a better way
• copy/paste my formulas into a document/notepad and printing from there

I've seen these suggestions ad nauseum on the net. They work fine for examples where the formulas are short and simple like =A2*1.2. They do not work for many of the formulas Excel is known for, such as : =XLOOKUP(SUBSTITUTE(A2," ","")&D2,SUBSTITUTE('[Products - 06-07-22.xlsx]Food'!$B$2:$B$14000&'[Products - 06-07-22.xlsx]Food'!$C$2:$C$14000," ","")&'[Products - 06-07-22.xlsx]Food'!$F$2:$F$14000,'[Products - 06-07-22.xlsx]Food'!$C$2:$C$14000,,2). Who wants to adjust column widths and word-wrap that, and then have to fix it when going back to viewing results - I dont.

But I'm not finding that thing I thought I saw before. It was like a series of this on a printout :

B2 : =XLOOKUP(SUBSTITUTE(A2," ","")&D2,SUBSTITUTE('[Patients - 06-07-22.xlsx]Patients'!$B$2:$B$14000&'[Patients - 06-07-22.xlsx]Patients'!$C$2:$C$14000," ","")&'[Patients - 06-07-22.xlsx]Patients'!$F$2:$F$14000,'[Patients - 06-07-22.xlsx]Patients'!$C$2:$C$14000)

Is there a better way?

Thank you.

Yeah. I like it! That's the bones of a process I can work with. I didnt know about FORMULATEXT function. I'd only need to use it on a row of cells most of the time, like the first row of data. And I now see how I can do that.
Thank you so much!