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