B
BernieN
Can I print the formulas that underlie the data on an Excel worksheet?
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.
M
Michael M
Hi Bernie
Press CTRL +~ to show all formulae and then print the pages.
Does that help ??
Regards
Michael M
Press CTRL +~ to show all formulae and then print the pages.
Does that help ??
Regards
Michael M
D
Dave Peterson
You can use:
Tools|Options|View|check Formulas
And print what you want.
Do this to a copy of your worksheet (or don't save after).
You'll want to widen columns and increase rowheight to see all the formula--and
it's sometimes a pain to reset those widths/heights.
Ps. Turn on the headers, too.
File|Page setup|sheet tab|check row and column headers
It'll make life a bit easier.
Tools|Options|View|check Formulas
And print what you want.
Do this to a copy of your worksheet (or don't save after).
You'll want to widen columns and increase rowheight to see all the formula--and
it's sometimes a pain to reset those widths/heights.
Ps. Turn on the headers, too.
File|Page setup|sheet tab|check row and column headers
It'll make life a bit easier.
G
Gord Dibben
John Walkenbach has a VBA routine to produce the formulas and their values.
Creates a new worksheet which is easy to print and you don't have to muck about
with column widths.
http://www.j-walk.com/ss/excel/tips/tip37.htm
Gord Dibben MS Excel MVP
Creates a new worksheet which is easy to print and you don't have to muck about
with column widths.
http://www.j-walk.com/ss/excel/tips/tip37.htm
Gord Dibben MS Excel MVP