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.
Jeff, thank you for another great tip 🙂
On this note, the other behavior I really miss from 2007 was the ability to press Alt + F and then press a number key to open a recent file. I’m all about the keyboard shortcuts, and I haven’t found one in 2013 to open a recent file. My current approach is to right-click on my Excel jump list in my task bar or to press Alt + F and use the mouse to select a recent file, but… both of these require the mouse 🙁
Thanks. During the workday I open a lot of Excel files. It looks like i will save some time thanks to you.
Thank you! The Backstage feature (I didn’t know it was called that) has been driving me nuts for months.
Yes, same here; Thank you, Jeff!
Another step you can take is to reset the file’s data range— the area that Excel interprets as containing data, which mistakenly also includes cells that have been cleared of data. To do that, open your workbook and press Ctrl+End. If you’re taken way beyond your data, that indicates Excel considers even those apparently blank cells as part of the workbook’s data range, and those apparently empty cells artificially inflate the file.
Thanks!!!! The Backstage feature has been driving me crazy. So much quicker to open files this way!