{"id":1053,"date":"2017-06-29T22:35:49","date_gmt":"2017-06-29T22:35:49","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=1053"},"modified":"2022-07-25T19:28:02","modified_gmt":"2022-07-25T19:28:02","slug":"creating-a-workbook-with-multiple-worksheets","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-compapp\/chapter\/creating-a-workbook-with-multiple-worksheets\/","title":{"raw":"Creating a Workbook with Multiple Worksheets","rendered":"Creating a Workbook with Multiple Worksheets"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Objectives<\/h3>\r\n<ul>\r\n \t<li>Create a new workbook with more than one worksheet.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<h2>Method 1<\/h2>\r\nThe easiest method to add additional worksheets to a workbook is by using the Insert Worksheet shortcut represented by the + button at the bottom of the workbook window. You can use this shortcut button multiple times to insert additional worksheets into your workbook.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223340\/multipleworksheets1.png\"><img class=\"aligncenter wp-image-1054\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223340\/multipleworksheets1.png\" alt=\"A blank excel sheet is open. A green arrow is pointing at the option to add a new sheet.\" width=\"800\" height=\"598\" \/><\/a>\r\n<h2>Method 2<\/h2>\r\nYou can also use the menu option Insert&gt;Insert Sheet from the Cells group of the ribbon.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223448\/multipleworksheets2.png\"><img class=\"aligncenter wp-image-1055\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223448\/multipleworksheets2.png\" alt=\"A blank excel sheet is open. There is a green arrow pointing to the insert dropdown menu, and specifically the insert sheet option.\" width=\"800\" height=\"599\" \/><\/a>\r\n<div class=\"textbox key-takeaways\">\r\n<h3>Practice Questions<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/d979236c-fdcd-4bfc-aa20-482cf3d6a00e\r\n\r\n<\/div>\r\n&nbsp;\r\n<div class=\"textbox key-takeaways\">\r\n<h3>Practice Questions<\/h3>\r\nhttps:\/\/assess.lumenlearning.com\/practice\/443e7bad-9f27-4348-b10b-23fd010413d7\r\n\r\n<\/div>\r\n&nbsp;","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Objectives<\/h3>\n<ul>\n<li>Create a new workbook with more than one worksheet.<\/li>\n<\/ul>\n<\/div>\n<h2>Method 1<\/h2>\n<p>The easiest method to add additional worksheets to a workbook is by using the Insert Worksheet shortcut represented by the + button at the bottom of the workbook window. You can use this shortcut button multiple times to insert additional worksheets into your workbook.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223340\/multipleworksheets1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1054\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223340\/multipleworksheets1.png\" alt=\"A blank excel sheet is open. A green arrow is pointing at the option to add a new sheet.\" width=\"800\" height=\"598\" \/><\/a><\/p>\n<h2>Method 2<\/h2>\n<p>You can also use the menu option Insert&gt;Insert Sheet from the Cells group of the ribbon.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223448\/multipleworksheets2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1055\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29223448\/multipleworksheets2.png\" alt=\"A blank excel sheet is open. There is a green arrow pointing to the insert dropdown menu, and specifically the insert sheet option.\" width=\"800\" height=\"599\" \/><\/a><\/p>\n<div class=\"textbox key-takeaways\">\n<h3>Practice Questions<\/h3>\n<p>\t<iframe id=\"assessment_practice_d979236c-fdcd-4bfc-aa20-482cf3d6a00e\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/d979236c-fdcd-4bfc-aa20-482cf3d6a00e?iframe_resize_id=assessment_practice_id_d979236c-fdcd-4bfc-aa20-482cf3d6a00e\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"textbox key-takeaways\">\n<h3>Practice Questions<\/h3>\n<p>\t<iframe id=\"assessment_practice_443e7bad-9f27-4348-b10b-23fd010413d7\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/443e7bad-9f27-4348-b10b-23fd010413d7?iframe_resize_id=assessment_practice_id_443e7bad-9f27-4348-b10b-23fd010413d7\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>&nbsp;<\/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-1053\">\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>Creating a Workbook with 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":3,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Creating a Workbook with Multiple Worksheets\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"3f7a4319-6209-4aef-b798-1a952933f6b2, 25d78a3f-76bd-484e-a0ff-020a672310ff","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-1053","chapter","type-chapter","status-publish","hentry"],"part":1049,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1053","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":10,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1053\/revisions"}],"predecessor-version":[{"id":2874,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1053\/revisions\/2874"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/parts\/1049"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1053\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/media?parent=1053"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapter-type?post=1053"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/contributor?post=1053"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/license?post=1053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}