Opening, Closing, and Saving Workbooks
Happy International Keyboard Shortcut Day. Today, three quick ones for dealing with workbooks.
Ctrl+O: Shows the Open dailog box to open a file from disk. The menu is File – Open (Alt + F + O)
Ctrl+S: Saves the active workbook. If the active workbook is previously unsaved, shows the Save As dialog to choose a location to save to. The menu is File – Save (Alt + F + S) for Save and File – Save As (Alt + F + A) for Save As.
Ctrl+W: Closes the active workbook. Actually it closes the active window, but if you only have one window open, the workbook is closed. If the workbook is unsaved, Excel will prompt you to save it. The menu File – Close (Alt + F + C). Fun fact: Ctrl+F4 works to.
Bonus Material
Alt+F4: Closes the Excel application. Excel will prompt you for any unsaved workbooks. I still use Excel 2010, so I have no idea how the SDI works in 2013. I imagine Alt+F4 only closes the active workbook. If you use use Excel 2013, leave a comment.