--- title: "How to Add a Watermark in Excel" lang: en canonical_url: https://www.papermark.com/blog/how-to-add-watermark-in-excel last_updated: 2026-06-15 published: 2025-03-21 category: [security] author: "Marc Seitz" summary: "Learn three effective methods to add watermarks to your Excel spreadsheets. Protect your confidential documents and intellectual property when sharing with clients or stakeholders." --- # How to Add a Watermark in Excel Watermarks in Excel spreadsheets are essential for protecting sensitive information when sharing files with clients, stakeholders, or team members. Whether you're sending financial reports, business forecasts, or confidential data, watermarks provide a layer of security by discouraging unauthorized sharing and clearly marking your intellectual property. Watermarking your Excel documents can help you track who viewed your spreadsheets, mark files as confidential, and add a professional branded appearance to your content. ## Watermark methods for excel compared Before diving into the step-by-step instructions for each method, here's a quick comparison to help you choose the best approach for your needs: | Feature | Papermark | Excel shapes | Header & footer | | --- | --- | --- | --- | | Dynamic personalization | ✓ (recipient info, date, time) | ✗ | ✗ | | Tracking capabilities | ✓ | ✗ | ✗ | | Ease of implementation | ✓✓✓ (web-based) | ✓✓ (manual setup) | ✓ (basic features) | | Removal difficulty | ✓✓✓ (very difficult) | ✓ (easy to remove) | ✓ (easy to remove) | | Works across all devices | ✓ | ✓ (with Excel) | ✓ (with Excel) | | Analytics on viewer behavior | ✓ | ✗ | ✗ | | Cost | Available in paid plans | Free (Excel required) | Free (Excel required) | | Best for | Confidential spreadsheets, financial reports | Internal documents | Basic watermarking needs | Now, let's explore each method in detail. ## Method 1: Using papermark for dynamic watermarking Papermark offers the most comprehensive and secure watermarking solution for Excel documents, with the unique ability to create dynamic watermarks that display the viewer's information, making each copy traceable. Note that you'll need to convert your Excel file to PDF before adding watermarks. ### Step-by-step guide for papermark watermarking: 1. **Convert Excel to PDF**: - Open your Excel file - Go to File > Save As - Choose "PDF (*.pdf)" as the file type - Select your desired save location - Click "Save" to create the PDF version 2. **Access papermark**: - Log into your papermark account at [papermark.com](https://www.papermark.com/login) - If you don't have an account, sign up for free ![Watermarked Document Example](https://img.papermarkassets.com/upload/file_Ks2dtpU7UXaoreiAAtXr54-watermarked-document.png) 3. **Upload your pdf document**: - From your dashboard, navigate to "documents" or "data rooms" - Click "add document" or the upload button - Select the PDF file you just created from your Excel document ![Upload PDF to Papermark](https://img.papermarkassets.com/upload/file_PAixTgZnXx25nUgUvvATMb-Screenshot-2025-03-20-at-22.39.34.png) 4. **Configure watermark settings**: - Once uploaded, find your document and click on the "settings" tab - Find the "apply watermark" section and toggle the switch to enable watermarking 5. **Customize your watermark**: - Enter your desired watermark text. You can use static text like "confidential" or "draft" - To make it dynamic, use variables like: - `{{email}}` - Shows the viewer's email address - `{{date}}` - Shows the current date - `{{time}}` - Shows the current time - `{{link}}` - Shows the specific link used to access - `{{ipAddress}}` - Shows the viewer's IP address ![Customize Watermark Settings](https://img.papermarkassets.com/upload/file_4QhomiSbGzJq9BQGLjGSEM-screenshot2.png) 6. **Share your watermarked excel file**: - Generate a shareable link from the "share" tab - Send this link to your recipients - Each viewer will see the spreadsheet with a personalized watermark ![Share PDF with Watermark](https://img.papermarkassets.com/upload/file_9iScKTWEZx4HmcofeSr8TM-Screenshot-2025-03-20-at-22.38.06.png) 7. **Track viewer access**: - Return to your papermark dashboard to see who has accessed your spreadsheet - View analytics on viewing time and activity ![Track Viewer Analytics](https://img.papermarkassets.com/upload/file_HKCLjWCkdTzc6qAFV2it65-all-links.png) Here is what your excel file with a dynamic watermark will look like: ![Excel with Dynamic Watermark](https://img.papermarkassets.com/upload/file_XpamYyK3cmNEd2rc3bsVeN-Screenshot-2025-03-24-at-13.56.32.png) ## Method 2: Using excel shapes for watermarking Excel's built-in shapes feature provides a straightforward way to add watermarks, though with less security than papermark's solution. ### Step-by-step guide for shape watermarking: 1. **Create the watermark**: - Go to insert > shapes > text box - Draw a large text box diagonally across your worksheet - Type your watermark text (e.g., "confidential" or "draft") ![Excel Shape Watermark Example](https://img.papermarkassets.com/upload/file_NbjtfCegrkpwMsHRfvJSPx-Screenshot-2025-03-21-at-14.45.26.png) 2. **Format the watermark**: - Set font size (72pt or larger recommended) - Choose a light gray color - Set transparency to 50% - Rotate 45 degrees - Right-click and select "send to back" 3. **Protect the worksheet**: - Go to review > protect sheet - Check "protect worksheet and contents of locked cells" - Set a password if desired ## Method 3: Using header and footer watermarks The header and footer method is best for adding watermarks that appear when printing or in page layout view. ### Step-by-step guide for header/footer watermarking: 1. **Access header/footer**: - Go to view > page layout - Double-click the header or footer area 2. **Add the watermark**: - Insert your desired text - Format using header & footer tools - Position as needed ![Excel Header Footer Watermark Example](https://img.papermarkassets.com/upload/file_3P32zmCGrn59FzA33mGAHm-Screenshot-2025-03-21-at-14.45.34.png) 3. **Format settings**: - Choose font and size - Set color (gray recommended) - Align as desired ![Excel Watermark Comparison](https://img.papermarkassets.com/upload/file_U4aQxFJFB5dtaiqTboecQT-Screenshot-2025-03-21-at-14.48.24.png) ## Conclusion Adding watermarks to Excel spreadsheets helps protect your intellectual property when sharing with clients, stakeholders, or team members. Choose papermark for dynamic watermarking with maximum security and tracking, excel shapes for internal documents, or header/footer method for basic watermarking needs. For sensitive financial data and confidential spreadsheets, papermark's dynamic watermarking capabilities provide superior protection while giving you visibility into who accessed your document and when. ## Frequently asked questions ### Will watermarks appear when printing my excel spreadsheet? Yes, watermarks added through any of the three methods described will appear when the document is printed. This is particularly important for ensuring document security across both digital and physical formats. ### Can watermarks be removed from my excel file by recipients? Watermarks added using excel shapes or header/footer can potentially be removed by technically savvy users. However, papermark's dynamic watermarks are rendered as part of the viewing experience and cannot be easily removed, providing superior protection. ### Do watermarks work when converting excel to other formats? Watermarks created using excel shapes will be preserved when converting to most formats. When using papermark, the watermark is part of the viewing experience and doesn't require conversion. ### Can I add different watermarks to different sheets? With excel shapes, you can create different watermarks for different sheets. With papermark, the watermark is consistent across all sheets, which is generally preferred for security and professional appearance. ### How do I add a watermark to multiple excel files at once? Papermark allows you to apply the same watermark settings to multiple documents in a data room. With excel shapes, you'll need to manually add watermarks to each file or use VBA scripts for automation. ### Will recipients need special software to view my watermarked excel files? For excel shape watermarks, recipients will need microsoft excel or a compatible spreadsheet program. With papermark, recipients can view watermarked documents directly in their web browser without any special software, making it more accessible. ![Papermark Watermark Preview](https://img.papermarkassets.com/upload/file_ASGPvXWzwwoXtxNwCXYX3V-Screenshot-2025-03-20-at-22.37.56.png) --- _Markdown version of [this article](https://www.papermark.com/blog/how-to-add-watermark-in-excel) for AI agents and LLMs._ _More Papermark content: [llms.txt](https://www.papermark.com/llms.txt) · [full index](https://www.papermark.com/llms-full.txt)._