xecl表格里黏贴链接后很长一串,怎么才能把链接按表格大小弄小一点 wps在表格里粘贴链接后怎么调整大小?
Excel\u8868\u683c\u91cc\u7684\u94fe\u63a5\u5730\u5740\u663e\u793a\u8fc7\u957f\u600e\u4e48\u89e3\u51b3\uff1f1\u3001\u6253\u5f00\u6d4f\u89c8\u5668\uff0c\u5728\u641c\u7d22\u6846\u8f93\u5165\u3010\u77ed\u94fe\u63a5\u5728\u7ebf\u751f\u6210\u3011\u3002\u8fd9\u662f\u6700\u65b9\u4fbf\u7684\u65b9\u5f0f\uff0c\u4e0d\u7528\u5b89\u88c5\u5ba2\u6237\u7aef\u4e4b\u7c7b\u7684\u3002
2\u3001\u641c\u7d22\u51fa\u6765\u4f1a\u6709\u5f88\u591a\u7ed3\u679c\uff0c\u9009\u62e9\u201c\u77ed\u94fe\u63a5\u751f\u6210\u201d\u3002
3\u3001\u70b9\u51fb\u3010\u7531\u6b64\u8fdb\u5165\u77ed\u94fe\u63a5\u7f29\u7565\u3011\u3002\u540e\u7f00\u6309\u9ed8\u8ba4\u7684\u5c31\u884c\u4e86\uff0c\u4e0d\u7528\u7279\u5730\u53bb\u4fee\u6539\u3002
4\u3001\u5148\u53bb\u628a\u81ea\u5df1\u7684\u957f\u7f51\u5740\u590d\u5236\u8fc7\u6765\u3002\u627e\u5230\u7f51\u5740\u53f3\u952e\u70b9\u51fb\u590d\u5236\u6216\u662f\u6309Ctrl+C\u590d\u5236\u3002
5\u3001\u5728\u3010\u8bf7\u8f93\u5165\u957f\u7f51\u5740\u3011\u7684\u6846\u6846\u4e0a\u628a\u521a\u521a\u590d\u5236\u7684\u7f51\u5740\u7c98\u8d34\u8fc7\u6765\u3002\u590d\u5236\u597d\u540e\uff0c\u70b9\u51fb\u3010\u538b\u7f29\u4e00\u4e0b\u3011\u3002
6\u3001\u53ef\u4ee5\u76f4\u63a5\u590d\u5236\u8be5\u94fe\u63a5\u3002\u5728\u590d\u5236\u8fd0\u7528\u4e4b\u524d\uff0c\u5148\u786e\u8ba4\u4e00\u4e0b\u8be5\u7f51\u5740\u662f\u5426\u80fd\u7528\u3002
\u8f93\u5165\u82f1\u6587\u5355\u5f15\u53f7 '
\u5927\u5bb6\u90fd\u77e5\u9053\uff0c\u82f1\u6587\u5355\u5f15\u53f7\u5728\u8f93\u5165\u957f\u4e32\u6570\u5b57\u65f6\uff0c\u4e3a\u4e86\u4f7f\u540e\u97624\u4e3a\u4e0d\u663e\u793a0\uff0c\u5e38\u5e38\u5148\u8f93\u4e00\u4e2a\u82f1\u6587\u5355\u5f15\u53f7\uff0c\u90a3\u4e48\u5728\u4e0d\u4f7f\u7528\u8d85\u94fe\u63a5\u7684\u60c5\u51b5\u4e0b\uff0c\u540c\u6837\u4e5f\u53ef\u4ee5\u7528\u5355\u5f15\u53f7\u6765\u89e3\u51b3\u3002
\u5982\u4e0a\u56fe\u6240\u793a\uff0c\u5355\u5143\u683c\u5185\u8f93\u5165\u90ae\u7bb1\u6216\u8005\u7f51\u5740\u524d\uff0c\u5148\u5728\u5355\u5143\u683c\u5185\u8f93\u5165\u82f1\u6587\u5355\u5f15\u53f7"'"\uff0c\u8fd9\u6837\u5728\u70b9\u51fb\u5355\u5143\u683c\u65f6\u5c31\u4e0d\u4f1a\u6709\u8d85\u94fe\u63a5\u4ea7\u751f\u3002
\u4f7f\u7528\u5feb\u6377\u952eCtrl+Z
Ctrl+Z\u5728\u4e00\u822c\u64cd\u4f5c\u4e2d\uff0c\u6307\u7684\u662f\u64a4\u9500\u4e0a\u4e00\u6b65\u64cd\u4f5c\uff0c\u4eca\u5929\u53c8\u6709\u65b0\u529f\u80fd\u4e86\uff0c\u8f93\u5b8c\u90ae\u7bb1\u6216\u5730\u5740\u540e\uff0c\u518d\u6b21\u9009\u4e2d\u8be5\u5355\u5143\u683c\uff0c\u6309\u4e0b\u5feb\u6377\u952eCtrl+Z\u5373\u53ef\u64a4\u9500\u81ea\u52a8\u751f\u6210\u7684\u94fe\u63a5\uff0c\u5982\u4e0b\u56fe\u6240\u793a\uff1a
\u5f53\u6211\u4eec\u8f93\u5165\u5b8c\u90ae\u7bb1\u6216\u7f51\u5740\u65f6\uff0c\u5148\u786e\u8ba4\uff0c\u518d\u4f7f\u7528Ctrl+Z\u6765\u53d6\u6d88\u8d85\u94fe\u63a5\u3002
\u9f20\u6807\u53f3\u952e
\u9f20\u6807\u53f3\u952e\u7684\u529f\u80fd\u5b9e\u5728\u662f\u592a\u4e30\u5bcc\u4e86\uff0c\u597d\u50cf\u5728\u6240\u6709\u8bbe\u7f6e\u7684\u64cd\u4f5c\u4e2d\u90fd\u6709\u5b83\u7684\u8eab\u5f71\uff0c\u56e0\u6b64\uff0c\u5728\u4f7f\u7528\u4efb\u4f55\u8f6f\u4ef6\u65f6\u8fd8\u5f97\u517b\u6210\u4e00\u4e2a\u70b9\u53f3\u952e\u7684\u4e60\u60ef\uff0c\u6307\u4e0d\u5b9a\u5c31\u4f1a\u53d1\u73b0\u65b0\u5927\u9646\uff01
\u9009\u4e2d\u8981\u53d6\u6d88\u8d85\u94fe\u63a5\u7684\u5355\u5143\u683c\u6216\u5355\u5143\u683c\u533a\u57df\uff0c\u70b9\u51fb\u9f20\u6807\u53f3\u952e\uff0c\u518d\u70b9\u51fb\u53d6\u6d88\u8d85\u94fe\u63a5\u5373\u53ef
\u94fe\u63a5\u540e\u9762\u7684\u5355\u5143\u683c\u6709\u5185\u5bb9\u65f6\uff0c\u94fe\u63a5\u8d85\u51fa\u90e8\u5206\u4f1a\u81ea\u52a8\u9690\u85cf\uff0c\u5355\u51fb\u624d\u80fd\u663e\u793a\u51fa\u6765\u3002
\u53e6\u5916\uff0c\u53ef\u4ee5\u8bbe\u7f6e\u5355\u5143\u683c\u683c\u5f0f\uff0c\u81ea\u52a8\u6362\u884c\u6216\u8005\u7f29\u5c0f\u586b\u5145\u6548\u679c\u3002
1，设置链接所在单元格格式，对齐-填充
2，将链接列隐藏，然后用公式设置超链接替代，比如链接所在列为C列，在D2中输入=hyperlink(链接所在单元格,"点击查看");，然后填充公式，隐藏C列即可，此时点击D列中的点击查看，一样超链接跳转
绛旓細1锛岃缃閾炬帴鎵鍦鍗曞厓鏍鏍煎紡锛屽榻-濉厖 2锛屽皢閾炬帴鍒楅殣钘忥紝鐒跺悗鐢ㄥ叕寮忚缃秴閾炬帴鏇夸唬锛屾瘮濡傞摼鎺ユ墍鍦ㄥ垪涓篊鍒楋紝鍦―2涓緭鍏=hyperlink(閾炬帴鎵鍦ㄥ崟鍏冩牸,"鐐瑰嚮鏌ョ湅");锛岀劧鍚庡～鍏呭叕寮忥紝闅愯棌C鍒楀嵆鍙紝姝ゆ椂鐐瑰嚮D鍒椾腑鐨勭偣鍑绘煡鐪嬶紝涓鏍疯秴閾炬帴璺宠浆
