Open Excel Files Faster
I’m not sure about you, but, sometimes I sort of miss the old days of Excel when Ctrl+O immediately displayed the Open dialog box. This dialog box allowed me to quickly navigate my computer and find the file I wanted to open. However, when Microsoft introduced the Backstage, this keyboard shortcut stopped displaying the Open dialog box. Instead, it displays the Backstage view. Now, don’t get me wrong, Backstage is a really nice enhancement, but…I miss my Ctrl+O shortcut! The good news is that there is a simple checkbox we can use to restore the Ctrl+O shortcut.
Before we get ahead of ourselves, let’s confirm our understanding and our objective.
Before Backstage was introduced, Ctrl+O caused Excel to display the standard Open dialog box, as shown below.
Now, using Ctrl+O opens Backstage, as shown below.
Our objective is to restore the Ctrl+O shortcut, but, still have Backstage available as needed. Can we do it? Yes, we have the technology.
To restore Ctrl+O, you want to head into the Excel Options dialog box (File > Options). Click Save on the left nav panel, and then check the “Don’t show the Backstage when opening or saving files” checkbox, as shown below.
Now, give it a try. Hit Ctrl+O…yes…the Open dialog immediately appears!
Don’t worry, Backstage can still be opened just by clicking the File tab with your mouse or pressing Alt+F.
That is one of the many little settings Microsoft provides in the Excel Options dialog box. If you have any other favorites, please share by posting a comment below…thanks!
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.