Printing Problems

How to Add a Graphic and Page Number to an Excel Header

Maira MehtabMaira Mehtab Nov 11, 2026 868 views

Question details

The user wants to format a worksheet for printing by adding both a background image and a page number to the header or footer.

How to Add a Graphic and Page Number to an Excel Header
Product
Excel
Device & OS
not provided
Scenario
Preparing an Excel document for printing that requires corporate branding (like a logo or watermark) alongside standard pagination.
Observed behavior
Needs to display a graphic and a page number together in the header or footer area, similar to the layout capabilities found in Word documents.
Before you start

Ensure you have the graphic or logo you intend to use saved on your local drive, and switch your Excel view to Page Layout so you can clearly see the header and footer areas while editing.

Solution 1Recommended

Insert a Picture and Page Number using Header & Footer Tools

Use Excel's built-in Header & Footer tools to insert your image and overlay the page number field in the desired section.

Excel allows you to insert dynamic codes for pictures and page numbers within the same header or footer section. By combining these codes and formatting the picture, you can achieve a professional document layout.

1
Switch to Page Layout View

Go to the 'View' tab on the top ribbon and click 'Page Layout'. This view makes the header and footer sections visible at the top and bottom of your pages.

2
Access the Header or Footer

Click inside the 'Add header' or 'Add footer' section on your worksheet. The area is divided into left, center, and right boxes. Select the box where you want your graphic and page number to appear, which opens the 'Header & Footer' tab on the ribbon.

3
Insert the Graphic

In the Header & Footer tab, click 'Picture'. Browse your computer to find the desired image and click 'Insert'. The code '&[Picture]' will appear in the header box.

4
Add the Page Number

Place your cursor right after the '&[Picture]' code in the box. Press 'Enter' to place the page number below the image, or add a space to place it next to the image. Then, click 'Page Number' in the ribbon to insert the '&[Page]' code.

5
Format the Picture

To ensure the image fits well and doesn't obscure your text, click 'Format Picture' in the ribbon. Here you can adjust the height, width, and scale. Under the 'Picture' tab in this dialog, you can also change the color to 'Washout' to create a watermark effect.

Insert a Picture and Page Number using Header & Footer Tools
Previewing the Result: Click any cell outside the header or footer box to exit editing mode. The codes will disappear, and you will see the actual graphic and page number displayed together.
WPS Spreadsheet Solution

Easily Customize Headers and Footers in WPS Spreadsheet

WPS Spreadsheet provides an intuitive and user-friendly interface for adding logos, background graphics, and page numbers to your printed documents, making document formatting a breeze.

  1. 1. Open Page Setup: Open your file in WPS Spreadsheet, navigate to the 'Page Layout' tab, and click the small arrow icon in the bottom right corner of the Page Setup group.
  2. 2. Navigate to Header/Footer: In the Page Setup dialog box, switch to the 'Header/Footer' tab and click either 'Custom Header' or 'Custom Footer' depending on your preference.
  3. 3. Insert Image and Page Number: Select the Left, Center, or Right section. Use the 'Insert Picture' icon to add your graphic, then use the 'Insert Page Number' icon in the same section to add the page number. Click OK to apply.
Seamlessly insert pictures and page numbers into headers or footers.Fully compatible with Microsoft Excel (.xlsx and .xls) formats.Free, lightweight, and fast alternative for professional spreadsheet formatting.Intuitive Page Layout view for real-time print previewing.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my header picture too large for the Excel page?

Images are inserted at their original resolution and size. To resize the image, click inside the header box containing the picture code, go to the Header & Footer tab, click 'Format Picture', and adjust the Height and Width under the Size tab.

Can I make the header picture look like a faded watermark?

Yes. After inserting the picture, click 'Format Picture' in the Header & Footer tab. Go to the 'Picture' tab, click the 'Color' dropdown, and select 'Washout'. This lowers the contrast and increases brightness, creating a perfect watermark effect behind your page numbers.

Why can't I see the header and footer in Normal view?

Headers and footers are only visible in 'Page Layout' view or in the Print Preview window. To edit them directly, you must switch to Page Layout view under the View tab.

How do I align the page number to the right of the picture?

The header is divided into three sections (Left, Center, Right). You can insert the picture in the Center section and the page number in the Right section. Alternatively, if they must be in the same section, you can use spaces on your keyboard to separate the '&[Picture]' and '&[Page]' tags.