How to insert company logo into worksheet?
Including your company logo in an Excel worksheet is a common requirement for branding, official documentation, and creating a more professional look, especially when preparing sheets for reports, presentations, or printouts. There are several straightforward ways to insert a company logo, with each method offering unique advantages for different usage scenarios. This article provides step-by-step instructions for a variety of approaches to help you efficiently incorporate your company logo into your worksheets.
Insert company logo as picture
One practical way to display a company logo on your worksheet is to insert it directly as an image. This method is especially useful when you want the logo to be visible during regular editing, and you need to move or resize it freely within the sheet. However, be aware that when printing, the logo’s position might shift if you make adjustments to the worksheet content. It's well-suited for digital presentations or customizing the layout on specific pages.
To insert your company logo as a picture, proceed as follows:
1. Select the cell where you would like the upper-left corner of the logo image to appear. Then click Insert > Pictures in the Excel ribbon.
2. In the Insert Picture dialog box, browse to the saved location of your company logo image file, select it, and click Insert.
3. The logo now appears on your worksheet as a picture object. You can resize the logo by clicking and dragging any of its corner handles. To move it, hover the mouse over the image edge until the cursor changes, and drag the logo to your preferred position.
Tip: Right-click the inserted logo and select Format Picture for further adjustments, such as adding a border or shadow for enhanced visibility. If you want the logo to stay in a certain position relative to worksheet data, right-click the image, choose Size and Properties, and set the relevant positioning options.
Note: This method does not link the logo specifically to Excel's printing headers/footers. Ensure your print settings show the logo as desired by checking Print Preview.
Insert company logo as header/footer
If your goal is to display the company logo at the top or bottom of each printed page, inserting it into the header or footer is a reliable choice. This ensures the logo repeats on relevant pages during printing, making it suitable for reports and official documents. However, the logo will not be visible during normal worksheet editing view—only in Page Layout or Print Preview.
Follow these steps to embed your company logo as a header or footer image:
1. Click the Page Layout tab on the ribbon, then, in the Page Setup group, click the small dialog launcher arrow icon at the bottom right.
2. In the Page Setup dialog box, go to the Header/Footer tab and click either Custom Header or Custom Footer based on where you want the logo to appear.
3. In the new dialog (Header or Footer), select the section (left, center, or right) where you want to insert your company logo. Click the Insert Picture button in the toolbar.
4. In the Insert Pictures dialog, click Browse (in the From a file section). Then, navigate to and select your company logo image file, and click Insert.
5. Once the image appears as a code such as &[Picture] in the header/footer field, click Format Picture to adjust the logo’s size or scale. This helps ensure the logo prints at an appropriate size and resolution.
6. In the Format Picture dialog, go to the Scale section and change the percentage to resize the logo without distortion. Preview the effect in Page Layout view if needed.
7. After completing your adjustments, click OK on each dialog to confirm and close. Your logo is now embedded in the worksheet’s header or footer and will appear on all printed pages as specified.
Tips: To avoid printing issues, use high-resolution images and test print a page to check alignment. The header and footer image display might be affected by page margins, scaling, and printer settings.
Common issue: If the logo appears stretched or pixelated, try resizing the image before inserting it, or adjust scaling within the Format Picture dialog.
Insert company logo as watermark with Kutools for Excel
If you want the company logo to appear as a subtle watermark in the worksheet background—visible both on screen and in print—using the Insert Watermark feature of Kutools for Excel is a very efficient solution. This approach is ideal when branding is important across the entire printable area, and you want a non-intrusive, stylish effect that doesn’t interfere with worksheet data.
1. In Excel, click Kutools on the main ribbon, then select Insert > Insert Watermark.
2. In the pop-up dialog, check the Picture Watermark option. Then, check the Washout box for a light, watermark-style effect. Click Select Picture to choose the company logo. Adjust the scale of the inserted logo if necessary to fit your worksheet layout.
3. Once satisfied with your settings, click Ok to apply the watermark. The logo will appear in the background of your worksheet, behind data, and will be visible in preview and printouts.
Tip: To achieve the best visual effect, use a logo with sufficient resolution and consider transparency to ensure the watermark does not make data hard to read. If you need to fine-tune or remove the watermark, simply return to the Insert Watermark dialog and adjust or delete as needed.
Kutools for Excel - Supercharge Excel with over 300 essential tools, making your work faster and easier, and take advantage of AI features for smarter data processing and productivity. Get It Now
Insert company logo with VBA code
For users looking to automate the insertion of a company logo—such as batch-inserting a logo into multiple sheets or at a standardized position—a VBA macro can provide a flexible solution. This is suitable for advanced users or repetitive tasks, although it may require initial setup and careful file management. The main benefit is the ability to programmatically control the logo placement and size.
1. To use this method, click Developer Tools > Visual Basic to open the Microsoft Visual Basic for Applications window. Click Insert > Module, then paste the following code into the module:
Sub InsertCompanyLogo()
Dim ws As Worksheet
Dim logoPath As String
Dim logoPic As Picture
On Error Resume Next
xTitleId = "KutoolsforExcel"
logoPath = Application.GetOpenFilename("Picture Files (*.jpg;*.jpeg;*.png;*.bmp),*.jpg;*.jpeg;*.png;*.bmp", , xTitleId)
If logoPath = "False" Then Exit Sub
Set ws = ActiveSheet
Set logoPic = ws.Pictures.Insert(logoPath)
If Not logoPic Is Nothing Then
With logoPic
.Top = ws.Range("B2").Top
.Left = ws.Range("B2").Left
.ShapeRange.LockAspectRatio = msoTrue
.Width = 100
End With
End If
End Sub2. Press F5 or click the 
Run button to execute the code. A dialog will prompt you to select the logo image. The code will insert the logo at cell B2 of the active worksheet and set its width to 100 points, preserving aspect ratio. You may adjust the position by changing the .Top and .Left references, or the size by modifying .Width as needed.
Note: Save your work before running VBA code to avoid unexpected changes. This VBA method works with standard image file formats (JPEG, PNG, BMP, etc.).
Insert company logo with Excel background feature
Another alternative is to use Excel’s background image feature, which places the logo across the sheet background but is visible only in Normal view—not in printouts. This method is suitable when you want branding visible during worksheet editing but do not require it in printed form. To use this feature, go to Page Layout > Background and select your logo image. The logo will tile across the background. Note: This method does not support scale or position adjustments and is best for subtle watermark-style backgrounds during data entry.
Demo: Insert watermark into Excel using Kutools
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in