• Excel 2010 – startup

    Author
    Topic
    #507768

    When Excel 2010 starts up, and I click on the green File menu, the first tab to open is Info.

    In Word 2010, clicking on the blue File menu, the first tab is Recent, but I cannot find whether this is something that I set or whether this is the default.

    How can I find the setting on Excel to have the same behaviour as Word, i.e. clicking on File opens Recent as the first tab?

    Dell E5570 Latitude, Intel Core i5 6440@2.60 GHz, 8.00 GB - Win 10 Pro

    Viewing 3 reply threads
    Author
    Replies
    • #1586848

      John,

      Interesting! Both of mine open to Recent on both my desktop and laptop running 32 Bit Office 2010 Pro.

      46221-RecentDefault

      Looks like maybe something has changed on your system.

      HTH :cheers:

      May the Forces of good computing be with you!

      RG

      PowerShell & VBA Rule!
      Computer Specs

    • #1586867

      Hi John

      I checked my Excel2010 and Word2010 and they both exhibit the behaviour you reported.
      I will check my other PC’s shortly.

      ..maybe RG’s is a US version

      zeddy
      PS: Thanks for discovering antibiotics – I use them every day

    • #1586869

      Hi John

      Before I check my other PC’s, there are a couple of things you could do.

      1. Click your first tab Recent and then look at the bottom of the page for a checkbox that allows you to set the number of quick access recent workbooks. If you choose 4 as your number, then these will appear above the Info tab when you click File. (You will notice from RG’s screenshot that RG hasn’t ticked this checkbox)

      2. Add the ‘Open Recent File‘ command to your quick access toolbar. You will find it in the ‘Popular Commands’, ‘Commands not in Ribbon’ or ‘All Commands’ group. Clicking this in your QAT will take you directly to the Recent workbooks tab

      zeddy

    • #1586895

      RG – thanks for your thoughts, funny to think that Excel 2010 might behave differently on the other side of the Atlantic.

      Zeddy – many thanks for taking the time to look into your various Office installations. I have indeed checked the box under Recent, which allows me six recent files on both my Excel and Word screens; any more and the Exit button slides off the bottom.

      As you say, Open Recent File takes me to the same screen that I am hoping to open as the default on clicking the File button.

      Dell E5570 Latitude, Intel Core i5 6440@2.60 GHz, 8.00 GB - Win 10 Pro

      • #1587151

        Hi John

        So, instead of clicking on “File”, then “Recent” (two clicks), just click once on your “Open Recent” from the QAT.

        You can also right-click on the Excel icon in your windows taskbar to show a recent list of files.
        Actually, right-clicking on any program icon in the bottom windows taskbar will show a recent list of files for that program.

        With Excel, I believe that I read something somewhere that said Microsoft’s default behaviour was to show the Recent tab if there was no workbook open, and then show the Info tab once you had loaded or saved a workbook. Don’t know where to find that though. And when I start Exel2010 with a blank file, I still get Info tab rather than Recent when I click the File command in the Ribbon.

        zeddy

    Viewing 3 reply threads
    Reply To: Excel 2010 – startup

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: