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.
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 ]
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 ]
