Go straight to browse when clicking File | Save as ...

jmt356
SilverLounger
Posts: 2371
Joined: 28 Mar 2010, 01:49

Go straight to browse when clicking File | Save as ...

Post by jmt356 »

When I go to File | Save as ... using keyboard shortcuts in Excel, I come to a page that gives me an option to save to Recent, One Drive, This PC, Add a Place or Browse. I believe this page is called the Backstage, though I am unsure. How can I skip it and go straight to Browse and when select File | Save as ... using keyboard shortcuts?

In File | Options | Save, "Don't show the backstage when opening or saving files with keyboard shortcuts" is already ticked.
Regards,

JMT

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Go straight to browse when clicking File | Save as ...

Post by HansV »

Press F12.
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12577
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Go straight to browse when clicking File | Save as ...

Post by StuartR »

That is a useful shortcut, thank you
StuartR


User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Go straight to browse when clicking File | Save as ...

Post by HansV »

It works in Word and PowerPoint too.
Best wishes,
Hans

jmt356
SilverLounger
Posts: 2371
Joined: 28 Mar 2010, 01:49

Re: Go straight to browse when clicking File | Save as ...

Post by jmt356 »

F12 is a bit hard to remember. Is there a way to get alt + f + a to get me to the same Save as dialogue as F12 does?
Regards,

JMT

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Go straight to browse when clicking File | Save as ...

Post by HansV »

Sheesh...

I don't think so.
Best wishes,
Hans

jmt356
SilverLounger
Posts: 2371
Joined: 28 Mar 2010, 01:49

Re: Go straight to browse when clicking File | Save as ...

Post by jmt356 »

alt + f + a gets me straight to the browse portion of Save as... in Word. I don't recall what I did to get that setting to bypass the Backstage (if that is what it is called). There is probably a way to get it to work in Excel too.
Regards,

JMT

User avatar
Argus
GoldLounger
Posts: 3081
Joined: 24 Jan 2010, 19:07

Re: Go straight to browse when clicking File | Save as ...

Post by Argus »

It can be quite useful to learn some universal shortcuts that will work in any language versions, and all applications in the Office suite.
Alt+F(ile) isn't the same in all languages.

What's wrong with Ctrl+S or F12?
Byelingual    When you speak two languages but start losing vocabulary in both of them.

jmt356
SilverLounger
Posts: 2371
Joined: 28 Mar 2010, 01:49

Re: Go straight to browse when clicking File | Save as ...

Post by jmt356 »

alt + s saves the document. I want to get to the Save as... dialogue in the Browse location where the file is currently saved.

f12 does this, but it is hard to remember and f12 is a stretch from the keyboard, at least on my keyboard layout, whereas alt + f + a is located right where I am typing.

I think there is a way to achieve this in Office. I got it to work in Word, but I can't remember how. I am relatively confidant it would work in Excel too if I could just remember how I was able to bypass the Backstage in Word.
Regards,

JMT

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Go straight to browse when clicking File | Save as ...

Post by HansV »

In Word, you can assign a multi-keystroke shortcut to a command. I suspect that you have assigned Alt+F+A to the FileSaveAs action.

Excel does not support that - you can only assign a single key plus any combination of Ctrl, Alt and Shift. So what you want is not possible in Excel.
Best wishes,
Hans

User avatar
Argus
GoldLounger
Posts: 3081
Joined: 24 Jan 2010, 19:07

Re: Go straight to browse when clicking File | Save as ...

Post by Argus »

F12 has the benefit that it works in both, with one keypress, in different language versions, and thus in other peoples' computers as well, and it's no further away than the Enter key, usually. (Alt+F+A is Alt+A+M, in Swedish versions of Office; that said it works in Notepad as well.) The best way to learn something is to start using it.
Byelingual    When you speak two languages but start losing vocabulary in both of them.

jmt356
SilverLounger
Posts: 2371
Joined: 28 Mar 2010, 01:49

Re: Go straight to browse when clicking File | Save as ...

Post by jmt356 »

Hans, you are correct. I found alt+f+a programmed as a multi-keystroke command in Word in File | Options | Customize Ribbon | Customize … | File | FileSaveAs. It was programmed along with f12.

Is the page I am seeking to bypass called the "Backstage"?
Regards,

JMT

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Go straight to browse when clicking File | Save as ...

Post by HansV »

Yes, it is.
Best wishes,
Hans

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: Go straight to browse when clicking File | Save as ...

Post by Jan Karel Pieterse »

If you put the Save-as button on the Quick Access toolbar it'll behave the same as F12 if you check the box "Don't show the back stage when opening or saving files with keyboard shortcuts" in Tools, options, Save tab. If you make sure it is the button next to the autosave switch you can press alt+2 to save-as.
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com