MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert formulas to text in a range.

Posted by Joe Staski on October 19, 1999 5:04 PM

I need to convert a range of formulas into text so the original formula shows. It helps to see cell references for logic flow.

Posted by Ivan Moala on October 19, 1999 7:09 PM

Joe, to see just the formula text press these
keys CTRL ~ together, to revert back to the
formula view press the same key combinations.


Posted by Dave Stimpson on October 21, 1999 4:26 PM

I use a UK keyboard - the key strokes are CTRL + ` on mine

Posted by JAF on October 24, 1999 10:01 AM

I've just had a similar problem at work, needing a list of all formulas within a spreadsheet that was created by someone who left the company 2 months ago.

I've written a macro that takes a copy of the original sheet and returns a list of all the cell references which contain formulas as well as the formula itself.

If you'd like a copy, just send me an email.

(I'm in the process of improving the macro so that it looks better, deletes all other data and formatting etc on the copy of the original sheet.)