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.
Go straight to browse when clicking File | Save as ...
-
- SilverLounger
- Posts: 2389
- Joined: 28 Mar 2010, 01:49
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- Administrator
- Posts: 12605
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Go straight to browse when clicking File | Save as ...
That is a useful shortcut, thank you
StuartR
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Go straight to browse when clicking File | Save as ...
It works in Word and PowerPoint too.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2389
- Joined: 28 Mar 2010, 01:49
Re: Go straight to browse when clicking File | Save as ...
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
JMT
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Go straight to browse when clicking File | Save as ...
Sheesh...
I don't think so.
I don't think so.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2389
- Joined: 28 Mar 2010, 01:49
Re: Go straight to browse when clicking File | Save as ...
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
JMT
-
- GoldLounger
- Posts: 3081
- Joined: 24 Jan 2010, 19:07
Re: Go straight to browse when clicking File | Save as ...
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?
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.
-
- SilverLounger
- Posts: 2389
- Joined: 28 Mar 2010, 01:49
Re: Go straight to browse when clicking File | Save as ...
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.
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
JMT
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Go straight to browse when clicking File | Save as ...
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.
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
Hans
-
- GoldLounger
- Posts: 3081
- Joined: 24 Jan 2010, 19:07
Re: Go straight to browse when clicking File | Save as ...
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.
-
- SilverLounger
- Posts: 2389
- Joined: 28 Mar 2010, 01:49
Re: Go straight to browse when clicking File | Save as ...
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"?
Is the page I am seeking to bypass called the "Backstage"?
Regards,
JMT
JMT
-
- Administrator
- Posts: 78484
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 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 ...
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.