Im putting together a business plan and I need to annotate an Excel
spreadsheet with endnotes. Is there anyway to make a note reference (e.g.
€œNote 23€�) print in excel without typing it into a cell? In other words is
there any kind of automated system to be able to insert and renumber notes so
that they can be printed out in a separate document, preferable, Word
document, and refer back to a particular line in the spreadsheet? What Im
looking for is a Word type endnote function.

A second unrelated question, is how do you copy a formula and past it
without changing the cell references. This works when you cut and past, but
Ive found no way to make it work when you copy and past. Thanks.