{"id":1451,"date":"2020-08-23T11:04:29","date_gmt":"2020-08-23T03:04:29","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=1451"},"modified":"2026-08-27T16:14:53","modified_gmt":"2026-08-27T08:14:53","slug":"merged_cells_skills","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/en\/merged_cells_skills\/","title":{"rendered":"Complete Guide to Merging Cells"},"content":{"rendered":"<blockquote><p>In data processing and analysis, minimize the use of merged cells whenever possible, but they are often unavoidable in practice. Therefore, mastering common techniques for handling merged cells is very helpful for everyday office work. This article explains several common merged-cell problems, solutions, and interpretations \u2014 hope this helps everyone!<\/p><\/blockquote>\n\t\t\t\t\t\t<style>\r\n\t\t\t\t<style>\r\n#wpsm_accordion_1449 .wpsm_panel-heading{\r\n\tpadding:0px !important;\r\n}\r\n#wpsm_accordion_1449 .wpsm_panel-title {\r\n\tmargin:0px !important; \r\n\ttext-transform:none !important;\r\n\tline-height: 1 !important;\r\n}\r\n#wpsm_accordion_1449 .wpsm_panel-title a{\r\n\ttext-decoration:none;\r\n\toverflow:hidden;\r\n\tdisplay:block;\r\n\tpadding:0px;\r\n\tfont-size: 18px !important;\r\n\tfont-family: Open Sans !important;\r\n\tcolor:#000000 !important;\r\n\tborder-bottom:0px !important;\r\n}\r\n\r\n#wpsm_accordion_1449 .wpsm_panel-title a:focus {\r\noutline: 0px !important;\r\n}\r\n\r\n#wpsm_accordion_1449 .wpsm_panel-title a:hover, #wpsm_accordion_1449 .wpsm_panel-title a:focus {\r\n\tcolor:#000000 !important;\r\n}\r\n#wpsm_accordion_1449 .acc-a{\r\n\tcolor: #000000 !important;\r\n\tbackground-color:#e8e8e8 !important;\r\n\tborder-color: #ddd;\r\n}\r\n#wpsm_accordion_1449 .wpsm_panel-default > .wpsm_panel-heading{\r\n\tcolor: #000000 !important;\r\n\tbackground-color: #e8e8e8 !important;\r\n\tborder-color: #e8e8e8 !important;\r\n\tborder-top-left-radius: 0px;\r\n\tborder-top-right-radius: 0px;\r\n}\r\n#wpsm_accordion_1449 .wpsm_panel-default {\r\n\t\tborder:1px solid transparent !important;\r\n\t}\r\n#wpsm_accordion_1449 {\r\n\tmargin-bottom: 20px;\r\n\toverflow: hidden;\r\n\tfloat: none;\r\n\twidth: 100%;\r\n\tdisplay: block;\r\n}\r\n#wpsm_accordion_1449 .ac_title_class{\r\n\tdisplay: block;\r\n\tpadding-top: 12px;\r\n\tpadding-bottom: 12px;\r\n\tpadding-left: 15px;\r\n\tpadding-right: 15px;\r\n}\r\n#wpsm_accordion_1449  .wpsm_panel {\r\n\toverflow:hidden;\r\n\t-webkit-box-shadow: 0 0px 0px rgba(0, 0, 0, .05);\r\n\tbox-shadow: 0 0px 0px rgba(0, 0, 0, .05);\r\n\t\tborder-radius: 4px;\r\n\t}\r\n#wpsm_accordion_1449  .wpsm_panel + .wpsm_panel {\r\n\t\tmargin-top: 5px;\r\n\t}\r\n#wpsm_accordion_1449  .wpsm_panel-body{\r\n\tbackground-color:#ffffff !important;\r\n\tcolor:#000000 !important;\r\n\tborder-top-color: #e8e8e8 !important;\r\n\tfont-size:16px !important;\r\n\tfont-family: Open Sans !important;\r\n\toverflow: hidden;\r\n\t\tborder: 2px solid #e8e8e8 !important;\r\n\t}\r\n\r\n#wpsm_accordion_1449 .ac_open_cl_icon{\r\n\tbackground-color:#e8e8e8 !important;\r\n\tcolor: #000000 !important;\r\n\tfloat:right !important;\r\n\tpadding-top: 12px !important;\r\n\tpadding-bottom: 12px !important;\r\n\tline-height: 1.0 !important;\r\n\tpadding-left: 15px !important;\r\n\tpadding-right: 15px !important;\r\n\tdisplay: inline-block !important;\r\n}\r\n\r\n\t\t\t\r\n\t\t\t<\/style>\t\r\n\t\t\t<\/style>\r\n\t\t\t<div class=\"wpsm_panel-group\" id=\"wpsm_accordion_1449\" >\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1449 \" href=\"javascript:void(0)\" data-target=\"#ac_1449_collapse1\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-minus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t1.1. \u5408\u4f75\u5132\u5b58\u683c\u586b\u5145\u5e8f\u865f - \u65b9\u6cd51\uff1aCOUNTA\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1449_collapse1\" class=\"wpsm_panel-collapse collapse in\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<ul>\r\n \t<li><strong>Function:<\/strong>Counts the non-empty cells in a specified range.<\/li>\r\n \t<li><strong>Syntax:<\/strong>=COUNTA(value or cell range).<\/li>\r\n \t<li><strong>Method:<\/strong><\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>Select A2:A7<\/li>\r\n \t<li>Enter =COUNTA(A$1:A1)<\/li>\r\n \t<li>Ctrl + Enter<\/li>\r\n<\/ol>\r\n<ul>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1450\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%861.png?resize=610%2C423\" alt=\"\" width=\"610\" height=\"423\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%861.png?w=610&amp;ssl=1 610w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%861.png?resize=300%2C208&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%861.png?resize=150%2C104&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%861.png?resize=230%2C159&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%861.png?resize=350%2C243&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%861.png?resize=480%2C333&amp;ssl=1 480w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/li>\r\n \t<li>Explanation:<\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>The COUNTA function's argument starts at the cell above the current cell and uses a mixed reference. If the cell above is blank, it will start from the first non-blank cell.<\/li>\r\n \t<li>Here, merged cells refer mainly to irregular merged cells.<\/li>\r\n<\/ol>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1449 \" href=\"javascript:void(0)\" data-target=\"#ac_1449_collapse2\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-plus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t1.2. \u5408\u4f75\u5132\u5b58\u683c\u586b\u5145\u5e8f\u865f - \u65b9\u6cd52\uff1aMAX\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1449_collapse2\" class=\"wpsm_panel-collapse collapse\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<ul>\r\n \t<li><strong>Function:<\/strong>Returns the maximum value in a specified range.<\/li>\r\n \t<li><strong>Syntax:<\/strong>=MAX(value or cell range).<\/li>\r\n \t<li><strong>Method:<\/strong><\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>Select A2:A7<\/li>\r\n \t<li>Enter =MAX(A$2:A2)+1<\/li>\r\n \t<li>Ctrl + Enter<\/li>\r\n<\/ol>\r\n<ul>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1453\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%862.png?resize=608%2C419\" alt=\"\" width=\"608\" height=\"419\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%862.png?w=608&amp;ssl=1 608w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%862.png?resize=300%2C207&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%862.png?resize=150%2C103&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%862.png?resize=230%2C159&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%862.png?resize=350%2C241&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%862.png?resize=480%2C331&amp;ssl=1 480w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/li>\r\n \t<li>Explanation:<\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>MAX's argument is numeric; if non-numeric, the result is 0. Because A2 contains text, =MAX(A$2:A2) returns 0, and adding +1 yields 1. When filling the second merged-cell range the reference becomes A$2:A3, whose maximum is 1; +1 then returns 2, and so on.<\/li>\r\n \t<li>You can also control the starting serial number by using X as the adjustment value.<\/li>\r\n<\/ol>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1449 \" href=\"javascript:void(0)\" data-target=\"#ac_1449_collapse3\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-plus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t2. Summing merged cells\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1449_collapse3\" class=\"wpsm_panel-collapse collapse\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<ul>\r\n \t<li><strong>Method:<\/strong><\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>Select D2:D7<\/li>\r\n \t<li>Enter =SUM(C2:C7)-SUM(D3:D7)<\/li>\r\n \t<li>Ctrl + Enter<\/li>\r\n<\/ol>\r\n<ul>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1455\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?resize=783%2C416\" alt=\"\" width=\"783\" height=\"416\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?w=783&amp;ssl=1 783w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?resize=300%2C159&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?resize=150%2C80&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?resize=768%2C408&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?resize=230%2C122&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?resize=350%2C186&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%863.png?resize=480%2C255&amp;ssl=1 480w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/li>\r\n \t<li><strong>Explanation:<\/strong><\/li>\r\n \t<li style=\"list-style-type: none;\"><\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>The value of a merged cell is stored in the top-left cell of the merged range.<\/li>\r\n \t<li>This formula is divided into two parts: the first part calculates the sum of F3:F9; the second part calculates the sum of G4:G9. In other words, the total sum of all ranges minus the sums of the other ranges leaves the value of the first merged range.<\/li>\r\n<\/ol>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t<!-- Inner panel Start -->\r\n\t\t\t\t\t<div class=\"wpsm_panel wpsm_panel-default\">\r\n\t\t\t\t\t\t<div class=\"wpsm_panel-heading\" role=\"tab\" >\r\n\t\t\t\t\t\t  <h4 class=\"wpsm_panel-title\">\r\n\t\t\t\t\t\t\t<a  class=\"collapsed\"  data-toggle=\"collapse\" data-parent=\"#wpsm_accordion_1449 \" href=\"javascript:void(0)\" data-target=\"#ac_1449_collapse4\" onclick=\"do_resize()\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"ac_open_cl_icon fa fa-plus\"><\/span>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t<span class=\"ac_title_class\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span style=\"margin-right:6px;\" class=\"fa fa-laptop\"><\/span>\r\n\t\t\t\t\t\t\t\t\t3. Copying merged-cell contents\t\t\t\t\t\t\t\t<\/span>\r\n\t\t\t\t\t\t\t<\/a>\r\n\t\t\t\t\t\t  <\/h4>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t<div id=\"ac_1449_collapse4\" class=\"wpsm_panel-collapse collapse\"  >\r\n\t\t\t\t\t\t  <div class=\"wpsm_panel-body\">\r\n\t\t\t\t\t\t\t<ul>\r\n \t<li><strong>Function:<\/strong>Returns the value at the intersection of a specified row and column within a range.<\/li>\r\n \t<li><strong>Syntax:<\/strong>=INDEX(cell range, row number).<\/li>\r\n \t<li><strong>Method:<\/strong><\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>Select D2:D7<\/li>\r\n \t<li>Enter =INDEX(E$2:E$4,COUNTA(D$1:D1))<\/li>\r\n \t<li>Ctrl + Enter<\/li>\r\n<\/ol>\r\n<ul>\r\n \t<li><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1454\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=963%2C419\" alt=\"\" width=\"963\" height=\"419\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?w=963&amp;ssl=1 963w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=300%2C131&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=150%2C65&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=768%2C334&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=830%2C361&amp;ssl=1 830w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=230%2C100&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=350%2C152&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/08\/%E5%90%88%E4%BD%B5%E5%84%B2%E5%AD%98%E6%A0%BC%E6%8A%80%E5%B7%A7%E5%85%A8%E9%9B%864.png?resize=480%2C209&amp;ssl=1 480w\" sizes=\"auto, (max-width: 963px) 100vw, 963px\" \/><\/li>\r\n \t<li>Explanation:<\/li>\r\n<\/ul>\r\n<ol>\r\n \t<li>The purpose of this task is to copy values from the Notes column into the total cells. Pasting from a non-merged range into a merged range (or into merged ranges with different structures) will cause errors.<\/li>\r\n \t<li>In the formula, the COUNTA function counts the non-empty cells starting from the cell above the current cell and serves as INDEX's second argument.<\/li>\r\n<\/ol>\t\t\t\t\t\t  <\/div>\r\n\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<!-- Inner panel End -->\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\r\n<script type=\"text\/javascript\">\r\n\t\r\n\t\tfunction do_resize(){\r\n\r\n\t\t\tvar width=jQuery( '.wpsm_panel .wpsm_panel-body iframe' ).width();\r\n\t\t\tvar height=jQuery( '.wpsm_panel .wpsm_panel-body iframe' ).height();\r\n\r\n\t\t\tvar toggleSize = true;\r\n\t\t\tjQuery('iframe').animate({\r\n\t\t\t    width: toggleSize ? width : 640,\r\n\t\t\t    height: toggleSize ? height : 360\r\n\t\t\t  }, 250);\r\n\r\n\t\t\t  toggleSize = !toggleSize;\r\n\t\t}\r\n\t\t\r\n<\/script>","protected":false},"excerpt":{"rendered":"<p>\u5728\u8cc7\u6599\u8655\u7406\u548c\u5206\u6790\u4e2d\uff0c\u76e1\u53ef\u80fd\u7684\u5c11\u7528\u5408\u4f75\u5132\u5b58\u683c\uff0c\u4f46\u662f\u5728\u5be6\u969b\u7684\u5de5\u4f5c\u4e2d\uff0c\u53c8\u96e2\u4e0d\u958b\u5408\u4f75\u5132\u5b58\u683c\uff0c\u6240\u4ee5\uff0c\u638c\u63e1\u5e38\u7528\u7684\u5408\u4f75\u5132\u5b58\u683c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3789,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8,20],"tags":[176,3,22,13,93],"class_list":["post-1451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-onlinesupport","tag-counta","tag-index","tag-max","tag-sum","tag-merged-cells"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2026\/08\/new_covers_batch_02_451_excel.jpg?fit=816%2C1088&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/comments?post=1451"}],"version-history":[{"count":2,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1451\/revisions"}],"predecessor-version":[{"id":1457,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1451\/revisions\/1457"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media\/3789"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media?parent=1451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/categories?post=1451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/tags?post=1451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}