This text exhibits how to remove a watermark in Excel sheet. In Microsoft Excel, you’ll be able to add two sorts of watermarks, picture watermark and textual content watermark. When you’ve got an Excel file that has a watermark and you do not need that watermark on the printout, you’ll be able to remove it.
How to remove Watermark in Excel sheet
Eradicating a watermark in an Excel sheet is as simple as including a watermark in Excel. This text exhibits a step-by-step information to present you the way to remove a picture or a textual content watermark in Excel.
The method to remove each picture and textual content watermarks in Excel is identical. To remove a watermark in an Excel sheet, you have got to open the Web page Format view. Undergo the next directions.
- Open the Excel file containing the textual content or the picture watermark.
- Choose the Insert tab.
- Now, click on on the Header & footer. The Header & footer possibility is offered beneath the Textual content group.
- When you click on on the Header & footer possibility, three rectangular blocks will seem on the Header and the Footer. The view of your Excel sheet will even change from the Regular view to the Web page Format view.
- Click on on all these three blocks one after the other till you see the textual content &[Picture]. Excel shows the &[Picture] textual content while you insert a picture watermark.
- Delete &[Picture].
- Save your Excel file. The picture watermark has been eliminated.
In case your Excel file has a textual content watermark, you have got to comply with the identical steps to remove it. Within the case of a textual content watermark, Excel exhibits the entire textual content as an alternative of the &[Picture].
Usually, customers insert the textual content and the picture watermarks on the Header in Excel. However in some instances, it may be inserted in the Footer part. Due to this fact, when you discover all three blocks empty on the Header part, you also needs to verify the Footer part.
For this, scroll down to view the Footer. If the Footer incorporates the watermark, you will note it there. Now, click on on all three blocks on the Footer part one after the other and delete the textual content from there.
You can even change to the Web page Format view by clicking on the respective button on the underside proper aspect in Excel (refer to the above screenshot). Hover your mouse cursor on the icons displayed there to learn their names. Click on on the icon that exhibits the identify Web page Format on hovering the mouse cursor.
After switching to the Web page Format view, hover your cursor over Header and Footer to view three blocks.
The place is watermark in Excel?
A few of you might also come throughout a scenario the place the watermark shouldn’t be proven in the Excel file however while you generate the Print Preview of the sheet, you see the picture or the textual content watermark there.
Do word that Excel exhibits the watermark solely in the Web page Format view. When you open Excel in the Regular view, you’ll not see the watermark.
How to remove the web page 1 background in Excel?
Excel exhibits the Web page 1 background while you open it in Web page Break Preview mode. That is solely a background and never a watermark. Therefore, there isn’t any want to trouble about it as your printed Excel sheets is not going to present this background.
If you need to remove the Web page 1 background, you have got to change the Web page Break Preview mode to the Regular mode. To take action, choose Regular beneath the View tab.
Learn subsequent: How to add Border in Excel.
