Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Excel Shortcuts To Open, Close & Save Workbooks

February 29, 2016 by terp Leave a Comment

Here’s a quick look at three sets of Excel shortcuts for (1) opening, (2) closing and (3) saving workbooks.

Excel Shortcuts For Opening Workbooks

Open Workbook (keyboard): Ctrl+O (this requires the right hand but I’m unaware of any left-hand only shortcut)

Ctrl+O works fine, but there’s a faster way if you’re opening a file that you recently had open (which, for me, is 95% of the time).  Using this method, you can avoid wading through directories, thus saving some time.  What is this method?  Simple: go to the list of Recent Workbooks on the File tab, as shown below:

excel-open-recent-files

Luckily, the shortcut to get there is a quick left-hander (after you type it in, you can either just click on the file name as it appears in the list, or type in the keyboard accelerator — e.g., “Y1” or “Y2”):

Open Recent Files (keyboard): Alt-F-R

Learn more about pervasive Alt shortcuts like the one above (you can do pretty much anything with them).

If you’re an Excel beginner, check out my free one-hour online video course with shortcuts for Save, Copy, Paste, Cut, Undo, Redo, Bold, Italics, Underline, Find and Replace.

 

Excel Shortcuts For Saving Workbooks

For saving files, let’s review five shortcuts — two for “regular” Save, two for Save As and one for Save And Send (for emailing attachments):

Save (keyboard #1): Ctrl+S (very fast, easy to memorize and hard to beat)

For those who like to be different, here’s a slower one that uses an Alt sequence:

Save (keyboard #): Alt-F-S

Here are the two Save As shortcuts — the first is left-hand only (but three keys), while the second is right-handed (but only one key), so you can take your pick (I prefer the first one):

Save As (keyboard #1): Alt-F-A

Save As (keyboard #2): F12

Finally, here’s a nifty shortcut for “Save and Send” — when you want to send a file by email:

Save And Send (keyboard): Alt-F-D-A

 

Excel Shortcuts For Closing A Workbook

To wrap up this post, here are two keyboard shortcuts for closing a workbook — they’re both left-hand-only, and I prefer the first one since it’s one fewer keystroke:

Close Workbook (keyboard #1): Ctrl+W

Close Workbook (keyboard #2): Alt-F-C

 

Did I miss any of your favorites?

P.S. Learn how to discover thousands of Alt shortcuts like the ones above.

Filed Under: Alt Shortcuts, Excel Shortcuts, Save Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel