Skip to main content

How to remove/hide page number watermark in Excel?

doc remove page number watermark 1
If you receive or import workbooks from other users or sources, some sheets of the workbook may contain page number watermark as below screenshot shown, which annoyed you. In this article, I give you some tricks to quickly remove or hide the page number watermark.
Hide page number watermark with Normal view
Insert or remove watermark with Kutools for Excelgood idea3

Hide page number watermark with Normal view

If you just want to hide the page number watermark, you only need to switch Page Break Preview to Normal View.

Click View > Normal, and then the page number watermark is hidden.
doc remove page number watermark 2

Also, you can click Normal button in the status bar to quickly switch to Normal view.
doc remove page number watermark 3


Insert or remove watermark with Kutools for Excel

Have you ever confused with inserting watermark in a sheet? If you have Kutools for Excel – a handy tool, you can quickly insert watermark as you need.

Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. 

After free installing Kutools for Excel, please do as below:

1. Click Kutools > Insert > Insert Watermark. See screenshot:
doc remove page number watermark 4

2. In the Insert Watermark dialog, you can specify insert picture watermark from a folder or text watermark with formatting you need. See screenshot:
doc kutools insert watermark 2doc kutools insert watermark 3

3. Click Ok or Apply, the watermark has been inserted in the current sheet.
doc kutools insert watermark 4

To remove the watermark you inserted by Kutools for Excel, you just need to click Kutools > Delete > Delete Watermark. See screenshot:
doc kutools insert watermark 5



quickly convert multiple XLSX. files to XLS or PDF. files in once time

In many cases, you may want to convert between XLSX and XLS, or convert a workbook to PDF file, but in Excel, you only can convert one workbook once time, have you ever imaged to convert multiple workbooks at once time? With Kutools for Excel's File Format Converter, you can quickly convert multiple workbook to pdf/97-2003 workbook/2007 or higher workbook at once and save them in a folder, at the same time, a converted report is generated!  Click for free full featured trial in 30 days!
doc file format
 
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (7)
Rated 5 out of 5 · 1 ratings
This comment was minimized by the moderator on the site
Perfect 👍🏻
Rated 5 out of 5
This comment was minimized by the moderator on the site
Thank you for the simple answer!
This comment was minimized by the moderator on the site
SU PUBLICACION FUE MUY UTIL ... ME TENIA CARDIACA ESA MARCA DE AGUA INCOMODA...GRACIAS
This comment was minimized by the moderator on the site
Muchas gracias! excelente artículo.
This comment was minimized by the moderator on the site
MUCHAS GRACIAS, ME FUNCIONÓ  
This comment was minimized by the moderator on the site
Huge thanks. Gracias!
This comment was minimized by the moderator on the site
Your Post Was Very Useful! Thank U!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations