Print listing of cell references and cell contents 2

[homeric]

What I want looks like a typed list by cell address, one line per address, something like this:

A1: SUM(C4.C9)*5
A2: D9*D10
A3: A6/8

In 123 V3.4 it used to be possible to print such a listing of cell contents quite easily

Do you know of a way of doing this in Excel please?

I use Excel 2000 on an XP based PC

 

[hext2003]

Open your Spreadsheet

Press

Control and ~ at the same time

This will shows the formulas.

I remember 123 doing that... that was a help... But this isn't bad either!

 

[PeterMoran]

Hi,

This maybe what you want:

http://www.cpearson.com/Excel/excelM.htm#PrintFormulas

' For XL2000 Requires that in VBA Tools References,
' "Microsoft Word 8.0 Object Library" is enabled.
' Provided by Chip Pearson at "

http://www.cpearson.com".

'
' Note: Do NOT use Ctrl+A to select Sheet - Select Cells Required.
'

Godd Luck,

Peter Moran

 

[BlueHorizon]

Hi,
Then, if it's necessary that you see the cell addresses, go to File/Page Setup/Sheet tab and select Row and Column Headings under Print.

HTH,


Best,
Blue Horizon