Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Let's save and open a worksheet

Let's save a worksheet

Let's save an Excel worksheet that we have created and edited. In Excel, when you interrupt your work or quit, you must "Save" or you will lose your work. When you "Save", the worksheet is saved as a "file" on your computer. Later, you can open the file, modify it and print it.

Let's save a worksheet using the following steps.

  1. Click the Save button (Save button).

    Quick Access Toolbar

    Click the Save button in the Quick Access toolbar.

  2. Specify the location where you want to save the worksheet.

    Save As dialog box

    Specify the location where you want to save the worksheet in the Save in box. The previously selected My Documents folder is displayed here.

    Save As dialog box

    "Book1" is entered in the File name box for you.

    To change the file name, type in a new file name.

    Save As dialog box

    Click Save.

  3. The worksheet is saved as a "file".

    File name

    The file name in the Title Bar changes from "Book1" to the saved file name.

  4. Check the location where the file was saved.

    Click the Start button (Start button), and then click My Documents.

    Select My Documents

    Let's check that the saved file is in the My Documents folder.

    My Documents folder

Tip: Characters that cannot be used in file names

Doctor Please note that the following characters cannot be used in a file name.
/ Slash
* Asterisk
| Hyphen
\ Back slash
? Question mark
: Colon
>< Less than or greater than sign
" Double quotation mark

Top of Page Top of Page

 

Let's open a worksheet

Let's open the file you just saved. Opening the file lets you resume your work.

Let's open the worksheet file using the following steps.

  1. Click the Start button (Start button), and then click My Documents.

    Select My Documents

    The saved file is in the My Documents folder.

    My Documents folder

  2. Double-click the file.

    The Excel startup screen appears, and the worksheet is displayed.

    Excel startup screen

    Worksheet is displayed

Tip: You can also use the Office Button's Open

Doctor When you click Excel's Office Button (Office Button), the Open command is in the menu that appears. You can use Open to open a worksheet.
  1. Click the Office Button (Office Button), and then click Open.

    Office Menu - Open

    Open dialog box

  2. Select the worksheet you want to open, and then click Open.

Tip: You can also open worksheets you have saved recently from "History"

Doctor When you click Excel's Office Button (Office Button), a list of recently saved files appears in the lower part of the displayed menu as "History". You can select a file from this "History" list, and open it.

Click Office Button (Office Button), and then select the worksheet file that you want to open from the "History" list.

Office Menu - History

Top of Page Top of Page

 
Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide
© 2009 Microsoft Corporation. All rights reserved. Legal | Trademarks | Privacy Statement
Microsoft