Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: templates

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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


    ~Anne Troy

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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".

  4. #4
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  7. #7
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Correction, Thanks Chris.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •