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!
If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.
Want to learn Excel?
Our Campus Pass includes access to our entire Undergrad and Masters catalog. Gamification ensures it is the most fun you can have learning Excel :)