Excel 2010 For Dummies
Book image
Explore Book Buy On Amazon

As you work in Microsoft Excel 2010, remember to save your work often or you risk losing your data if the computer crashes or the power goes out. When you save an Excel workbook for the first time, you see the Save As dialog box. The appearance and functionality of the Save As dialog box varies depending on whether you're running Excel 2010 on Windows 7 or Vista or on Windows XP.

Saving an Excel 2010 workbook on Windows 7 or Vista

Follow these steps to save your workbook when running Excel 2010 on Windows 7 or Vista:

  1. Click the File tab and choose Save.

    The Save As dialog box appears.

  2. Click the Browse Folders button (with the triangle pointing downward) to expand the Save As dialog box if necessary.

    When you expand the Save As dialog box, the dialog box displays the Navigation pane, where you can select a folder.

    The Save As dialog box as it appears when running Excel 2010 on Windows 7.
    The Save As dialog box as it appears when running Excel 2010 on Windows 7.
  3. In the Navigation pane, select the folder in which you want to save the file.

    (Optional) If you want to save the workbook file inside a new subfolder within the folder currently open in the Save As dialog box, you can click the New Folder button on the toolbar and then type the name of the folder and press Enter.

  4. Type a descriptive name for the file in the File Name box.

  5. Click the Save button to save the file in the selected folder.

When the Save As dialog box is expanded, you can add tags to the new workbook file by clicking the Add a Tag link. You can then use this information later when you're searching for the workbook.

Saving an Excel 2010 workbook on Windows XP

Follow these steps to save your workbook when running Excel 2010 on Windows XP:

  1. Click the File tab and choose Save.

    The Save As dialog box appears.

  2. Click the Save In drop-down list button and select the folder in which you want to save the file.

  3. Type a descriptive name for the file in the File name box.

  4. Click the Save button to save the file in the selected folder.

You don’t have to use the Save As dialog box again unless you want to rename the workbook, save it in a different file format (using the Save As Type list), or save it in a different folder. To do any of these things, click the File tab and choose Save As. Otherwise, to save additional changes to the workbook, simply click the Save button on the Quick Access toolbar or press Ctrl+S.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: