The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel 2010 default sheets

    Discussion in 'Windows OS and Software' started by fred2028, Jun 2, 2011.

  1. fred2028

    fred2028 Sexy member

    Reputations:
    196
    Messages:
    2,205
    Likes Received:
    1
    Trophy Points:
    56
    In Excel 2010, how do you set the # of worksheets that are created by default when you make a new file? Currently it is 3, I want to change it to 1.
     
    fred2028, Jun 2, 2011
    #1
  2. Pitabred

    Pitabred Linux geek con rat flail!

    Reputations:
    3,300
    Messages:
    7,115
    Likes Received:
    3
    Trophy Points:
    206
    Pitabred, Jun 2, 2011
    #2
  3. MidnightSun

    MidnightSun Emodicon

    Reputations:
    6,668
    Messages:
    8,224
    Likes Received:
    231
    Trophy Points:
    231
    There's an easier way, at least in Excel 2010: File > Options > General, and set the "Include this many sheets" value to 1.
     
    MidnightSun, Jun 2, 2011
    #3
  4. fred2028

    fred2028 Sexy member

    Reputations:
    196
    Messages:
    2,205
    Likes Received:
    1
    Trophy Points:
    56
    Oh hmm, I have that set, however if I right-click in Windows Explorer and go New > Excel it shows 3 sheets, but if I click the Excel app from my taskbar it shows 1 ...
     
    fred2028, Jun 2, 2011
    #4
  5. davepermen

    davepermen Notebook Nobel Laureate

    Reputations:
    2,972
    Messages:
    7,788
    Likes Received:
    0
    Trophy Points:
    205
    new -> excel in explorer is a preset file.. it then just creates a copy of that. and that file will most likely still have 3 sheets in.

    where are those stored again? hmm.. lets scan appdata :)
     
    davepermen, Jun 3, 2011
    #5
  6. newsposter

    newsposter Notebook Virtuoso

    Reputations:
    801
    Messages:
    3,881
    Likes Received:
    0
    Trophy Points:
    105
    If you're going to modify the default templates, be sure to create a new templates for both the older 97-2003 file format (.xlt) as well as the new 2007-2010 format (.xltx).

    If you use macro-enabled templates, you're going to need a new default .xltm file too.

    This will cover you no matter what you select as your default format.

    On vista/win7, user templates are kept in this directory:

    C:\Users\<username>\AppData\Roaming\Microsoft\Templates
     
    newsposter, Jun 3, 2011
    #6