Resizing the Height of a Footer in Excel
Microsoft Excel includes Page Layout options to help you resize the height for the footer. You can adjust the Custom Margins option to raise or lower the worksheet’s bottom margin, which increases the amount of free space at the bottom to make more room for a taller footer. Resizing the footer can help you fit more content, such as an image, in the footer box, and prevent overlapping the content on your worksheet.
1 Click the Insert tab
Click the "Insert" tab on the command ribbon, and then click "Header & Footer" in the Text group. Click anywhere in the worksheet, and then scroll down to bring the footer section into view.
2 Click the Click to add footer section
Click the "Click to add footer" section to bring up the left, middle and right footer boxes, select a footer box, and then enter your footer text. The Header & Footer Tools ribbon and the Design tab display on the ribbon.
3 Click anywhere on the worksheet
Click anywhere on the worksheet, click the "Page Layout" tab on the ribbon, and then click "Margins" in the Page Setup group to open the menu.
4 Select Custom Margins
Select "Custom Margins" to open the Margins tab sheet in the Page Setup window. The Footer and Bottom list boxes with arrow buttons display near the page sample.
5 Click an arrow button or type
Click an arrow button or type a new value in the Footer or Bottom boxes to adjust. For example, type "4" in the Bottom list box, and then click "OK" to raise the lower margin and allow more space above the footer. To make the footer box shorter and placed higher up the page layout, type a larger value in the Footer list box, and then click "OK." To make the footer box taller -- and placed lower down the page layout -- enter a smaller value in the Footer list box, and then click "OK."
Press "Ctrl-S" to save your updated worksheet.
- Information in this article applies to Microsoft Excel 2013 for Home & Business. It may vary slightly or significantly with other versions or products.
- Experiment with different values in the Footer and Bottom list boxes. If the footer text is hidden from view, go back to the Page Layout tab, click "Margins" in the Page Setup group, click "Custom Margins," type a smaller value in the Footer list box or a larger value in the Bottom list box, and then click "OK."
- The Design tab on the Header & Footer Tools ribbon includes the Header & Footer Elements group, such as Current Time, Page Number and File Path, to help you keep organized.
- Print your worksheet to see if the layout is correct. Press "Ctrl-P" to bring up the Print preview and view how the footer displays on your worksheet.