Using keyboard shortcuts
Opening a Workbook
To open a new workbook:
Press Ctrl+N.
To open a recently saved workbook:
Press Alt+F and then the number of the file, as shown in the recently used file list (at the bottom of the File menu).
To open a linked workbook:
1. Select the cell with the linked formula, and press Ctrl+[.
OR
1. From the Edit menu, select Links.
2. In the Edit Links dialog box, select the linked workbook and click Open Source.
To prevent a macro from running while opening a workbook:
Press the Shift key while opening.
Closing Workbooks
To close a workbook:
Press Ctrl+F4.
To close all open workbooks without closing Excel:
Press Shift, and from the File menu, select Close All.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
To close the current workbook the short cut key is Ctrl + W.This will automatically close the current active workbook