ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Printing a formula (https://www.excelbanter.com/excel-worksheet-functions/8779-printing-formula.html)

TNMAN

Printing a formula
 
I have a complex formula entered into a single cell. Is there a way to
print the single cell showing the entire formula. Thanks in advance for the
help.



hweiss

Go to your toolbar. Click on 'Tools', 'Formula Auditing', 'Formula
Auditing Mode'. That should show your formulas. Repeat the process to
go back to your regular spreadsheet


Ken Wright

Tools / Options / View / Formulas - Print and then reset

or

Precede formula with an apostrophe - Print and then remove apostrophe

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"TNMAN" wrote in message
...
I have a complex formula entered into a single cell. Is there a way to
print the single cell showing the entire formula. Thanks in advance for

the
help.






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

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