{"id":505441,"date":"2022-10-31T22:00:58","date_gmt":"2022-10-31T19:00:58","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-find-merged-cells-in-microsoft-excel\/"},"modified":"2022-10-31T22:00:58","modified_gmt":"2022-10-31T19:00:58","slug":"how-to-find-merged-cells-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-find-merged-cells-in-microsoft-excel\/","title":{"rendered":"#How to Find Merged Cells 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-6a3dcb17ddd0d\" 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-6a3dcb17ddd0d\" 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-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-merged-cells-in-microsoft-excel\/#%E2%80%9CHow_to_Find_Merged_Cells_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Find Merged Cells in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-merged-cells-in-microsoft-excel\/#Find_Merged_Cells_in_Excel_on_Windows\" >Find Merged Cells in Excel on Windows<\/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-find-merged-cells-in-microsoft-excel\/#Unmerge_Cells_on_Mac\" >Unmerge Cells on Mac<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Find_Merged_Cells_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Find Merged Cells in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\"\/><\/p>\n<p>You can easily locate all of your merged cells in Excel on Windows by using the Find tool. Or, you can unmerge all of your cells in Excel on Mac.<\/p>\n<p>Have you ever tried to sort data in Excel, only to receive an error about merged cells? It can be a pain to try and locate all of those merged cells manually. Luckily, there\u2019s a simple way to find them.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_Merged_Cells_in_Excel_on_Windows\"><\/span>Find Merged Cells in Excel on Windows<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft Excel on Windows offers a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/442859\/how-to-find-and-replace-text-and-numbers-in-excel\/\">Find tool that offers extra options. This allows you to locate cells with specific formatting.<\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> Currently, Excel on Mac doesn\u2019t have this robust search tool. These instructions currently only <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 to Windows. On Mac, you\u2019ll need to unmerge all of your cells (<a rel=\"nofollow noopener\" target=\"_blank\" href=\"#moka_anchor_UnmergeCellsonMac\">as discussed below<\/a>).<\/p><\/blockquote>\n<p><strong>RELATED:<\/strong> <strong><em>How to Find and Replace Text and Numbers in Excel<\/em><\/strong><\/p>\n<p>Head to the sheet where you want to find the merged cells and go to the Home tab. Select the \u201cFind &amp; Select\u201d drop-down arrow and pick \u201cFind.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-839552\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/FindSelect-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Find in the Find and Select drop-down menu\" width=\"362\" height=\"485\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Find and Replace box opens, click \u201cOptions\u201d on the bottom right.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-839551\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/FindReplaceOptions-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Options button in the Find and Replace window\" width=\"650\" height=\"244\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After you see these additional options, you\u2019ll also see a Format button to the right of the Find What box. Select the drop-down arrow for that Format button and pick \u201cFormat.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-839554\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/FindReplaceOptionsFormat-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format in the Find and Replace window\" width=\"650\" height=\"247\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the Find Format box, go to the Alignment tab and check the box for Merge Cells. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-839565 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/FindFormatAlignmentMergeCells-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Merge Cells box checked in the Find Format window\" width=\"650\" height=\"475\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This brings you back to the Find and Replace window. You can leave the Find What box empty. Then, be sure that \u201cSheet\u201d is selected in the Within box. You can keep the other options as-is.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-839556\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/FindReplaceWithinSheet-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Sheet selected in the Within field for Find and Replace\" width=\"650\" height=\"304\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select \u201cFind All\u201d to see all of the sheet\u2019s merged cells in the expanded portion of the window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-839558\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/FindReplaceResults-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Merged cells in the Find and Replace results\" width=\"650\" height=\"426\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can click one of the results to go directly to it in your sheet to unmerge the cell using the Merge and Center drop-down menu on the Home tab.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Merge and Unmerge Cells in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Unmerge_Cells_on_Mac\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_UnmergeCellsonMac\">Unmerge Cells on Mac<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As mentioned, the Find tool in Excel on Mac doesn\u2019t offer the Format option like on Windows. But if you\u2019re receiving the merged cell error when trying to sort data, you can simply unmerge all the cells in your sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-839559\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/MergedCellsErrorMac-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Merged cells alert on Mac\" width=\"260\" height=\"218\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This isn\u2019t ideal and may cause issues with the appearance or function of those merged cells. However, it\u2019s still an option if you\u2019re interested.<\/p>\n<p>Select the entire sheet using the triangle button on the top left where column A and row 1 meet. Then, go to the Home tab, click the Merge and Center drop-down arrow, and pick \u201cUnmerge Cells.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-839560\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/UnmergeCellsMac-ExcelFindMergedCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Unmerge Cells in the Merge and Center menu on Mac\" width=\"650\" height=\"313\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you have a spreadsheet containing a large amount of data, locating cells you\u2019ve merged over time can be tedious. With the Find tool in Excel on Windows, you can locate the cells you need quickly.<\/p>\n<p>For more, learn how to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/817605\/how-to-find-circular-references-in-microsoft-excel\/\">find circular references or how to list and sort unique values in Excel.<\/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\/839546\/how-to-find-merged-cells-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Find Merged Cells in Microsoft Excel&#8221; You can easily locate all of your merged cells in Excel on Windows by using the Find tool. Or, you can unmerge all of your cells in Excel on Mac. Have you ever tried to sort data in Excel, only to receive an error about merged cells?&#8230;<\/p>\n","protected":false},"author":1,"featured_media":505442,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-505441","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\/505441","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=505441"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/505441\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/505442"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=505441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=505441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=505441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}