E
Eric Clapton
How do you print out the formula in the xls? 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.
J
JON JON
Try ctrl+`
N
Norman Harker
Hi Eric!
You could use Ctrl+` [the symbol on key to left of 1 key]
or
Tools > Options > View
Check formulas.
You might prefer a better approach that allows you to see the result
plus the formula by using the following User Defined Function:
Function GETFORMULA(cell As Range) As String
GETFORMULA = cell.Formula
End Function
Or you could use the following link:
John Walkenbach:
http://j-walk.com/ss/excel/tips/tip37.htm
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
You could use Ctrl+` [the symbol on key to left of 1 key]
or
Tools > Options > View
Check formulas.
You might prefer a better approach that allows you to see the result
plus the formula by using the following User Defined Function:
Function GETFORMULA(cell As Range) As String
GETFORMULA = cell.Formula
End Function
Or you could use the following link:
John Walkenbach:
http://j-walk.com/ss/excel/tips/tip37.htm
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
D
David McRitchie
Hi Eric,
The ctrl+` (accent grave) toggles between normal and formula view.
The width of the columns for the formula view is exactly 2 times
the normal width of the column. If you change the width in the
formula view then you will be also changing the width of the column
in the normal view. You might want to copy the worksheet to another
sheet if you want to adjust columns and then print.
What I like to do is to display the formulas of one column or just
display some representative formulas, very seldom would I need
to display or print all of the formulas -- in fact I would say I never do I
want to see all of the formulas. For information on displaying the formula
used in another cell see GetFormula and GetFormulaD in
http://www.mvps.org/dmcritchie/excel/formula.htm
i.e. =GetFormula(B3)
=personal.xls!GefFormulaD(B3)
The advantage is that you get the see the actual working formula right
on the same page at the same time as you look at the actual spreadsheet.
Some other means of printing all of the formula on a worksheet can
be found in John Walkenbach's (it's referenced on my formula.htm page)
Creating a List of Formulas (Tip 37)
http://j-walk.com/ss/excel/tips/tip37.htm
which I believe will print the cell address, value, formula
This is slightly modified/corrected from my posting March 2, 2004 nothing
you would not have seen had you used Google Groups search to find answers.
and looked in the entire thread. Most of the people answering questions do
use Google searches to find answers for themselves and to answer newsgroups.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100
The ctrl+` (accent grave) toggles between normal and formula view.
The width of the columns for the formula view is exactly 2 times
the normal width of the column. If you change the width in the
formula view then you will be also changing the width of the column
in the normal view. You might want to copy the worksheet to another
sheet if you want to adjust columns and then print.
What I like to do is to display the formulas of one column or just
display some representative formulas, very seldom would I need
to display or print all of the formulas -- in fact I would say I never do I
want to see all of the formulas. For information on displaying the formula
used in another cell see GetFormula and GetFormulaD in
http://www.mvps.org/dmcritchie/excel/formula.htm
i.e. =GetFormula(B3)
=personal.xls!GefFormulaD(B3)
The advantage is that you get the see the actual working formula right
on the same page at the same time as you look at the actual spreadsheet.
Some other means of printing all of the formula on a worksheet can
be found in John Walkenbach's (it's referenced on my formula.htm page)
Creating a List of Formulas (Tip 37)
http://j-walk.com/ss/excel/tips/tip37.htm
which I believe will print the cell address, value, formula
This is slightly modified/corrected from my posting March 2, 2004 nothing
you would not have seen had you used Google Groups search to find answers.
and looked in the entire thread. Most of the people answering questions do
use Google searches to find answers for themselves and to answer newsgroups.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100