Nothing is more frustrating than spending hours creating a complicated Excel workbook only to have it destroyed by a power failure, a hard drive crash, or even human error. nĬhapter 7: Understanding Excel Files Safeguarding Your Work If you’d like a quick exit, without saving any workbooks, press Shift while you click the Don’t Save button. The dialog box has a Save All button, but it doesn’t have a Don’t Save Anything button. When you close Excel, you are prompted to save each workbook that hasn’t been saved. 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. This icon is visible only if the workbook window is not maximized. Double-click the Excel icon on the left side of the workbook’s title bar.Click the Close button (the X) in the workbook’s title bar.You can close a workbook by using any of the following methods:
EXCEL QUERY TABLE IN CLOSED WORKBOOK FREE
Closing WorkbooksĪfter you’re finished with a workbook, you can close it to free the memory that it uses. Alternatively, you can delete the files manually. This command simply deletes all unsaved files on your drive. If you accidentally forget to save a file, this command may help you out. This command displays the Open dialog box, pointed to the folder where Excel displays AutoRecover versions of workbooks that were not saved. For more information, see “Excel File Compatibility,” later in this chapter.Ĭlicking the Manage Versions button of the Versions section of the Info pane displays two options: This dialog box also appears when you save a workbook using an older file format. It displays a very helpful Compatibility Checker dialog box that lists potential compatibility problems. This command is useful if you need to save your workbook in an older file format. Reviewing the Available ActiveX Controls.Understanding the Different Web Formats.Working with External Reference Formulas.Using Formulas for Data Validation Rules.Types of Validation Criteria You Can Apply.Displaying a Sparkline for a Dynamic Range.User Interface Choices for Modifying Chart Elements.Understanding the Dimensions of an Array.Conditional Sums Using Multiple Criteria.Conditional Sums Using a Single Criterion.Creating Custom Views of Your Worksheet.Preventing Certain Cells from Being Printed.Copying Page Setup Settings across Sheets.Adding a Header or Footer to Your Reports.Using Named Styles for Easier Formatting.Adding a Background Image to a Worksheet.Entering Dates and Times into Your Worksheets.Entering Text and Values into Your Worksheets.