如何快速地拆分合并的单元格并填充数据

如何快速地拆分合并的单元格并填充数据

回复
  • 林爷ミ吐槽帝用户
    [[{"txt": "\u5728\u505aExcel\u6570\u636e\u8868\u4e3a\u4e86\u7f8e\u89c2\u3001\u76f4\u89c2\uff0c\u7ecf\u5e38\u4f1a\u628a\u76f8\u540c\u5185\u5bb9\u7684\u5355\u5143\u683c\u6570\u636e\u5408\u5e76\u3002\u4f46\u8fd9\u6837\u505a\u7834\u574f\u4e86Excel\u8868\u7684\u5b8c\u6574\u6027\uff0c\u4e0d\u5229\u4e8e\u540e\u671f\u6570\u636e\u5206\u6790\u3002\u8fd9\u5c31\u8981\u6211\u4eec\u628a\u5408\u5e76\u7684\u5355\u5143\u683c\u91cd\u65b0\u62c6\u5206\u5e76\u586b\u5145\u6570\u636e\uff0c\u5982\u4e0b\u56fe\uff0c\u5982\u4f55\u5feb\u901f\u5b9e\u73b0\u5462\uff1f"}, {"img": ["https://exp-picture.cdn.bcebos.com/4080a927ac530688cfa4057957e8904801fc96df.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "Excel 2013"}], [{"txt": ["\u6b65\u9aa41/\u53d6\u6d88\u5355\u5143\u683c\u5408\u5e76"]}, {"txt": "\u5355\u51fb\u201c\u5f00\u59cb\u201d\u9009\u9879\u5361\u2192\u201c\u5408\u5e76\u540e\u5c45\u4e2d\u201d\u9009\u9879\u9009\u62e9\u201c\u53d6\u6d88\u5355\u5143\u683c\u5408\u5e76\u201d\u547d\u4ee4\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/ad121888912ca5cabc6030fb8bfc77f7990e94df.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/dda98e4800fc77f7fc86ff93c8715fdb372090df.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6b65\u9aa42/\u4f7f\u7528\u683c\u5f0f\u5237\u683c\u5f0f\u5316\u590d\u5236\u5355\u5143\u683c\u683c\u5f0f"]}, {"txt": "\u9009\u4e2d\u5df2\u7ecf\u62c6\u5206\u8fd8\u539f\u7684\u5355\u5143\u683c\uff0c\u5355\u51fb\u201c\u5f00\u59cb\u201d\u9009\u9879\u5361\u2192\u201c\u526a\u8d34\u677f\u201d\u9009\u9879\u9009\u62e9\u201c\u683c\u5f0f\u5237\u201d\u547d\u4ee4\uff0c\u4e0b\u62c9\u5c06\u62c6\u5206\u683c\u5f0f\u5e94\u7528\u5230\u6240\u6709\u5408\u5e76\u7684\u5355\u5143\u683c\u4e2d\u3002\u6240\u6709\u5408\u5e76\u7684\u5355\u5143\u683c\u4f1a\u88ab\u8fd8\u539f\u4e3a\u62c6\u5206\u5355\u5143\u683c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/01bd69f7980e5f2025f9ff68bd20b93acc898edf.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/994f412043715fdb5ea81989468920c5270f8cdf.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5c06\u6240\u6709\u5355\u5143\u683c\u9009\u4e2d\uff0c\u6309\u4e0b\u5feb\u6377\u952e\u201cF5\u201d\uff0c\u5f39\u51fa\u201c\u5b9a\u4f4d\u201d\u5bf9\u8bdd\u6846\uff0c\u9009\u62e9\u201c\u5b9a\u4f4d\u6761\u4ef6\u201d\u547d\u4ee4\uff0c\u9009\u62e9\u201c\u7a7a\u503c\u201d\u9009\u9879\uff0c\u70b9\u51fb\u786e\u5b9a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/423041db3620b93aa7018076ad0f8835dc8a8adf.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/b87bd38920c5260fe5bd7d39d2de4507890189df.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/274e9635dd8a59de358f28b2b370d5413b8c84df.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8fd9\u65f6\u6240\u6709\u7a7a\u503c\u7684\u5355\u5143\u683c\u4f1a\u663e\u793a\u4e3a\u9009\u4e2d\u72b6\u6001\uff0c\u5982\u56fe\u76f4\u63a5\u8f93\u5165\u516c\u5f0f\u201c=A3\u201d\uff08\u6b64\u5904\u4e0d\u5f97\u5355\u673a\u56fe\u6807\uff0c\u800c\u662f\u76f4\u63a5\u901a\u8fc7\u952e\u76d8\u8f93\u5165\u5185\u5bb9\u4f1a\u81ea\u52a8\u5728\u7b2c\u4e00\u4e2a\u7a7a\u5355\u5143\u683c\u8f93\u5165\uff09\uff0c\u8f93\u5165\u5b8c\u6210\u540e\u6309\u4e0b\u201cCtrl+Enter\u201d\u5feb\u6377\u952e\uff0c\u5373\u53ef\u81ea\u52a8\u586b\u5145\u6240\u6709\u7a7a\u503c\u5355\u5143\u683c\u3002\u5c06A\u5217\u6570\u636e\u590d\u5236\uff0c\u9009\u62e9\u6027\u7c98\u8d34\u4e3a\u6570\u503c\u5373\u53ef\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/589f5b0788013870a6c99a3f2d08a50f95fc83df.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/89402670d5413a8cd38005bc1ffc508c9ace81df.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/3bcdb808a50f94fc28043b7d4cf88a775cddfcdf.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "F5\u9009\u62e9\u7a7a\u503c\u53e3\uff0c\u4e0d\u5f97\u70b9\u51fb\u9f20\u6807\uff0c\u5426\u5219\u9009\u62e9\u65e0\u6548"}, {"txt": "\u8f93\u5165\u5185\u5bb9\u540e\u4e0d\u5f97\u6309Enter\uff0c\u800c\u9700\u6309Ctrl+Enter\u7ec4\u5408\u952e\u3002"}]]
    2024-11-22
    1楼
    回复

参与评论

游客评论不支持回复他人评论内容,如需回复他人评论内容请