• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Lesson 2. Creating and Opening Workbook Files > Opening an Existing Workbook

Opening an Existing Workbook

If you have a workbook you've previously saved that you would like to work on, you must open the file first, before you can make any changes. Follow these steps to open an existing workbook:

  1. Open the File menu and select Open, or click the Open button on the Standard toolbar. The Open dialog box shown in Figure 2.2 appears.

  2. If the file is not located in the current folder, open the Look in drop-down list box and select the correct drive and folder.

    Alternatively, you can switch to several common folders by clicking the appropriate icon on the Places bar:

    History. This folder contains links to as many as 50 of your most recently used documents.

    My Documents. The default folder for your Office programs; you'll probably find most of your documents here.

    Desktop. From here, you can access any folder on your computer.

    Favorites. If you use certain files a lot, you can save them to the Favorites folder, and then quickly open them by clicking this icon.

    Web Folders. This folder contains links to folders on your company's intranet, or on the Internet. You can use this icon to quickly open documents you've published to the Web or to your company's intranet.

    Select the file you want to open in the files and folders list. Or, type the name of the file in the File name box. (As you type, Excel highlights the first filename in the list that matches your entry; this is a quick way to move through the list.)

    To see a preview of the workbook before you open it, click the Views button and select Preview. Excel displays the contents of the workbook in a window to the right of the dialog box.

  3. Click Open or press Enter. There are other open options, if you click the arrow on the Open button:

    • To open the workbook as a read-only file (to prevent you from accidentally changing data), click the arrow and select Open Read-Only.

    • To open a copy of the workbook so that you can create a similar workbook without changing the original, click the arrow and select Open as Copy.

    • To open an HTML document in your Web browser instead of within Excel, click the arrow and select Open in Browser.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint