View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel 2002 : How to remove large page numbers ?

Cannot be changed.


Gord Dibben MS Excel MVP

On Mon, 8 Jun 2009 17:40:01 -0700, zaayin
wrote:

Hi.

Does anyone know if one can change the appearance of the "Page #" in the
background, i.e. can the colour or transparency of this object be changed?

Thanks,
Niyaaz

"Mike Rogers" wrote:

Mr. Low

You are in "Page Break Preview". This also allows you to re-size the page
so as to have your data together, instead of having it split by the page
break. Drag the blue lines to the configuration desired then goto "view" and
select "Normal" and you have stepped out. (You may need to play with this a
little because it will change the size of your printed page.) Back in
"Normal" view there might be a light dotted line indicating where your pages
will break. If you do not want these to be seen goto Toolsoptionsview
tab, and remove the check mark from "view page breaks". I hope this helps!

Mike Rogers

"Mr. Low" wrote:

Dear Sir,

I have a .xls file generated from a laptop computer. This file has large
page numbers (i.e. Page 1, Page 2 ...) at the centre of each worksheet. These
page numbers are blocking the content of the worsheet.

May I know how to remove them from the worksheet ?


Thanks

Low

--
A36B58K641