Converting Comments to Footnote Type References

  • Thread starter Thread starter Planner
  • Start date Start date
P

Planner

I understand that Excel is not a word processor. What I wanted to kno
is if there was a better way to anotate a spreadsheet. This i
important for providing spreadsheet data (budgets in this case) i
printed form to others. Referencing cell notes for these hardcop
users would be much better if there were a supersrcipt reference numbe
in a cell which then would match to comments at the bottom of the page.

I'll try some of those macro suggestions you provided though. Thanks,

Scot
 
You could always add the footnote/backnote number to your comment, then use an
out of the way range to store the real notes.

But that won't help with seeing them on paper.

Maybe you could add a shape from the Drawing toolbar (triangle in the top left
corner). Put a number in that and it should be visible when you print.
 
You are working with an Excel spreadsheet the proper way to have a cell
comment reference would be to refer to the cell.
File, Page Setup, Sheet (tab), Print Comments: At end of Sheet
and also suggest Print: Row and Column Headers

If you don't like that format (row then column) the you could use a
Macro to populate another sheet with comments by column (#printcommentsbycolumn)
http://www.mvps.org/dmcritchie/excel/ccomment.htm#printcommentsbycolumn

Print all cell comments to a file and view the results with your web browser. (#printastext)
http://www.mvps.org/dmcritchie/excel/ccomment.htm#printsastext

List all comments from all sheets, Dick Kusleika,
http://groups.google.com/groups?threadm=uqEBW52WCHA.3808@tkmsftngp08

My page on Cell Comments is: http://www.mvps.org/dmcritchie/excel/ccomment.htm
 
--


David McRitchie said:
You are working with an Excel spreadsheet the proper way to have a cell
comment reference would be to refer to the cell.
File, Page Setup, Sheet (tab), Print Comments: At end of Sheet
and also suggest Print: Row and Column Headers

If you don't like that format (row then column) the you could use a
Macro to populate another sheet with comments by column (#printcommentsbycolumn)
http://www.mvps.org/dmcritchie/excel/ccomment.htm#printcommentsbycolumn

Print all cell comments to a file and view the results with your web browser. (#printastext)
http://www.mvps.org/dmcritchie/excel/ccomment.htm#printsastext

List all comments from all sheets, Dick Kusleika,
http://groups.google.com/groups?threadm=uqEBW52WCHA.3808@tkmsftngp08

My page on Cell Comments is: http://www.mvps.org/dmcritchie/excel/ccomment.htm
Click to expand...
 
Back
Top