Page 138 - Excel 2013 All-in-One For Dummies

120 Saving the Data
✦ Excel Template: Saves the workbook in the .xltx file format as an Excel template file that you can use to generate new workbooks contain- ing the same layout and content as the template.
✦ Excel Macro-Enabled Template: Saves the workbook in the .xltx tem- plate file format with all the macros (see Book VIII, Chapter 1) it contains enabled.
✦ PDF: Saves the workbook in an Adobe PDF (Portable Document File) format with the .pdf filename extension that can be opened with the free Adobe Reader program.
✦ XPSDocument:SavestheworkbookinanXPS(XMLPaperSpecification) file with the .xps filename extension used by many printers to render the data in a document, including Microsoft Office programs.
✦ OpenDocument Spreadsheet: Saves the workbook in ODF (OpenDocument Format) with an .ods filename extension that’s used by other Office suites of programs, particularly Sun Microsystems’s StarOffice suite.
Although less frequently needed, don’t forget that the Save As options include a number of text file conversions that you can use when your spreadsheet contains lists of data that you need to make available to pro- grams that can deal with strings of text data. The major difference between the various text file formats is what character they use to separate the data in each worksheet cell. So, the various Text (.txt) formats use tabs, the various comma-separated value (or CSV, .csv) formats use commas, and the various text (.txt) formats use spaces.
Changing the default file location
Whenever you select the Computer button on Save As screen in the Backstage view to save a new workbook file locally (as opposed to in the cloud on a SharePoint site or your SkyDrive), Excel 2013 automatically selects the folder listed in the Default File Location text box on the Save tab of the Excel Options dialog box (File➪Options➪Save or Alt+FTS).
If you don’t have a SkyDrive or don’t ever save workbook files in the cloud, you can prevent Excel 2013 from asking you to sign into your SkyDrive loca- tion when saving a new workbook by deselecting the Show Additional Places for Saving, Even If Sign-In May Be Required check box on the Save tab of the Excel Options dialog box. Also, if you prefer selecting the drive and folder into which to save your workbook files directly in the Save As dialog box, you can prevent Excel 2013 from initially displaying the Save As screen by selecting the Don’t Show the Backstage When Opening or Saving Files check box on this same tab of the Excel Options dialog box.