Excel 2010 Bible

(National Geographic (Little) Kids) #1

Part I: Getting Started with Excel


156


l (^) Check Compatibility
This command is useful if you need to save your workbook in an older file format. It dis-
plays a very helpful Compatibility Checker dialog box that lists potential compatibility
problems. This dialog box also appears when you save a workbook using an older file for-
mat. For more information, see “Excel File Compatibility,” later in this chapter.


Versions section ......................................................................................................


Clicking the Manage Versions button of the Versions section of the Info pane displays two options:

l (^) Recover Draft Versions
This command displays the Open dialog box, pointed to the folder where Excel displays
AutoRecover versions of workbooks that were not saved. If you accidentally forget to save
a file, this command may help you out.
l (^) Delete All Draft Versions
This command simply deletes all unsaved files on your drive. Alternatively, you can delete
the files manually.


Closing Workbooks ..........................................................................................................


After you’re finished with a workbook, you can close it to free the memory that it uses. You can
close a workbook by using any of the following methods:

l Choose File ➪ Close.

l (^) Click the Close button (the X) in the workbook’s title bar.
l Double-click the Excel icon on the left side of the workbook’s title bar. This icon is visible
only if the workbook window is not maximized.
l Press Ctrl+F4.
l (^) Press Ctrl+W.
If you’ve made any changes to your workbook since it was last saved, Excel asks whether you want
to save the changes to the workbook before closing it.
Tip
When you close Excel, you are prompted to save each workbook that hasn’t been saved. The dialog box has a
Save All button, but it doesn’t have a Don’t Save Anything button. If you’d like a quick exit, without saving any
workbooks, press Shift while you click the Don’t Save button. Excel shuts down immediately. n

Free download pdf