Printing Row number and Formula in Excel Worksheet

[Terence]

Hi all,

I have 2 problems:

(1) Is it possible to print out the row number of a
worksheet?

(2) On the worksheet, there are some cells which contain a
formula. Is it possible to print out the formula on the
cell instead of print out the calculated value?

Can anyone help?
Thanks a lot.

Terence

 

[Niek Otten]

Hi Terence,

File>Page Setup>Sheet, check "Print Row and Column headers"

To show (and print) formulas, press CTRL and ` simultaneously

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Terence]

Thanks a lot!

-----Original Message-----
Hi Terence,

File>Page Setup>Sheet, check "Print Row and Column headers"

To show (and print) formulas, press CTRL and ` simultaneously

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel




.