Excel Title Move Down Page: Keep Headings Visible

Updated 5 November 2026 · Standard formula, shown below

To move an Excel title or heading farther down a printed page, adjust the top margin or insert space above the title; to make a heading repeat at the top of every printed page, use Print Titles instead. These are different fixes: one changes where content sits, while the other repeats selected worksheet rows.

Choose the Right Way to Move a Title

First decide what “move down” means in your sheet. If the title is too close to the top edge on paper, change the page’s top margin. If the title is in the wrong row in the worksheet, move its cell contents or insert rows. If you want a column heading to appear on each printed page, configure repeating rows rather than copying the heading manually.

Printed page position: Change page margins or vertical alignment.
Worksheet position: Move the cell or insert a row above it.
Repeated heading: Set print-title rows so Excel prints them again on each page.

These adjustments affect different things. A margin change does not move the title to another worksheet row, and a worksheet row change may affect formulas, references, and the layout of the whole sheet.

Move a Printed Title Down with the Top Margin

For a title that should sit lower on the printed page, increase the top margin. In current desktop versions of Excel, open the worksheet, select Page Layout, choose Margins, and select Custom Margins. Increase the value for Top, then check the preview before printing.

Open the worksheet you plan to print.
Select Page Layout > Margins > Custom Margins.
Enter a larger value in the Top box. For example, changing 0.5 inches to 1 inch adds half an inch of top margin.
Choose OK, then open File > Print to inspect the preview.

The margin applies to the printed page, not just the title. It moves the printable content lower and reduces the vertical space available for the worksheet. If the sheet already fills a page, increasing the margin can push rows onto another page or cause Excel to scale the content smaller when fit-to-page options are in use.

Excel’s displayed measurement units depend on regional settings and configuration. Check the unit shown in the margin dialog rather than assuming a value is inches or centimeters. You can also choose a built-in margin preset, but custom margins give you more precise control.

Use Vertical Centering for a Short Page

If a small amount of content should sit lower or centrally on a page, use vertical alignment for the printed page rather than adding many blank rows. Open Page Layout, select the dialog launcher in the Page Setup group, and go to the Margins tab. Under Center on page, select Vertically.

This centers the printed content vertically within the area between the top and bottom margins. It is useful for a short cover sheet or a compact report, but it is not a precise “move down by a set amount” control. If you need the title at a specific location, adjust the top margin or the worksheet layout instead. Turn off vertical centering if later pages or longer content no longer align as intended.

Move the Title in the Worksheet

If the title itself is in the wrong worksheet row, select its cell and move its contents to the intended cell. You can cut and paste the title, or insert a row above it using the row heading’s context menu and choose Insert. Inserting a row shifts cells below it, which may alter the layout and can affect formulas or references, so inspect the sheet afterward.

A title that spans several columns may be a merged cell. Select the merged area as a whole when moving it; do not try to move only one cell within the merge. If the title is merely centered across columns using formatting, moving the original cell may be enough, but check the alignment after the move.

Adding blank rows above a title can create space in the worksheet, but it is usually less convenient for print positioning. Blank rows are part of the sheet’s content and can affect page breaks, formulas, sorting, and navigation. For a print-only adjustment, use page setup rather than inserting rows just to create a margin.

Repeat Headings on Every Printed Page

Sometimes “move the title down the page” means that a heading should remain visible at the top of each printed page. For a table’s column labels, use print-title rows. Select Page Layout > Print Titles, then enter the row or rows in Rows to repeat at top on the Sheet tab. For example, to repeat row 1, enter $1:$1. Use Print Preview to verify the result.

This setting repeats the specified rows on printed pages; it does not move the original title or make it appear lower. A report title may belong only on the first page, while column headings are often useful on every page. Choose the rows accordingly. If the print-title controls are unavailable, check whether you are editing a cell, whether multiple sheets are grouped, or whether the workbook is open in a version with a different interface.

Check Page Breaks and Print Scaling

A title may appear lower or disappear from a page because Excel is dividing the worksheet differently than expected. In View > Page Break Preview, inspect the page boundaries and adjust them if needed. You can also set a print area under Page Layout > Print Area so unrelated cells are not included.

In the Print screen, review scaling options such as fitting the sheet to a page. Scaling can shrink the entire printout to fit its width or height; it does not simply add space above the title. If a larger top margin makes text unexpectedly small, check whether a fit-to-page setting is active. Compare the preview with the worksheet and, when available, print a test page before producing a large report.

Common Problems and Quick Fixes

The title did not move: Confirm that you changed the worksheet’s top margin, not a different page setting or a margin in another worksheet.
The title is lower but the table is split: The larger margin reduced printable space. Reduce the margin, adjust scaling, or revise page breaks.
The heading repeats but is still at the top: That is how print-title rows work. Use margins or vertical positioning if you need more space above it.
Only some pages changed: Page setup can differ between worksheets. Select and configure each sheet that needs the same layout.
The preview differs from the sheet: Printing uses page layout, print areas, margins, and scaling. Check all four before changing cell positions.

Frequently Asked Questions

How do I move an Excel title lower when printing?
Increase the top margin under Page Layout > Margins > Custom Margins, then check File > Print preview.

How do I move a title down one row in Excel?
Move its cell contents to the next row, or insert a row above the title. Review formulas and layout because inserted rows shift other cells.

How do I put a title in the middle of a printed page?
Open the Page Setup dialog, select the Margins tab, and enable Vertically under Center on page.

How do I repeat a heading at the top of every printed page?
Choose Page Layout > Print Titles and set the relevant row or rows in Rows to repeat at top.

Why does changing the margin make my Excel text smaller?
A larger margin leaves less room for the worksheet. If fit-to-page scaling is enabled, Excel may shrink the content to fit the remaining printable area.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.