Contents
The Excel 2007 Interface
Keyboard Shortcuts in Excel 2007
How to Create New Spreadsheets and Open Existing Spreadsheets
How to Save and Close an Excel Spreadsheet
How to Navigate an Excel 2007 Spreadsheet
Basic Cell Operations in Excel
Excel Formulas and Functions
How to Use Excel’s Fill Feature
How to Sort Data in Excel
How to Format Cells in Excel
How to Format Excel Spreadsheets
How to Add Charts or Graphics to Excel Spreadsheets
How to Print Excel Spreadsheets
 |
Previous: How to Create New Spreadsheets and Open Existing Spreadsheets |
Next: How to Navigate an Excel 2007 Spreadsheet |
 |
|
 |
 |
 |
|
How to Save and Close an Excel Spreadsheet
Though Excel 2007 is less prone to crashes than previous versions, it’s still a good idea to save your work often.
How to Save Your Excel Spreadsheets
You can save your work in Excel using one of two commands: Save or Save As.
-
Save: This command saves an existing file under the same name. Open the Save As dialog box (see below) for a file you haven’t yet saved. Access the Save command through the Office button menu, the Save icon on the Quick Access Toolbar
or using the keyboard shortcut Ctrl+S. - Save As: This command allows you to save an existing file under a new name while preserving the original file under the old name. For example, you can use Save As to save different drafts of a spreadsheet you’re creating. Access the Save As command through the Office button menu. A Save As dialog box will appear; it will allow you to give the file a name, choose a folder to house the file, and select a file type (explained below).
File Types in Excel 2007
As opposed to the .xls files produced by old Excel versions, Excel 2007 saves files as either .xlsx, .xlsb, or .xlsm files.
- .xlsx: This is the default file type used by Excel to save a regular-sized document that does not contain macros (programming code included in an Excel file).
- .xlsb: Similar to .xlsx in that it doesn’t allow macros, this file type is designed for saving very large spreadsheets.
- .xlsm: This is the file type used by Excel to save documents that do contain macros.
Microsoft made this change in part to stop hackers from
exploiting macros to spread malicious software. If you
receive a .xlsx or .xslb file, you can feel comfortable opening it—but be suspicious of .xlsm files from unknown sources.
Compatibility and Excel’s New File Types
Older versions of Excel can’t open .xlsx, .xlsb, or .xlsm files. To save files compatible with older versions of Excel, use the Excel 97–2003 file type. When you save a file in this format, Excel also runs a check to make sure that your spreadsheet doesn’t contain any formulas or other items that previous Excel versions don’t support.
How to Close a Spreadsheet in Excel 2007
To close a spreadsheet, choose Close from the Office button menu or press Ctrl+W.
| Acknowledgments & Disclaimer |
