{"id":1802,"date":"2012-10-04T17:13:24","date_gmt":"2012-10-04T17:13:24","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=747"},"modified":"2023-12-30T23:12:17","modified_gmt":"2023-12-30T23:12:17","slug":"excel-training-wrap-text","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-training-wrap-text\/","title":{"rendered":"Excel Training &#8211; Wrap Text"},"content":{"rendered":"<p>Text wrapping allows you to make all the contents of a cell visible without adjusting the cell\u2019s size.<\/p>\n<p>When you enter data, if that data is longer than the width of the cell, it appears in one of two ways:<\/p>\n<p>(1)\u00a0\u00a0\u00a0 If the cell to the right contains data, you will see only as much as the size of its cell allows. ( fig.1, column B)<\/p>\n<p>(2)\u00a0\u00a0\u00a0 If the cell to the right is blank, the data will spill across into that cell. (fig.1, column C)<\/p>\n<p>Text wrapping gives you a third option, where none of the data is obscured, nor does it spill across to the next cell. (fig.1, column E)<\/p>\n<p>You will find the Wrap Text (fig.2) command in the <strong>Home<\/strong> ribbon and the Alignment group.To apply it, highlight the relevant cell(s) and click on the Wrap Text button.<\/p>\n<p class=\"size-medium wp-image-748\">It\u2019s that simple. Why not give it a try.<\/p>\n<figure id=\"attachment_754\" aria-describedby=\"caption-attachment-754\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Wrap-Text-11.png\"><img decoding=\"async\" class=\"size-medium wp-image-754\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Wrap-Text-11-300x237.png\" alt=\"\" width=\"300\" height=\"237\" \/><\/a><figcaption id=\"caption-attachment-754\" class=\"wp-caption-text\">fig.1<\/figcaption><\/figure>\n<figure id=\"attachment_751\" aria-describedby=\"caption-attachment-751\" style=\"width: 86px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Wrap-Text-22.png\"><img decoding=\"async\" class=\"size-full wp-image-751\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Wrap-Text-22.png\" alt=\"\" width=\"86\" height=\"31\" \/><\/a><figcaption id=\"caption-attachment-751\" class=\"wp-caption-text\">fig.2<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Text wrapping allows you to make all the contents of a cell visible without adjusting the cell\u2019s size. When you enter data, if that data is longer than the width of the cell, it appears in one of two ways: (1)\u00a0\u00a0\u00a0 If the cell to the right contains data, you will see only as much [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1802","post","type-post","status-publish","format-standard","hentry","category-excel-training"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1802"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1802\/revisions"}],"predecessor-version":[{"id":6722,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1802\/revisions\/6722"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}