I am working with several large tables with have comments at the bottom of
the table explaining some of the acronyms used. Does anyone know how to have
these comments print at the end of the table only? I have rows at the top
repeating and the columns on the left repeating, which cuts off the comment
text if it runs past the first three columns.

Does anyone know how or if Excel does this?

Thank you,
Stefani

If these are true Cell Comments then you can print them at the end under
FilePage SetupSheetComments "at end of sheet"

If they are just notations in cells then there is no way to have them "repeat at
bottom"


Gord Dibben MS Excel MVP

On Fri, 28 Dec 2007 12:58:02 -0800, Stefani
wrote:

I am working with several large tables with have comments at the bottom of
the table explaining some of the acronyms used. Does anyone know how to have
these comments print at the end of the table only? I have rows at the top
repeating and the columns on the left repeating, which cuts off the comment
text if it runs past the first three columns.

Does anyone know how or if Excel does this?

Thank you,
Stefani

So if I change the notations to actual comments, is there a way to print
these comments without the editor's name attached?

Thank you.

"Gord Dibben" wrote:

If these are true Cell Comments then you can print them at the end under
FilePage SetupSheetComments "at end of sheet"

If they are just notations in cells then there is no way to have them "repeat at
bottom"


Gord Dibben MS Excel MVP

On Fri, 28 Dec 2007 12:58:02 -0800, Stefani
wrote:

I am working with several large tables with have comments at the bottom of
the table explaining some of the acronyms used. Does anyone know how to have
these comments print at the end of the table only? I have rows at the top
repeating and the columns on the left repeating, which cuts off the comment
text if it runs past the first three columns.

Does anyone know how or if Excel does this?

Thank you,
Stefani

Delete or change the Username from ToolsOptionsGeneral or use a macro to
create Plain Comments.

A generic username could be "Note"(no quotes)


Gord

On Fri, 28 Dec 2007 14:17:00 -0800, Stefani
wrote:

So if I change the notations to actual comments, is there a way to print
these comments without the editor's name attached?

Thank you.

"Gord Dibben" wrote:

If these are true Cell Comments then you can print them at the end under
FilePage SetupSheetComments "at end of sheet"

If they are just notations in cells then there is no way to have them "repeat at
bottom"


Gord Dibben MS Excel MVP

On Fri, 28 Dec 2007 12:58:02 -0800, Stefani
wrote:

I am working with several large tables with have comments at the bottom of
the table explaining some of the acronyms used. Does anyone know how to have
these comments print at the end of the table only? I have rows at the top
repeating and the columns on the left repeating, which cuts off the comment
text if it runs past the first three columns.

Does anyone know how or if Excel does this?

Thank you,
Stefani