!!! Print Your Company Logo On Every Page !!!

Couple of days ago at an Excel Training workshop a participant asked me “Can I add my company’s logo in a worksheet so whenever i print, it should appears on every page? “

I said Yes why not……. Excel can do whatever you say except to prepare a cup of coffee….. J


So guys let’s see how we can do this:

Step 1   Put your company logo in any folder in your system and resize it as desired;

Step 2   Open a blank Workbook;


Step 3   Go to Insert Tab, Click on Header & Footer in the Text group. 


Step 4   This will put your worksheet in Page Layout
view and open a new Header & Footer Tools, Design tab.



Step 5  The center header section is selected by default. You can also click the left or right header area to place the logo there. Or to put your logo in the footer, click the Goto Footer command in the Navigation group;


Step 6  Click the Picture command in the Header & Footer Elements group. Then browse to the folder where your logo is located, select it and click Insert. You will see &[Picture]inserted into your chosen header/footer section. Click away from the header/footer area and you will see your logo displayed;







Step 7  On the far left edge of the Page Layout window, point to the top edge (for header logo) or bottom edge (for footer logo) of the ruler just to the left of the row numbers and drag the margin until it is just below the bottom of your header logo or just above the top of your footer logo;





Step 8   Exit the Page Layout view by clicking the Normal view (left) button on the bottom right side of the Taskbar.



However, you can save it as a template. From the File tab click Save As. In the Save As dialog, click the 'Save as type' dropdown and select Excel Template (*.xltx). Give your template a name (e.g. Company Logo.xltx) and click Save. 

Now, whenever you want a new a workbook with your company logo, you can choose this template by clicking the File tab, selecting New, click My Templates, select your company logo template and click OK.

If you have any question any query just post it into the comment section...

If you like my post, then don't forget to subscribe my blog. To subscribe just put in your email ID at the top right corner of the page and you will get notification of my latest post on this blog, directly in your Inbox.

Keep learning...... :)