{"id":1226,"date":"2012-11-14T13:00:28","date_gmt":"2012-11-14T13:00:28","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1226"},"modified":"2023-12-30T23:11:49","modified_gmt":"2023-12-30T23:11:49","slug":"how-to-wrap-text-in-column-headings-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-wrap-text-in-column-headings-in-excel\/","title":{"rendered":"How to wrap text in column headings in Excel"},"content":{"rendered":"<p>You can save yourself time scrolling across your Excel documents by wrapping text in column headings.<\/p>\n<p>It\u2019s easy to do, takes a few seconds and improves the way you can move through and use your Excel worksheet.<\/p>\n<p>Here is a worksheet where better use of column format could help.<\/p>\n<figure id=\"attachment_1228\" aria-describedby=\"caption-attachment-1228\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/long-headings-excel-powerpoint-courses.png\"><img decoding=\"async\" class=\"size-medium wp-image-1228\" src=\"\/b\/wp-content\/uploads\/2012\/11\/long-headings-excel-powerpoint-courses-300x45.png\" alt=\"long-headings-excel-powerpoint-courses\" width=\"300\" height=\"45\" \/><\/a><figcaption id=\"caption-attachment-1228\" class=\"wp-caption-text\">Long headings use loads of space and make it harder for you to navigate around your document.<\/figcaption><\/figure>\n<p>I have used <strong>autofit<\/strong> to make the titles fit into the columns, but the titles are taking up lots of space. There has to be a better way&#8230;oh, now wait&#8230;there is! \u00a0I can <strong>wrap the text in the column headings<\/strong>, so the focus is on the contents in the cell, not on the width of the column.<\/p>\n<p>I select the entire row A1, and right click. \u00a0I then select <strong>format cells<\/strong>, and click <strong>Wrap Text.\u00a0<\/strong><\/p>\n<p>Under <strong>Text alignment<\/strong>, select the Vertical text box and select <strong>Top. \u00a0<\/strong><\/p>\n<figure id=\"attachment_1229\" aria-describedby=\"caption-attachment-1229\" style=\"width: 224px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/format-text-excel-powerpoint-courses.png\"><img decoding=\"async\" class=\"size-full wp-image-1229\" src=\"\/b\/wp-content\/uploads\/2012\/11\/format-text-excel-powerpoint-courses.png\" alt=\"format-text-excel-powerpoint-courses\" width=\"224\" height=\"266\" \/><\/a><figcaption id=\"caption-attachment-1229\" class=\"wp-caption-text\">Format cells options.<\/figcaption><\/figure>\n<p>Now, for each column I can amend the column width and height manually using click and drag.<\/p>\n<figure id=\"attachment_1231\" aria-describedby=\"caption-attachment-1231\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"\/b\/wp-content\/uploads\/2012\/11\/Wrap-text-excel-powerpoint-courses.png\"><img decoding=\"async\" class=\"size-medium wp-image-1231\" src=\"\/b\/wp-content\/uploads\/2012\/11\/Wrap-text-excel-powerpoint-courses-300x57.png\" alt=\"Wrap-text-excel-powerpoint-courses\" width=\"300\" height=\"57\" \/><\/a><figcaption id=\"caption-attachment-1231\" class=\"wp-caption-text\">Tidy!<\/figcaption><\/figure>\n<p>Simple touches, like improving the look of and Excel worksheet, makes it easier to use. \u00a0If you add Excel worksheets within a Powerpoint presentation, making sure that the column headings are readable is key. \u00a0Using the wrap text option can help you do this. \u00a0You can get more out of Excel and Powerpoint, take a look at what more you can do with\u00a0<a title=\"Excel and Powerpoint training\" href=\"\/excel-training-london.php\">https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can save yourself time scrolling across your Excel documents by wrapping text in column headings. It\u2019s easy to do, takes a few seconds and improves the way you can move through and use your Excel worksheet. Here is a worksheet where better use of column format could help. I have used autofit to make [&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":[183,613],"class_list":["post-1226","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-and-powerpoint-courses","tag-wrap-text-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1226","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=1226"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1226\/revisions"}],"predecessor-version":[{"id":6705,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1226\/revisions\/6705"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}