ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is there a why to show the cell formulas to print? (https://www.excelbanter.com/excel-worksheet-functions/131966-there-why-show-cell-formulas-print.html)

Sheryl Stewart

Is there a why to show the cell formulas to print?
 
I have been trying to print off the sheet that I am using to check the
formulas myself. I know there is a way to do this but can't seem to remember
how.

Thanks

Sheryl

JE McGimpsey

Is there a why to show the cell formulas to print?
 
Type CTRL-` (accent grave, on the key above the Tab key on standard US
keyboards) to display formulas.

In article ,
Sheryl Stewart <Sheryl wrote:

I have been trying to print off the sheet that I am using to check the
formulas myself. I know there is a way to do this but can't seem to remember
how.

Thanks

Sheryl


Gord Dibben

Is there a why to show the cell formulas to print?
 
John's suggestion is one method but doesn't isolate just the formulas.

I like John Walkenbach's ListFormulas macro.

Places the formulas, results and addresses on a new sheet for printing.

http://www.j-walk.com/ss/excel/tips/tip37.htm

Makes for a nice printout.


Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 13:55:41 -0800, Sheryl Stewart <Sheryl
wrote:

I have been trying to print off the sheet that I am using to check the
formulas myself. I know there is a way to do this but can't seem to remember
how.

Thanks

Sheryl




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

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