ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   footnotes/endnotes or similar (https://www.excelbanter.com/excel-discussion-misc-queries/193178-footnotes-endnotes-similar.html)

Barbara

footnotes/endnotes or similar
 
I have an 8 page table in excel and would like to show the notes at the end
of each page. I tried footer but have too many characters. Any suggestions
would be helpful.

Kevin B

footnotes/endnotes or similar
 
If your notes are inserted as cell comments you can specify where you want
the comments to print form the PAGE SETUP dialog box.

Click FILE in the menu and select PAGE SETUP and click the SHEET tab.

In the PRINT panel on the SHEET tab drop down the combo box to the right of
COMMENTS and select AT END OF SHEET.

--
Kevin Backmann


"Barbara" wrote:

I have an 8 page table in excel and would like to show the notes at the end
of each page. I tried footer but have too many characters. Any suggestions
would be helpful.


Barbara

footnotes/endnotes or similar
 
Kevin B, thanks for your input. Unless I did something wrong, I can only get
the comment to print at the very end of the table not at the end of each page
like I need.

"Kevin B" wrote:

If your notes are inserted as cell comments you can specify where you want
the comments to print form the PAGE SETUP dialog box.

Click FILE in the menu and select PAGE SETUP and click the SHEET tab.

In the PRINT panel on the SHEET tab drop down the combo box to the right of
COMMENTS and select AT END OF SHEET.

--
Kevin Backmann


"Barbara" wrote:

I have an 8 page table in excel and would like to show the notes at the end
of each page. I tried footer but have too many characters. Any suggestions
would be helpful.



All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com