Open Excel 2013 With a Blank Template

If you’ve been using Excel 2013, you might enjoy seeing the collection of templates when you open Excel.

There is a blank template at the top left, and you can even take a tour of Excel.

excel2013templates01

There is a wide assortment of templates to choose from – everything from a balance sheet to a vacation checklist.

excel2013templates03

Turn Off the Start Screen

It was interesting to see those templates the first time that I opened Excel 2013, but 100% of the time I click on the Blank Template.

Instead of having to click on it, I’d like a blank template to open automatically. That would save me thousands of clicks each month, and at 1 second per click, that’s a huge time saver! (I just made those numbers up, so the actual time savings might be lower than expected.)

Fortunately, there is a way to turn off the template selection, and get right to work.

  1. Open Excel, and click the Blank Template, to go to the Excel window.
  2. Click the File tab, and click Options, at the bottom of the list at the left.
  3. In the Options window, click the General category
  4. Scroll down to Start up Options, and remove the check mark from ‘Show the Start screen when this application starts’
  5. Click OK, to close the Options window.

excel2013templates02

Now get to work!

______________

17 comments to Open Excel 2013 With a Blank Template

  • What irritates me are the two extra clicks I need when opening a file, to get to the current directory. Why did they remove "Recent Places"?

    • Patrick, I added the Open button to the QAT, and when I click that, Recent Places appears under Favorites.

      • I don't get that, Debra. The Open button just gives the same Open dialog as from the File menu:
        Recent Workbooks, SkyDrive, Other Web Locations, Computer, Add a Place

        "Add a Place" only offers Office 365 SharePoint and Skydrive.
        If I could add "Favorites" to that, that would work.

        I added an open folder button linked to this macro in my PERSONAL.XLSB

        Sub OpenFile() ' the traditional Open file dialog, three clicks away in Excel 2013
        Dim FileName As Variant
        FileName = Application.GetOpenFilename("Excel files (*.xl*),*.xl*,All Files (*.*),*.*")
        If TypeName(FileName) = "String" And Len(FileName) > 0 Then
        Application.Workbooks.Open (FileName)
        End If
        End Sub

        • Patrick, if you still have Excel 2010 installed, try this:

          - Open Excel 2013, and add the standard Open button on the QAT
          -- if you point to that button, the screen tip will say "Open"
          -- if you click on that button, it opens the Backstage view
          - Keep Excel 2013 open, and open Excel 2010
          - Open Excel 2010, and add the standard Open button on the QAT
          -- if you point to that button, the screen tip will say "Open (Ctrl + O)"
          -- if you click on that button, the Open dialog opens
          - Close Excel 2010, and the button on the Excel 2013 QAT has changed to the Open (Ctrl + O) button

          It's a bug, I guess, from having multiple versions installed, and the QAT gets confused. It works for me though!

  • THANK YOU - THANK YOU - THANK YOU

  • Thanks Deb. I can't believe that I didn't think to look for an option to turn off those templates. It is a relief to be back to normal.

  • Wow - thanks a lot for that information!! As you mention yourself the templates are only interesting the first time you start excel. Did on my work computer alread. Such a small setting made a big impact :)

    Thanks again for this little neat trick!

    Kindest
    Peer

  • Michael (Micky) Avidan

    Dear Debra & Patrick,

    If I'm not mistaken there is a dedicated Icon to quick enable the Recent files list.

    I think I added it myself to the QAT.

    To clarify my point - here is a link to a snap-shot:

    http://jpg.co.il/view/5123e54282276.png

    Michael Avidan
    “Microsoft®” MVP – Excel
    ISRAEL

  • william

    Currently i'm using excel templates 2010, but your post forcing me to get new updated excel version.

    Thanks Debra Dalgleish for this informative details

  • Ed Solem

    Is there any way to make personal templates the default instead of featured templates?
    I never use the featured templates.

    • Margaret

      I was looking for what Ed was - a way to default to personal templates.

      I changed my options to show a blank excel worksheet when I open Excel - thanks for that - and I added the "New..." icon to my Quick Access toolbar so that I could quickly bring up templates. But I always want MY templates, never what Microsoft recommends.

  • Linda Nelson

    I love when such an excellent, detailed instruction is given to perform a task. Thank you!

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>