Opening, Closing, and Saving Workbooks

Happy International Keyboard Shortcut Day. Today, three quick ones for dealing with workbooks.

: Shows the Open dailog box to open a file from disk. The menu is File – Open (Alt + F + O)

: 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.

: 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:

works to.

Bonus Material

: 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

only closes the active workbook. If you use use Excel 2013, leave a comment.

7 thoughts on “Opening, Closing, and Saving Workbooks

  1. Hi Dick,

    Happy International Keyboard Shortcut Day too!

    For explicitly calling File > Save As I like the F12 key shortcut.

    Are you going to suggest some keyboard shortcuts for those of us who are further advanced as well? Something less obvious perhaps? I like using Alt in combination with the Page Up/Down keys to assist with in-sheet movement (to supplement the Ctrl and arrow keys you mentioned previously). I’m also a big fan of Ctrl+# for applying my preferred date format.

  2. Excel 2013:

    closes the active workbook (just as it only closes the active document in Word).

  3. Does anyone freakout when asked if you want to save and you don’t recall if you made any changes or not?

  4. Have you got anything on the keyboard for Open Recent File – something I ues all the time with a QAT icon?

  5. AlexJ, for recent files, building on what Dirk said, I use Alt, F, R. The R is only needed if you’ve still got any workbooks open. Then you can use numbers to select the file that you want

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.