templates

ford

New Member
Joined
Apr 1, 2002
Messages
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?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
He goes to his View menu and chooses *Page Break Preview*.

:)
 
Upvote 0
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".
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top