Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101


Home > Lessons > Jan's CompLit 101 > Working with Numbers > Basics > Finish > Print - Defaults

Jan's Working with Numbers

    Excel Basics: Finish: Print - Defaults

Getting your spreadsheet onto paper is more complex than printing letters and reports. A single worksheet can be of any size from 1 cell to over 16 million cells. You must decide how you want itto be broken up into pages. There are quite a number of options.

The Appendix contains a general Pre-print checklist reference table. Not all items in this list will be important for every sheet you print, of course. The bigger the sheet, the more complex the printing. 


Icon Step-by-Step 

Step-by-Step: Print with the Defaults

 Icon Step-by-Step

What you will learn: to check sheet for printing
to print with defaults
to use Page Break Preview and Print Preview
to add a button to the Quick Access Toolbar
to print chart

Start with: Icon: Class disk, trips8-Firstname-Lastname.xlsx (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. Switch  to the Review tab and click on Spell Check Button: Spell Check (Excel 2010).Message: Do you want to continue checking at the beginning of the sheet? (Excel 2010)

    Excel checks spelling down the document from the current cell. If the current cell is not A1, you will see a message asking if you want to continue checking spelling from the beginning of the document. Usually you would want Excel to check the whole document.

  3. Click Yes.

    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.

  4. Dialog: Page Setup > Header/Footer - with header for trips8 (excel 2010)Open the Page Setup dialog,  Page Layout tab > Page Setup dialog box launcher Button: Dialog Box Launcher.
    Make corrections if necessary to the settings on all the tabs.

    Page - Portrait, 100%, Letter size

    Margins - top and bottom 1 inch, left and right 0.75 inch, header and footer 0.5 inch

    Header - Create a Custom Header with your name & date, file name - sheet name, Excel Project 2

    Sheet - all text boxes blank.  Page order: Down then over.

  5. Click OK to close Page Setup.
     
  6. Page Break Preview - all on one pageOn the Status bar click on the button for
    Page Break Preview Status bar: Page Break Preview (Excel 2010).

    The whole sheet fits neatly on one page.
     
    If the wide blue line leaves some cells with data outside, drag the lines to include the cells.

  7. Trips sheet after pre-print checkOpen Print Preview and check that all looks right.
    Icon: Excel 2007 Excel 2007: Office button Button: Office 2007 > Print > Print Preview
    Icon: Excel 2010 Excel 2010: File tab > Print 
  8. Print Print with the default settings.
    Icon: Excel 2007 Excel 2007: Button: Print - on Print Preview ribbon (Excel 2007) Print button on the Print Preview ribbon and then OK.
    Icon: Excel 2010 Excel 2010: Button: Print - Print Preview pane (Excel 2010) Print button to the upper left of the preview and then OK.
    Only the active sheet prints.
  9. Icon: Class diskSave As  trips9-Firstname-Lastname.xlsx  to your Class disk in the excel project2 folder.
    Icon: Full diskHow to handle a full disk
     

Add Button to Quick Access Toolbar

Are you tired of needing multiple clicks to get to Print Preview. You can add a button to the Quick Access Toolbar to go straight to it!

  1. At the top of the window, click the More button Button: More (Excel 2010) at the right end of the Quick Access Toolbar. Quick Access Toolbar - More button (Excel 2010)
    A list of buttons that are often added to the toolbar appears.
    A check mark by a name means that button is already on the toolbar.

    The default buttons are Save, Undo, and Redo (which changes to the Repeat icon when the action can be repeated in a different spot.

  2. Button: More - list dropped > Preview & Print (Excel 2010)Click on Icon: Excel 2007 Print Preview or Icon: Excel 2010 Print Preview and Print.
    A new icon appears at the right end of the toolbar. Quick Access Toolbar with Print Preview & Print button (Excel 2010)
     

Print: Chart Sheet

  1. Pie Chart sheet is active - chart is selectedClick on the tab Pie Chart - people to make it the active sheet. 
  2. If necessary, click on the chart to select it.
    There are resizing handles on the chart (gray dots on the chart border in the corners and middle of each side. .
     
    The Name Box shows "Chart 1". If you created the chart more than once, the number after 'Chart' will be larger than 1 even if you deleted those other versions of the chart.
     
  3. Pie Chart preview - chart was selectedOpen Print Preview with the new icon on the Quick Access Toolbar.
    The chart takes up the whole piece of paper. How unexpected!
    When you open Print Preview with the chart selected, Excel will print only the chart itself.
  4. Close Print Preview.
     
  5. Chart sheet - pie chart not selectedDeselect the chart by clicking on a cell outside the chart.
    No border and no handles should be showing around the chart.
    The Name Box shows the cell reference where you clicked.
     
  6. Pie Chart print preview of Sheet2- chart not selected, no headerOpen 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. <sigh> 

  7. Open Page Setup while still in Print Preview.
    Icon: Excel 2007 Excel 2007: Page Setup button on Print Preview ribbon
    Icon: Excel 2010 Excel 2010:
    link Page Setup to the lower left of the preview

    The Page Setup dialog opens.
  8. Click on the Header/Footer tab and create a custom header with your name, two spaces, the date in the Left section, File Dialog: Page Setup - showing header for Sheet2 (Excel 2010)name - Sheet name in the Center section, and Excel Project 2 in the Right section.
  9. Click on OK to close Page Setup.
     
  10. Chart sheet with headerPrint Click the Print button in the Print Preview window.
    The Print dialog opens. Use the default settings to print the active window.
  11. Click OK to print the chart sheet. 
  12. Icon: Class diskSave
     [trips9-Firstname-Lastname.xlsx]