Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Yreka, California, USA
    Posts
    192
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Worksheet Templates

    Does anyone know how I can use a worksheet template internally in a workbook to use the same formatting on a number of worksheet. If I just copy I loose row and column widths. Anyone have any other suggestion on how to make all worksheets appear with the same format? I have a user who is wanting to keep all his budgets in one workbook, but also needs to keep the same format. All your ideas are welcome and thanks in advance. Judy
    Thanks much, Judy Crawford

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet Templates

    If you copy an entire row or column or the whole sheet and paste it, the column widths and/or row widths would go with it. You can also copy an entire sheet, and then do a Paste Special Formats to duplicate the formatting without changing the cell contents. You could also put code in the Workbook Newsheet event routine to copy the formatting from an existing sheet and paste it into the new sheet. Does any of that help?
    Legare Coleman

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Worksheet Templates

    Probably the simplest thing for your user to do would be to set up a blank worksheet with the formatting he wants. If Column or Row headings are the same for each sheet, they could be set up as well. Then any time a new sheet is needed, instead of inserting a worksheet, go to Edit, Move or Copy Sheet, and then make sure that Create a copy is ticked and select Move to end. Then name the new sheet as required.

    Andrew C

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Yreka, California, USA
    Posts
    192
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Worksheet Templates

    Thanks so much Andrew, why didn't I think of this. I appreciate your help so much. I'm indebted and can't even send cookies through cyberspace! Judy
    Thanks much, Judy Crawford

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Yreka, California, USA
    Posts
    192
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Worksheet Templates

    Thanks so much I tried your suggestions and they work well. Also tried Andrew's, and it is a great suggestion, too. So glad for this group and can't even reach you to let you know. Judy
    Thanks much, Judy Crawford

Posting Permissions

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