Teach MeShow MeLet Me TryPrint

Opening and Closing Workbooks

Opening a file retrieves it from storage and displays it on your computer screen.

To open an existing workbook:

  1. Click the Open button on the standard toolbar.
  2. The Open dialog box appears; make sure the location in the Look in: box is correct.
  3. Select the workbook name in the large list box.
  4. Click the Open button in the dialog box.

Closing a workbook removes it from your computer screen and stores the last saved version for future use. If you have not saved your latest changes, Excel prevents you from losing work by displaying a dialog box that asks if you want to save the changes you made before closing. You must click one of the three options in the dialog box before Excel will close the workbook.

To close a workbook and save your latest changes:

  1. Click Close Window on the menu bar.
    Be careful not to click the Close button above the Close Window button — they look the same, but the Close button will exit the application.
  2. Click Yes in the dialog box.

Once you have typed or selected a workbook name, pressing the Enter key will also open the workbook. Another way to open the workbook is to double-click its name.

To open a workbook, you can also:

To close a workbook, you can also: