4

In Excel 2013, it now takes 3 or 4 clicks to browse and open a file (File/Open/Computer/Browse). How I do add a shortcut to the top Quick Access Toolbar to take me directly to the "Browse" dialog?

The suggested Open shortcut simply takes you to the open backstage view - I'm hoping to avoid the backstage view altogether.

I can find the equivalent for "Save As", which is to add the shortcut to "Save As Other Formats" (you need to Customize the Quick Access Toolbar and select "All Commands").

Improve this question
0

6 Answers 6

Reset to default
9

CTRL+F12 gets the job done for me.

Improve this answer
1
  • Also works great for Office 2016 (365)
    – mischab1
    Commented Jan 22, 2018 at 18:41
8

Try this:

http://blog.contextures.com/archives/2013/01/24/show-the-file-open-window-in-excel-2013/

I can't believe someone thought making the backstage the default for something as simple as opening a file was a good idea. Way to complicate an otherwise simple process.

ETA cliffs notes as per comment below:

Click the File tab, and then click Options.
Click the Save category, and click "Don't show the Backstage when opening or saving files"
Click OK to save the settings
Improve this answer
1
  • I have unchecked "Don't show the Backstage when opening or saving files", however when I hit the Open button on the Quick Access Toolbar it still takes me to the backstage. (I don't have other versions of Office installed as mentioned in the article).
    – PeterX
    Commented Jul 23, 2013 at 23:58
2

Try Ctrl-O to go to the Open dialog - and F12 to get to the Save As dialog...

Improve this answer
1
  • Thanks for the answer, but I'd like to add a shortcut to the top-left Quick Access Toolbar that brings-up the Open File dialog directly. (And CTRL+O only opens the backstage Open view unfortunately). The F12 is quite handy though thanks.
    – PeterX
    Commented Feb 26, 2013 at 23:27
1

This is a bit clunky, but if you want to discard the mouse, you can go for: ALT+F > O > C > B. As mentioned above F12 is fastest way to "Save as..."

Once you memorize the combo it takes less than a second.

Improve this answer
1
  • But it takes longer than a second to wait for the UI to hurky jerky finally get you into the open (or save) dialog.
    – ErikE
    Commented Nov 10, 2015 at 23:16
0

It's very simple:

  1. Go into Options
  2. Click General
  3. Under "Startup Options" uncheck "Show the start screen when the application starts."
  4. Click OK.
Improve this answer
-2

in the quick access toolbar, at the top left of word/excel/pp, etc, use the arrow drop-down to add the individual shortcut buttons to the toolbar. Then just click the buttons.

Improve this answer
1
  • How I do add a shortcut to the top Quick Access Toolbar to take me directly to the "Browse" dialog?
    – PeterX
    Commented Jul 19, 2015 at 23:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .