{"id":1447,"date":"2017-07-13T23:43:20","date_gmt":"2017-07-13T23:43:20","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=1447"},"modified":"2024-05-16T19:09:29","modified_gmt":"2024-05-16T19:09:29","slug":"introduction-to-using-multiple-worksheets","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/chapter\/introduction-to-using-multiple-worksheets\/","title":{"raw":"Introduction to Using Multiple Worksheets","rendered":"Introduction to Using Multiple Worksheets"},"content":{"raw":"<h2>What you'll learn to do: create a new workbook with more than one worksheet.<\/h2>\r\nWhen you open a new Excel file, there is automatically a single worksheet. However, there are a number of reasons why you may want more than one worksheet in a single workbook. For example, consider the following ways multiple worksheets in a workbook can help with keeping data organized:\r\n<ol>\r\n \t<li>A workbook with monthly sales figure with each year on a different worksheet<\/li>\r\n \t<li>A workbook with mailing lists for weekly flyers on one worksheet and coupon mailings on another<\/li>\r\n \t<li>A workbook with inventory data with each month on a different worksheet<\/li>\r\n<\/ol>\r\nIn any of these cases, or others, it is very easy to add more worksheets to an Excel workbook.","rendered":"<h2>What you&#8217;ll learn to do: create a new workbook with more than one worksheet.<\/h2>\n<p>When you open a new Excel file, there is automatically a single worksheet. However, there are a number of reasons why you may want more than one worksheet in a single workbook. For example, consider the following ways multiple worksheets in a workbook can help with keeping data organized:<\/p>\n<ol>\n<li>A workbook with monthly sales figure with each year on a different worksheet<\/li>\n<li>A workbook with mailing lists for weekly flyers on one worksheet and coupon mailings on another<\/li>\n<li>A workbook with inventory data with each month on a different worksheet<\/li>\n<\/ol>\n<p>In any of these cases, or others, it is very easy to add more worksheets to an Excel workbook.<\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-1447\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Introduction to Using Multiple Worksheets. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":20,"menu_order":15,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Introduction to Using Multiple Worksheets\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"3f7a4319-6209-4aef-b798-1a952933f6b2","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-1447","chapter","type-chapter","status-publish","hentry"],"part":975,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":7,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1447\/revisions"}],"predecessor-version":[{"id":5818,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1447\/revisions\/5818"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/parts\/975"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapters\/1447\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/media?parent=1447"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/pressbooks\/v2\/chapter-type?post=1447"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/contributor?post=1447"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-computerapplicationsmgrs-2\/wp-json\/wp\/v2\/license?post=1447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}