ExcelBanter - formula to get the spreadsheet address to print on the spreadsheet

Hi Jeri,
Please don't make people look at the subject to find the question.
For one thing it looks like the question will not load and really
wastes people's time.

If you asked a proper question it might not be as ambiguous
as being limited to fitting on one line.

As far as a worksheet formula goes, the formula to show it's own address is
=CELL("address") returns an absolute address like $E$1

Getting the row and column headings to print on the worksheet
does not involve a formula.
File, Page Setupl, sheet, Print: [x] Row and Column Headings.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jen" wrote..
(nothing, nothing, nothing, not a single word)