M
Marie
I have a worksheet with several formulas. How do I print
a hard copy so I can reference it?
Thanks.
a hard copy so I can reference it?
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
GB
Click Tools ... Options ... View tab then tick Formulas
Don't forget to untick later on after you have printed.
GB
Don't forget to untick later on after you have printed.
GB
L
Laura
Hit CTRL + ` (this is the key right below escape) and the
formulas will show up. Then you can print the page.
formulas will show up. Then you can print the page.
O
OZZIE
IF THERE ARE ONLY A COUPLE OF CELLS YOU COULD ADD A
COMMENT BOX (RIGHT CLICK, ADD COMMENT) AND MOVE THE
COMMENT BOX FOR PRESENTATION PURPOSES (THAT NOW HAS A
FORMULA IN IT) WHEREVER YOU WANT. (IF YOU HIGHLIGHT THE
FORMULA AND HIT CONTROL C BEFORE YOU ADD THE COMMENT BOX,
THEN HIT CONTROL V AFTER YOU ADD THE COMMENT THEN YOU
DON'T NEED TO RE-TYPE THE FORMULA)
YOU CAN ADD AN APOSTROPHE TO THE FORMULA SO THAT THE
FORMULA IS VISIBLE AS TEXT. PROBABLY TOO MANY FORMULAS FOR
THAT TO BE FEASIBLE.
HAVE FUN
-
COMMENT BOX (RIGHT CLICK, ADD COMMENT) AND MOVE THE
COMMENT BOX FOR PRESENTATION PURPOSES (THAT NOW HAS A
FORMULA IN IT) WHEREVER YOU WANT. (IF YOU HIGHLIGHT THE
FORMULA AND HIT CONTROL C BEFORE YOU ADD THE COMMENT BOX,
THEN HIT CONTROL V AFTER YOU ADD THE COMMENT THEN YOU
DON'T NEED TO RE-TYPE THE FORMULA)
YOU CAN ADD AN APOSTROPHE TO THE FORMULA SO THAT THE
FORMULA IS VISIBLE AS TEXT. PROBABLY TOO MANY FORMULAS FOR
THAT TO BE FEASIBLE.
HAVE FUN
-
K
Ken Wright
Another way to do this is to use Chip Pearson's PrintFormula macro, which will print both cell
reference and the formula inside it into Microsoft Word. Gives you a nice easy to use reference.
http://www.cpearson.com/excel/excelM.htm#PrintFormulas
reference and the formula inside it into Microsoft Word. Gives you a nice easy to use reference.
http://www.cpearson.com/excel/excelM.htm#PrintFormulas
D
David McRitchie
Hi Marie,
Printing the formula at the end, or printing the formula view is not as
useful in my mind as being able to look at the completed spreadsheet
and reference sample formulas printed on the same page from the worksheet.
See GetFormula in (look for #install for installation instructions)
http://www.mvps.org/dmcritchie/excel/formula.htm
Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function
The following variation includes the cell address as a descriptor:
Function GetFormulaD(Cell)
GetFormulaD = Cell.Address(0, 0) & ": " & Cell.Formula
End Function
usage:
=GetFormulaD(B14)
=personal.xls!GetFormulaD(b14)
Page also has functions to get the cell format, conditional format, font information,
and has links for printing at end similar to at least one of your other replies.
Printing the formula at the end, or printing the formula view is not as
useful in my mind as being able to look at the completed spreadsheet
and reference sample formulas printed on the same page from the worksheet.
See GetFormula in (look for #install for installation instructions)
http://www.mvps.org/dmcritchie/excel/formula.htm
Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function
The following variation includes the cell address as a descriptor:
Function GetFormulaD(Cell)
GetFormulaD = Cell.Address(0, 0) & ": " & Cell.Formula
End Function
usage:
=GetFormulaD(B14)
=personal.xls!GetFormulaD(b14)
Page also has functions to get the cell format, conditional format, font information,
and has links for printing at end similar to at least one of your other replies.