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

Thread: Copying formatting of worksheets

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Eastbourne
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would be very grateful for any help on this topic. I would like to be able to copy the complete formatting of a worksheet to a new worksheet. For example, I have a credit card records workbook containing detailed records of my credit card transactions. The workbook contains a separate worksheet for each card. When I get a new credit card I obvoiusly need to create a new worksheet, and I like to keep them all standardised. Ideally, a template would be handy which would contain all the formatting and formulas for the new worksheet. I find it particularly boring to size all the columns, and I just know there must be a simple way around this.
    Thanks.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Make a copy of your worksheet in a new workbook.

    Remove any of the existing data that you don't want in your template.

    Save the "new" workbook as a template.

    Good luck

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
  •