How to Footnote in Excel
Microsoft Excel does not contain a specific function that allows a user to leave footnotes on the spreadsheet. It is possible, nonetheless, to create comments that are hyperlinked to a cell and then print these comments at the bottom of the sheet. Each comment will be referenced to the specific cell it was made in, and therefore will fulfill the same purpose as a footnote. It is not possible, however, to view these comments while working in the program, except when the cursor is floated over the cells individually.
Things You'll Need
- Microsoft Excel
Select the "Page Layout" tab.
Click on the dialog box launcher on the "Page Setup" group. The dialog box launcher is the little arrow in the bottom right corner of the box. The "Page Setup" window will pop up.
Click on the "Sheets" tab.
Locate the "Comments" drop down menu. Select "At end of sheet." This will make sure all of your footnotes appear at the bottom of the document.
Click "Print." All comments that are hyperlinked to a cell will be included below the spreadsheet.
Tips & Warnings
- Select "Print Preview" from the print menu to see how the comments will appear.