ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð±Ð¤@­Ó¤p°ÝÃD

½Ð±Ð¤@­Ó¤p°ÝÃD



§Ú§Æ±æ±o¨ì²Ä¤G¦Cªº¨ç¼Æ(¤£¬OÀx¦s®æ¡A¬O¤½¦¡¡A°é°_¨Óªº³¡¤À)¡A¨Ò¦p
F2¨ç¼Æ(¤½¦¡)Åã¥Ü¬° =¤u§@ªí2!¡¦23.¦WºÙ¡¥
G2¨ç¼Æ(¤½¦¡)Åã¥Ü¬° =¤u§@ªí2!¡¦65.¦WºÙ¡¥
H2¨ç¼Æ(¤½¦¡)Åã¥Ü¬° =¤u§@ªí2!¡¦101.¦WºÙ¡¥
I2¨ç¼Æ(¤½¦¡)Åã¥Ü¬° =¤u§@ªí2!¡¦33.¦WºÙ¡¥
J2¨ç¼Æ(¤½¦¡)Åã¥Ü¬° =¤u§@ªí2!¡¦12.¦WºÙ¡¥
¨Ì¦¹Ãþ±À
½Ð°Ý¦³¦ó¤èªk¥i¥H®M¥Î?

¥»©«³Ì«á¥Ñ p212 ©ó 2016-1-28 14:10 ½s¿è

¦^´_ 1# kk9999321
Àx¦s®æF2¿é¤J
="¤u§@ªí2!'"&F$1&"¦WºÙ'"
¦V¥k½Æ»s
¬O³o¼Ë¡H
½Ð°Ñ¦Ò¡I

TOP

²Ä1¦C³£¬O¼Æ¦r, ²Ä2¦C³£¬O¤½¦¡?
µM«á, ²Ä3¦CÅã¥Ü¬° ¼Æ¦r.¤½¦¡¦WºÙ?

TOP

¦^´_ 2# p212


    ÁÂÁ¡A
§Ú­nªº¤£¬O³o¼Ë¡A
§Ú§Æ±æ±o¨ì²Ä¤G¦Cªº¨ç¼Æ(¤£¬OÀx¦s®æ¡A¬O¤½¦¡¡A°é°_¨Óªº³¡¤À)¡AF2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦23.¦WºÙ¡¥¡A¥Øªº¬O­n°µ¥~³¡³sµ²
G2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦65.¦WºÙ¡¥
H2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦101.¦WºÙ¡¥
I2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦33.¦WºÙ¡¥
J2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦12.¦WºÙ¡¥
¨Ì¦¹Ãþ±À

TOP

F2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦23.¦WºÙ¡¥¡A¥Øªº¬O­n°µ¥~³¡³sµ²
G2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦65.¦WºÙ¡¥
H2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦101.¦WºÙ¡¥
I2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦33.¦WºÙ¡¥
J2¨ç¼Æ®æ(°é°_¨Óªº³¡¤À)(¤½¦¡)¿é¤J¬° =¤u§@ªí2!¡¦12.¦WºÙ¡¥


¥i¯à·|¥Î¨ìªº¨ç¼Æ¬OINDIRECT©ÎHYPERLINK¡A¥H¤U¥ý¸Õ¸Õ
F2 =HYPERLINK("¤u§@ªí2!¡¦23.¦WºÙ¡¥", "23.¦WºÙ")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD