Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
raygeeknyc
 
Posts: n/a
Default Worksheet background text w/page numbers


Hi
I have a worksheet that I have inherited and it displays the text
"Page ##" on each page in the print area. I need to recreate this
effect but I cannot find out where it is specified.

It is not a series of background image, it centers vertically and
horizontally and is in gray (I assume a color was assigned to it
whereever the text was specified)

As you add or remove to the print area, new pages have the correct #.
I have looked in the header and footer and do not see it there.

Where is this being defined? Any ideas?

Thanks


--
raygeeknyc
------------------------------------------------------------------------
raygeeknyc's Profile: http://www.excelforum.com/member.php...o&userid=34570
View this thread: http://www.excelforum.com/showthread...hreadid=543387

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dominic LeVasseur
 
Posts: n/a
Default Worksheet background text w/page numbers

Perhaps you are in Page Break Preview.

Click View:Page Break Preview.

Does that help?

"raygeeknyc" wrote:


Hi
I have a worksheet that I have inherited and it displays the text
"Page ##" on each page in the print area. I need to recreate this
effect but I cannot find out where it is specified.

It is not a series of background image, it centers vertically and
horizontally and is in gray (I assume a color was assigned to it
whereever the text was specified)

As you add or remove to the print area, new pages have the correct #.
I have looked in the header and footer and do not see it there.

Where is this being defined? Any ideas?

Thanks


--
raygeeknyc
------------------------------------------------------------------------
raygeeknyc's Profile: http://www.excelforum.com/member.php...o&userid=34570
View this thread: http://www.excelforum.com/showthread...hreadid=543387


  #3   Report Post  
Posted to microsoft.public.excel.misc
raygeeknyc
 
Posts: n/a
Default Worksheet background text w/page numbers


Thanks, it was the view! :)


--
raygeeknyc
------------------------------------------------------------------------
raygeeknyc's Profile: http://www.excelforum.com/member.php...o&userid=34570
View this thread: http://www.excelforum.com/showthread...hreadid=543387

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP should compare numbers stored as text to plain numbers. VLOOKUP - Numbers stored as text Excel Worksheet Functions 0 March 31st 06 05:53 PM
How to change number to text in new column from another worksheet? Lynn Excel Worksheet Functions 3 November 16th 05 12:45 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM
Bring all text from "Text" worksheet Dradin Excel Discussion (Misc queries) 1 December 27th 04 08:37 PM
I enter numbers and they are stored as text burkeville Excel Discussion (Misc queries) 5 December 3rd 04 01:59 AM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"