{"id":884,"date":"2019-08-15T14:08:16","date_gmt":"2019-08-15T06:08:16","guid":{"rendered":"http:\/\/www.fyndpro.com\/?p=884"},"modified":"2026-08-27T16:15:42","modified_gmt":"2026-08-27T08:15:42","slug":"highlight_cells","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/en\/highlight_cells\/","title":{"rendered":"Highlight the cell, row, and column under the mouse in real time"},"content":{"rendered":"<blockquote><p>When working with a large, data-dense Excel sheet, it\u2019s easy to lose your place without highlighting. If you can highlight the cell, row, and column under the mouse in real time, reviewing data becomes much more effective. How do you set that up?<\/p><\/blockquote>\n\t\t\t\t\t\t\t<h3 style=\"margin-bottom:20px;display:block;width:100%;margin-top:10px\">Highlight the cell, row, and column under the mouse in real time <\/h3>\r\n\t\t\t\t\t\t<style>\r\n\t\t\t\t<style>\r\n#wpsm_accordion_881 .wpsm_panel-heading{\r\n\tpadding:0px !important;\r\n}\r\n#wpsm_accordion_881 .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_881 .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_881 .wpsm_panel-title a:focus {\r\noutline: 0px !important;\r\n}\r\n\r\n#wpsm_accordion_881 .wpsm_panel-title a:hover, #wpsm_accordion_881 .wpsm_panel-title a:focus {\r\n\tcolor:#000000 !important;\r\n}\r\n#wpsm_accordion_881 .acc-a{\r\n\tcolor: #000000 !important;\r\n\tbackground-color:#e8e8e8 !important;\r\n\tborder-color: #ddd;\r\n}\r\n#wpsm_accordion_881 .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_881 .wpsm_panel-default {\r\n\t\tborder:1px solid transparent !important;\r\n\t}\r\n#wpsm_accordion_881 {\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_881 .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_881  .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_881  .wpsm_panel + .wpsm_panel {\r\n\t\tmargin-top: 5px;\r\n\t}\r\n#wpsm_accordion_881  .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_881 .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_881\" >\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_881 \" href=\"javascript:void(0)\" data-target=\"#ac_881_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-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\tStep 1: Configure row and column highlighting\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_881_collapse1\" 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<ol>\r\n \t<li>Select A1:M20<\/li>\r\n \t<li>Home \u2192 Conditional Formatting \u2192 New Rule<\/li>\r\n \t<li>Use a formula to determine which cells to format<\/li>\r\n \t<li>Enter the formula:\r\n<pre>=OR(CELL(\"row\")=ROW(), CELL(\"col\")=COLUMN())\r\n\r\n<\/pre>\r\n<\/li>\r\n \t<li>Format \u2192 Fill \u2192 select a color<\/li>\r\n<\/ol>\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-883\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight2.png?resize=363%2C409\" alt=\"\" width=\"363\" height=\"409\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight2.png?w=363&amp;ssl=1 363w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight2.png?resize=133%2C150&amp;ssl=1 133w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight2.png?resize=266%2C300&amp;ssl=1 266w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight2.png?resize=230%2C259&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight2.png?resize=350%2C394&amp;ssl=1 350w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/>\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_881 \" href=\"javascript:void(0)\" data-target=\"#ac_881_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\tStep 2: Configure cell highlighting\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_881_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<ol>\r\n \t<li>Select A1:M20<\/li>\r\n \t<li>Home \u2192 Conditional Formatting \u2192 New Rule<\/li>\r\n \t<li>Use a formula to determine which cells to format<\/li>\r\n \t<li>Enter the formula:\r\n<pre>=AND(CELL(\"row\")=ROW(),CELL(\"col\")=COLUMN())<\/pre>\r\n<\/li>\r\n \t<li>Format \u2192 Fill \u2192 select a color<\/li>\r\n<\/ol>\r\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-882\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight.png?resize=364%2C409\" alt=\"\" width=\"364\" height=\"409\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight.png?w=364&amp;ssl=1 364w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight.png?resize=133%2C150&amp;ssl=1 133w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight.png?resize=267%2C300&amp;ssl=1 267w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight.png?resize=230%2C258&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/08\/%E5%AF%A6%E6%99%82%E6%8A%8A%E9%BC%A0%E6%A8%99%E6%89%80%E5%9C%A8%E4%BD%8D%E7%BD%AE%E7%9A%84%E5%84%B2%E5%AD%98%E6%A0%BC%E3%80%81%E8%A1%8C%E3%80%81%E5%88%97Highlight.png?resize=350%2C393&amp;ssl=1 350w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/>\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_881 \" href=\"javascript:void(0)\" data-target=\"#ac_881_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\tFormula explanation:\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_881_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>CELL(\"row\")\uff0c\u7372\u53d6\u6ed1\u9f20\u6240\u5728\u5132\u5b58\u683c\u884c\u865f<\/li>\r\n \t<li>ROW() \u2014 returns the row number of the cell containing the formula<\/li>\r\n \t<li>CELL(\"row\")=ROW()\uff0c\u6ed1\u9f20\u6240\u5728\u5132\u5b58\u683c\u884c\u865f\u7b49\u65bc\u516c\u5f0f\u6240\u5728\u884c\u7684\u884c\u865f<\/li>\r\n<\/ul>\r\n<ul>\r\n \t<li>CELL(\"col\")\uff0c\u7372\u53d6\u6ed1\u9f20\u6240\u5728\u5132\u5b58\u683c\u5217\u865f<\/li>\r\n \t<li>COLUMN() \u2014 returns the column number of the cell containing the formula<\/li>\r\n \t<li>CELL(\"col\")= COLUMN ()\uff0c\u6ed1\u9f20\u6240\u5728\u5132\u5b58\u683c\u5217\u865f\u7b49\u65bc\u516c\u5f0f\u6240\u5728\u5217\u7684\u5217\u865f<\/li>\r\n<\/ul>\r\n<ul>\r\n \t<li>OR(condition1, condition2) \u2014 returns TRUE if either condition1 or condition2 is met<\/li>\r\n \t<li>The formula means that when a cell's row or column number equals the row or column number of the cell clicked with the mouse, the condition is true and the entire row or column of the clicked cell will use the specified fill format.<\/li>\r\n<\/ul>\r\n<ul>\r\n \t<li>AND(condition1, condition2) \u2014 returns TRUE only if both condition1 and condition2 are met<\/li>\r\n \t<li>This formula means the condition is met when a cell's row and column numbers both equal those of the mouse-clicked cell; the clicked cell will then use the specified fill format.<\/li>\r\n<\/ul>\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_881 \" href=\"javascript:void(0)\" data-target=\"#ac_881_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\tFinal step\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_881_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\tClick any cell with the mouse, then press F9 \u2014 the cell and its row and column will be highlighted.\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_881 \" href=\"javascript:void(0)\" data-target=\"#ac_881_collapse5\" 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\tDownload demo file\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_881_collapse5\" 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<span style=\"color: #d1d1d1;\">[Hide]<\/span>\r\n\r\nJoin our 'Office Suite Real-Time Support' free Facebook group to learn more about Office.\r\n<a href=\"https:\/\/www.fyndpro.com\/index.php\/our-service\/unlimited-support\/\">View details<\/a>\r\n\r\n<div id=\"grid-gallery-10-69065\" data-gg-id=\"10\" data-title=\"\u52a0\u5165FB\u7fa4\u7d44\" data-grid-type=\"3\" data-offset=\"15.3\" data-area-position=\"center\" data-icons=\"false\" data-preloader=\"false\" data-width=\"400\" data-height=\"400\" data-padding=\"0\" data-quicksand=\"disabled\" data-quicksand-duration=\"none\" data-popup-type=\"disable\" data-columns-number=\"3\" data-popup-image-text=\"data-description\" data-popup-widthsize=\"auto\" data-popup-heightsize=\"auto\" data-popup-i18n-words=\"{&quot;close&quot;:&quot;close&quot;,&quot;next&quot;:&quot;next&quot;,&quot;previous&quot;:&quot;previous&quot;,&quot;start_slideshow&quot;:&quot;start slideshow&quot;,&quot;stop_slideshow&quot;:&quot;stop slideshow&quot;,&quot;image&quot;:&quot;image&quot;,&quot;of&quot;:&quot;of&quot;,&quot;prev&quot;:&quot;prev&quot;,&quot;cExpand&quot;:&quot;Expand&quot;,&quot;cPrevious&quot;:&quot;Previous&quot;,&quot;cNext&quot;:&quot;Next&quot;,&quot;cExpandStr&quot;:&quot;Expand the image&quot;,&quot;cRotate&quot;:&quot;Rotate&quot;,&quot;cDetails&quot;:&quot;Details&quot;}\" data-popup-slideshow=\"false\" data-popup-slideshow-speed=\"2500\" data-popup-hoverstop=\"true\" data-popup-slideshow-auto=\"false\" data-popup-background=\"\" data-popup-transparency=\"30\" data-popup-disable-history=\"\" data-popup-disable-changed-url=\"\" data-popup-border-type=\"solid\" data-popup-border-color=\"\" data-popup-border-width=\"\" data-popup-border-enable=\"\" data-fullscreen=\"false\" data-hide-tooltip=\"false\" data-caption-font-family=\"Default\" data-caption-text-size=\"14px\" data-is-mobile=\"0\" data-caption-mobile=\"false\" data-hide-long-tltp-title=\"0\" data-caption-disabled-on-mobile=\"false\" data-responsive-colums=\"{&quot;desktop&quot;:{&quot;width&quot;:&quot;1200&quot;,&quot;columns&quot;:&quot;3&quot;},&quot;tablet&quot;:{&quot;width&quot;:&quot;768&quot;,&quot;columns&quot;:&quot;2&quot;},&quot;mobile&quot;:{&quot;width&quot;:&quot;320&quot;,&quot;columns&quot;:&quot;1&quot;}}\" data-thumb-overlay-personal=\"1\" data-popup-placement-type=\"0\" data-social-sharing=\"{&quot;enabled&quot;:&quot;&quot;,&quot;gallerySharing&quot;:{&quot;enabled&quot;:null,&quot;position&quot;:null},&quot;imageSharing&quot;:{&quot;enabled&quot;:null,&quot;wrapperClass&quot;:&quot; vertical &quot;},&quot;popupSharing&quot;:{&quot;enabled&quot;:null,&quot;wrapperClass&quot;:&quot; vertical &quot;}}\" class=\"grid-gallery grid-gallery-fixed\" style=\" width:100%; height:auto; margin-left:auto; margin-right:auto;position:relative;\"> <div class=\"gallery-sharing-top\" style=\"display:none;\"> <\/div> <div id=\"photos-10\" class=\"grid-gallery-photos\"><a id=\"gg-10-209\" class=\"gg-link\" data-attachment-id=\"807\" href=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-1-2.png?ssl=1\" target=\"_self\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (1)\" rel=\"nofollow\" style=\"border-radius:0px;\" ><figure class=\"grid-gallery-caption\" data-grid-gallery-type=\"none\" data-index=\"0\" style=\"display:none;border-radius:0px;; margin:15.3px; width:400px;\" ><div class=\"crop\" style=\" width:400px; height:400px; overflow:hidden;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-1-2-400x400.png?resize=400%2C400\" class=\"ggImg ggNotInitImg\" alt=\"\u52a0\u5165FB\u7fa4\u7d44 (1)\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (1)\" data-description=\"\u52a0\u5165FB\u7fa4\u7d44 (1)\" data-caption=\"\u53ef\u6536\u770b\u904e\u767e\u6bb5\u5ee3\u6771\u8a71\u6559\u5b78\u77ed\u7247\uff0c\u5305\u62ec\u6c92\u6709\u516c\u958b\u7684Excel\u6280\u5de7\" data-title=\"\u52a0\u5165FB\u7fa4\u7d44 (1)\" data-gg-original-width=\"400\" width=\"400\" data-gg-original-height=\"400\" height=\"400\" style=\" width:400px; height:400px;\" \/><\/div><figcaption class=\"\" data-alpha=\"2\" style=\"color:#ffffff; background-color:#d20a11; font-size:14px; text-align:left; font-family:Default; opacity:1; bottom:0;\" ><div class=\"grid-gallery-figcaption-wrap\" style=\" vertical-align:top;\"><\/div><\/figcaption><\/figure><\/a><a id=\"gg-10-221\" class=\"gg-link\" data-attachment-id=\"1238\" href=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/05\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-8.jpeg?ssl=1\" target=\"_self\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (8)\" rel=\"nofollow\" style=\"border-radius:0px;\" ><figure class=\"grid-gallery-caption\" data-grid-gallery-type=\"none\" data-index=\"1\" style=\"display:none;border-radius:0px;; margin:15.3px; width:400px;\" ><div class=\"crop\" style=\" width:400px; height:400px; overflow:hidden;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/05\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-8-400x400.jpeg?resize=400%2C400\" class=\"ggImg ggNotInitImg\" alt=\"\u52a0\u5165FB\u7fa4\u7d44 (8)\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (8)\" data-description=\"\u52a0\u5165FB\u7fa4\u7d44 (8)\" data-caption=\"\u591a\u500b\u55ae\u5143\u5206\u985e\uff0c\u5167\u5bb9\u4e00\u76ee\u4e86\u7136\" data-title=\"\u52a0\u5165FB\u7fa4\u7d44 (8)\" data-gg-original-width=\"400\" width=\"400\" data-gg-original-height=\"400\" height=\"400\" style=\" width:400px; height:400px;\" \/><\/div><figcaption class=\"\" data-alpha=\"2\" style=\"color:#ffffff; background-color:#d20a11; font-size:14px; text-align:left; font-family:Default; opacity:1; bottom:0;\" ><div class=\"grid-gallery-figcaption-wrap\" style=\" vertical-align:top;\"><\/div><\/figcaption><\/figure><\/a><a id=\"gg-10-207\" class=\"gg-link\" data-attachment-id=\"805\" href=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-2-1.png?ssl=1\" target=\"_self\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (2)\" rel=\"nofollow\" style=\"border-radius:0px;\" ><figure class=\"grid-gallery-caption\" data-grid-gallery-type=\"none\" data-index=\"2\" style=\"display:none;border-radius:0px;; margin:15.3px; width:400px;\" ><div class=\"crop\" style=\" width:400px; height:400px; overflow:hidden;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-2-1-400x400.png?resize=400%2C400\" class=\"ggImg ggNotInitImg\" alt=\"\u52a0\u5165FB\u7fa4\u7d44 (2)\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (2)\" data-description=\"\u52a0\u5165FB\u7fa4\u7d44 (2)\" data-caption=\"\u5167\u5bb9\u4e5f\u5305\u62ecWord\u548cPowerPoint\" data-title=\"\u52a0\u5165FB\u7fa4\u7d44 (2)\" data-gg-original-width=\"400\" width=\"400\" data-gg-original-height=\"400\" height=\"400\" style=\" width:400px; height:400px;\" \/><\/div><figcaption class=\"\" data-alpha=\"2\" style=\"color:#ffffff; background-color:#d20a11; font-size:14px; text-align:left; font-family:Default; opacity:1; bottom:0;\" ><div class=\"grid-gallery-figcaption-wrap\" style=\" vertical-align:top;\"><\/div><\/figcaption><\/figure><\/a><a id=\"gg-10-208\" class=\"gg-link\" data-attachment-id=\"806\" href=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-4-1.png?ssl=1\" target=\"_self\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (4)\" rel=\"nofollow\" style=\"border-radius:0px;\" ><figure class=\"grid-gallery-caption\" data-grid-gallery-type=\"none\" data-index=\"3\" style=\"display:none;border-radius:0px;; margin:15.3px; width:400px;\" ><div class=\"crop\" style=\" width:400px; height:400px; overflow:hidden;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-4-1-400x400.png?resize=400%2C400\" class=\"ggImg ggNotInitImg\" alt=\"\u52a0\u5165FB\u7fa4\u7d44 (4)\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (4)\" data-description=\"\u52a0\u5165FB\u7fa4\u7d44 (4)\" data-caption=\"\u5982\u9047\u4e0d\u660e\u767d\u7684\u5730\u65b9\uff0c\u53ef\u96a8\u6642\u767c\u554f\" data-title=\"\u52a0\u5165FB\u7fa4\u7d44 (4)\" data-gg-original-width=\"400\" width=\"400\" data-gg-original-height=\"400\" height=\"400\" style=\" width:400px; height:400px;\" \/><\/div><figcaption class=\"\" data-alpha=\"2\" style=\"color:#ffffff; background-color:#d20a11; font-size:14px; text-align:left; font-family:Default; opacity:1; bottom:0;\" ><div class=\"grid-gallery-figcaption-wrap\" style=\" vertical-align:top;\"><\/div><\/figcaption><\/figure><\/a><a id=\"gg-10-222\" class=\"gg-link\" data-attachment-id=\"1239\" href=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/05\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-9.jpeg?ssl=1\" target=\"_self\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (9)\" rel=\"nofollow\" style=\"border-radius:0px;\" ><figure class=\"grid-gallery-caption\" data-grid-gallery-type=\"none\" data-index=\"4\" style=\"display:none;border-radius:0px;; margin:15.3px; width:400px;\" ><div class=\"crop\" style=\" width:400px; height:400px; overflow:hidden;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2020\/05\/%E5%8A%A0%E5%85%A5FB%E7%BE%A4%E7%B5%84-9-400x400.jpeg?resize=400%2C400\" class=\"ggImg ggNotInitImg\" alt=\"\u52a0\u5165FB\u7fa4\u7d44 (9)\" title=\"\u52a0\u5165FB\u7fa4\u7d44 (9)\" data-description=\"\u52a0\u5165FB\u7fa4\u7d44 (9)\" data-caption=\"\u6bcf\u500b\u6559\u5b78\u4ea6\u4ee5\u66f4\u4ed4\u7d30\u7684\u4e3b\u984c\u5206\u985e\uff0c\u4f8b\u5982\u8981\u5b78VLOOKUP\uff0c\u6240\u6709\u76f8\u95dc\u5f71\u7247\u5373\u6642\u9001\u4e0a\" data-title=\"\u52a0\u5165FB\u7fa4\u7d44 (9)\" data-gg-original-width=\"400\" width=\"400\" data-gg-original-height=\"400\" height=\"400\" style=\" width:400px; height:400px;\" \/><\/div><figcaption class=\"\" data-alpha=\"2\" style=\"color:#ffffff; background-color:#d20a11; font-size:14px; text-align:left; font-family:Default; opacity:1; bottom:0;\" ><div class=\"grid-gallery-figcaption-wrap\" style=\" vertical-align:top;\"><\/div><\/figcaption><\/figure><\/a> <div class=\"grid-gallery-clearfix\"><\/div> <\/div> <div class=\"gallery-sharing-bottom\" style=\"display:none;\"> <\/div> <div class=\"gallery-sharing-image\" style=\"display:none;\"> <\/div> <div class=\"gallery-sharing-popup\" style=\"display:none;\"> <\/div> <div class=\"grid-gallery-clearfix\"><\/div> <\/div> <!-- Gallery by Supsystic plugin1.21.1 -->\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>\u5982\u679c\u8981\u9762\u5c0d\u4e00\u500b\u5927\u7bc4\u570d\u3001\u591a\u8cc7\u6599\u7684Excel\uff0c\u6c92\u6709Highlight\u78ba\u5be6\u597d\u5bb9\u6613\u770b\u932f\u4f4d\uff0c\u6240\u4ee5\u5982\u679c\u53ef\u505a\u5230\u5be6\u6642\u5c07\u9f20\u6a19\u6240\u5728 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3788,"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":[116,112,113,114,115,28,273,152,281],"class_list":["post-884","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-onlinesupport","tag-and","tag-cell","tag-column","tag-f9","tag-or","tag-row","tag-conditional-formatting","tag-column-2","tag-data-lookup"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2026\/08\/new_covers_batch_02_455_excel.jpg?fit=816%2C1088&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/884","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=884"}],"version-history":[{"count":2,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/884\/revisions"}],"predecessor-version":[{"id":887,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/884\/revisions\/887"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media\/3788"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media?parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/categories?post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/tags?post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}