Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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").

share|improve this question
    
"File->Options->Save" then check "Don't show the Backstage when opening or saving files". –  Robino Mar 11 at 17:51

4 Answers 4

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
share|improve this answer
2  
Could you include some of what the link says within the answer in case the blog page goes dead or something. –  jonsca Jul 23 '13 at 17:18
    
Done. Thanks for the reminder. –  Ryan Jul 23 '13 at 22:41
    
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 Jul 23 '13 at 23:58

CTRL+F12 gets the job done for me.

share|improve this answer

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.

share|improve this answer

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

share|improve this answer
    
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 Feb 26 '13 at 23:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.