Format when viewing formulas

B

bruno

I'm trying to get two prints of the same document: one showing absolute
numbers and the other showing the formulas.

When I'm pressing ctrl+~ to show functions for my 2nd print, the format is
changing. The cells are getting too wide, so I end up getting only the left
half of the document in print preview. How do I change the document to show
functions with the format staying the same so I can print it??? Thanks.
 
G

Gord Dibben

Bruno

Go to John Walkenbach's site and copy his ListFormulas code to a general
module in your workbook.

The macro creates a new worksheet with the formulas, addresses and results in
3 columns for printing. Very nice layout.

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

Gord Dibben Excel MVP
 
Top