+ Reply to Thread
Results 1 to 3 of 3

Same Info on Every Sheet

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    15

    Same Info on Every Sheet

    Is there a way to set up a workbook so that everytime you open a new sheet the colum headings are automatically on it. I am adding like 200 new sheets to my book and copy / pasting everyone is getting old.

    Thanks in advance!

    Lauren L

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,800

    Re: Same Info on Every Sheet

    Here is the information from Excel Help:

    Insert a new sheet that is based on a custom template
    1.If needed, create the worksheet template that you want to base a new worksheet on.
    How to create a worksheet template

    1.Select the worksheet that you want to use as a template.
    2.Click Microsoft Office Button , and then click Save As.
    3.In the File name box, type the name of the worksheet template.
    To create a custom worksheet template, type the file name that you want to use.
    To create the default worksheet template, type sheet.
    Note Custom templates are automatically saved in the Templates folder. The default worksheet template, sheet.xltx or sheet.xltm, should be saved in the XLStart folder, which is usually C:\Program Files\Microsoft Office\Office12\XLStart.
    4.On a computer that is running Windows Vista:
    In the list, click Excel Template or Excel Macro-Enabled Template.

    On a computer that is running Microsoft Windows XP:
    In the Save as type box, click Excel Template or Excel Macro-Enabled Template.
    5.Click Save.
    2.Right-click the sheet tab of a worksheet, and then click Insert.
    3.Double-click the template for the type of sheet that you want.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-15-2012
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Same Info on Every Sheet

    Thanks this helped alot!

+ 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