Remove Page Watermark [Page Break Preview]

Q

Qull666

Dear All,

Is it possible to remove the page watermark AND maintain page break preview.

Why remove it?
Coz sometimes it blocks the information display.

I can't find a swith to turn it off, probably VBA codes could work, I think.

Thanks.
 
B

badeth

Hi!

if your watermark was created by setting the background of the worksheet,
you can just simply go to Format --> Worksheet --> Remove Background

but if your watermark was created tru headers, you can jst simply go to View
--> Headers and Footers then click the custom header and remove the image

hope it can help you!

thanks! ^_^
 
G

Gord Dibben

If you mean the large gray numbers, I have never heard of a way to remove those
while in pagebreak view mode.


Gord Dibben MS Excel MVP
 
J

Jim Cone

If it is the large number shown in the center of the page you are stuck with it.
You can use Print Preview on the File menu to view how the sheet will print.
That view has no page number superimposed on it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"[email protected]"
<[email protected]>
wrote in message
Dear All,
Is it possible to remove the page watermark AND maintain page break preview.
Why remove it?
Coz sometimes it blocks the information display.
I can't find a swith to turn it off, probably VBA codes could work, I think.
Thanks.
 
Q

Qull666

When we make presentation using the MS Excel (using a projector), the PAGE
mark just disturbs the view. I don't fancy Power Point. I am still an Excel
stubborn goon.

Thanks for clearing it Bad, Gord, Jim.
 
B

Bob I

You may "hide" the Page number by making the background the same shade
of gray. It's the center row selection if I recall correctly.
 
Q

Qull666

Thanks for the suggestion.

Hopefully one day there will be a switch or really lighten the watermark.
The page watermark is 40% grey.

Appreciate it!!
 
B

Bob I

You're welcome, have a good day!

Thanks for the suggestion.

Hopefully one day there will be a switch or really lighten the watermark.
The page watermark is 40% grey.

Appreciate it!!

:
Click to expand...
 
T

Tapper

I just ran into the problem with the large gray Page 1, Page 2, etc. If
that's what your problem is try View>Normal. That should get them off the
pages.
 
Top