轻松搞定Excel2003的二级联动菜单

[[{"txt": "Excel2003\u7684\u4e8c\u7ea7\u8054\u52a8\u83dc\u5355\u529f\u80fd\u5f3a\u5927\uff0c\u65b9\u4fbf\u5b9e\u60e0\uff0c\u5c3d\u4eba\u7686\u77e5\uff0c\u4f46\u662f\u4e5f\u522b\u4ee5\u4e3a\u5f88\u597d\u4e0a\u624b\u3002\u719f\u4e86\u4e0d\u89c9\u5f97\uff0c\u65b0\u5b66\u7684\u4eba\u6068\u4e0d\u5f97\u8981\u6253\u5e08\u5085\u4e86\uff0c\u56e0\u4e3a\u4ed6\u4eec\u641e\u7684\u8bfb\u4e0d\u61c2\uff01\u9996\u5148\u4ed6\u7ed9\u4f60\u770b\u4e00\u4e2a\u8868\uff0c\u5982\u4f55\u8ba9\u4f60\u53bb\u6279\u91cf\u5b9a\u4e49\u540d\u79f0\u63a5\u7740\u8bbe\u7f6e\u6570\u636e\u6709\u6548\u6027\u7b49\u3002\u5176\u5b9e\u90a3\u51e0\u4e2a\u8868\u5e76\u975e\u662f\u4e00\u8bbe\u7f6e\u597d\u5c31\u81ea\u52a8\u8df3\u51fa\u6765\uff0c\u4f60\u600e\u4e48\u4e5f\u5f04\u4e0d\u660e\u767d\u3002\u8fd8\u5728\u4f7f\u75282003\u7684\u670b\u53cb\uff0c\u8bf7\u770b\u6211\u4e0b\u9762\u7684\u5206\u6b65\u8bf4\u660e\uff0c\u4e00\u5f04\u5c31\u4e0a\u624b\uff0c\u8f7b\u677e\u641e\u5b9a2003\u7684\u4e8c\u7ea7\u8054\u52a8\u83dc\u5355\uff01"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "Excel2003\u529e\u516c\u8f6f\u4ef6"}, {"txt": "\u7535\u5b50\u6570\u636e\uff08\u8868\uff09"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u8fd0\u884cEXCEL2003\uff0c\u5728\u540e\u9762\u7684\u4f4d\u7f6e\uff08\u53ea\u8981\u7559\u51fa\u5236\u4f5c\u4e8c\u7ea7\u8054\u52a8\u83dc\u5355\u7684\u64cd\u4f5c\u4f4d\u7f6e\u5373\u53ef\uff09\uff0c\u5236\u4f5c\u4e00\u4e2a\u8868\u5907\u7528\uff08\u63d0\u4f9b\u6e90\u6570\u636e\uff09\u3002\u8fd9\u91cc\u6211\u4eec\u5236\u4f5c\u7684\u8868\u6781\u7b80\u5355\uff0c\u5e76\u4e14\u662f\u5047\u8bbe\u7684\u3002\u4f4d\u7f6e\u5728H1\uff1aJ7\uff0c\u5982\u4e0b\u56fe\u6240\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/fdb4f00d3aceaad715d97951eee7340f6578b805.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5bf9\u6e90\u8868\u4f5c\u4e00\u4e9b\u7279\u5b9a\u7684\u8bbe\u7f6e\u3002\u5426\u5219\u63a5\u4e0b\u6765\u7684\u4e8c\u7ea7\u8054\u52a8\u83dc\u5355\u65e0\u6cd5\u5f15\u7528\u3002\u6211\u4eec\u8bbe\u7f6e\u5176\u9996\u884c\u4e3a\u540d\u79f0\uff0c\u63a5\u4e0b\u6765\u7684\u5f15\u7528\u4e2d\u53ea\u8981\u5f15\u7528\u540d\u79f0\uff0c\u4e5f\u5c31\u5f15\u7528\u4e86\u4e0b\u9762\u7684\u6570\u636e\u4e86\u3002\u5177\u4f53\u64cd\u4f5c\u662f\uff1a\u9009\u4e2d\u9996\u884c+\u81f3\u5c11\u4e00\u884c\u6570\u636e\uff08\u4f60\u4e5f\u53ef\u4ee5\u628a\u6570\u636e\u5168\u9009\uff09\uff0c\u7136\u540e\u5728\u83dc\u5355\u4e0a\u627e\u5230\u201c\u63d2\u5165\u2014\u2014\u540d\u79f0\u2014\u2014\u6307\u5b9a\u201d\uff0c\u5982\u4e0b\u56fe\u6240\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/0da37be7340f64787891cb0afd3e21c2bad6b505.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u5355\u51fb\uff0c\u51fa\u73b0\u4e0b\u9762\u7684\u8bbe\u7f6e\u9762\u677f\uff0c\u6b64\u52fe\u9009\u201c\u540d\u79f0\u521b\u5efa\u4e8e\u2014\u2014\u9996\u884c\u201d\uff0c\u5982\u4e0b\u56fe\u6240\u793a\uff0c\u518d\u5355\u51fb\u786e\u5b9a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/bff8683e21c2bbd69062185b116186254093ae05.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u8868\u7684\u524d\u9762\uff08\u6b64\u5904\u4ee5A\u5217\u4e3a\u4f8b\uff09\u8f93\u5165\u5982\u4e0b\u56fe\u6240\u793a\u7684\u5185\u5bb9\u3002\u6211\u4eec\u7684\u4e8c\u7ea7\u8054\u52a8\u83dc\u5355\u5c31\u662f\u5728\u6b64\u8868\u4e2d\u4f53\u73b0\u4e86\u3002A\u5217\u7684\u5b57\u6bb5\u540d\u79f0\u5c31\u662f\u4e0a\u9762\u6b65\u9aa41\u30012\u30013\u4e2d\u7684\u8868\u7684\u9996\u884c\u540d\u79f0\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/6ca9846186254193b85ac5b7df1bd10ff326ab05.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u4e0b\u56fe\u6240\u793a\u7684\u4f4d\u7f6e\uff08\u533a\u57dfB2\uff1aB4\uff09\u9009\u4e2d\uff0c\u7136\u540e\u5728\u83dc\u5355\u4e0a\u627e\u5230\u201c\u6570\u636e\u2014\u2014\u6709\u6548\u6027\u201d\uff0c\u5982\u4e0b\u56fe\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/d04eec260d9a310e6a2b9c9931b842406bfea205.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u70b9\u51fb\u51fa\u73b0\u5982\u4e0b\u56fe\u6240\u793a\u7684\u9762\u677f\uff0c\u5728\u201c\u5141\u8bb8\u201d\u5e95\u4e0b\u9009\u62e9\u201c\u5e8f\u5217\u201d\uff1b\u5728\u4e0b\u9762\u7684\u201c\u6765\u6e90\u201d\u5904\u8f93\u5165\u6846\u4e2d\u8f93\u5165\"=indirect(A2)\"\uff0c\u7136\u540e\u5355\u51fb\u786e\u5b9a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e86ba4b842406afe41a684761eee41c1b6279f05.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u6b64\u65f6\uff0c\u6211\u4eec\u53d1\u73b0\uff0c\u70b9\u51fbB2\uff1aB4\u7684\u4efb\u4f55\u4e00\u5355\u5143\u683c\uff0c\u53f3\u8fb9\u90fd\u6709\u4e00\u4e2a\u4e0b\u62c9\u7bad\u5934\u3002\u5982\u4e0b\u56fe\u6240\u793a\uff0c\u5de6\u8fb9\u70b9\u51fb\u201c\u4e09\u661f\u201d\uff0c\u5728\u53f3\u8fb9\u4e0b\u62c9\u7bad\u5934\u4e0a\u70b9\u51fb\uff0c\u5c31\u51fa\u73b0\u4e86\u4e09\u661f\u624b\u673a\u7684\u4e0d\u540c\u578b\u53f7\uff0c\u53ea\u8981\u70b9\u51fb\u5176\u4e2d\u4e00\u4e2a\uff0c\u5b83\u5c31\u81ea\u52a8\u586b\u5145\u5230\u5355\u5143\u683c\u4e2d\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/4080a927ac530688189ed07957e8904801fc9605.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u5b66\u54ea\u4e2a\u7684\u6559\u7a0b\u90fd\u597d\uff0c\u8bb0\u4f4f\u4e00\u70b9\u4e0d\u8981\u5728\u6e90\u8868\u4e0a\u53bb\u7ea0\u7f20\u3002\u4ec0\u4e48\u8bbe\u7f6e\u90fd\u4e0d\u4f1a\u76f4\u63a5\u5c06\u6e90\u8868\u5f04\u6210\u4e8c\u7ea7\u8054\u52a8\u83dc\u5355\u7684\u8868\u3002"}, {"txt": "\u6279\u91cf\u5b9a\u4e49\u540d\u79f0\u4e4b\u540e\uff0c\u6e90\u8868\u6ca1\u6709\u6539\u53d8\u5916\u89c2\u3002\u56e0\u6b64\u4f60\u4e0d\u8981\u4e00\u8bbe\u7f6e\u5c31\u6709\u6240\u671f\u671b\u3002"}]]