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

[µo°Ý] Excel ¤½¦¡"¨S¦³¦^À³"

[µo°Ý] Excel ¤½¦¡"¨S¦³¦^À³"

¦U¦ì¦n¡A

½Ð°Ý¦³¨S¦³­þ¦ìºô¤Í´¿¸g¹J¹L¤@­Ó±¡§Î¡A´N¬O·í¦bexcel ¨Ï¥Î¬Y¨Ç¤½¦¡ªº®É­Ô¡]¤ñ¦p»¡¡A§Ú¦bB2¤¤¼g¤U=SUM(A1:A10)¡^¡A¥Lªº­È·|³Q¡u­á¦í¡v¡C¤]´N¬O»¡¡A·í§Ú¶}©l§ó°ÊA1:A10¤¤ªº¸ê®Æªº®É­Ô¡AB2ªº­È¤£·|¬Û¹ïÀ³ªº§ó°Ê¡C

¨ä¹ê³o­Ó°ÝÃD¤@ª½§xÂZ§Ú³\¤[¡C½Ð°Ý¬O§_¦³­þ¦ì«e½ú¤]¦³¸I¹LÃþ¦üªº±¡§Î¡A¦Ó¥B¦³¸Ñ¨M¤§ªk¡H

¥ýÁÂÁ¦U¦ì¡C

PS¡G§Ú¥Ø«e¸Ñ¨Mªº¤è¦¡¡A¬O­«·s¿é¤J¤½¦¡¡C¤]´N¬O²¾°Ê¨ìB2«á¡A«öF2¤§«á¦A­«·s¿é¤J(¤½¦¡§¹¥þ¤£°Ê)¡A³o­Ó®É­Ôexcel´N·|¦A¦¸§ó·s­È¡C¦ý³o­Ó¤è¦¡¨ä¹ê¨Ã¤£¹ê¥Î¡A¦]¬°§Ú¥D­n¬O¦bexcel ¦Û»s ¬Ý½L¬É­±ªº®É­Ô¹J¨ì±¡§Î¡A¦pªG·í¸ê®Æ§ó°Êªº®É­Ô¡A¬Û¹ïÀ³ªº®æ¤lµLªk¦Û°Ê§ó·s¡A¨º´N¥Õ·f¤F¡C
§Ú·R³Â»¶®a±Ú°Q½×°Ï¡I¡I

¥ýÀˬd¤@¤U¬Ý¬O¤£¬O¦Û°Ê­pºâ³Q§ï¦¨¤â°Ê¤F
¡y¤u¨ã¡z¡÷¡y¿ï¶µ¡z¡÷¡y­pºâ¡z¡÷¡y¦Û°Ê¡z
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

¦^´_ 2# huijuang

ÁÂÁÂi]huijuang¤j¡I¡I ³ºµM´N¬O³o­Ó­ì¦]¡I  §Ú±q¨Ó¨S¦³§ó°Ê³oÃä°Ú¡A«ç»ò·|§ï¦¨¤â°Ê¡H¡H


µL½×¦p¦ó¡A·PÁ§A¡I¡I
§Ú·R³Â»¶®a±Ú°Q½×°Ï¡I¡I

TOP

¦³¥i¯à¬OVBAµ{¦¡¬°¤è«Kexcel³B²z
±N¥¦¼È®É§ï¬°¤â°Ê
¦Ó¦bµ{¦¡µ²§ô«e¨S§ï¦^¨Ó
©ÎªÌ¬OVBAµ{¦¡³Q¨Ï¥ÎªÌ¤¤Â_¦Ó¨S¶]§¹

©Î³\¥i¥H½T»{¤@¤U¬Ý¬O¤£¬O¦³¤°»òÀɮ׶}±Ò¤§«á´N·|³Q§ï¤â°Ê¤F
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

¦^´_ 4# huijuang


¤F¸Ñ¡I¦A¦¸·PÁ±zªºÀ°¦£¡I:D
§Ú·R³Â»¶®a±Ú°Q½×°Ï¡I¡I

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD