{"id":138,"date":"2024-05-10T12:56:37","date_gmt":"2024-05-10T12:56:37","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-10-charts\/"},"modified":"2024-09-18T00:54:00","modified_gmt":"2024-09-18T00:54:00","slug":"chapter-10-charts","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-10-charts\/","title":{"raw":"Chapter 10: Printing","rendered":"Chapter 10: Printing"},"content":{"raw":"
\r\n
\r\n

Learning Objectives<\/p>\r\n\r\n<\/header>\r\n

\r\n
    \r\n \t
  1. Insert header and footer.<\/li>\r\n \t
  2. Set print area.<\/li>\r\n \t
  3. Print a worksheet.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<\/div>\r\n

    <\/p>\r\n

    In this last chapter, you will learn how to insert a header and footer to a worksheet, set the print area, and print a worksheet.<\/p>\r\n

    You can add or edit a header or footer to a worksheet. For example, you can create a header that has your company\u2019s name and a footer that has page numbers, the date, and the name of your workbook.<\/p>\r\n

    Let\u2019s open a workbook from Chapter 7, and open a worksheet called Fruits. To insert a header or a footer to this worksheet, click the Insert tab, then click the Text button and the Header & Footer button. See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 10.1 Click the Header & Footer button.[\/caption]\r\n

    Immediately after you click the Header and Footer button, you will get a different worksheet view. This view is called a Page Layout view. The header is located at the top of the worksheet, and it has three sections, the left section, the centre section, and the right section. You can click and type in any of the sections to add the header. See the Figure below.<\/span><\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 10.2 The header is located at the top of the worksheet.[\/caption]\r\n

    If you scroll down until the bottom of the worksheet, you will see the footer. It also has three sections like the footer. See the Figure below.<\/span><\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 10.3 The footer is located at the top of the worksheet.[\/caption]\r\n

    To type text in either the header or footer, you can just click on any of the sections and then type your text.<\/span><\/p>\r\n

    Let\u2019s type the company name, Fresh Fruits Company in the centre section of the header. Then, select the text and click the Bold button on the Home ribbon to bold it. Alternatively, you can select the text and press Ctrl + B shortcut keys. See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 10.4 Type and bold text in the centre section of the header.[\/caption]\r\n

    Now, let\u2019s insert the page number at the footer. Click the right section of the footer and click the Page Number button to insert the page number code. See the Figure below.<\/span><\/p>\r\n\r\n\r\n[caption id=\"attachment_137\" align=\"alignnone\" width=\"601\"]\"\" Figure 10.5 Click at the footer section and click the Page Number button.[\/caption]\r\n

    The page number code will change to a page number if you move outside the footer by clicking at the worksheet area. See the Figure below.<\/span><\/p>\r\n\r\n\r\n[caption id=\"attachment_137\" align=\"alignnone\" width=\"600\"]\"\" Figure 10.6 Click on the worksheet area and the page number is displayed.[\/caption]\r\n

    Now, let\u2019s learn how to set the print area. This is to make sure that we print out only an area that we have selected in the worksheet.<\/span><\/p>\r\n

    Scroll up until the top of the worksheet and select all cells from cell A1 and cell B9. Say, this is the area that you want to print out, so exclude the other data in the worksheet. See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 10.7 Select all cells from cell A1 until cell B9.[\/caption]\r\n

    While the above cells are selected, click Set Print Area located on the Page Layout ribbon. See the Figure below.<\/span><\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"602\"]\"image\" Figure 10. 8 Click Set Print Area to set the selected area for printing.[\/caption]\r\n

    To print out the worksheet, click the File tab and Excel brings you to the new screen called the Backstage. Here you will see the preview of the worksheet. See the Figure below.<\/span><\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 10.9 The Backstage and the preview of the worksheet for printing.[\/caption]\r\n

    To print the worksheet, just click the Print button.<\/span><\/p>\r\n

    That\u2019s all for this Chapter.<\/p>\r\n

    You're awesome!<\/p>\r\n\r\n<\/div>","rendered":"

    \n
    \n
    \n

    Learning Objectives<\/p>\n<\/header>\n

    \n
      \n
    1. Insert header and footer.<\/li>\n
    2. Set print area.<\/li>\n
    3. Print a worksheet.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n

      \n

      In this last chapter, you will learn how to insert a header and footer to a worksheet, set the print area, and print a worksheet.<\/p>\n

      You can add or edit a header or footer to a worksheet. For example, you can create a header that has your company\u2019s name and a footer that has page numbers, the date, and the name of your workbook.<\/p>\n

      Let\u2019s open a workbook from Chapter 7, and open a worksheet called Fruits. To insert a header or a footer to this worksheet, click the Insert tab, then click the Text button and the Header & Footer button. See the Figure below.<\/p>\n

      \"image\"
      Figure 10.1 Click the Header & Footer button.<\/figcaption><\/figure>\n

      Immediately after you click the Header and Footer button, you will get a different worksheet view. This view is called a Page Layout view. The header is located at the top of the worksheet, and it has three sections, the left section, the centre section, and the right section. You can click and type in any of the sections to add the header. See the Figure below.<\/span><\/p>\n

      \"image\"
      Figure 10.2 The header is located at the top of the worksheet.<\/figcaption><\/figure>\n

      If you scroll down until the bottom of the worksheet, you will see the footer. It also has three sections like the footer. See the Figure below.<\/span><\/p>\n

      \"image\"
      Figure 10.3 The footer is located at the top of the worksheet.<\/figcaption><\/figure>\n

      To type text in either the header or footer, you can just click on any of the sections and then type your text.<\/span><\/p>\n

      Let\u2019s type the company name, Fresh Fruits Company in the centre section of the header. Then, select the text and click the Bold button on the Home ribbon to bold it. Alternatively, you can select the text and press Ctrl + B shortcut keys. See the Figure below.<\/p>\n

      \"image\"
      Figure 10.4 Type and bold text in the centre section of the header.<\/figcaption><\/figure>\n

      Now, let\u2019s insert the page number at the footer. Click the right section of the footer and click the Page Number button to insert the page number code. See the Figure below.<\/span><\/p>\n

      \"\"
      Figure 10.5 Click at the footer section and click the Page Number button.<\/figcaption><\/figure>\n

      The page number code will change to a page number if you move outside the footer by clicking at the worksheet area. See the Figure below.<\/span><\/p>\n

      \"\"
      Figure 10.6 Click on the worksheet area and the page number is displayed.<\/figcaption><\/figure>\n

      Now, let\u2019s learn how to set the print area. This is to make sure that we print out only an area that we have selected in the worksheet.<\/span><\/p>\n

      Scroll up until the top of the worksheet and select all cells from cell A1 and cell B9. Say, this is the area that you want to print out, so exclude the other data in the worksheet. See the Figure below.<\/p>\n

      \"image\"
      Figure 10.7 Select all cells from cell A1 until cell B9.<\/figcaption><\/figure>\n

      While the above cells are selected, click Set Print Area located on the Page Layout ribbon. See the Figure below.<\/span><\/p>\n

      \"image\"
      Figure 10. 8 Click Set Print Area to set the selected area for printing.<\/figcaption><\/figure>\n

      To print out the worksheet, click the File tab and Excel brings you to the new screen called the Backstage. Here you will see the preview of the worksheet. See the Figure below.<\/span><\/p>\n

      \"image\"
      Figure 10.9 The Backstage and the preview of the worksheet for printing.<\/figcaption><\/figure>\n

      To print the worksheet, just click the Print button.<\/span><\/p>\n

      That\u2019s all for this Chapter.<\/p>\n

      You’re awesome!<\/p>\n<\/div>\n","protected":false},"author":91,"menu_order":10,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":"cc-by"},"chapter-type":[],"contributor":[],"license":[53],"class_list":["post-138","chapter","type-chapter","status-publish","hentry","license-cc-by"],"part":27,"_links":{"self":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/chapters\/138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/users\/91"}],"version-history":[{"count":1,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/chapters\/138\/revisions"}],"predecessor-version":[{"id":139,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/chapters\/138\/revisions\/139"}],"part":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/parts\/27"}],"metadata":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/chapters\/138\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/media?parent=138"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/pressbooks\/v2\/chapter-type?post=138"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/contributor?post=138"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/wp-json\/wp\/v2\/license?post=138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}