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

--
Planne
-----------------------------------------------------------------------
Planner's Profile: http://www.excelforum.com/member.php...fo&userid=1296
View this thread: http://www.excelforum.com/showthread.php?threadid=26521

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.



Planner wrote:
>
> I understand that Excel is not a word processor. What I wanted to know
> is if there was a better way to anotate a spreadsheet. This is
> important for providing spreadsheet data (budgets in this case) in
> printed form to others. Referencing cell notes for these hardcopy
> users would be much better if there were a supersrcipt reference number
> 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,
>
> Scott
>
> --
> Planner
> ------------------------------------------------------------------------
> Planner's Profile: http://www.excelforum.com/member.php...o&userid=12964
> View this thread: http://www.excelforum.com/showthread...hreadid=265215

--

Dave Peterson
(E-Mail Removed)

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...mmentsbycolumn

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

List all comments from all sheets, Dick Kusleika,
http://groups.google.com/groups?thre...%40tkmsftngp08

My page on Cell Comments is: http://www.mvps.org/dmcritchie/excel/ccomment.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Planner" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>
> I understand that Excel is not a word processor. What I wanted to know
> is if there was a better way to anotate a spreadsheet. This is
> important for providing spreadsheet data (budgets in this case) in
> printed form to others. Referencing cell notes for these hardcopy
> users would be much better if there were a supersrcipt reference number
> 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,
>
> Scott
>
>
> --
> Planner
> ------------------------------------------------------------------------
> Planner's Profile: http://www.excelforum.com/member.php...o&userid=12964
> View this thread: http://www.excelforum.com/showthread...hreadid=265215
>

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David McRitchie" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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...mmentsbycolumn
>
> Print all cell comments to a file and view the results with your web browser. (#printastext)
> http://www.mvps.org/dmcritchie/excel...m#printsastext
>
> List all comments from all sheets, Dick Kusleika,
> http://groups.google.com/groups?thre...%40tkmsftngp08
>
> My page on Cell Comments is: http://www.mvps.org/dmcritchie/excel/ccomment.htm
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Planner" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> >
> > I understand that Excel is not a word processor. What I wanted to know
> > is if there was a better way to anotate a spreadsheet. This is
> > important for providing spreadsheet data (budgets in this case) in
> > printed form to others. Referencing cell notes for these hardcopy
> > users would be much better if there were a supersrcipt reference number
> > 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,
> >
> > Scott
> >
> >
> > --
> > Planner
> > ------------------------------------------------------------------------
> > Planner's Profile: http://www.excelforum.com/member.php...o&userid=12964
> > View this thread: http://www.excelforum.com/showthread...hreadid=265215
> >
>
>