ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I display and print formulas in a worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/101925-how-do-i-display-print-formulas-worksheet.html)

rklemenhag

How do I display and print formulas in a worksheet?
 
I want to print a worksheet that shows the formulas in each cell versus the
result of the formulas. How do I do this?

Bob Phillips

How do I display and print formulas in a worksheet?
 
ToolsOptionsView, click the Formulas checkbox, or just Ctrl-` (the tick
mark, above the Tab key on my keyboard).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"rklemenhag" wrote in message
...
I want to print a worksheet that shows the formulas in each cell versus

the
result of the formulas. How do I do this?





All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com