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

[­ì³Ð] ÁôÂÃÄæ¦C¤]¬O¤@ªù§Þ¥©¡@¨S¾Ç·|­n³Z§O»¡·|ÁôÂüÚ(³q«h)

[­ì³Ð] ÁôÂÃÄæ¦C¤]¬O¤@ªù§Þ¥©¡@¨S¾Ç·|­n³Z§O»¡·|ÁôÂüÚ(³q«h)

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2010-7-5 19:35 ½s¿è

ÁôÂÃÄæ¦C¤]¬O¤@ªù§Þ¥©¡@¨S¾Ç·|­n³Z§O»¡·|ÁôÂüÚ

Excel½Òµ{-Äæ¦CÁôÂçޥ©

³o¬O­Ó¦ÒÅçÃD
§OÃhºÃ ¸Ì­±¦³ªF¦è

¨SÂê
¥i¥H§âÄæ¦CÅã²{¥X¨Ó´N¾Ç·|¤F
¨ä¥L·f°t¤W­±¦³¼g

¤p§Þ¥©¤@«h

³o¬O¥H«e°µªº½Òµ{Á¿¸q ¨Ñ¤j®a°Ñ¦Ò¨Ï¥Î

Äæ¦CÁôÂçޥ©¬Oexcel¤¤«D±` ±`¥Îªº§Þ¥©¤§¤@

«Ü¦h¤HÁ`¬O¤@ª¾¥b¸Ñ
¥H¬° ÁôÂÃ¥¼¨Ï¥Îªº¥þ³¡ Äæ»P¦C ´N¬O°ª²`§Þ¥©!

¯uªº´N¥u¬O³o¼Ë¶Ü?
µª®×¤£¬Oªº Äæ»P¦CÁôÂÃÁÙ¦³«Ü¦h¨ä¥LªºªF¦è

¦¹Àɦ@¦³7­ÓSHEET ¨S¦³Âê ¤]µLvba
¨Ï¥Î»P·f°t¤Q¤­­Ó¤£¦Pªº¤p§Þ¥©
¦U¦³¤£¦Pªº§e²{

¦b±Ð¾Ç¤W¦³¤£¤@¼Ëªº±Òµo


¥D­«ÂI¦bÁôÂÃÄæ¦C»P¤u§@ªí«OÅ@«á
¨ú®øÁôÂÃÄæ¦C«OÅ@®É©ÒÅã²{¥X¨Ó®ÄªG
¦p²Ä¤@¦¸§âÄæ¦C¨ú®øÁôÂëá Åã²{ªº¼Ë¤l ¥i¯à¶·­n²Ä¤G¦¸¨ú®øÄæ¦CÁôÂÃ
¤âªk¤£¦P·|¦³¤£¦P®ÄªG ¦¹ªk³q±`·f°t©w¸q¿ï¨ú
§A¥u­n
1.¥´¶}­áµ²µ¡®æ
2.¨ì¿ï¶µ §â¤u§@ªí¼ÐÅÒ»PÄæ¦C¼ÐÃD¥´¶} ¥HÅã¥ÜÄæ¦C¼ÐÃD»P¤u§@ªí¼ÐÅÒ
3¨ì®æ¦¡ /Äæ/¨ú®øÁôÂÃ

5.²Ä¤G¦¸¿ï¾ÜÄæ¸Ñ°£ÄæÁôÂà ¨ì®æ¦¡ /Äæ/¨ú®øÁôÂÃ
¨ä¥Lsheet ¨Ï¥Î ctrl + pageup ´N¬Ý±o¨ì
·íµM¦³«Ü¦h¤p²Ó¸` ³£«Ü©úÅã ¥i¥H²Ó²Ó«~¨ý»P´¢¼¯
A4.rar (13.65 KB)

ªü¦N¥Sªº±Ð¾Ç±`¬O¤@¯ë¨Ï¥ÎªÌ©¿²¤ªº
­n¦h¥[¾Ç²ßÅo!
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁªü¦N¥Sªº±Ð¾Ç
§Ú·|¦h¥[¾Ç²ß

TOP

谢谢¦U¦ì¤j¤jªº´£点, ¥i¬O§Ú¤w经ª`册¤F,为¤°¤\还¬O¬Ý¤£¨ìªþ¥ó©O ...
flying008 µoªí©ó 2010-5-4 08:38



    http://forum.twbts.com/viewthread.php?tid=34
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁôÂÃÄæ¦C¤]¬O¤@ªù§Þ¥©¡@¨S¾Ç·|­n³Z§O»¡·|ÁôÂüÚ

Excel½Òµ{-Äæ¦CÁôÂçޥ©

³o¬O­Ó¦ÒÅçÃD
§OÃhºÃ ¸Ì­±¦³ ...
HUNGCHILIN µoªí©ó 2010-5-2 20:09


½Ð°Ýªü¦N¥S
¥Î±z¥H¤Uªº¨BÆJ¨S¦³¥´¶}A4ªºÁôÂÃÄæ¦C? A4-2.rar (13.79 KB)
    1.¥´¶}­áµ²µ¡®æ
2.¨ì¿ï¶µ §â¤u§@ªí¼ÐÅÒ»PÄæ¦C¼ÐÃD¥´¶} ¥HÅã¥ÜÄæ¦C¼ÐÃD»P¤u§@ªí¼ÐÅÒ
3¨ì®æ¦¡ /Äæ/¨ú®øÁôÂÃ

5.²Ä¤G¦¸¿ï¾ÜÄæ¸Ñ°£ÄæÁôÂà ¨ì®æ¦¡ /Äæ/¨ú®øÁôÂÃ
¨ä¥Lsheet ¨Ï¥Î ctrl + pageup ´N¬Ý±o¨ì

½Ð°Ý­þ­Ó¦a¤è°µ¿ù¨BÆJ?
ÁÂÁÂ!

TOP

·Ó»Õ¤Uªº«ü¥Ü¡A¦U¤u§@ªí³£¥´¶}¤F¡C
¦ý¥H§Úªº¹D¦æ¡A§@¦hµf¹Á¸Õ¡A¤´µLªk±N¦U¤u§@ªíªº¼ÐÃD¦WºÙÅã¥Ü¥X¨Ó¡H

§Ú´¿´¢ºN»Õ¤Uªº§@ªk¡A­ì¨Ó±NÄæ¼e¤Î¦C°ª³]©w¬°[0]¡A§Y·|¥X²{¦Çµe­±¡I

TOP

·Ó»Õ¤Uªº«ü¥Ü¡A¦U¤u§@ªí³£¥´¶}¤F¡C
¦ý¥H§Úªº¹D¦æ¡A§@¦hµf¹Á¸Õ¡A¤´µLªk±N¦U¤u§@ªíªº¼ÐÃD¦WºÙÅã¥Ü¥X¨Ó¡H

...
trainee µoªí©ó 2010-5-5 12:24



    ¤£¦n·N«ä
§ÚªºÀÉ®×¥´¶}
¦C/°ª³£¬O0
¦Ó¥B¤]¬O¦Ç¦âªº¤@¤ù
¤£ª¾¹D­þ¸Ì¨BÆJ¤£¹ï!!
ÁÂÁÂ!

TOP

¤£¦n·N«ä
§ÚªºÀÉ®×¥´¶}
¦C/°ª³£¬O0
¦Ó¥B¤]¬O¦Ç¦âªº¤@¤ù
¤£ª¾¹D­þ¸Ì¨BÆJ¤£¹ï!!
ÁÂÁÂ!
PD961A µoªí©ó 2010-5-5 14:29



    §Ú¤U¸ü¸Õ¥Î,¨S°ÝÃD,³£¥¿±`
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

§Ú¤U¸ü¸Õ¥Î,¨S°ÝÃD,³£¥¿±`
¤p»x µoªí©ó 2010-5-5 16:13


¤p»xª©¥DÁÂÁÂ
­ì¨Ó¨BÆJ¦³ÂI¤£À´

    1.¥´¶}­áµ²µ¡®æ
2.¨ì¿ï¶µ\À˵ø\ §â¤u§@ªí¼ÐÅÒ»PÄæ¦C¼ÐÃD¥´¶} ¥HÅã¥ÜÄæ¦C¼ÐÃD»P¤u§@ªí¼ÐÅÒ(³o­Ó¦a¤è§ä¤£¨ì?)
¦ý¬O·í°õ¦æ3.5¨BÆJ®É  ¦C/Äæ³£¿ï¾Ü"¨ú®øÁôÂÃ"«á..¦A¥[¤Wctrl + pageup ´N¥i¥H¥Î¤F

3¨ì®æ¦¡ /Äæ/¨ú®øÁôÂÃ(¦ý¬O·í¦C/Äæ³£¿ï¾Ü
5.²Ä¤G¦¸¿ï¾ÜÄæ¸Ñ°£ÄæÁôÂà ¨ì®æ¦¡ /Äæ/¨ú®øÁôÂÃ
¨ä¥Lsheet ¨Ï¥Î ctrl + pageup ´N¬Ý±o¨ì

ÁÂÁÂ!

TOP

ªü¦N¥S:
¿ï¨ú ²Ä20¦C ¦Ü ³Ì«á1¦C (65536)
¦pªG¤£¨Ï¥Î ±²¶b
ÁÙ¦³¨ä¥L¤èªk¶Ü(¥u¬O·QÁôÂéҿï¨ú)

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD