You are currently viewing How to add a footnote in Excel

How to add a footnote in Excel

Most people have encountered situations where they need to use an Excel spreadsheet. It is used to store, organize and manipulate data. You might have used it to track your revenues and expenditures in business, feed-in project details, and even budgeting. It is pretty simple to use it, more so if you are familiar with other Microsoft Office programs. Some features are different, for example, footnote. MS Word footnote is auto which is not the case for Excel. however, this doesn't mean that you cannot insert a footnote in a spreadsheet.

Footnotes appear at the bottom of the page in a document. Footnotes can include any information, including dates, page numbers, file names, and any other symbols that match up with a reference mark in your document. Footnoting in Excel is pretty much simple as all the options are available. Below are the steps you have to follow.

Steps to follow when adding footnotes to an Excel Spreadsheet

1. Start Microsoft Excel, and open the workbook- you can do this by double-clicking the file name on your computer.

2. Click on the worksheet on which you want to add a footnote in case you have different ones in your workbook. To get here, click the worksheet's tab at the bottom of Excel to view it.

3. Click the "Page Layout" tab. It is the 3rd tab at the top left of Excel on your Windows PC.

4. Open the page setup dialog box. If you are using Windows, it is a small square with an arrow at the bottom of the panel. In the case of a Mac, a page setup icon will appear in the icon bar at the top of the screen.

5. Click the "Header/Footer" tab.

6. Select a footer design from the Footer menu. From the drop-down arrow, pick the option you need as they are pre-set. In case you need to customize your own, follow the next step.

7. To customize your footnote, click "Custom Footer." The option shows three blank boxes representing the left, center, and right areas of the document. Enter the text you want as a footer in any of the boxes. From the ten options given, you can format text, insert a page number, number of pages, date, time, file path, file name, sheet name, picture, and format pictures. The options are represented by symbols; for example, format text is A. Click OK when finished to return to the page setup window.

8. Click "Print Review" Because your footnotes will not show up on the Excel spreadsheet. It is done to display how your footer will appear when you print the worksheet.

9. Click the back button to return to page setup. From here, you can edit the footnote if it did not appear as you wanted.

10. Click OK. Your footnote will be completed and added. It will appear at the bottom of each worksheet.

Conclusion

The above article shows you a way to footnote your Excel spreadsheet. It is one of the options as you may choose to use the Insert tab procedure, which is also easy. Remember, any changes made on numbers or deleting them will require you to manually renumber them in the footer section as footers are not autocorrelated as in Word.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.