How to Improve the Picture Appearance in the Header or Footer in Microsoft Excel

Use one of the following methods to improve the appearance of the worksheet and to make sure that all the data is displayed:

  • Increase the header margin by dragging the margin indicators that appear on the screen.
  • Change the size of the picture.

How to change the size of the picture

To change the size of the picture, use one of the following methods:

Method 1: Microsoft Office Excel 2007

  1. Click the header or the footer that contains the picture that you want to adjust.
  2. Click any location inside the &[Picture] text.
  3. Click the Design tab under Header & Footer Tools.
  4. Click Format Picture in the Header & Footer Elements group.
  5. Type .5 in the Height box.Note Because both the Lock aspect ratio and the Relative to original picture size check boxes are selected, the width changes in proportion to the change that you make in the Height box.
  6. Click OK to close the Format Picture dialog box.

Method 2: Microsoft Office Excel 2003

  1. On the View menu, click Head and Footer.
  2. Click Custom Header or Custom Footer.
  3. Click any where in the &[Picture] text.
  4. Click the Format Picture button.
  5. Click to clear the Height check box, and then type .5 in the Height box.Because both the Lock aspect ratio and the Relative to original picture size check boxes are selected, the width changes in proportion to the change that you make in the Height box.
  6. Click OK three times.

Note If you decide to move the picture to another section of the header or the footer after you have positioned and formatted it, you can copy and paste the code &[Picture], but you must select the picture again and reformat it if you do so.

Advertisements
Published in: on March 6, 2011 at 11:19 pm  Leave a Comment  

The URI to TrackBack this entry is: https://blackbeltreview.wordpress.com/2011/03/06/how-to-improve-the-picture-appearance-in-the-header-or-footer-in-microsoft-excel/trackback/

RSS feed for comments on this post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: