How do you save a spreadsheet in a different file format in Excel?
|
Click the File | Save To Multi-Sheet Excel File command to save some or all of the open worksheets to a multi-sheet Excel XLSX file. Select a file name and location in the Save To Multi-Sheet Excel File dialog. Then specify which open worksheets are included in the saved file in the Multi-Sheet Export Selection dialog. The active window must be a worksheet window to use the Save To Multi-Sheet Excel File command. The command is disabled when the active window is a plot document. Show Save To Multi-Sheet Excel File DialogThe Save To Multi-Sheet Excel File dialog is similar to the Save As dialog.
 Specify the file name and location in the Save To Multi-Sheet Excel File dialog. Save InThe Save in field shows the current directory. Click the down arrow to see the directory structure. Click on the folders to change directories. The buttons to the right of the Save in field allow you to create new folders and change the view of the file list. File ListThe File list displays the files using the extension specified in the Save as type box. A file can be overwritten by selecting it from the file list. File NameThe File name box displays the name of the selected file. Type the path and file name of the file to be saved. Select the file format in the Save as type box. File TypeWhen saving a multi-sheet Excel file, the Save as type field is XLSX Excel 2007 Spreadsheet (*.xlsx). Save and CancelClick Save to continue to the Multi-Sheet Export Selection dialog. Click Cancel to close the dialog without saving the worksheets. Multi-Sheet Export Selection DialogSelect which open worksheets will be included in the saved multi-sheet Excel file in the Multi-Sheet Export Selection dialog.
Select the worksheets you wish to save and edit the sheet names in the Multi-Sheet Export Selection dialog. Worksheet ListThe Multi-Sheet Export Selection dialog displays a list of open worksheets. The check box indicates whether the sheet will be included in the output file. The list displays the worksheet file name to the left of the exclamation point ' ! '. The sheet name with which the worksheet will be saved is displayed to the right of the ' ! '. By default the sheet name is the file name for single sheet Excel files and other data file types. The sheet name is the same for multi-sheet Excel files that are open in the worksheet. Selecting WorksheetsClick a worksheet name or check box in the worksheet list to check or uncheck the box. Worksheets with a check will be included in the output Excel file. Select or deselect multiple contiguous sheets by clicking the first desired sheet. Next hold SHIFT and click the last desired sheet. The boxes are either all checked or all unchecked between the clicked sheets. Click the Select / Deselect All check box to change the selection between all sheets and no sheets. The Select / Deselect All check box will display a check when all sheets are selected, a black square when some sheets are selected, and nothing when no sheets are selected. OK and CancelClick OK and the multi-sheet XLSX file is created. Click Cancel to close the dialog without saving the worksheets. See AlsoSave As Excel Files TranscriptIn this lesson we'll look at how to save an Excel workbook in a different format. Let's take a look. In order to save an Excel workbook to a different file format, you need to use the Save As command. You can access Save As in several different ways. One way is to go to the File tab and click the Save As command at the upper left. The Save As dialog box allows you to choose a location, a file name, and select a file type from a long list of file formats. You can also get to Save As using Save & Send. On the Save & Send screen, click Change File Type. This gives you a limited list of common file types. Select the file type you want, then click the Save As button. In the Save As dialog box, the file format will be pre-selected. Finally, you can use the keyboard shortcut F12 to access Save As. Excel 2010 provides a list of 27 file formats to choose from. These file types can be grouped into six categories - Excel formats, PDF and XPS formats, XML formats, text file formats, web file formats, and other formats. XLSX is the format of choice for Excel 2010 and 2007. If you need to share spreadsheets with Excel 2003 users, you'll need to use the XLS format. If you'd like to share your spreadsheet with someone who doesn't have a spreadsheet program, PDF is your best choice. It's a widely supported format available on many different platforms. If you need to import data from Excel into another program that can't read Excel files directly, a text format like CSV is probably the best choice. CSV files are simple text files, with commas separating values. When you save an Excel file to a format like CSV, Excel will display a warning about Excel features not supported in that format. After you click OK for any warnings, Excel will change the name in the window title to reflect the new file type. Keep in mind that you're now working in a new file. If you need to make changes, you probably should do so in the original Excel workbook, and then use Save As again to create an updated copy of the other file format. |
