Look Who it Was Random video

Excel - Learn How to Add a Custom Logo to Your Excel Header - Episode 860

1,053 views · Published 7 January 2009 · 3:16 · Indexed 8 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Learn How to Add a Custom Logo to Your Excel Header.

Welcome to another MrExcel netcast! In this video, I'll be sharing a cool tip for creating a custom header with a logo in Excel. But first, I have a question for you to try out on your own. So, let's dive in and see what we can discover.

I have a document with wide columns, A through H, and I want to fit it to one page wide. To do this, I'll go to File, Page Setup, and select "Fit to" 1 "page(s) wide". But here's the catch - I'm going to leave the number of pages tall blank, which means it can be as tall as needed. Next, I'll go to the Header and Footer section and click on Custom Header. Here, I'll add a logo to my header, in this case, the MrExcel logo. I can even format the logo and adjust its height to my liking.

Now, let's do a Print Preview and see how it looks. You'll notice that the logo takes up about half the page. To make sure the data starts beneath the logo, I'll adjust the margins accordingly. So far, so good. But here's where things get interesting. I had a student in my Data Analyst Boot Camp who showed me a similar worksheet, but with one major issue. Every month, they would add new data to the right-hand side, causing the logo to shrink in size. This resulted in a smaller and smaller logo in each subsequent report, making it difficult to read. 

So, here's my challenge to you. Try adding a logo to your header and then start adding columns to the right-hand side. Make sure you have the "Fit to" 1 "page(s) wide" setting and leave the number of pages tall blank. Let me know if your logo shrinks or stays the same size. Also, please include the version of Excel you're using in your email to [email protected]. This will help us determine if it's a version issue or if there's another setting causing the logo to shrink. And if you happen to know the solution, feel free to drop me a note and save us all some trouble. Thanks for watching and stay tuned for more netcasts from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


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.

Table of Contents:
(00:00) Introduction and overview of the topic
(00:22) Adjusting page setup and adding a logo to the header
(01:10) Issue with logo shrinking when adding columns to the right
(02:10) Request for viewers to try the same and report their results
(02:51) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adding columns in Excel
Adjusting margins in Excel
Custom header in Excel
Fit to page in Excel
Help menu in Excel
Logo shrinking in Excel
Logo size in Excel header
Page setup in Excel
Scaling data in Excel
Version of Excel
YouTube video tips


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152006/

More from this channel