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...... :)