The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Click OK, the header or footer height will be changed.
In the popping Page Setup dialog, enter larger or smaller numbers into Top or Bottom textbox to change the height of header or footer. Click Page Layout > Margins > Custom Margins. Moreover, you can change the height of header or footer in the Page Setup dialog.ġ. If you want to change the height of footer, dragging bottom margin to resize.
Then dragging the top margin up or down as you need to change the height of the header. To change the height of header or footer, you can drag the height bigger or smaller as you need in Page Layout view.Ĭlick View > Page Layout to entering Page Layout view. How to change height of header or footer to bigger or smaller in Excel?Īs we known, we can change the row height and column width of the selected cells, but have you ever tried to change the height of header or footer to bigger or smaller in Excel? Here, this article, I will tell you the methods on solving this job.Ĭhanging height of header or footer by draggingĬhanging height of header or footer by Margin