• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to Add a Watermark in Excel

0 Comments

A watermark is an image or text that appears in the background of a document, often used to protect it from unauthorized use or to indicate its status as “Confidential,” “Draft,” or “Sample.” Excel doesn’t have an inbuilt watermark feature, but there are several ways to add, format, replace, and delete watermarks as images or text in a spreadsheet.

Add Watermark as Image in Excel Using Header & Footer

To add a watermark as an image using the Header & Footer option, follow these steps:

  1. Go to the “Insert” tab and click on the “Text” icon on the ribbon. How to Add Watermark in Excel 1
  2. Select the “Header & Footer” option.
  3. Click on the “Picture” icon under the “Header & Footer Elements” group on the ribbon.How to Add Watermark in Excel 2
  4. Select the image or picture you want to use as a watermark from the “Insert Pictures” dialog box and click on the “Insert” button.How to Add Watermark in Excel 3
  5. To center the watermark on the page, place your cursor just before the &[Picture] code and press enter multiple times to move the watermark.How to Add Watermark in Excel 4
  6. Click anywhere in the cell outside the header to view the added image as a watermark.How to Add Watermark in Excel 5

Format Watermark Image in Excel

To format the watermark image’s size and color, open the Header & Footer view and click on the “Format Picture” icon under the “Header & Footer Elements” group on the ribbon. From there, you can adjust the size, brightness, contrast, and color of the image.How to Add Watermark in Excel 6

To rotate the watermark image, save the image as a rotated image first. To do this, follow these steps:

  1. Go to the “Insert” tab and click on the “Illustrations” icon.
  2. Click on “Pictures” and select the option from where you want to add the image.
  3. Select the image and click “Insert.”
  4. Hold on to the rotate arrow and rotate the image as you want.How to Add Watermark in Excel 7
  5. Once you’ve rotated the image, right-click on it and select “Save as Picture” from the pop-up menu, and save it.
  6. After saving the image, click on the image border and delete it.
  7. Open the “Header & Footer” and add the above-saved image as a watermark.

Add Text as Watermark Image Using Word Art

To add text as a watermark image using Word Art, follow these steps:

  1. Go to the “Insert” tab and click on the “Text” icon. How to Add Watermark in Excel 14
  2. Select the “WordArt” option and select any “WordArt” style you want to use for writing text as a watermark.
  3. Add the text you want to use as a watermark.
  4. Move the text box anywhere you want and rotate it as desired.How to Add Watermark in Excel 15
  5. To format the text box, including the font and background style, use the “Shape Format” tab.
  6. Right-click on any edge circle of the text box and select “Save as Picture.”

Add Watermark as Editable Text in Excel Using Header & Footer

To add a watermark as editable text in Excel using Header & Footer, follow these steps:

  1. Open the “Header & Footer” view and enter the text you want as a watermark.
  2. Place your cursor just before the text and press enter multiple times to move the watermark to the center of the page.
  3. Select the whole text and go to the “Home” tab.
  4. Under the “Font” group on the ribbon, select the font type, size, and color you want for your watermark text.
  5. Click anywhere in the cell outside the header to view the added text as a watermark.

To delete or replace an existing watermark, go to the “Insert” tab, click on the “Text” icon, and choose the appropriate option.

Rate this post
26
271 Views
How to Count Blank Cells in Excel using COUNTIF FunctionPrevHow to Count Blank Cells in Excel using COUNTIF FunctionApril 26, 2023
Sort By Date, Date and Time & Reverse Date SortApril 26, 2023Sort By Date, Date and Time & Reverse Date SortNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
Products
  • Windows Server 2012 R2 Standard Key Global Windows Server 2012 R2 Standard Key Global
    Rated 4.78 out of 5
    $15.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 1 Year
    Rated 4.91 out of 5
    $34.00
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • Microsoft Project 2019 Professional Key Global Microsoft Project 2019 Professional - 5 PC
    Rated 4.97 out of 5
    $12.00
  • Office 2024 Home and Student Office 2024 Home and Student $88.00
  • Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global Windows Server 2016 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.74 out of 5
    $15.00
  • Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC Buy Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.95 out of 5
    $32.00
  • Buy Windows Server 2016 Essentials Key Global Buy Windows Server 2016 Essentials Key Global
    Rated 4.75 out of 5
    $10.00
  • Microsoft Visio Standard 2021 Key 1PC Microsoft Visio Standard 2021 Key 1PC $13.00
  • Windows Server 2025 Remote Desktop Services 50 Device Connections Windows Server 2025 Remote Desktop Services 50 Device Connections $25.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.