{"id":1297,"date":"2017-07-07T19:29:47","date_gmt":"2017-07-07T19:29:47","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=1297"},"modified":"2021-06-01T19:39:34","modified_gmt":"2021-06-01T19:39:34","slug":"discussion-hard-return-within-a-cell","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/wm-compapp\/chapter\/discussion-hard-return-within-a-cell\/","title":{"raw":"Discussion: Hard Return within a Cell","rendered":"Discussion: Hard Return within a Cell"},"content":{"raw":"This discussion can be found in Google Docs:\u00a0<a href=\"https:\/\/docs.google.com\/document\/d\/1p3-FUt8KciqThAtMjTexw5SuhMqrkiyc8ZBLFRqZ4w0\/edit\" target=\"_blank\" rel=\"noopener\">Business Communication Skills for Managers Discussion: Hard Return within a Cell<\/a>\r\n\r\nTo make your own copy to edit:\r\n<ul>\r\n \t<li><strong>If you want a Google Doc:<\/strong>\u00a0in the file menu of the open document, click \u201cMake a copy.\u201d This will give you your own Google Doc to work from.<\/li>\r\n \t<li><strong>If you want a PDF or Word file:<\/strong>\u00a0in the file menu of the open document, click \u201cDownload\u201d and select the file type you would like to have (note: depending on the file type you select, the formatting could get jumbled).<\/li>\r\n \t<li>Instructions for faculty to paste the content into their LMS are located in the course resource pages.<\/li>\r\n<\/ul>\r\n&nbsp;\r\n\r\nFor visual reasons, there are times that you may wish to have multiple lines of text within an Excel cell rather than one long string. Do you know how to do this? Hint: you don\u2019t want to use the TAB or space bar button because this spacing will be incorrect if you resize your cells! Instead you want to place what is known as a \u201chard return\u201d (or a new line of text) within the cell.\r\n\r\nA hard return is very easy to insert in a cell. Simply type your first line of text. When you reach the end of that line, hold down the Alt button of your keyboard as you hit the Enter (or Return) button. A new line will be started inside the cell.\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213457\/hardreturn1.png\"><img class=\"aligncenter wp-image-1584\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213457\/hardreturn1.png\" alt=\"An excel sheet is open with 4 lines of text in cell A1. There is a green arrow pointing at the cell.\" width=\"800\" height=\"599\" \/><\/a>\r\n\r\nYou can add as many lines of text as you would like this way. When you are finished with that cell, simply hit Enter or Tab as normal to proceed to the next cell. Your cell should automatically resize to accommodate the multiple hard returns you have created in the cell. Best of all, if you manually resize your cells, columns, or rows, the hard returns will remain in place and the separate lines of text will remain separate lines of text!\r\n\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213610\/hardreturn2.png\"><img class=\"aligncenter wp-image-1585\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213610\/hardreturn2.png\" alt=\"An excel sheet is open with 3 lines of text in cell A1. There is a green arrow pointing at the cell.\" width=\"800\" height=\"597\" \/><\/a>\r\n\r\nNow consider these questions: In what situations would a hard return be useful? Would you ever use this feature? Why or why not? Share your opinions below and respond to two of your classmates\u2019 thoughts.","rendered":"<p>This discussion can be found in Google Docs:\u00a0<a href=\"https:\/\/docs.google.com\/document\/d\/1p3-FUt8KciqThAtMjTexw5SuhMqrkiyc8ZBLFRqZ4w0\/edit\" target=\"_blank\" rel=\"noopener\">Business Communication Skills for Managers Discussion: Hard Return within a Cell<\/a><\/p>\n<p>To make your own copy to edit:<\/p>\n<ul>\n<li><strong>If you want a Google Doc:<\/strong>\u00a0in the file menu of the open document, click \u201cMake a copy.\u201d This will give you your own Google Doc to work from.<\/li>\n<li><strong>If you want a PDF or Word file:<\/strong>\u00a0in the file menu of the open document, click \u201cDownload\u201d and select the file type you would like to have (note: depending on the file type you select, the formatting could get jumbled).<\/li>\n<li>Instructions for faculty to paste the content into their LMS are located in the course resource pages.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>For visual reasons, there are times that you may wish to have multiple lines of text within an Excel cell rather than one long string. Do you know how to do this? Hint: you don\u2019t want to use the TAB or space bar button because this spacing will be incorrect if you resize your cells! Instead you want to place what is known as a \u201chard return\u201d (or a new line of text) within the cell.<\/p>\n<p>A hard return is very easy to insert in a cell. Simply type your first line of text. When you reach the end of that line, hold down the Alt button of your keyboard as you hit the Enter (or Return) button. A new line will be started inside the cell.<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213457\/hardreturn1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1584\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213457\/hardreturn1.png\" alt=\"An excel sheet is open with 4 lines of text in cell A1. There is a green arrow pointing at the cell.\" width=\"800\" height=\"599\" \/><\/a><\/p>\n<p>You can add as many lines of text as you would like this way. When you are finished with that cell, simply hit Enter or Tab as normal to proceed to the next cell. Your cell should automatically resize to accommodate the multiple hard returns you have created in the cell. Best of all, if you manually resize your cells, columns, or rows, the hard returns will remain in place and the separate lines of text will remain separate lines of text!<\/p>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213610\/hardreturn2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1585\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/07\/17213610\/hardreturn2.png\" alt=\"An excel sheet is open with 3 lines of text in cell A1. There is a green arrow pointing at the cell.\" width=\"800\" height=\"597\" \/><\/a><\/p>\n<p>Now consider these questions: In what situations would a hard return be useful? Would you ever use this feature? Why or why not? Share your opinions below and respond to two of your classmates\u2019 thoughts.<\/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-1297\">\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>Discussion: Hard Return within a Cell. <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":17,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Discussion: Hard Return within a Cell\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"1ad79852-e0a3-4cb4-9e36-bd7467aaac9d","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-1297","chapter","type-chapter","status-publish","hentry"],"part":1049,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1297","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":9,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1297\/revisions"}],"predecessor-version":[{"id":2825,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1297\/revisions\/2825"}],"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\/1297\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/media?parent=1297"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/pressbooks\/v2\/chapter-type?post=1297"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/contributor?post=1297"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/wm-compapp\/wp-json\/wp\/v2\/license?post=1297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}