Excel Basics:
Print Defaults

Step-by-Step: Print

---

What you will learn:

to check sheet for printing to print with defaults to print chart

---

Start with: , trips8.xls (saved in previous lesson)

Print: Defaults

1. Click on the tab for Sheet1 to make it the active sheet.
    If cells are selected, click on a cell to remove the selection.
    
2. Spell Check. ( Tools  |  Spelling ) Many of the names in the Customer column will be unknown to Excel's dictionary. Look carefully to see if you've typed the name in correctly. Do not add these names to the dictionary.
    
3. Select  File  |  Page Setup... . Verify the settings on all the tabs.

   Page - Portrait, 100%, Letter size

   Margins - top and bottom 1 inch, left and right .75 inch, header and footer .5 inch

   Header - name & date, file name - sheet name, Excel Project 2

   

   Sheet - all blank except Page order: Down then over.
    

4. Click OK to close Page Setup.
    
5. On the menu select  View  |  Page Break Preview 

   The whole sheet fits neatly on one page.
   
   

6. Click on Print Preview and check that all looks right. Close Print Preview.
    
7. Print by clicking the Print button. Only the active sheet prints.
   

---

Print: Chart sheet

1. Click on the tab Pie Chart to make it the active sheet. 
    
2. If necessary, click on the chart to select it. There are resizing handles on the chart and the Name Box shows "Chart Area".
   
    
3. Click on Print Preview. The chart takes up the whole piece of paper. How unexpected!
    
4. Close Print Preview.
   
    
5. Deselect the chart by clicking on a cell. No handles should be showing around the chart. The Name Box shows the cell reference where you clicked.
   
    
   
6. Click on Print Preview. Now the chart is in the upper left of the page. Much smaller. But, there is no header showing! You must set the header separately for each sheet in a workbook or else group the sheets and then set the header.

   If your chart takes up the whole sheet, it was selected when you went to Print Preview. Return to Normal view and click off the chart. Try again.

7. Click on the Setup… button in Print Preview. The Page Setup dialog opens. Click on the Header/Footer tab and create a custom header with your name, two spaces, the date in the Left section, File name - Sheet name in the Center section, and Excel Project 2 in the Right section. Click on OK to close Page Setup.

8. Click the Print button in the Print Preview window. The Print dialog opens. Use the default settings to print the active window. Click OK to print the chart sheet.

   
   

9. Save As  trips9.xls 
   How to handle a full disk