{"id":1232,"date":"2015-05-07T19:24:12","date_gmt":"2015-05-07T17:24:12","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1232"},"modified":"2023-11-30T01:36:16","modified_gmt":"2023-11-30T00:36:16","slug":"excels-fill-justify-tool","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excels-fill-justify-tool\/","title":{"rendered":"Excel\u00b4s Fill Justify Tool"},"content":{"rendered":"<p>An interesting tool within Excel is the Fill Justify.\u00a0 It allows you to select text from several rows and merge them in to one cell.<\/p>\n<p>So if you have data that gets downloaded in to separate rows and want to join them up in to one sentence, then the Excel\u00b4s Fill Justify option is your savior.<\/p>\n<p>See the short gif below to see how easy it is to implement.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/FF0UsvPLg00?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Fill-Justify.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Fill-Justify.xlsx<\/span><\/a><\/span><\/p>\n<p>This is our text:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u00b4s Fill Justify Tool\"  class=\"alignnone size-full wp-image-19712\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-01.jpg\" alt=\"Excel\u00b4s Fill Justify Tool\" width=\"188\" height=\"205\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Adjust your column width so all the text could fit in one cell<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u00b4s Fill Justify Tool\"  class=\"alignnone size-full wp-image-19713\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-02.jpg\" alt=\"Excel\u00b4s Fill Justify Tool\" width=\"465\" height=\"267\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-02.jpg 465w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-02-300x172.jpg 300w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Select the cells that you want to combine together. Go to\u00a0<em><strong>Home &gt; Fill &gt; Justify<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u00b4s Fill Justify Tool\"  class=\"alignnone size-full wp-image-19714\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-03.jpg\" alt=\"Excel\u00b4s Fill Justify Tool\" width=\"1258\" height=\"423\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-03.jpg 1258w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-03-300x101.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-03-1024x344.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-03-768x258.jpg 768w\" sizes=\"(max-width: 1258px) 100vw, 1258px\" \/><\/p>\n<p>With just that, everything is now <strong>combined into one single cell<\/strong>!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u00b4s Fill Justify Tool\"  class=\"alignnone size-full wp-image-19715\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-04.jpg\" alt=\"Excel\u00b4s Fill Justify Tool\" width=\"486\" height=\"197\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-04.jpg 486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/05\/Excel\u00b4s-Fill-Justify-Tool-04-300x122.jpg 300w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An interesting tool within Excel is the Fill Justify.\u00a0 It allows you to select text from several rows and merge them in to one cell. So if you have data that gets downloaded in to separate rows and want to join them up in to one sentence, then the Excel\u00b4s Fill Justify option is your [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17473,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,41],"tags":[88],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1232"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1232"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1232\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17473"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}