Image inserts into header way WAY too big

Question

Hi there,

I'm going a little crazy with this one!

I've developed some Excel templates for a client with their logo inserted in top left header, their client's logo in top right header. I've set up 30+ WBs with client logo already in place and am now working on an add-in that they can apply to existing workbooks, that formats in the same way, inserting the logos for them. Client is using Excel 2011.

I used Excel 2010 to set them up because, when I tried inserting images into the headers with 2011, the logos went in crazily oversized (looks about 5 times bigger). When I insert through Excel 2010, the logo goes in at the exact same size as the image file. The catch is that the client will need to insert logos using the mac version only, so I need to find a way to insert an image in the header at the same size as the file.

When I insert the logo into the sheet in 2011, it comes up at the correct size. But when I insert the exact same file (300dpi jpeg) into the header, it is wildly oversized (see screenshot below).

Does anyone have any idea what is causing this weird oversizing? Or if there is any way to override it?

Thanks in advance,

Joseph

Answer 1

PS: You can adjust the properties of a Header/Footer image (including Size) in Excel...

1. Click in the Header/Footer box containing &[Picture]
2. Click the Format Picture button on the Header/Footer toolbar

Answer 2

I can't reproduce what you're describing in Excel 2010. Inserting an image in the Header there yields exactly the same result as inserting it in the Header of 2011. What I experience is that the image is inserted in either version based on the print dimensions of the image -- which is exactly what I would expect to happen :-) Likewise, the image inserts into the sheet [again, either version] at precisely the same size.

A possible variable may be a matter of how the image was produced. Opening the image in a graphics editor, such as Photoshop, & setting the print dimensions & resolution should give you the result you want.

What you refer to as "300dpi" [actually ppi (pixels per inch)] is the resolution of the image which has no correlation to print dimensions. IOW, that indicates how many pixels per inch, but not how many inches :-) A 2"x2" JPEG image can have a 300 ppi resolution just as readily as a 5"x7". The difference is that the 2x2 will be a significantly smaller file size & will print smaller but at the same quality.

Answer 3

Hi Bob,

Thanks for your swift reply. The dimensions of the logo in the screen grab above are H2.2cm x W2.3cm. The dimensions and resolution were set in Photoshop. The page size of the sheet in the screen grab is A4, so you would expect the logo to show up in the header the same size as the image in the sheet (which is more-or-less accurate to the print dimensions).

Here's a screen grab of an image of the same print dimensions and resolution going into the header in 2010...

As you can see, it goes in at the exact same dimensions as the image in the worksheet.

And here is the exact same image file inserted into the same sheet in 2011...

The only difference between the two being that in one the image is inserted via 2010 and in the other by 2011.

I'm stumped! And would welcome any suggestions at this point.

Answer 4

See if something like this is what you want:  First here is an upload screen shot of the results:

LOGO

Now here is screen shot here will be compressed and not look as good

Here is how I created my Test Logo

(the Graphic program used is of no importances other than it should allow to to format in DPI/PPI) Also (The steps are somewhat generalized you do the steps in what ever you use how you get there may be different.) :

1. Open Graphic Converter.
2. Choose Create  > New > Image.
3. Set canvas to 200 DPI/PPI Vertically and Horizontally.
4. Set back Ground Color to desired color.
5. Double Click on Text Button " A inside a square".
6. Set desire Font Point Then type desired Text for logo.
7. Once complete Get out of text mode and Select  the Text which will show its bounding box.
8. Center within Canvas (background) both vertically and horizontally.
9. Once satisfied with with results Save as a PNG.

and be sure is set to desired DPI/PPI 300 or 150 dpi.

Now:

1. Open Excel sheet (Excel 2011).
2. Click on File menu.
3. Show header Footer.
4. Click header.
5. Choose custom Header.

You will see three parts Left Justified, Center, Right Justified. Choose Left Justified. 6. click on the icon that look like a wall painting (Insert Picture). 7. Locate the Logo you just created, and Select. 8. Image should appear in Header. 9. Click somewhere in body of document, to get out of header/footer. 10. Now Double Click in Margin and Page set should appear. 11. Click on Margins set header to .75" (Logo is .67" Tall). 12. Set Top of page 1.5 "

Now to show size of Logo I pasted a copy of the Logo in the document to create this Test Screenshot.

You can save your Blank Sheet as a Template and send the folks the template. Al you need to send them a Copy of the logo they created. So they can add to the additional. 

One thing that has infuriated me over the years. Is that You have to go through this customization from start to Finish with each sheet you add to a workbook. Instead of having a choice whether to Duplicate Formatting of first sheet or use a new format.

For instance I just created a workbook that was supposed to look identical so far as formatting over 12 sheets. I had to go through this setup 12 times rather than when you click new sheet, the new sheet would look like the original first sheet. Luckily I know to select the entire sheet that is being used. Doing copy. Switch to new sheet click in first cell and do Paste. But the idea of having to do even that is infuriating it time wasting big time. Can you imagine seeing someone having to duplicate formatting over 150-200 sheets.  By the end they woul be ready to punch their fist through the screen.

Answer 5

Can you put a copy of the image on Dropbox, OneDrive, or some-such as provide a link to it? I'd like to see what happens here.

I'd also like to know exactly what steps you're taking, both to put the image into the Sheet as well as into the Header.