Thread: Formula display for worksheet or workbook

Is there a way to display all the formulas of a workbook or worksheet without going through each individual cell. Thank you.

Meg

Are you using 2007? If so, you can go to the 'Formulas' tab and click 'Show formulas' and it will do what you're describing, I believe.

Not sure about earlier versions, though I think you can do this (I just can't point you to it personally, sorry). You might check in the error checking/auditing area...

in excel 2003, hold down the CTRL button and press the grave key ` (normally next to the number one button), this will show all formulas, press the same again to get back to normal

thanks reg

Originally Posted by reggie1000

in excel 2003, hold down the CTRL button and press the grave key ` (normally next to the number one button), this will show all formulas, press the same again to get back to normal

thanks reg

Cool - that works in 2007, too, by the way (just tried it).

Thanks, you guys rock!