Formatting Issues

How to Keep an Excel Heading Fixed Above a Resized Table

John Wilson Sep 27, 2026 869 views

Question details

The user needs to keep a company name and address heading fixed at the top of an Excel sheet, preventing it from moving into the table when the table is resized.

How to Keep an Excel Heading Fixed Above a Resized Table

Product: Excel
Device & OS: not provided
Scenario: Pasting a company heading from Word into an Excel sheet that contains a formatted table.
Observed behavior: The pasted heading moves into the table area and loses its intended position when the table size changes.

Before you start

Ensure there is at least one completely empty row between your pasted heading and the top of your formatted Excel table to prevent the table from automatically expanding to include the text.

Solution 1Recommended

Place the Heading Outside the Table and Freeze Panes

Separating the heading from the table data and freezing the top rows ensures the heading remains visible and unaffected by table resizing.

When Excel detects data immediately adjacent to a formatted table, it may automatically absorb that data into the table range. By inserting a gap and freezing the view, your heading remains static.

Insert blank rows

Right-click the row numbers above your table and select 'Insert' to create enough empty rows for your heading, plus one extra blank row as a buffer.

Paste the heading

Copy your company name and address from Word, select the top-left cell of your new blank rows (e.g., A1), right-click, and choose 'Keep Source Formatting' or 'Match Destination Formatting' to paste.

Apply Freeze Panes

Select the entire row immediately below your blank buffer row. Go to the 'View' tab on the ribbon, click 'Freeze Panes', and select 'Freeze Panes' from the dropdown to lock the heading in place.

Place the Heading Outside the Table and Freeze Panes

Pro Tip: Using a buffer row prevents Excel's Auto-Expand feature from absorbing your static header text into the dynamic table range.

Solution 2

Use Print Titles to Keep Headings Fixed on Output

If you only need the heading to stay at the top of your document when printing or exporting to PDF, using Print Titles is the cleanest solution.

Smart Layout Formatting

Fix Headers and Manage Tables Easily with WPS Spreadsheet

WPS Spreadsheet offers an intuitive interface to handle dynamic tables, freeze panes, and paste external text seamlessly. You can lock headers in place with just a few clicks, without worrying about accidental table expansions.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx file containing the table.
2. Paste and isolate the header: Paste your Word header into row 1. Ensure row 2 is completely empty to separate it from your table.
3. Freeze the header row: Select row 3 (or the first row of your table). Navigate to the 'View' tab and click 'Freeze Panes' to lock your heading securely at the top.

One-click Freeze Panes feature to lock headers instantlyFully compatible with Microsoft Excel (.xlsx and .xls) formatsSmart paste options to keep or discard Word formatting automaticallyFree to use with a lightweight, user-friendly interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel table automatically expand to include pasted text?

Excel has a feature called 'Include new rows and columns in table' which automatically absorbs adjacent data to save time. Leaving a completely blank row between your text and the table prevents this from happening.

How do I turn off automatic table expansion in Excel?

Go to File > Options > Proofing > AutoCorrect Options. Click on the 'AutoFormat As You Type' tab, and uncheck 'Include new rows and columns in table'.

Can I put my company header directly inside the Excel table header?

Table headers in Excel are designed for column labels (like 'Date', 'Amount', 'Name') and must remain in a single row. It is best practice to keep overarching document titles or company addresses entirely outside of the defined table object.

Document & File Issues