{"id":166582,"date":"2021-01-29T13:24:38","date_gmt":"2021-01-29T10:24:38","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-line-breaks-in-microsoft-excel\/"},"modified":"2021-01-29T13:24:38","modified_gmt":"2021-01-29T10:24:38","slug":"how-to-add-line-breaks-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-line-breaks-in-microsoft-excel\/","title":{"rendered":"#How to Add Line Breaks in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a40dcd4d7198\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a40dcd4d7198\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-line-breaks-in-microsoft-excel\/#Adding_a_Line_Break\" >Adding a Line Break<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-line-breaks-in-microsoft-excel\/#Auto_Line_Break_Using_Wrap_Text\" >Auto Line Break Using Wrap Text<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-line-breaks-in-microsoft-excel\/#Add_a_Line_Break_After_Specific_Characters\" >Add a Line Break After Specific Characters<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Add Line Breaks in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-435491\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png\" alt=\"Excel Logo on a gray background\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>There are multiple ways to add line breaks in Excel, though none of them are obvious solutions. As with most problems in Excel, there are actually multiple ways to accomplish this. We\u2019ll look at three different ways to add line breaks.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Adding_a_Line_Break\"><\/span>Adding a Line Break<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To add a line break, first click inside the cell (or cells) where you want to add a break.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704122 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/click.png\" alt=\"click inside cell\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click once more in the precise location where you want to insert the break. Because our example uses first and last names, we\u2019ll click between the two to display them on separate lines.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704123 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/click-precise.png\" alt=\"click between first and last name\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Press Alt + Enter on the keyboard if you\u2019re using Excel on a Windows PC. If you\u2019re using a Mac, press Control + Option + Return instead.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704124 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/alt-enter.png\" alt=\"alt + enter\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can repeat these steps to add additional line breaks. If we want to separate a middle name onto its own line, for example, we\u2019d just repeat the steps, placing the cursor where we want it and pressing Alt + Enter (Control + Option + Return on Mac).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704125 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/middle-name.png\" alt=\"repeat alt + enter\" width=\"650\" height=\"301\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Auto_Line_Break_Using_Wrap_Text\"><\/span>Auto Line Break Using Wrap Text<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to automatically break your lines once you reach the cell border, you can instead rely on the Wrap Text tool to do this automatically.<\/p>\n<p>Select all of the cells you want to <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ly this text wrap to by clicking inside the first and then dragging until you reach the last cell you want to wrap.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704126 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/select-all.png\" alt=\"click and drag\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>From the \u201cHome\u201d tab, click \u201cWrap Text.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704127 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/home-text-wrap.png\" alt=\"wrap text icon\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Wrapping text in this way often leaves a few undesirable results. For example, the text may get broken in places you don\u2019t want. To fix this, just enlarge the column by clicking and dragging the line next to your column of choice.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704128 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/enlarge-column.png\" alt=\"click and drag to enlarge cell\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_a_Line_Break_After_Specific_Characters\"><\/span>Add a Line Break After Specific Characters<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Select all the cells where you want to add a line break.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704129 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/select-all2.png\" alt=\"click and drag\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>From the \u201cHome\u201d tab, click Find &amp; Select &gt; Replace. Alternatively, you can just use the Ctrl+H keyboard shortcut to bring up the same dialog.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704130 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/find-replace.png\" alt=\"\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cFind what\u201d field, type the character you\u2019re looking for. In our case, we\u2019re looking for the comma that separates names from titles.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704131 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/find-what.png\" alt=\"\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cReplace with\u201d field, press Ctrl + J to add a carriage return. This will insert a line break in place of each comma.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-704136\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/ctrl-j-shortcut.png\" alt=\"ctrl + j\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click the \u201cReplace All\u201d button at the bottom to replace all commas with carriage returns.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" alignnone wp-image-704133 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/replace-all.png\" alt=\"\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Whichever method you used, your spreadsheet should now be easier to read at a glance.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/704121\/how-to-add-line-breaks-in-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Add Line Breaks in Microsoft Excel&#8221; There are multiple ways to add line breaks in Excel, though none of them are obvious solutions. As with most problems in Excel, there are actually multiple ways to accomplish this. We\u2019ll look at three different ways to add line breaks. Adding a Line Break To add&#8230;<\/p>\n","protected":false},"author":1,"featured_media":166583,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-166582","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/166582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=166582"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/166582\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/166583"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=166582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=166582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=166582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}