Excel½Ì³ÌÏÂÔØºÍÈí¼þÏÂÔØÖÐÐÄ£¬Microsoft¼¼ÊõÉçÇøÁªÃ˳ÉÔ±£¬È«Çò¼«¾ßÓ°ÏìÁ¦µÄExcelÃÅ»§£¬Office¼¼ÊõÅàѵÉçÇø

¸ß½×ͼ±í£¬ÊÇÕâÑù×ö³öÀ´µÄ

2019-12-21  ×÷Õß:ExcelHome  ÔĶÁ:´Î
½ñÌìºÍ´ó¼Ò·ÖÏíÒ»¸öìÅ¿áµÄͼ±í¼¼ÇÉ£¬ÏÈ¿´Ð§¹û£º


Ö»Òª¹â±ê»¬¹ý²»Í¬µÄÉÌÆ·Ãû³Æ£¬Í¼±í¾Í»á×Ô¶¯±ä»¯£¬ÊDz»ÊǺÜìſᰡ¡£

²½ÖèÒ»£º×¼±¸Êý¾ÝÔ´


²½Öè¶þ£ºÊäÈë´úÂë
Alt+F11 ´ò¿ªVBE´°¿Ú£¬¡¾²åÈë¡¿→¡¾Ä£¿é¡¿
¸´ÖÆÈçÏ´úÂ뵽ģ¿éÖУ¬Í˳öVBE´°¿Ú£º
Function techart(rng As Range)
Sheet1.[g1] = rng.Value
End Function



²½ÖèÈý£ºÊäÈ빫ʽ
ÔÚG1µ¥Ôª¸ñÖÐÊäÈëÈÎÒâÒ»¸öÉÌÆ·Ãû³Æ£¬ÈçÅ£×п㡣
G2ÊäÈ빫ʽ£¬ÏÂÀ­ÖÁG13£º


Ñ¡ÖÐG1£ºG13£¬¡¾²åÈë¡¿→¡¾ÕÛÏßͼ¡¿


²½ÖèËÄ£ºÃÀ»¯Í¼±í
ÉèÖÃÕÛÏßͼΪÎÞÏßÌõ¡£
ÉèÖÃÊý¾ÝµãÑùʽ£¬Ìí¼Ó´¹Ö±Ïß¡£
´Ë´¦Ê¡ÂÔ¾ßÌå²½Ö裬´ó¼Ò¿ÉÒÔ¸ù¾ÝÐèÒªºÍϲºÃ£¬ÉèÖóö²»Í¬Ñùʽ²»Í¬·ç¸ñµÄͼ±íÑùʽ¡£
×îÖÕЧ¹ûÈçÏ£º


²½ÖèÎ壺ÊäÈ빫ʽÔÚͼ±íÉÏ·½£¬ÊäÈëÄ£Äâͼ±í±êÌâµÄ¹«Ê½¡£
=G1&"2015ÄêÏúÊÛÇ÷ÊÆ"
ÔÚͼ±íÏ·½£¬ÊäÈëÄ£Äâ×ø±êÖáµÄ¹«Ê½¡£
±¾ÀýÒÔJ15:K16µ¥Ôª¸ñÇøÓòΪÀý£¬ÒÀ´ÎÊäÈëÒÔϹ«Ê½£º
=IFERROR(HYPERLINK(techart(B1)),"¡ô"&B1&"¡ô"&REPT(" ",99))
=IFERROR(HYPERLINK(techart(C1)),"¡ô"&C1&"¡ô"&REPT(" ",99))
=IFERROR(HYPERLINK(techart(D1)),"¡ô"&D1&"¡ô"&REPT(" ",99))
=IFERROR(HYPERLINK(techart(E1)),"¡ô"&E1&"¡ô"&REPT(" ",99))
ÊäÈ빫ʽºóµÄЧ¹ûÈçÏ£º


¹«Ê½ºóÃæÎªÊ²Ã´ÒªÁ¬½ÓREPT("",99)ÄØ£¿
Èç¹ûÖ»Êǵ¥¶ÀÏÔʾ·ÖÀàµÄ»°£¬Êó±êÐèҪͣµ½ÎÄ×ÖÉϲŻá±ä»¯£¬ËùÒÔʹÓÃ99¸ö¿Õ¸ñռ룬Êó±êֻҪͣÔÚµ±Ç°·ÖÀ൥Ԫ¸ñÈÎÒâÒ»¸öµØ·½£¬¶¼¿ÉÒÔ´¥·¢´úÂëÔËÐС£
½«Îļþ±£´æ³ÉÆôÓúêµÄÎļþ£¨xls¡¢xlsm£©£¬OKÀ²£¡


×ªÔØÇë×¢Ã÷À´Ô´"ExcelHome"²¢±£ÁôÔ­ÎÄÁ´½Ó¡£
¹Ì¶¨Á´½Ó£ºhttps://www.excelhome.net/lesson/article/excel/1955.html
·ÖÏíµ½£º
Copyright 1999 - 2020 Excel Home.All Rights Reserved.
±¾Õ¾ÌØÆ¸·¨ÂɹËÎÊ£ºÐ컳ÓñÂÉʦ Àî־ȺÂÉʦ   »¦ICP±¸11019229ºÅ-2

»¦¹«Íø°²±¸ 31011702000001ºÅ

Õ÷ÐÅ