+ Reply to Thread
Results 1 to 2 of 2

Setting up page template

  1. #1
    John Sullivan
    Guest

    Setting up page template

    How do you set up a page template so that when I go to print a worksheet, I
    don't have to reset the orientation as landscape, reset margins, and the
    like? I have a workbook, and everytime I add a worksheet, I now copy another
    worksheet and paste it on the new worksheet, but all of the page set up
    formatting is at default on the new page.

  2. #2
    Chip Pearson
    Guest

    Re: Setting up page template

    Create a workbook template named Sheet.xlt with a single
    worksheet. Set up your printing preferences on this worksheet and
    save the file in your XLStart directory (typically C:\Program
    Files\Microsoft Office\Office\XLStart).

    Excel will use this as a template when creating new worksheets.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com



    "John Sullivan" <[email protected]> wrote in
    message
    news:[email protected]...
    > How do you set up a page template so that when I go to print a
    > worksheet, I
    > don't have to reset the orientation as landscape, reset
    > margins, and the
    > like? I have a workbook, and everytime I add a worksheet, I now
    > copy another
    > worksheet and paste it on the new worksheet, but all of the
    > page set up
    > formatting is at default on the new page.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1