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



One thought on “Opening/Closing a Workbook(s)

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>