MS Excel Chapter 13: Saving and Exporting Files
- Daniel LaGrow
Instructions
Section 13.1: Saving Excel Files
Check your spelling by clicking the Review Tab then click Spelling.
Preview the print layout by clicking File > Print. View how the sheets will appear when printed.
Set the print area by highlighting the range of cells you want printed. In the Page Layout tab, select Print Area, then Set Print Area.
Fill out the metadata/properties.
Give the file a clear name with no special characters.
Section 13.2: Exporting Excel Files as a PDF
Save your file.
Click File, Save As, and choose a location for saving.
In the “Save as type” drop-down menu, select PDF. Below this, you will have to fill out the fields for Authors, Tags, Title, and Subject.
Click the Options button. Specify the Page Range, and Publish What sections as needed. Under Include non-printing information, check “Document properties” and “Document structure tags for accessibility”.
Hit OK.
Most of the document should be correctly tagged, including table structure and link tagging. However, you will likely need to go in and do some manual touch-ups. Automatic tagging is not perfect and (for now, at least) always requires manual checking.
Section 13.3: Exporting an Excel File as HTML
Save your file.
Click File, Save As, and choose a location for saving.
In the “Save As Type” dropdown menu, select Web Page or Single File Web Page.
Section 13.4: Exporting Excel Files as a CSV File
Overview: A CSV file is a Comma Separated Values file that stores data in a basic table structured format. The values are separated by commas, hence the name. It does not store any type of formatting and can only contain a single sheet. CSV files are compatible across all spreadsheet programs and can also be created and opened with any text editor.
To save as a CSV file, click File, Save As.
Choose the location for saving.
From the drop-down menu for "Save as type," select CSV.