To remove a watermark, we must delete the text ' &' that appears in the header/ footer. For instance, if there is any image watermark, the text ' &' will be displayed in a corresponding section of the header/ footer. After clicking on the 'Header & Footer', all the header and footer sections will be highlighted, and object inserted into them will be displayed, if any. Once the watermark is visible, we need to navigate to the ' Insert' tab and click on the ' Header & Footer' from the options given under the ' Text' group. We must ensure that the ' Page Layout' view is selected to display the watermark if added in the header/ footer. First, we need to open an Excel file in which we want to remove or delete the watermark. The following are the steps to remove an image from the header/ footer In Excel: Therefore, we need to click on the ' Page Layout' option from the ' View' tab to check if there is any watermark in the header/ footer of the Excel file. This happens because the watermark added in the header/ footer only appears in the 'Page Layout' view. But, whenever we take prints of corresponding documents, the watermark appears. Sometimes, watermarks inserted using this method do not show when we open an excel file. In case the watermark is an image and repeating on each page only once or two (Header, or Footer, or both), the watermark is more likely inserted using 'Header & Footer' in Excel. Inserting a watermark in excel using the 'Header and Footer' function is very common. Remove a Watermark by using the 'Header & Footer' Function Additionally, when we click on the 'Delete Background' button, the button option will change to 'Background' from the 'Delete Background'. In case the 'Delete Background' button is not present, it means that the watermark is added using any other method. It is important to note that the 'Delete Background' button in the 'Page Layout' tab will only be visible when the watermark is added as a background. After clicking on the 'Delete Background' button, the watermark will be removed from all the worksheet pages. Next, we need to click on the ' Delete Background' option, as displayed in the following image:. After that, we must click on the ' Page Layout' tab from the top navigation menu. First, we need to open a specific excel file using the MS Excel software. These types of watermarks are so easy to remove.įollowing are the steps to remove a watermark in Excel that is added as a sheet background: More specifically, the watermark is added by navigating to the 'Page Layout' tab and then selecting the option of 'Background'. In case the watermark is repeating again and again on each page many times, it is more likely added as an image in the background. Let us now discuss each of the above methods in detail, including the corresponding steps: Remove a Watermark by Deleting a Background Additionally, we should compare the file after deleting the watermark with the original file to ensure that we have removed nothing but the watermark. This is an essential step because we can recover the data when we follow the wrong way and lose the data. 
Caution: It is highly recommended to make a copy of the original file before trying any of the above methods to remove the watermark in Excel. One must try each method one by one until the watermark is completely removed from the Excel file.
Remove a Watermark by using the Third-Party Tools. Remove a Watermark by using the 'Go to Special' function. Remove a Watermark by using the 'Header & Footer' function. 
Remove a Watermark by Deleting a Background. Generally, we can try the following methods to remove a watermark from the excel files: 
It is typically a reverse of inserting a watermark in Excel.īecause one can use different methods to add a watermark in excel, we may need to follow different ways to remove a watermark from excel. If we want to remove a watermark in Excel files, we must do it manually or by using some third-party tools. Since there are some alternate options to insert watermarks in excel, we may get Excel files with watermarks one way or another.
That way, they claim ownership or promote their brand. Thus, most people follow alternative methods or use third-party tools to insert a watermark in Excel.
#Excel for mac remove watermark how to#
Next → ← prev How to Remove Watermark in ExcelĮxcel is a powerful spreadsheet software with various features but lacks an option of a watermark.
0 kommentar(er)
