Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.
The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. See screenshot:Īctually, if you have Kutools for Excel – a handy add in tool with more than 300 utilities, you can quickly insert or remove watermark as quickly as possible. Then you can see there is a text “ &” in the header or footer, delete this text, and then, the watermark of the whole sheet has been removed. Then click Insert > Header & Footer to show headers and footers. Firstly, you need to go the Page Layout view by clicking View > Page Layout.Ģ. If the watermark is inserted as header/footer, you need to do as below steps:ġ. Tip: With this method, the other objects, such as pictures, shapes will be also removed. Then you can see the Art Word watermark have been selected, press Delete button to remove the watermark. In the Go To Special dialog, check Object option, then click OK to close the dialog.Ĥ.
Then click Home > Find & Select > Go To Special. Firstly you need to switch to Page Layout view to view the watermark, click View > Page Layout. If the watermark is inserted as Art Word, you can use the Go To Special function to find the Art Word, and then press Delete button to remove this type of watermark.ġ. Insert/remove watermark with Kutools for Excel Remove watermark with Header & Footer function Remove watermark with Go To Special function Here are some tricks can help you to quickly remove watermark from sheet in Excel. If the file you copy or import from other sources have been insert watermark, and in this case, you want to remove the watermark from the sheet. How to quickly remove watermark in Excel?
0 kommentar(er)
