

You can also select the small down arrow under the footer icon in the far left section titled "Header & Footer" to open a drop-down menu of automatic footer options. There are also a variety of options available to automate your footer content in the toolbar.įor example, you can click on the buttons under the "Header & Footer Elements" section to add elements like page number, number of pages, current date, current time, file path, file name, sheet name or images to whichever section of the footer on which you've clicked.

To switch to editing the footer, locate the "Navigation" section and click "Go to Footer." This allows you to type into the left, middle or right side of the footer. Once you're in the "Header & Footer" toolbar tab, the default is to edit the header.

#SANDVOX ADD FOOTER HOW TO#
Related: How To Write and Use Footnotes 2. The "Header & Footer" tab also opens automatically in the toolbar at the top of the screen. This changes the Excel readout to show you what your page would look like printed, including the header and footer space. Next, click the small downward arrow under the "Text" option, located next to "Symbols" on the far right side of the toolbar. To open the "Header & Footer" tab, first click on the "Insert" tab of your toolbar. To insert a footer this way, you may follow these steps: 1. One way to add a footer in Excel is by using the "Header & Footer" function under the "Insert" tab. If you'd like to insert a footer in your Excel spreadsheet, you can do so by following these directions: 1. This may make footers in Excel best suited to documents you intend to print out and share. In Excel, the footer is only visible in the "Page Layout" mode, "Print Preview" mode and after printing the page. You can also choose which pages you'd like to add a footer. Excel offers a variety of footer options, including the ability to add page numbers or the name of the author. Related: How To Create a Header Row in Excel Using 3 Methods What is a footer in Excel?Ī footer in Excel is a section of a document located underneath the main body of the document at the bottom of the page. In this article, we explain what a footer is and describe two methods for how to insert a footer in Excel. If you plan to print out your Excel document, it may be helpful to include information like your name or the page number in a footer. You can also print out Excel spreadsheets to share them more easily with colleagues. Microsoft Excel is a spreadsheet tool that helps users store, organize and display their data.
