How to Remove a Watermark in Excel 2010


When a spreadsheet is created by someone at a business, they may occasionally add the business’s watermark to the spreadsheet. If you are working on a spreadsheet that the business has sent, however, that watermark could be distracting and difficult to work with.

Fortunately it is possible to remove the watermark in Excel 2010 once you have determined how the watermark was added to the file. Our tutorial below will help you to identify the method of watermark insertion so that you can correctly determine the way to remove it.

 

Removing Watermarks in an Excel 2010 Spreadsheet

Microsoft Excel 2010 does not have a watermark feature, so what you are seeing is actually being caused by something else. In order to determine what changes you need to make, it is necessary to determine what it looks like on your spreadsheet.

1. Is the watermark an image that repeats many times on each page?

If the answer to this question is yes, then there is a sheet background applied to the worksheet. If the answer is no, then you can continue to the next question. You can remove a sheet background by clicking the Page Layout tab at the top of the window, then clicking the Delete Background button in the Page Setup section of the navigational ribbon.

click the delete background button

 

 

2. Is there an image that repeats on every page, but it only repeats once?

If the answer to this question is yes, then you have an image in your header or footer. If the answer is no, then you can continue to the next question. You can remove a header or footer image by clicking the Insert tab at the top of the window, then clicking the Header & Footer button in the Text section of the navigation ribbon.

open the header and footer section

 

 

You can then delete the &[Picture] text that you find in the header or footer section. Note that you might have to click in each section to view the text, as it can be hidden by large images.

delete the picture text

 

 

You can then double-click one of your cells to return to the body section of the spreadsheet.

 

 

3. Is there a watermark that says “Page 1,” “Page 2,” etc. that you can see on your screen, but that does not appear when you print the spreadsheet?

If the answer to this question is yes, then your worksheet is in Page Break view. If the answer is no, then you can continue to the next question. You can exit Page Break view by clicking the View tab at the top of the window, then clicking the Normal option in the Workbook Views section of the navigational ribbon.

switch the worksheet view

 

 

4. If you still have a watermark, then it is either an image or a WordArt object.

You can delete elements on the page by clicking them with your mouse, then pressing the Delete key on your keyboard.

 

If you are having difficulty printing in Excel, then you are not alone. Check out our guide to printing in Excel for some handy tips that will improve the appearance of your printed spreadsheets.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.