How to set up a personalized Excel header footer

You can set the personalized Excel header footer. So how do I set up a personalized Excel header footer? The way to personalize an Excel header footer is simple. This article is about setting up personalized Excel header and footer methods for reference.

1. Start Excel, open the workbook file you want to work on, and click Page Setup on the File menu to bring up the Page Setup dialog box.

2. Click the "Header/Footer" tab and click "Custom Header" to open the "Header" Settings dialog box.

3. Click in the "Left (L)" edit box below and click "Insert Picture" to open the Insert Picture dialog box (to center the header picture, in (C)).

4. In the Insert Picture dialog box, locate the picture file you want to insert into the header, and then click Insert. The &[picture text appears in the left edit area, and the Format Picture button in the tool button area becomes available.

5. Click "Format Picture" to open the "Format Picture" dialog box. Size, position, scale, trim, and adjust the picture as needed.

6. Click "OK" to return to the Page Setup dialog box when you have finished setting it up two times. Select the Margins tab to set the margin parameters.

7. Click "OK" to return to the Excel worksheet edit area.

The contents of headers and footers in Excel are not displayed in the edit, and users who want to see the actual display of headers and footers must click Print Preview on the toolbar and view them in the Print preview window.

If you find in the preview window that the picture you inserted in the header is too large to extend beyond the header margin to overwrite the data in some of the data cells in the worksheet, you can adjust the following actions:

1. Enlarge the header margin. Click "Margins" on the Print Preview window toolbar, in the preview area, show the handles that you can drag to adjust the margins, header and footer margins, and column widths, and then drag the margin handles that appear on the screen to increase the header margin range so that you can hold the entire logo picture.

2. Change the image size. Under Print Preview status, click Settings, open the Page Setup dialog box, select the Header/Footer tab, and click Custom Header to open the Header Setup dialog box. Click "Format Picture" to open the "Format Picture" dialog box, adjust the size of the picture as needed.

The method for setting the footer is the same as this method.