ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Comments/Footnotes Printing (https://www.excelbanter.com/new-users-excel/148696-comments-footnotes-printing.html)

jaygreg

Comments/Footnotes Printing
 
I've used Excel 2003 to create a matrix of Medicare & Medicare Supplement
Plans containing comments in selected cells. I've lettered and numbered the
columns and lines to aid finding cells quickly when speaking to others. When
I place the document in Print Preview, I see that although my comment will
print at the end of my matrix, they bear matrix coordinates different from
those I assigned; they bear the coordinates of the basic matrix regardless
of how I chose to rename them. A bigger problem is that it appers there is
no way to reference the proper comment from any given cell as one would do
in a Word document. Anyone have a suggestion?



jaygreg

Comments/Footnotes Printing
 
Disregard the above.
Q1) How do I mark a cell so that the reader of a long matrix will know that
there were comments inserted for a given cell?
Q2) Is there some way to arrange the text of these comments so that more
than one prints across the page?

"jaygreg" wrote in message
...
I've used Excel 2003 to create a matrix of Medicare & Medicare Supplement
Plans containing comments in selected cells. I've lettered and numbered
the columns and lines to aid finding cells quickly when speaking to
others. When I place the document in Print Preview, I see that although my
comment will print at the end of my matrix, they bear matrix coordinates
different from those I assigned; they bear the coordinates of the basic
matrix regardless of how I chose to rename them. A bigger problem is that
it appers there is no way to reference the proper comment from any given
cell as one would do in a Word document. Anyone have a suggestion?





All times are GMT +1. The time now is 08:48 AM.

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