Footnotes and Numbering?

  • Thread starter Thread starter skestenbaum
  • Start date Start date
S

skestenbaum

I am working on a series of spreadsheets that require detailed footnote
on each page (up to 100 footnotes). I've dedicated one column t
numbering for footnotes and have then added these numbers and footnote
manually to the bottom of the page being printed. On occasion I remov
a footnote and have to renumber all the following footnotes.

Is there a shortcut that would allow me to automatically number th
footnotes so that if a note is deleted all other footnotes jump up t
the proper order? I do not want footnotes apearing for line items tha
do not necessatate footnotes.

Set
 
If I understand you correctly, here's one way:

If your footnotes start in row 50,

A50: 1
A51: =A50+1

copy down as far as needed.
 
Back
Top