Excel doesn't have a built-in footnote feature like Word does, but you can add explanatory notes to cells using comments, which serve the same purpose

When you need to explain data in an Excel spreadsheet — to clarify a calculation, note a data source, or flag an assumption — you have two practical options. The most common is a cell comment, which attaches a note to a specific cell that readers can view by hovering over it. The second is to add a text box or note directly on the sheet itself. Neither is a true footnote in the Word sense, but both let you document your work without cluttering the cells themselves.

The method you choose depends on whether you want the note hidden until someone clicks or hovers (comments), or visible at all times (text boxes). For most spreadsheets shared with others, comments are cleaner because they don't take up space on the printed page.

Key Takeaways

  • Right-click any cell, select "Insert Comment" (or "New Comment" in newer Excel versions), and type your note to attach an invisible comment that shows when someone hovers over the cell.
  • Comments appear as a small red triangle in the cell corner and can be edited, deleted, or resolved without removing the original note.
  • Text boxes, inserted from the Insert menu, sit visibly on the sheet and are useful when you want a note that's always readable without hovering.
  • When you print a spreadsheet with comments, Excel can print them at the end of the sheet or hide them entirely, depending on your print settings.
  • In shared workbooks or when using Excel Online, comments function as threaded discussions where multiple people can reply to the same note.

Adding a Comment to a Cell

The fastest way to add a note to a cell is through a comment. Right-click the cell where you want the note, then select Insert Comment (in Excel 2016 and earlier) or New Comment (in Excel 2019 and Microsoft 365). A box will appear next to the cell with your name already filled in. Type your explanation, then click outside the box or press Escape to close it.

Once you've added a comment, a small red triangle appears in the top-right corner of the cell. When anyone opens the spreadsheet and hovers their mouse over that cell, the comment pops up automatically. The comment stays attached to the cell even if you move or copy the data elsewhere in the sheet.

To edit a comment later, right-click the cell and select Edit Comment. To remove it entirely, right-click and choose Delete Comment. If you want to see all comments in the sheet at once without hovering, go to the Review tab and click Show All Comments.

Using Text Boxes for Visible Notes

If you want a note that's always visible on the sheet — for example, a disclaimer or a source citation — use a text box instead. Go to the Insert tab, click Text Box, then click and drag on the sheet to create a box. Type your note inside, then click outside to finish. The text box sits on top of the sheet and prints by default, so it's useful for notes you want readers to see immediately.

Text boxes can be moved, resized, and formatted like any other object. You can change the font, add a border, or adjust the background color. Right-click the box to access formatting options. Unlike comments, text boxes are part of the sheet's visual design, so use them sparingly to avoid making the spreadsheet look cluttered.

Managing Comments in Shared Workbooks

When you share an Excel file with others — either through OneDrive, SharePoint, or by emailing the file — comments become collaborative. In Excel Online and modern versions of Excel 365, comments support threaded replies. Someone can add a comment, another person can reply to it, and the conversation stays attached to that cell. This is useful for team feedback or tracking changes to data.

To reply to a comment, click the cell with the comment, then click the comment box and select Reply. Your response appears as a separate message in the same thread. You can also Resolve a comment once the issue is addressed, which collapses it but keeps it in the history. This is different from deleting it — resolved comments can be reopened if needed.

Printing Spreadsheets with Comments

By default, Excel hides comments when you print a spreadsheet. If you want to print them, go to File > Print, then look for Print Options or Page Setup (depending on your Excel version). Under the Sheet tab, find the option for comments and select either As displayed on sheet (prints comments where they appear) or At end of sheet (prints all comments on a separate page with cell references).

Most of the time, you'll leave comments hidden during printing because they're meant for internal reference. But if you're creating a formal document with annotations, printing them at the end of the sheet keeps the explanations with the data without cluttering the main view.

Keyboard Shortcuts for Faster Work

If you add comments frequently, keyboard shortcuts save time. In most Excel versions, press Shift + F2 to insert or edit a comment in the active cell. Press Ctrl + Alt + C to open the comment pane on the right side of the screen, which shows all comments in the sheet at once. These shortcuts work in desktop Excel but not always in Excel Online.

The comment pane is especially useful when you're reviewing a spreadsheet with many notes. You can scroll through all comments without clicking individual cells, and you can navigate between them using the arrow buttons in the pane. This is faster than hovering over cells one by one.

Frequently Asked Questions

Can I add a footnote at the bottom of an Excel sheet like in Word?

Excel doesn't have a native footnote feature that automatically numbers and places notes at the bottom of a page. Your best option is to use comments for hidden notes or text boxes for visible ones. If you need formal footnotes, copy your data into Word instead.

Will my comment disappear if I move or delete the cell?

No. Comments stay attached to the cell itself, not to its position. If you cut and paste a cell with a comment, the comment moves with it. If you delete the cell, the comment is deleted too. If you just clear the contents, the comment remains.

How do I see all comments in my spreadsheet without hovering?

Go to the Review tab and click Show All Comments. All comments will appear on the sheet at once. Click Show All Comments again to hide them. You can also open the comment pane using Ctrl + Alt + C to see a list of all comments in a sidebar.

Can I format text inside a comment?

In desktop Excel, you can use basic formatting like bold and italics inside comments. In Excel Online, formatting options are more limited. Text boxes support full formatting including fonts, colors, and borders, so use those if you need styled text.

What happens to comments when I save as PDF?

Comments are not included in PDF exports by default. If you want to preserve notes, print to PDF with comments visible, or convert to Word first. Text boxes will appear in the PDF since they're part of the sheet's visual content.