"Ctrl+O" should open the Open File dialog box not the Recent File pane
"Ctrl+O" has been an incredibly useful keyboard shortcut for two decades. Changing its functionality and moving the old functionality to Alt, F, O, O is a huge detraction from the functionality of Excel.
I open 10 to 20 files a day. of those, only 3 tend to be files which were recently opened. When I open those, the Recent File pane is nice. When I open the other 17, the recent file pane is just wasting my time.
You can get Ctrl+O to open the dialog box and not the backstage by going to File > Options > Save > Save workbooks > Don’t show the Backstage when opening or saving files.
Check that box, and you’ll see the behavior you want.
Personally, since I like the backstage for some things, I’ve gotten used to using Ctrl+F12 to jump directly to the Open dialog, and F12 to jump directly to Save – so that’s another option for you.
4 commentsComments are closed
Da'ud Mitchell commented
Thank you Dan [MS],
I had recently changed PCs and this stared happening, I was going out of my mind. Luckily I came across this post else i way just have to quit me job and stop using excel.
Control-O is used in so many applications that remembering to switch to Control-F12 for Excel alone is not really a good option. But I did re-map Control-O to Control-F12 using keybindings to point to a sendkeys macro, so that's fixed for me, for now.
I must say that MS seems to have a vendetta going against keyboard-centric Excel users. I am no longer astonished, just weary, when exceedingly useful one-handed one-key keystrokes like alt-q and alt-z get assigned to new features that are so rarely needed by power users, and the useful features get buried behind 3 or 4 keys that require both hands. And there's no option to customize the keystrokes in the QAT to a scheme that has some mnemonic value. It's just dreadful. The application interface development seems to be targeted now at tablet-tapping folks who must be looking at reports that others prepare. Does anyone who does serious work with Excel do so with a tablet, or use a touch-screen?
Thank you Dan! Big help
Tom O commented
Replying to two year old posts but what the ****...
This is what drives me crazy about Microsoft. They have this "we know better" attitude when it comes to functionality. Stop it!
If you want to add a different way to do things add it without changing the old way. I do so many things using muscle memory and suddenly they don't work. Then you make us have to hunt and change things (if we even can!) to get things back. Why not make the new way Crtl-F12 and leave the old.