need help very urgently , please read and help

[LMF]

I have used a lots of cell references such as dynamic range. Is it possible to print all these onto paper????

how do i do that, without copy and pasting each one?????

pls let me know!

[smozgur]

I am not sure that i understood but:

Tools_Options_View

and mark

Formulas

?

[Jay Petrulis]

Sub test()
With Sheets("Sheet1")
.Range("A1").ListNames
End With
End Sub

[LMF]

Thanks Jay, you are the best!

it works great

can I do the same for all formulas?

so that i can have every formula on one page to be print off???

if would be the best if it is will their original position, i meant:

in cell A2, it has a formula =Sum()

can it show A2 =sum()?????

pls help!

[Jay Petrulis]

On 2002-04-23 15:02, LMF wrote:
->snip<-
can I do the same for all formulas?

so that i can have every formula on one page to be print off???
->snip<-

Try,

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

Bye,
Jay

[LMF]

this is very urgent

pls help me, anyone please????

[rcavedo]

On any worksheet
Press Ctrl~
It will show all formulas.
Go to page setup. then to sheet.
Under print check
"Gridlines" and "Row and col headings". Click on "OK". then print.
Go back and remove the gridlines and row and column headings.
Press Ctrl~ again.
Your worksheet will return to the normal view.

Bob