1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Monthly Tabs

Discussion in 'Business Applications' started by spotts2244, Apr 2, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. spotts2244

    spotts2244 Thread Starter

    Joined:
    Sep 2, 2003
    Messages:
    75
    Is there a way to fill the tabs automaticaly with Months of the year or days of the week etc. i know how to do it across cells, but can not find a way across tab labels.

    thanks,

    Spotts
     
  2. jbcalg

    jbcalg

    Joined:
    Oct 29, 2001
    Messages:
    2,056
    make one yourself:

    - either as the default, or as a template to use when you want

    (from excel help, default, customize how excel starts - office xp))

    Create a template

    Decide which type of template you want:

    Workbook template

    Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting you want in new workbooks based on the template.

    Worksheet template

    Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.

    To display a picture of the first page of a template in the Preview box of the Templates dialog box (General Templates..., New Workbook task pane), click Properties on the File menu, click the Summary tab, and then select the Save preview picture check box.

    On the File menu, click Save As.

    In the Save as type box, click Template.

    In the Save in box, select the folder where you want to store the template.

    To create the default workbook template or default worksheet template, select either the XLStart folder or the alternate startup folder. The XLStart folder is usually

    C:\Program Files\Microsoft Office\Office10\XLStart

    To create a custom workbook or worksheet template, select the Templates folder, which is usually

    C:\Documents and Settings\user_name\Application Data\Microsoft\Templates

    Enter the name of the template in the File name box. Do one of the following:

    Workbook template

    Type book to create the default workbook template.

    To create a custom workbook template, type any valid file name.

    Worksheet template

    Type sheet to create a template for default worksheets.

    To create a custom sheet template, type any valid file name.

    Click Save, and then click Close on the File menu.
     
  3. spotts2244

    spotts2244 Thread Starter

    Joined:
    Sep 2, 2003
    Messages:
    75
    good idea jb, but is that long for no (ha,ha). seriously I like the idea.

    spotts
     
  4. jbcalg

    jbcalg

    Joined:
    Oct 29, 2001
    Messages:
    2,056
    lazy one ;)

    probably some vb code that would make 12 sheets, then rename each one accordingly

    but cranking out a template with the same shouldn't take too long

    if you already have one, could even copy, save as - avoid the rest
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/216944

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice