Printing Problems

Make Excel Header Images and Columns Fit the Page Width

Ayan MasoodAyan Masood Nov 18, 2026 868 views

Question details

The user wants an Excel header image and worksheet columns to fit the printed page width consistently.

Make Excel Header Images and Columns Fit the Page Width
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing a worksheet with a header image and columns scaled to fit one page wide.
Observed behavior
The header image may not scale with the worksheet columns when Scale to Fit settings are applied.
Before you start

Check whether the image is in a page header or placed over worksheet cells; the formatting controls differ. Confirm the paper size and orientation under Page Layout before adjusting the image.

Solution 1Recommended

Resize the page header image and fit columns to one page

Use this method when the image is inserted in an Excel page header and needs to fit above the scaled worksheet.

A page header image is separate from worksheet cells, so changing the worksheet's Scale to Fit settings may not resize it proportionally. Adjust the image and worksheet scaling separately.

1
Open the header

Go to Insert > Header & Footer, then click the header section containing the image. The section displays &[Picture] rather than the image itself while you edit it.

2
Insert an image if needed

If the header does not yet contain an image, click the desired header section and select Picture on the Header & Footer tab. Choose the image file to insert it.

3
Resize the header image

With the header section selected, choose Format Picture on the Header & Footer tab. On the Size tab, adjust the width and height or scale, then click OK.

4
Fit the worksheet columns

Go to Page Layout > Scale to Fit and set Width to 1 page. Set Height to Automatic if the worksheet may extend across multiple pages vertically.

5
Check the printed layout

Open File > Print and review the preview. If needed, return to Format Picture to adjust the image or use Page Layout > Margins to provide more header space.

Resize the page header image and fit columns to one page
Check each adjustment: Repeat the image-size adjustment and print preview until the header and columns fit as intended. Fitting columns to one page does not automatically guarantee a matching header image width.
Free Microsoft Office alternative

Preview and Print Spreadsheets with WPS Office

WPS Office is a free, lightweight alternative for opening and printing spreadsheets. Its familiar interface and Excel format compatibility make it easy to move existing workbooks and review page layouts.

Preview spreadsheet pages before printingOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceMove existing workbooks to a lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my Excel header image shrink with the columns?

A page header image is separate from worksheet cells, so worksheet scaling may not resize it proportionally. Click the header and use Header & Footer > Format Picture to adjust its size.

How do I print all columns on one page without limiting the number of rows?

On Page Layout, set Scale to Fit > Width to 1 page and Height to Automatic. Check the result under File > Print.

Where is the Move and size with cells option?

For an image placed on the worksheet, right-click it and select Format Picture. Under Size & Properties > Properties, choose Move and size with cells.

How can I tell whether an image is in the page header?

Go to Insert > Header & Footer and click the relevant header section. If it contains an image, the section shows the placeholder &[Picture] while you edit it.