{"id":135636,"date":"2019-04-17T20:14:11","date_gmt":"2019-04-17T20:14:11","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/en\/?p=135636"},"modified":"2025-07-01T22:05:37","modified_gmt":"2025-07-02T05:05:37","slug":"excel-text-cell-trick","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/excel-text-cell-trick\/","title":{"rendered":"Excel trick: How to write a lot of text in a single cell"},"content":{"rendered":"<p><a href=\"https:\/\/microsoft-excel.en.softonic.com\/\" target=\"_blank\">Excel<\/a> is <strong>not designed for text<\/strong>. When you write long sentences, the program shows all the text on the same line, even if it is very long, although it really is only in a single cell.<\/p>\n<p>In some tables, performing a line break inside a cell allows for a&nbsp;<strong>clearer visualization.&nbsp;<\/strong>This isn&#8217;t necessarily the best option design-wise.<\/p>\n\n<div class=\"howto_container schema-howto-acf-block\"><ol><li><div class=\"howto_item\"><h2>Click on the cell where you want to write a lot of text<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/Microsoft_Excel_cell_gjocv9.jpg\" alt=\"\" width=\"0\" height=\"0\"><p>Click on the cell where you want to write several lines and, before pressing &#8220;Enter,&#8221;\u00a0<strong>keep the\u00a0Alt\u00a0key pressed.<\/strong><\/p>\n<\/div><\/li><li><div class=\"howto_item\"><h2>Repeat step one to add height to the cell<\/h2><p>Keep pressing Enter while holding down the Alt key.<b>\u00a0<\/b>The more times you hit Enter, the higher the cell will be.<\/p>\n<\/div><\/li><li><div class=\"howto_item\"><h2>Resize the height of the cell<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2019\/04\/Excell-resize-cell.jpg\" alt=\"\" width=\"268\" height=\"188\"><\/div><\/li><\/ol><\/div><style type=\"text\/css\">\n\t.howto_container {\n\t  margin: 0 auto;\n\t}\n\t.howto_container img {\n\t\theight: 100%;\n\t\tmargin-bottom: 30px;\n\t}\n\t\n\t\t  .howto_container ol {\n\t\t\t  counter-reset:li;\n\t\t\t  margin-left:0;\n\t\t\t  padding-left:5px;\n\t\t\t  color: rgb(100,100,100);\n\t\t  }\n\t\t  .howto_container ol li {\n\t\t\t  position: relative;\n\t\t\t  padding-left: 3em;\n\t\t\t  margin: 0.45em 0;\n\t\t\t  list-style: none;\n\t\t\t  line-height: 1.8em;\n\t\t  }\n\t\t  .howto_container ol li::before {\n\t\t\t  content: counter(li);\n\t\t\t  counter-increment:li;\n\t\t\t  position:absolute;\n\t\t\t  top:0;\n\t\t\t  left:0;\n\t\t\t  width: 1.8em;\n\t\t\t  height: 1.8em;\n\t\t\t  line-height: 1.8em;\n\t\t\t  padding:0px;\n\t\t\t  color:#fff;\n\t\t\t  background:#2980b9;\n\t\t\t  font-weight:bold;\n\t\t\t  text-align:center;\n\t\t\t  border-radius: .9em;\n\t\t\t  box-shadow: 0px 1px 4px 0px rgba(0,0,0,0.3);\n\t\t\t  z-index: 1;\n\t\t  }\n\t\t  .howto_container ol li:after {\n\t\t\t  position: absolute;\n\t\t\t  top: 2.1em;\n\t\t\t  left: 0.9em;\n\t\t\t  width: 2px;\n\t\t\t  height: calc(100% - 2em);\n\t\t\t  content: '';\n\t\t\t  background-color: rgb(203, 203, 203);\n\t\t\t  z-index: 0;\n\t\t  }\t\n\t.howto_container ol li::before {\n\t\tcolor: #ffffff !important;\n\t\tbackground:#0073aa !important;\n\t}\n<\/style>\n\n\t\t","protected":false},"excerpt":{"rendered":"<p>Learn how to become a master of Microsoft Office with this trick.<\/p>\n","protected":false},"author":9181,"featured_media":181486,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":0},"categories":[2441],"tags":[2523],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-135636","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","tag-app-subdomain-redirectionmicrosoft-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/135636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/users\/9181"}],"replies":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/comments?post=135636"}],"version-history":[{"count":1,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/135636\/revisions"}],"predecessor-version":[{"id":326234,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/135636\/revisions\/326234"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media\/181486"}],"wp:attachment":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media?parent=135636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/categories?post=135636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/tags?post=135636"},{"taxonomy":"usertag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/usertag?post=135636"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/vertical?post=135636"},{"taxonomy":"content-category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/content-category?post=135636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}