Make Excel Header Images and Columns Fit the Page Width
Question details
The user wants an Excel header image and worksheet columns to fit the printed page width consistently.

- 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.
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.
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.
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.
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.
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.
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.
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.

Make an image placed over worksheet cells move and size with them
Use this option for an image on the worksheet grid, rather than an image inserted in a page header.
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.

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.




