Results 1 to 5 of 5

Thread: setting print areas
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2012
    Posts
    247
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default setting print areas

    Hi

    I have 7 documents in a worksheet.Each document range is A5:AB34 for document 1 , Document2 range is A36:AB65 etc..etc ...A 2 row gap between each document...How can i set a print area for each document ( 1 to 7 )....Can print areas named Document 1,Document 2 , Document 3 etc..etc... be saved into the "Name Box" so i can then just select which document to print from the Name Box?
    Also is there a way to have a watermark on each document (each sheet has a watermark say document 1,document 2 ,document 3 etc..etc..) but when each document gets printed it does not show the watermark on the printed sheet

    Thanks for any help

    Rich
    XL2010

  2. #2
    Board Regular
    Join Date
    Jan 2012
    Location
    CHENNAI , India
    Posts
    216
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: setting print areas

    Hi Rich ,

    The answer to your first question is YES. If you select the area A5:AB34 , you can type Document1 in the Name Box to assign this name to this area ; similarly , you can create other names such as Document2 , Document3 ,... to refer to the various other areas in your worksheet.

    When you wish to print , just select the name from the Name Box , so that the referred to area gets selected , and then click on Set Print Area.

    Regarding your second question , if your watermark is through WordArt , then just right click on the watermark to bring up the Size and Properties dialog box , select Properties , and uncheck the Print Object checkbox. Your watermark should not print now.

    Narayan

  3. #3
    Board Regular
    Join Date
    Sep 2012
    Posts
    247
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: setting print areas

    Hi Narayan
    Thank you for your help on print area.
    I have never created a watermark before.What steps do i use to create the Watermark please?
    Rich

  4. #4
    Board Regular
    Join Date
    Jan 2012
    Location
    CHENNAI , India
    Posts
    216
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: setting print areas

    Quote Originally Posted by rich_cirillo View Post
    Hi Narayan
    Thank you for your help on print area.
    I have never created a watermark before.What steps do i use to create the Watermark please?
    Rich
    Hi Rich ,

    It's explained well here ; can you check this link ?

    Little Known Secrets of Adding Watermarks in Excel 2010

    Narayan

  5. #5
    Board Regular
    Join Date
    Jan 2012
    Location
    CHENNAI , India
    Posts
    216
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: setting print areas

    Hi Rich ,

    One more link which explains how to insert a watermark in your Excel worksheet :

    Excel Blog - Tip: Add a watermark to an Excel worksheet

    Narayan

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
  •