Printing formulas in a spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan Furjanic - 09 Oct 2003 15:53 GMT

How can I print the formulas in a worksheet??

Thanks,

Reply to this Message

Paul B - 09 Oct 2003 16:35 GMT

Susan, here is one way, Ctrl+`

> How can I print the formulas in a worksheet??
>
> Thanks,

Reply to this Message

David McRitchie - 09 Oct 2003 19:46 GMT

If you mean how to show the formula used in another cell see
the GetFormula macro in
http://www.mvps.org/dmcritchie/excel/formula.htm
other solutions are in the related area at the bottom of the page such
as on John Walkenbach's pages.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Susan, here is one way, Ctrl+`

> > How can I print the formulas in a worksheet??

Reply to this Message

tel - 10 Oct 2003 10:27 GMT

Select Tools, Options and click the formulas box

> If you mean how to show the formula used in another cell see
> the GetFormula macro in
[quoted text clipped - 10 lines]
>
> > > How can I print the formulas in a worksheet??

Reply to this Message