Remove Watermark in Microsoft Excel sheet
0Here's how to Remove Watermark in Microsoft Excel sheet.
i. There are a few ways to remove the page 1 background in Excel.
**Method 1: Using the Page Setup dialog box**
1. Click the "Page Layout" tab.
2. In the "Page Setup" group, click the "Page Setup" dialog box launcher.
3. In the "Page Setup" dialog box, click the "Watermark" tab.
4. Clear the "Watermark" checkbox.
5. Click "OK".
**Method 2: Using the keyboard shortcut**
1. Press `Ctrl`+`Shift`+`D`.
2. Clear the "Watermark" checkbox.
3. Press `Enter`.
**Method 3: Using the Developer tab**
1. If the Developer tab is not visible, click the "File" tab.
2. In the "Backstage view", click "Options".
3. In the "Excel Options" dialog box, click "Customize Ribbon".
4. In the "Customize the Ribbon" dialog box, select the "Developer" checkbox.
5. Click "OK".
6. On the "Developer" tab, in the "Controls" group, click the "Watermark" button.
7. In the "Watermark" dialog box, clear the "Watermark" checkbox.
8. Click "OK".
**Method 4: Using VBA**
1. Press `Alt`+`F11` to open the Visual Basic Editor.
2. In the Visual Basic Editor, click the "Insert" menu.
3. In the "Insert" menu, click "Module".
4. In the Module window, paste the following code:
```
Sub RemoveWatermark()
'This macro removes the watermark from the active worksheet.
Dim ws As Worksheet
Set ws = ActiveSheet
ws.Watermark = ""
End Sub
```
5. Press `F5` to run the macro.
The watermark will be removed from the active worksheet.
ii. There are a few reasons why there might be a big page 1 watermark in Excel.
* **You are in Page Break Preview.** Page Break Preview is a view in Excel that shows you where pages will break when you print your worksheet. In this view, a large "Page 1" watermark is displayed in the middle of the worksheet. To remove the watermark, simply switch back to Normal view.
* **You have a watermark applied to your worksheet.** You can apply a watermark to your worksheet to add a subtle background image or text. To remove a watermark, go to the Page Layout tab and click the Watermark button. In the Watermark dialog box, clear the Watermark checkbox and click OK.
* **You have a header or footer that includes the page number.** If you have a header or footer that includes the page number, it may appear as a watermark when you are in Page Break Preview.
iii. To turn off a watermark in Word, follow these steps:
1. Open the document that contains the watermark.
2. Go to the **Design** tab.
3. In the **Page Background** group, click the **Watermark** button.
4. In the **Watermark** menu, select **Remove Watermark**.
Here are some additional tips that may help you turn off a watermark in Word:
* If you can't find the **Watermark** button, make sure that the **Header & Footer Tools** are visible. To do this, click the **View** tab and then select the **Header & Footer Tools** check box in the **Show/Hide** group.
* If you've applied a watermark to your document and then saved it, you can still turn off the watermark by following the steps above. However, if you've already printed the document, the watermark will appear on the printed pages.
* You can also turn off a watermark by deleting the header or footer that contains the watermark. To do this, go to the **Header & Footer Tools** tab and then click the **Remove Header** or **Remove Footer** button.
iv. There is no shortcut key for watermark in Excel. You can apply a watermark to your worksheet by going to the **Page Layout** tab and clicking the **Watermark** button. In the **Watermark** dialog box, you can select from a variety of built-in watermarks, or you can type your own text watermark. Once you have selected a watermark, click **OK**.
If you want to remove a watermark, simply go back to the **Watermark** dialog box and clear the **Watermark** checkbox.
v. You can make the background transparent in Excel by following these steps:
1. Select the cells that you want to make transparent.
2. Click the **Format** menu.
3. Click **Cells**.
4. Click the **Fill** tab.
5. In the **Transparency** section, drag the **Transparency slider** to the desired level of transparency.
6. Click **OK**.
Here are some additional tips that may help you make the background transparent in Excel:
* You can also make the background of an entire worksheet transparent by following the steps above, but instead of selecting individual cells, select the entire worksheet by clicking the **Select All** button (the square box in the top-left corner of the worksheet).
* If you want to make the background of a picture or other object transparent, you can do so by following the steps above, but instead of selecting cells, select the picture or object.
* You can also make the background of a cell or object transparent by using the **Format Painter** tool.