Excel Essentials - Printing and Exiting

Printing a Worksheet

You may want to print your worksheet when you’ve finished working with it. This will give you a hard copy of your data to look over and to share with others. Best of all, you can get a quick printout of the active worksheet very easily.

Method

To print a worksheet:

1. Click the FILE button and choose the Print button.

Exercise

In the following exercise, you will print a worksheet.

1. Click the FILE button and choose the Print button. [The PRINT dialog box appears].
2. Select the printing options you require. [Click the PRINT button. The worksheet is printed.]

Closing a Workbook and Exiting from Excel

Closing a workbook removes it from your screen but leaves you in Excel so that you can keep working. Before you close a workbook, you should make sure that you’ve saved your work. If you’ve forgotten, however, Excel reminds you that you need to save the document and gives you a chance to do so. You can exit from Excel after you have saved and closed any open workbooks.

Method

To close a workbook:

1. Click the workbook Window Close button.
   or
2. Click the FILE button and choose Close.
3. Save the file if prompted.

To exit from Excel:

1. Click the application Close button.
   or
2. Click the FILE button and click the Exit Excel button (bottom right).
3. Save the file if prompted.

Exercise

In the following exercise, you will close the Orchard Report Draft workbook and exit Excel.

1. Click the workbook Window Close button. [Save As appears].
2. If a message appears asking you if you would like to save the changes to the workbook file, choose Yes. [The workbook closes].
3. Click the application Close button. [Excel closes].

Assignment

1. Load Excel.
2. Select cell C3 with the keyboard.
3. In cell C3, enter Cathy’s Computers.
4. In cell C4, enter Sales Report.
5. Using the keyboard, select the range B6:E6.
6. Using Figure 1-11 as a guide, enter the years in the range B6:E6.
7. Select the entire worksheet.
8. Use the mouse to select the range A7:A10.
9. Using Figure 1-11 as a guide, enter the product names into the range A7:A10.
10. Enter zeros in the range B7 through B10.
11. Using a range, enter the data for 2007, 2008, 2009 and 2013.
12. Adjust the width of column A so you can read the text clearly.
13. Select the nonadjacent cell ranges B6:E6 and A7:A10.
14. Save the worksheet in the Data folder on the C: drive as Cathy’s Computers.
15. Save cells A1:E10 in the Data folder as an HTML document (with no title or header) with the name Cathy.htm.
16. In cell A11, enter Yearly Total.
17. Use Save As to save the workbook again. Use the file name Cathy’s Computers Draft.
18. Print the worksheet.
19. Close the workbook, and then exit Excel.