print sheet name in header/footer

[dmccallum]

I have added the filename by putting ^ in the header and I have added the date by putting @ in the header but I can't find the way to add the sheet name.

 

[Guest_imported]

We no longer have Lotus 123 at work (even though 123 is VASTLY SUPERIOR to Excel), but I recall having referenced the filename in headers. I believe you use the "\\" characters, followed by a range name. In the cell named with the range name, use the @CELL(filename) command which I believe will also include the sheetname. If you want to isolate the sheetname, use the String functions (@MID or @RIGHT) --- or perhaps there is a separate function for the sheetname - such as @CELL(sheetname). ...hope this helps ...Dale Watson

 

[german12]

Unfortunately I have only a german version of Lotus 123 - however using this formular makes
it possible to write the letter (A,B.....etc) on every page:

@REFKONVERT(@BLATT(A1..A1)) (german expression -BLATT means SHEET in english, I do not know,
what REFKONVERT means in english, but it could be the same expression for you - please check)

@REFKONVERT(@BLATT(A1..A1)) on page A gives you an "A" in that cell where the formular is in on SHEET A
@REFKONVERT(@BLATT(A1..A1)) on page B gives you a "B" in that cell where the formular is in on SHEET B

etc.

perhaps this can help you.

regards from germany

klaus

 

[rick6]

To print the file name in lotus 5.

1) Put the formula @cell("filename",a:a1) in any blank cell. The cell address (a:a1) in the example can be any cell in the spreadsheet.

Lets say you put this formula in cell a:d24. You will see something like C:\123r5w\work\report.wk4 in cell a:d24.

2) Go to Print, Page Setup. In any header or footer position type \a:d24 and the file name should appear in your printout.