Saving a Workbook Under a New Name or Location

Saving a Workbook Under a New Name or Location

There might be an occasion when you want to save a copy of a particular workbook under a different name or in a different location. Excel makes it easy for you to make duplicates of a workbook. Follow these steps:

1. Select the File menu and select Save As . The Save As dialog box opens, just as if you were saving the workbook for the first time.

2. To save the workbook under a new name, type the new filename over the existing name in the File Name text box.

3. To save the new file on a different drive or in a different folder, select the drive letter or the folder from the Save In list.

4. To save the new file in a different format (such as WK4, which is a Lotus 1-2-3 format), click the Save As Type drop-down arrow and select the desired format.

5. Click the Save button or press Enter .

Saving Excel Workbooks in Other File Formats Occasionally, you might share Excel workbook data with coworkers or colleagues who don't use Excel. Being able to save Excel workbooks in other file formats, such as Lotus 1-2-3 (as discussed in step 4), enables you to provide another user a file that they can open in their spreadsheet program.