How to set up a personalized Excel header footer

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.