{"id":24117,"date":"2021-06-20T16:54:35","date_gmt":"2021-06-20T14:54:35","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=24117"},"modified":"2023-11-29T23:07:27","modified_gmt":"2023-11-29T22:07:27","slug":"break-line-on-worksheet","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/break-line-on-worksheet\/","title":{"rendered":"Break Line on Worksheet"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/29.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24591\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/29.png\" alt=\"Break Line on Worksheet\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/29.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/29-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/29-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>While working on Excel, sometimes you may<strong> see solid or dashed break lines added<\/strong> and the <strong>worksheet is divided into multiples pages<\/strong>.<\/p>\n<p>The <strong>solid lines are manually inserted ones<\/strong> whereas the <strong>dashed line is automatically generated<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-483-1-e1623877580988.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone wp-image-24318 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-483-1-e1623877580988.png\" alt=\"Break Line on Worksheet\" width=\"1205\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-483-1-e1623877580988.png 1205w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-483-1-e1623877580988-300x112.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-483-1-e1623877580988-1024x382.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-483-1-e1623877580988-768x287.png 768w\" sizes=\"(max-width: 1205px) 100vw, 1205px\" \/><\/a><\/p>\n<p>These are basically <strong>page breaks inserted in Excel for printing purposes<\/strong>! They may be useful when you are trying to print a document but other times are just <strong>visually distracting<\/strong>.<\/p>\n<p>You may want to <strong>remove these lines before presenting<\/strong> your worksheet to someone!<\/p>\n<p>In this article, we will cover the <strong>different ways to remove lines<\/strong> from the worksheet:<\/p>\n<ul>\n<li><a href=\"#lesson1\"><strong>Solid Page Break Line<\/strong><\/a><\/li>\n<li><a href=\"#lesson2\"><strong>Dotted Page Break Line<\/strong><\/a><\/li>\n<\/ul>\n<p>So, let&#8217;s learn to <strong>remove and adjust page breaks<\/strong> in Excel!<\/p>\n<p>Download this <strong>Excel\u00a0workbook<\/strong> so you can practice along with us:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Break-Lines-on-Worksheet.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/10\/XLOOKUP.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Break-Lines-on-Worksheet.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"lesson1\"><\/a>Solid Page Break Line<\/strong><\/span><\/h3>\n<p>In this screenshot, we have <strong>two solid lines inserted<\/strong> in the worksheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-481.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24319\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-481.png\" alt=\"Break Line on Worksheet\" width=\"716\" height=\"444\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-481.png 716w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-481-300x186.png 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/a><\/p>\n<p>These are <strong>manually added page breaks<\/strong> and can easily be removed by following the\u00a0<strong>step-by-step tutorial<\/strong> below:<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong><\/span><strong> Select the cell<\/strong> just below the page break line.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-484.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24320\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-484.png\" alt=\"Break Line on Worksheet\" width=\"721\" height=\"459\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-484.png 721w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-484-300x191.png 300w\" sizes=\"(max-width: 721px) 100vw, 721px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 2:<\/strong><\/span> Go to the <strong>Page Layout<\/strong> tab.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-480.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24322\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-480.png\" alt=\"Break Line on Worksheet\" width=\"1117\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-480.png 1117w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-480-300x34.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-480-1024x117.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-480-768x88.png 768w\" sizes=\"(max-width: 1117px) 100vw, 1117px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3:<\/strong><\/span> Click on <strong>Breaks<\/strong> in the Page Setup group.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-485.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24324\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-485.png\" alt=\"Break Line on Worksheet\" width=\"1117\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-485.png 1117w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-485-300x35.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-485-1024x118.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-485-768x89.png 768w\" sizes=\"(max-width: 1117px) 100vw, 1117px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 4:<\/strong><\/span> Click on <strong>Remove Page Break<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-479.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24321\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-479.png\" alt=\"Break Line on Worksheet\" width=\"1118\" height=\"199\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-479.png 1118w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-479-300x53.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-479-1024x182.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-479-768x137.png 768w\" sizes=\"(max-width: 1118px) 100vw, 1118px\" \/><\/a><\/p>\n<p>This will remove the page break between row 9 and row 10!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-486.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24325\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-486.png\" alt=\"Break Line on Worksheet\" width=\"735\" height=\"465\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-486.png 735w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-486-300x190.png 300w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/a><\/p>\n<p>Now, follow the same steps to remove the solid line between rows 15 and 16.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-487.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24326\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-487.png\" alt=\"Break Line on Worksheet\" width=\"724\" height=\"464\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-487.png 724w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-487-300x192.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"lesson2\"><\/a>Dotted Page Break Line<\/strong><\/span><\/h3>\n<p>When you select the <strong>Page Break Preview<\/strong> in Excel, the <strong>dotted and solid lines<\/strong> dividing the worksheet into different pages become visible.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-491.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24331\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-491.png\" alt=\"Break Line on Worksheet\" width=\"1027\" height=\"647\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-491.png 1027w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-491-300x189.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-491-1024x645.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-491-768x484.png 768w\" sizes=\"(max-width: 1027px) 100vw, 1027px\" \/><\/a><\/p>\n<p>Now when you go to <strong>View &gt; Normal<\/strong>, the page preview is returned to normal but the lines still visible.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-492.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24332\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-492.png\" alt=\"Break Line on Worksheet\" width=\"1143\" height=\"659\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-492.png 1143w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-492-300x173.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-492-1024x590.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-492-768x443.png 768w\" sizes=\"(max-width: 1143px) 100vw, 1143px\" \/><\/a><\/p>\n<p>To remove the solid lines, follow the steps mentioned below. But, this will not remove the dashed lines.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-493.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24333\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-493.png\" alt=\"Break Line on Worksheet\" width=\"1027\" height=\"641\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-493.png 1027w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-493-300x187.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-493-1024x639.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-493-768x479.png 768w\" sizes=\"(max-width: 1027px) 100vw, 1027px\" \/><\/a><\/p>\n<p>To remove the dashed line, follow the steps below:<\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 1:<\/strong><\/span> Select the <strong>File<\/strong> tab.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\"  class=\"alignnone size-full wp-image-23782\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"864\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384.png 864w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384-300x45.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-384-768x115.png 768w\" sizes=\"(max-width: 864px) 100vw, 864px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #339966;\">STEP 2:<\/span><\/strong> Click <strong>Options<\/strong> from the menu on the left side<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\"  class=\"alignnone size-full wp-image-23783\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"723\" height=\"729\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385.png 723w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385-298x300.png 298w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-385-150x150.png 150w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 3:<\/strong><\/span> In the dialog box, click on <strong>Advanced<\/strong> from the left panel<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 20 Common Excel Problems Solved\"  class=\"alignnone size-full wp-image-23784\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386.png\" alt=\"Top 20 Common Excel Problems Solved\" width=\"821\" height=\"677\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386.png 821w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386-300x247.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/05\/Screenshot-386-768x633.png 768w\" sizes=\"(max-width: 821px) 100vw, 821px\" \/><\/a><\/p>\n<p><span style=\"color: #339966;\"><strong>STEP 4:<\/strong><\/span> Under display options for this worksheet, <strong>uncheck Show Page Breaks<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-495.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24334\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-495.png\" alt=\"Break Line on Worksheet\" width=\"821\" height=\"679\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-495.png 821w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-495-300x248.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-495-768x635.png 768w\" sizes=\"(max-width: 821px) 100vw, 821px\" \/><\/a><\/p>\n<p>This will remove the dashed lines from the worksheet as well!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-496.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Break Line on Worksheet\"  class=\"alignnone size-full wp-image-24335\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-496.png\" alt=\"Break Line on Worksheet\" width=\"894\" height=\"473\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-496.png 894w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-496-300x159.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screenshot-496-768x406.png 768w\" sizes=\"(max-width: 894px) 100vw, 894px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Conclusion<\/h3>\n<p>If you wish to <strong>remove the solid page break line<\/strong>, select the cell below <em>(or cell right to)<\/em> the horizontal page break line <em>(or vertical page break line)<\/em> and select click on <strong>Page Layout &gt; Breaks &gt; Remove Page Break<\/strong>.<\/p>\n<p>If you wish to<strong> remove the dashed page break line,<\/strong> go to<strong> File &gt; Options &gt; Advanced &gt; Uncheck Show Page Breaks<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While working on Excel, sometimes you may see solid or dashed break lines added and the worksheet is divided into multiples pages. The solid lines are manually inserted ones whereas the dashed line is automatically generated. These are basically page breaks inserted in Excel for printing purposes! They may be useful when you are trying [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24591,"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":[10],"tags":[743,750],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24117"}],"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=24117"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/24117\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/24591"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=24117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=24117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=24117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}