Comments at End of Large Table

[Stefani]

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

 

[Gord Dibben]

If these are true Cell Comments then you can print them at the end under
File>Page Setup>Sheet>Comments "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

 

[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]

Delete or change the Username from Tools>Options>General or use a macro to
create Plain Comments.

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


Gord