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

[µo°Ý] Excel§Þ¥©¸ß°Ý

[µo°Ý] Excel§Þ¥©¸ß°Ý



¦p¤W¹Ï~¬O¼Ï¯Ã¤§«áªºªí®æ
·Q½Ð°Ý¤@¤U
¦³¨S¦³¤°»ò§Þ¥©¥i¥H§Ö³t±NªÅ®æ¶ñº¡

¤p§Ì½Æ»s¨ì®ÇÃ䪺ªí®æ¨Ï¥ÎIF¨ç¼Æ¥h¼g
¦³¨Ç·|¥X²{0
¥t¥~¨Ï¥ÎCtrl+G
¨Ï¥Î¯S®í¤ºªºªÅ®æ·Q§Ö³t¶K¤W¤]¤£¦æ

¬G·Q½Ð°Ý¤@¤UÁÙ¦³¨ä¥L¦n¥Îªº¤èªk¶Ü?
Àµ½Ð½ç±Ð~ÁÂÁÂ!!

1. ¿ï¨ú¸ê®Æ½d³ò¡AA6:A19¡C
2. «ö Ctrl+G ¡A¶}±Ò[¨ì]¹ï¸Ü®Ø¡C
3. ÂI¿ï ¯S®í¡C
4. ¿ï¨ú ªÅ®æ->½T©w¡C
5.¤½¦¡¿é¤J=A7¡A
6.Ctrl+Enter

TOP

¦^´_ 2# totomomo

totomomo ¤j¤j~·PÁ§Aªº¦^ÂÐ
¦ý§Ú¤W­±¤w¦³»¡©ú¹L
§Ú¥ÎGtrl+G
¨Ï¥ÎªÅ®æ¶K¤W~¬O¤£¦æªº....
¦³§ó¦nªº¤è¦¡¶Ü~·PÁÂ^^

TOP

§Ú¸Õ¹L¬O¥i¥Hªº¡C
¨Ï¥ÎªÅ®æ¶K¤W¬O¤°»ò·N«ä?

TOP

¦^´_ 4# totomomo


    totomomo§A¦n
½Ð°Ñ¦Ò¤U¹Ï


³o´N¬O§Ú©Ò´£¨ìªºCtrl+G §Ö³t¶K¤W
¦ý¤j¤j§A¥i¥H~«Ü©Ç !!·|¤£·|¦³±ø¥ó­­¨î©O?
«á¨Ó§Ú´N¶K¦b®ÇÃ䪺Àx¦s®æ
¦h¤@­Ó»²§UÄæ¥h§PÂ_´N¼g¥X¨Ó¤F!!

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2015-2-27 04:07 ½s¿è

2010ª©EXCEL

ª½±µ¥Î¼Ï¯Ã°µ¤£¥Î¨ç¼Æ½Õ¾ã

1.¿ï¶Ç²Î¼Ï¯Ãª©­±


2.¶Ç²Î¼Ï¯Ãª©­±


3.¿ï­«½Æ©Ò¦³¼ÐÅÒ

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD