Click the Watermark icon. Select a pre-designed watermark and it will be automatically added, or select Custom Watermark for more options including text and images. To remove: Select the Design tab in the Ribbon. Click the Watermark icon. Click Remove Watermark. Fortunately these watermarks in Excel 2013 spreadsheets can be removed with a few steps. The steps in this guide were written using Microsoft Excel 2013. This guide assumes that you currently have a watermark on your spreadsheet, and that you wish to remove it. 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. Firstly you need to switch to Page Layout view to view the watermark, click View > Page Layout. See screenshot: 2. Then click Home > Find & Select > Go To Special. Best universal media player for mac. See screenshot: 3. In the Go To Special dialog, check Object option, then click OK to close the dialog. Then you can see the Art Word watermark have been selected, press Delete button to remove the watermark. See screenshot: Tip: With this method, the other objects, such as pictures, shapes will be also removed. Remove watermark with Header & Footer function If the watermark is inserted as header/footer, you need to do as below steps: 1. Firstly, you need to go the Page Layout view by clicking View > Page Layout. Then click Insert > Header & Footer to show headers and footers. See screenshot: 3. Then you can see there is a text “ &[Picture]” in the header or footer, delete this text, and then, the watermark of the whole sheet has been removed. See screenshot: Insert/remove watermark with Kutools for Excel Actually, 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. With more than 120 handy Excel functions, enhance your working efficiency and save your working time. After Kutools for Excel, please do as below: 1. Enable the sheet you want to insert watermark, and go to Page Layout view by click Page Layout button in the status bar. See screenshot: 2. Click Kutools > Insert > Insert Watermark. See screenshot: 3. Free hidden object games online for mac no download. In the Insert Watermark dialog, you can import a picture as watermark in A part, or specify a text with the formatting you want in B part. See screenshot: 4. Click Apply or Ok, and the watermark has been inserted. Remove watermark Enable the sheet you want to remove its watermark, and click Kutools > Delete > Delete Watermark. See screenshot: Demo. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful: • Merge Cell/Rows/Columns without Losing Data. • Combine and Consolidate Multiple Sheets and Workbooks. • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter, • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |