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

[µo°Ý] ¡i¦C¡j¤è¦VªººÃ°Ý¡H¡H¡H

[µo°Ý] ¡i¦C¡j¤è¦VªººÃ°Ý¡H¡H¡H

1. ¦bExcelÁcÅ骩¤¤, ¡i¦C¡j«üªº¬O¤ô¥­¤è¦V¡F¡iÄæ¡j«üªº¬O««ª½¤è¦V.¡]²³©Ò©Pª¾¡^
2. ¦ý¬O¦bExcel²Å骩, ¡i¦C¡j«üªº¬O««ª½¤è¦V¡F¡i¦æ¡j«üªº¬O¤ô¥­¤è¦V.
¡E ¥H¤W¥i¨£¡i¦C¡j¦bÁc²¤¤ªº·N«ä§¹¥þ¬Û¤Ï
¡E¡i°ÝÃD¡j¡G
½Ð°Ý­Ó¦ì¦b¨ü¥xÆW¥¿²Î±Ð¨|ªº¦U¦ì¤j¤j­Ì, §A­Ì¤p¾Ç¾Çªºª¾ÃѨ쩳¤ô¥­¤è¦V©M««ª½¤è¦V¬O¦p¦óºÙ©Iªº¡H¦pªG¦³¤p«Äªº, ¥i§_¬d¬Ý¤@¤U±Ð¬ì®Ñ½T»{¤@¤U¡H
µù¡G¦b´ä¿DÁöµM¥ÎÁcÅé¦r, ¦ý¬O¤S²`¨ü¤j³°¼vÅT«ÜÃøÅçÃҨ쩳¦óªÌ¬°¬O.
ss

¦^´_  sunnyso

ÁÙ¦³¥­®É·|»¡[¨â¦æ²´²\], ²\¤ô¤£·|¥´¾î¬y. ©Ò¥H»¡¥j¥N¡i¦æ¡jÀ³¸Ó¬Oª½ªº¡C
sunnyso µoªí©ó 2014-3-5 14:27


¦A¨Ó¤@­ÓºÃ°Ý, ¦b¥xÆW¦pªG¦bŪ®Ñ¬Ý³ø®É¡]¥Î¾î®Ñ¡^, ­n«ü¬Y¥y¸Üªº¦ì¸m®É, ¤ñ¦p·|»¡"²Ä¤@¬q²Ä¤T¦æ" ¨º¥y¸Ü¶Ü¡HÁÙ¬O¥Î§Oªº»¡ªk¡H
ss

TOP

¥»©«³Ì«á¥Ñ sunnyso ©ó 2014-3-5 14:41 ½s¿è

¦^´_ 14# sunnyso

ÁÙ¦³¥­®É·|»¡[¨â¦æ²´²\], ²\¤ô¤£·|¥´¾î¬y. ©Ò¥H»¡¥j¥N¡i¦æ¡jÀ³¸Ó¬Oª½ªº¡C
ss

TOP

§Úªº¤@­ÓÆ[ÂI¡A§Ú­Ì·|±`±`»¡¡¨¤@¦æ¤å¦r¡§¡A°²¦p³oºØ»¡ªk¥j¥N´N¦³¡A¨º»ò¡i¦æ¡jÀ³¸Ó¬O««ª½¤è¦Vªº¡F¦]¬°¥j®É­Ôªº®Ñ¼g²ßºD¬O¥´½Ýªº¡F©Ò¥H¡i¦æ¡j¬O½Ýª½ªº¡C

«á¨Ó¥Ñ©ó®Ñ¼g²ßºD§ï¦¨¤F¾î®Ñ¡A©Ò¥H´N¶}©l¥X²{¡i¦æ¡j©M¤è¦V²V²c¡C¦b¥[¤W¤j³°ªº¤å­²¥i¯à·|¥O¬Y¨ÇÂ_¼h¡C¾É­P¦b¤j³°¡i¦æ¡j´N¬O«ü¤ô¥­¤è¦Vªº¡A¦Ó¡i¦C¡j´N¦ÛµM爲««ª½¤è¦V¡C

Ãö©ó¡i¦C¡j§Ú°Ý¹L´X­Ó»OÆWªº¦Ñ®v¡A¥L­Ì§i¶D§Ú»¡¥L­Ì±q¤pªº»{ª¾¬O¡i¦C¡j¬O¾î¦Vªº¡C¤p®É­Ô¦Ñ®v·|»¡²Ä¤@¦Cªº¾Ç¥ÍÂI¥X¨Ó¡A©ó¬O²Ä¤@Rowªº¦P¾Ç´N¥X¨Ó¤F¡C

Áٽаݦ³ªA§L§Ðªº¤j¤j­Ì¡A¦b­x¶¤¸Ì­±¡A¡i¦C¡j«ü¤°»ò¤è¦V©O¡H

ÁÂÁ¡C
ss

TOP

¦^´_ 12# seer_et

·PÁ¤j¤jªº¦^´_, ¤Î°Ñ¦ÒªºLink.

¤£ª¾¹D§Oªº¤j¤j¦³¨S¦³°ª¨£. ½Ðµoªí¤@¤U, ¤j®a±´°Q¤@¤U.
ss

TOP

¦^´_ 11# sunnyso

¹ï¤£°_¡A¥ý«eªº¦^ÂЦ³ÂI¶}ª±¯º¡A¨ä¹ê¬O·QÁÈ¿n¤À¡C¤£¹L¡A±zªº°ÝÃD½T¬O­@¤H´M°Q ..

¥xÆW³o¸Ì¥Í¬¡¤é±`¥Î¨ì"¦æ"ªº¦a¤è¤j¬ù´N :"¦æ¦æ¥Xª¬¤¸","»È¦æ","1¦æ2¦æ" ...³o´X­Ó,¦ý¤]¨S©w¸q¬O"ª½¦æ"ÁÙ¬O"¾î¦æ";¦¹¥~¡A

"³æ¦æ¹D","¾î¦æÅQ¹D","¦æ¤£¦æ" ..,«h¤£Åª"£~£µ£½" ,¤]¨S¦³¾îª½ªº·N«ä¡A¦Ü©ó"ù¦C¦¨¦æ"«h¤£ª¾©Ò¤ª ..

±zªº°ÝÃD³o¸Ì¦³¬ÛÃö°Q½×:

http://lifehaskilledme.blogspot.tw/2007/08/blog-post.html

http://www.ptt.cc/bbs/gallantry/M.1344351296.A.1DC.html

´N«öEXCELªº¥Îªk§a ¡C

TOP

¦^´_ 10# seer_et

­º¥ý·PÁ¤j¤jªº¦^´_¡A§Ú·Qª¾¹Dªº¬O¤é±`¥Í¬¡ªº»y¨¥ªí­z¡A¤£¬OExcelªº¡C

¥Ø«e¤¤¤å¹J¨ì¡i¦æ¡j¡i¦C¡j¤è¦Vªº°g«ä¡A­^¤å´N«Ü²M·¡Row & Column¡C¦]¬°¦b´ä¿D²`¨ü¤j³°ªº¬r®`¡A©Ò¥H·Q§ä¤@­Ó²MÀR¤§¦a¨ÓÁA¸Ñ³o­Ó°g«ä¡C

¦A¦¸·PÁ¡C
ss

TOP

as "C44" or "$C$4D$4"

TOP

¦^´_ 7# newlink

¦A½Ð°Ý¤@¤U¦U¦ì¤j¤j¡A¦b¥­®É§A­Ì¤é±`¥Í¬¡¤¤¡A¤ñ¦p¦bŪ®Ñ©Î¬Ý³ø¯È®É¡A¦pªG­nªí­z¦p¤U¹Ï¤å³¹¤¤ªº¥Î¬õµ§°é¥X¨Óªº¤å¦r¡]¡§¾Ç²ß¡¨¡^¦ì¸m¡A¤@¯ë·|¥Î¥H¤U­þ¤@ºØ©O¡H

¡i1¡j²Ä¥|¦C²Ä4¡B5¨â­Ó¦r¬O¡¨¾Ç²ß¡§
¡i2¡j²Ä¥|¦æ²Ä4¡B5¨â­Ó¦r¬O¡¨¾Ç²ß¡§
¡i3¡j¨ä¥Lªí­z¤èªk¡H


«Ü·Qª¾¹D¦b»OÆWªº¤j¤j­Ìªº¨Ï¥Î²ßºD¡C¡]¤£¹³¦b´ä¿D²`¨ü¤j³°ªº¼vÅT¡A²{¦b¦æ¦CÃø¤À¡C§Ú°O±o¤p®É­Ô¾Ç®Õ±Ðªº¤@¥y¤f³Z¬O¡i¦C¾îª½¦æ¡j¡A¦ý¬O²{¦b¤é±`¥Í¬¡¤¤¤S¸g±`Å¥¨ì¹³¤@¦æ¤å¦r³oºØ»¡ªk¡C¨ì©³¬O§Ú°O¿ùÁÙ¬O¤j³°§ï²Åé¬O§â·N«ä¤]§ï¤F©O¡H¡^

¦A¦¸·PÁ¤j¤j­Ìªº¦^´_¡C

ss

TOP

¦^´_ 7# newlink

·PÁÂ
ss

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD