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.

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! ^_^

" wrote:

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.

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

On Wed, 11 Jul 2007 20:18:00 -0700,
wrote:

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.

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)



"

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.

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.


"Gord Dibben" wrote:

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

On Wed, 11 Jul 2007 20:18:00 -0700,
wrote:

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.

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.

wrote:

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.


"Gord Dibben" wrote:


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

On Wed, 11 Jul 2007 20:18:00 -0700,
wrote:


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.

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!!

"Bob I" wrote:

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.

wrote:

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.


"Gord Dibben" wrote:


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

On Wed, 11 Jul 2007 20:18:00 -0700,
wrote:


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.

You're welcome, have a good day!

wrote:

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!!

"Bob I" wrote:


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.

wrote:


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.


"Gord Dibben" wrote:



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

On Wed, 11 Jul 2007 20:18:00 -0700,
wrote:



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.

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

"Jim Cone" wrote:


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)



"

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.