Opening/Closing a Workbook(s)

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+[.
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.


Leave a Reply

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

Terms and Conditions of use

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.