MrExcel's Learn Excel #860 - Header Log

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 7, 2009.
Adding a company logo jpg to your worksheet header. Episode 860 shows how to add a header, and then poses a question about if your image is scaling in size as you add more data.
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Got a cool tip for you today, but then also a question.
I want you to check some things out.
I have a document here that's fairly wide-- wide columns, A through H-- and I go in a File, Page Setup, want to say it "Fit to" 1 "page(s) wide", but I'm going to clear out the number of pages tall-- that forces it to fit one page wide, but it can be as tall as you want.
Back here on the Header and Footer, I'm going to go into Custom Header and create a logo up in my header.
So I'll choose the MrExcel logo up there and I can even format that.
And I'm going to have to adjust the height down a little bit, so we'll go down to about an inch and a half tall; maybe an inch tall, there we go.
You notice that these boxes are checked-- "Lock aspect ratio", "Relative to original picture size"-- I'm not doing any cropping on this particular one.
Thinking everything is okay.
Okay, now let's do a Print Preview, and you'll see that the logo is a certain size-- comes out to about half the page.
Adjust my margins here, so that way the data starts beneath the logo.
Alright, cool.
Now, here's the problem: I had someone in the Data Analyst Boot Camp who showed me a worksheet similar to this, and they said, "What we noticed is that every month we add new data to the right hand side." So i'm going to copy a couple of more months here, August and September, I'll make those wide enough because now, what's going to happen is, everything has to scale down in order to fit August and September.
And when we go into Print Preview, alright, you'll notice on my computer the logo is the exact same size that it was; but on this person's computer, every month, as they added new data to the right, the logo kept scaling smaller and smaller and smaller, and so as you went from report to report to report, when you looked at them in the notebook where they store all these reports, the logo kept getting smaller.
So here's what I want you to do: I want you to give this a shot, go to your computer, add a logo to the header and then start adding columns to the right-hand side.
And, again, in Setup, we have it set up for "Fit to" 1 "Page(s) wide by"; blank pages "tall"-- doesn't matter how many pages tall-- and let me know whether your logo is shrinking or not shrinking.
Now send that result to Bill@MrExcel.com.
I'm also interested in what version of Excel you have-- so, specifically, if we go to Help, About Microsoft Excel, I'm in the SP3 version of Excel 2003.
Take a look and let me know what you're running and whether your logo shrinks or doesn't shrink.
We'll figure out if it's a version issue or if there's some other setting that's causing that.
And if you happen to know, just save us all a lot of trouble and drop me a note.
Well, thanks for stopping by, we'll see you next time for another netcast from MrExcel.
[ music ]
 

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top