templates

ford · Apr 2nd, 2002, 08:19 PM

I co-worker is using excel with a big Page 1, Page 2 and so on these pages are darkendand are used as the work sheet. I've been watching him work with these for a while. I don't want to ask the office jerk how he does this so I'me asking here. How does he do this?

Anne Troy · Apr 2nd, 2002, 09:06 PM

He goes to his View menu and chooses *Page Break Preview*.

ford · Apr 2nd, 2002, 09:19 PM

No NO No He is actually working on his work sheet tha active page with boarders are darkened with a water mark like "Page 1".

Joe Was · Apr 2nd, 2002, 09:30 PM

You can add a watermark as a background graph in Excel. Try:

On the Format menu, point to Sheet, and then click Background.
Select the graphics file to use for the background pattern.

Create the graphic with Word or Paint.
You may need to play with your graphic, as it may want to fill the whole background? JSW

Chris Davison · Apr 3rd, 2002, 10:51 AM

Ford,

Dreamboat is spot on once again.... I use this all the time (must be an office jerk thing!)

go to print preview and then select "page break preview", it will darken all the non-print range and put in big "page 1" and "page 2" on your working area.

Then you just carry on working as normal with this enhanced viewing mode.

(From memory, it a bit like WYSIWIG in Lotus)

try it !

_________________
Hope this helps,
Chris

edit... bloody acronyms, I meant "WYSIWYG"

[ This Message was edited by: Chris Davison on 2002-04-03 09:53 ]

ford · Apr 3rd, 2002, 03:15 PM

Sorry Dreamboat. Thanks for clearing this up for me, Joe. It works.

ford · Apr 3rd, 2002, 03:17 PM

Correction, Thanks Chris.

Apr 2nd, 2002, 09:06 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	He goes to his View menu and chooses Page Break Preview. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 08:19 PM	#1
ford New Member Join Date: Apr 2002 Posts: 4	I co-worker is using excel with a big Page 1, Page 2 and so on these pages are darkendand are used as the work sheet. I've been watching him work with these for a while. I don't want to ask the office jerk how he does this so I'me asking here. How does he do this?

Apr 2nd, 2002, 09:19 PM	#3
ford New Member Join Date: Apr 2002 Posts: 4	No NO No He is actually working on his work sheet tha active page with boarders are darkened with a water mark like "Page 1".

Apr 2nd, 2002, 09:30 PM	#4
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	You can add a watermark as a background graph in Excel. Try: On the Format menu, point to Sheet, and then click Background. Select the graphics file to use for the background pattern. Create the graphic with Word or Paint. You may need to play with your graphic, as it may want to fill the whole background? JSW

Apr 3rd, 2002, 10:51 AM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Ford, Dreamboat is spot on once again.... I use this all the time (must be an office jerk thing!) go to print preview and then select "page break preview", it will darken all the non-print range and put in big "page 1" and "page 2" on your working area. Then you just carry on working as normal with this enhanced viewing mode. (From memory, it a bit like WYSIWIG in Lotus) try it ! _________________ Hope this helps, Chris edit... bloody acronyms, I meant "WYSIWYG" [ This Message was edited by: Chris Davison on 2002-04-03 09:53 ]

Apr 3rd, 2002, 03:15 PM	#6
ford New Member Join Date: Apr 2002 Posts: 4	Sorry Dreamboat. Thanks for clearing this up for me, Joe. It works.

Apr 3rd, 2002, 03:17 PM	#7
ford New Member Join Date: Apr 2002 Posts: 4	Correction, Thanks Chris.