How to Add a Footnote in Excel

Excel has no built-in footnote feature like Microsoft Word, so there is no single “Insert Footnote” command. Instead, you create a footnote with a workaround: add a superscript reference number in your data and a matching note at the bottom of the sheet, or use a cell comment, a text box, or the print footer.

Are you struggling to include footnotes in your Excel spreadsheet? Adding footnotes in Excel may seem tricky at first, but with the right guidance, the process is quite simple. Footnotes are important in Excel because they provide additional details or explanations that cannot fit in the main body of your data. They also help to enhance the clarity and accuracy of your spreadsheet, making it easier for readers to understand and interpret. In this blog post, we will show you step-by-step how to add a footnote in Excel.

Why are Footnotes Important in Excel?

Before we dive into the process of adding footnotes in Excel, let’s first understand why they are important. Footnotes help provide additional information that cannot fit in the main body of your data. This information could be clarifications, sources, or even comments that help enhance the accuracy and clarity of your spreadsheet. Footnotes give readers insight into your thinking process and help them understand your data better.

Step-by-Step Guide to Adding a Footnote in Excel

Now, let’s get into the main objectives of this blog post, adding a footnote in Excel. Because Excel does not have a dedicated footnote command, the most common approach is to place a small superscript reference number next to the value you want to annotate and then list the matching note text at the bottom of your worksheet. Here is how to do it.

Step 1: Select the Cell to Add the Footnote Reference

First, select the cell that contains the value you want to footnote. If the value already has text in it, double-click the cell to enter edit mode so you can add a reference marker after the existing text.

Step 2: Add a Superscript Reference Number

Type a number such as 1 immediately after your value, then highlight just that number. Open the Format Cells dialog (Ctrl+1), check the Superscript box under the Font tab, and click OK so the number appears small and raised. For more detail on raised text, see our guide on how to use superscript in Excel.

Step 3: Choose a Spot for the Note Text

Scroll to an empty row a few lines below your data — the bottom of the sheet works well. This area will hold the actual footnote text that the superscript number points to.

Step 4: Type Your Footnote Text

In that cell, type the matching number followed by your explanation, for example “1. Figures are estimates as of Q1.” You can also use basic formatting options such as bold, italics, and underlining for clarity.

Step 5: Format and Align the Note

Keep the note in a smaller font or italics so readers recognize it as supporting detail rather than data. You can merge a few cells across to give the note room to display on one line.

Step 6: Review Your Footnote

Confirm that each superscript number in your data has a matching numbered note at the bottom. If you have several footnotes, number them sequentially so readers can match each marker to its explanation.

Adding footnotes to your Excel spreadsheet can seem like a daunting task, but with these simple steps, you can now confidently add them to your data. Remember, footnotes provide essential information that cannot fit within the main body of your data and helps enhance the accuracy and clarity of your spreadsheet for readers.

Tips for Adding Footnotes in Excel

Here are a few tips to keep in mind when adding footnotes to your Excel spreadsheet:

• Keep footnotes brief and to the point; aim for 1-2 sentences only.
• If you have multiple footnotes in a single worksheet, use sequential numbering (1, 2, 3, etc.) to help readers keep track.
• Ensure that your footnotes are clear and concise and add value to your data.

Adding Footnotes in Excel Tables

If you are using tables within your Excel worksheet, you can attach the note directly to a cell instead of placing it at the bottom of the sheet. In current versions of Excel this feature is called a Note (older versions and the table context menu call it a Comment), and it is a great way to keep explanatory text tied to a specific value. See our walkthrough on how to add a note in Excel for the full process.

Step 1: Select the Table Cell

Select the cell within the table where you want to add the footnote, and then right-click on it.

Step 2: Choose ‘New Note’ (or ‘Insert Comment’)

From the dropdown menu, select ‘New Note’ — in older versions of Excel this option is labeled ‘Insert Comment’. This will insert a small note box anchored to the cell.

Step 3: Add Your Footnotes

Type in the text of your footnote within the note box. You can format the text as you desire.

Step 4: View the Footnote

To view your footnote, simply hover your mouse over the cell, which is marked with a small red triangle in its corner. The text of your footnote will appear in a small box.

Using a Text Box or Print Footer as a Footnote

Two other workarounds are worth knowing. A floating text box lets you place footnote text anywhere on the sheet without disturbing your cell layout — our guide on how to add a text box in Excel covers the steps. If you only need the note to appear on printed or PDF copies, use a page footer instead: go to Page Layout → Header & Footer (or the Insert tab’s Header & Footer button) and type your note in the footer area so it repeats at the bottom of every printed page. Our tutorial on how to insert a footer in Excel walks through the footer options, and you can compare it with adding a header in Excel if you want the note at the top instead.

Important Note

It is worth noting that footnotes in Excel cannot contain hyperlinks or other interactive elements. They are limited to text only. If you require more advanced or interactive annotations, consider using a different data visualization tool or platform.

Footnotes are an essential part of an Excel spreadsheet and help to enhance the accuracy and clarity of your data. With these simple steps and tips, you can easily add footnotes to your Excel worksheet and take your data to the next level.

Frequently Asked Questions

Here are some frequently asked questions about adding footnotes in Excel:

Does Excel have a built-in footnote feature like Word?

No. Unlike Microsoft Word, Excel has no native “Insert Footnote” command. To add a footnote you use a workaround: a superscript reference number with matching note text at the bottom of the sheet, a cell Note or Comment, a text box, or a print footer.

Can I add footnotes to charts, graphs, or pivot tables?

No, footnotes are only possible in cells within an Excel worksheet and not within charts, graphs, or pivot tables.

Can I format the text of my footnote?

Yes, you can use basic formatting options such as bold, italics, and underlining for clarity.

How many footnotes can I add to a single cell?

There is no specific limit to the number of footnotes you can add to a single cell. However, it’s important to make sure your footnotes are brief and to the point, aiming for 1-2 sentences only.

Can I hyperlink my footnote text?

No, footnotes in Excel cannot contain hyperlinks or other interactive elements. They are limited to text only.

How do I delete a footnote in Excel?

To delete a footnote, simply right-click on the cell containing the superscript number and choose ‘Clear Contents’. This will remove both the footnote and the superscript number. If you used a cell Note instead, right-click the cell and choose ‘Delete Note’.

How do I show a footnote only when I print the sheet?

Add the note to a page footer instead of a cell. Go to Page Layout → Header & Footer, type your note in the footer area, and it will appear at the bottom of every printed or PDF page without taking up space in your data.