ªð¦^¦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:
¿ï¨ú ²Ä20¦C ¦Ü ³Ì«á1¦C (65536)
¦pªG¤£¨Ï¥Î ±²¶b
ÁÙ¦³¨ä¥L¤èªk¶Ü(¥u¬O·QÁôÂéҿï¨ú)
f1699 µoªí©ó 2010-5-14 13:49



1.¥ý¿ï21¦C¥þ¦C   
2.¨Ï¥Î§ÖÁäCTRL+SHIFT+ ¤è¦VÁä¡õ

±`¥Î§ÖÁä¦h¥Î¦ÛµM·|­I°_¨Ó
·|¥[§Ö³\¦h³t«×

TOP

®¦¤èªk«Ü¦h
¥ÎºDªº¯à·Q¨ìªº´N¦³¦n´XºØ
¹Á¸Õ«á¥i¥H§ä¨ì³Ì§Öªº³Ì³ßÅwªº¤èªk

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-11-22 20:29 ½s¿è

¦^´_ 25# brabus


brabus ¥S ±z¤£¬O¨Ó«Ü¤[¤F
«ç»ò²{¦b¤~ª±¨ì³o­ÓÀÉ^^

³o­ÓÀɸ̭±ªº§Þ¥©¤£Ãø¡A¨Ï¥Îªº§Þ¥©¦³
1.Äæ¦CÁôÂà ¤@¯ë§Þ¥©
          ¶i¶¥1.1Äæ¦CÁôÂäp§Þ¥©6«h

2.¿ï¶µ/À˵ø/¦C»PÄæ¼ÐÃD ¤@¯ë§Þ¥©

3.¤À³Îµøµ¡ ¤@¯ë§Þ¥©
          ¶i¶¥3.1¤À³Î½u©ì¦²§Þ¥©
          ­n¥ý¸Ñ°£3.1¤~¥i¥H¸Ñ°£4.1 ¦]¬°¥L»\¦í4.1ªº§Þ¥©

4.¤ô¥­±²¶b ¤@¯ë©ì¦²§Þ¥©
          ¶i¶¥4.1¤ô¥­±²¶b©ì¦²·f°tTAB§Þ¥©

5.ª«¥ó

¦³¤T¤jÃþªº¶i¶¥¤p§Þ¥©¡A¦ý¦¹©«¥D±À²Ä1.1ªº§Þ¥©¸Ì­±ÁÙ¤À¤»¤p«h
¬°¤°»ò¼g³o»ò²Ó¡A¦]¬°§Ú¤]·|§Ñªü¡A¦³³Ð·N´N­n°O¤U¨Ó¡A³o¬O§Úªº½d¨ÒÀÉ¡C§Ñ°O¬Ý¤@¤U´N¦n
§A¬O¨º¤@­ÓÅܤ£¦^¨Ó¡AÁ`¤£¥i¯à¥þ³¡³£?

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-1-12 19:52 ½s¿è
¦^´_  HUNGCHILIN
  ·PÁ±zªºÃö¤ß
¨ä¹ê§Ú¤£¬O¥»¬ì¨t²¦·~¤H­û
©Ò¦³ªºªF¦è³£¬O¦Û¾Ç¦Ó¨Ó
©Ò¥H¾Ç²ß¶i«×«ÜºC ...
brabus µoªí©ó 2011-11-30 16:26



    brabus ^^¨þ¨þ¡AÁÂÁ§Aªº¸Ø¼ú¡A¨ä¹êª©¤ºVBA§Þ¥©¯u¥¿¼F®`ªº¬OHsieh¡BGBKEE¨â¦ì¤j®v¡A
¬Ý¤F³o»ò¤[¡A°¨¤W´N¥i¥Hµo²{¡A¥L­Ì¦^ÂЪº«Ü§Ö¥B«ê·í¡A³o¬O§Ú¦h¦~¤@ª½µLªk¨´¤Îªº¡A©¹©¹§ÚÀYÁÙ¦b·w¡AµLªk¤J¤â¡A¥L­Ì´N¤w¸g¼g¦n¤F¡A§Úı±o§Ú¤ñ¸ûOKªº´N¬O³Ð·N»P³Ð·s§a¡A·Q¨ì¤°»ò´N¼g¤U¨Ó¡A¨Ã¥B¸ÕµÛ°µ¬Ý¬Ý¡A¬O­Ó²Â¤èªk¡A¤£¹L¤]²Ö¿n«Ü¦h¤£¦Pªº§@«~¡A·íµM¦³·Qªk¤£¤@©w¼gªº¥X¨Ó¡AHsieh¡BGBKEE¨â¦ì¤j®v¬O§Úªº¨}®v¯q¤Í¡A¥L­Ì¹ï§ÚÀ°§U«Ü¤j¡A¤]Åý§Ú¾Ç¨ì«Ü¦h¤£¦Pªº§Þ¥©¡C

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-1-4 10:26 ½s¿è

¦^´_ 44# lin

±q¥H¤U¥Ø¿ý§Ú­Ì¥i¥H¬Ý¨ì³o­ÓÀɮצ³7­ÓSHEET¡A°£¤F³Ì«á¤@­ÓSHEET¥~¨ä¥LªºSHEET³£¬O¥Î¨Ó§i¶D§Ú¡AÄæ¦CÁôÂóQ¸Ñ°£«á·|²£¥Í¤£¦Pªºµ²ªG
ÁôÂÃÄæ¦C¤]¬O¤@ªù§Þ¥©.jpg
2013-1-4 09:50


¾Þ§@»¡©ú:¤°»ò¬O²Ä¤@¦¸¸Ñ°£Äæ¦CÁôÂÃ? ´N¬O¨ìSHEET«á¡Aª½±µ¨ì  ®æ¦¡ ¸Ñ°£Äæ¡A¸Ñ°£¦C
0.jpg
2013-1-4 10:03


1.CELL
³o­ÓSHEET §i¶D§Ú­Ì:²Ä¤@¦¸¸Ñ°£Äæ¦CÁôÂîɥi¥H¥uÅã¥Ü1­ÓÀx¦s®æ
1.jpg
2013-1-4 09:50


2.¦h­Ó¤£¬Û³sCELL
³o­ÓSHEET §i¶D§Ú­Ì:²Ä¤@¦¸¸Ñ°£Äæ¦CÁôÂîɥi¥H¥uÅã¥Ü¦h­Ó¤£¬Û³sÀx¦s®æ
2.jpg
2013-1-4 09:50


3.Äæ¦C¥þ¿ï
³o­ÓSHEET §i¶D§Ú­Ì:²Ä¤@¦¸¸Ñ°£Äæ¦CÁôÂîɥi¥HÅã¥ÜÄæ¦C¥þ¿ïÀx¦s®æ¡A´N¬O¥þ³¡
3.jpg
2013-1-4 09:50


4.Äæ¥þ¿ï
³o­ÓSHEET §i¶D§Ú­Ì:²Ä¤@¦¸¸Ñ°£Äæ¦CÁôÂîɥi¥HÅã¥ÜÄæ¥þ¿ïÀx¦s®æ¡A´N¥u¦³³æ¤@Äæ©Î´XÄæ
4.jpg
2013-1-4 09:50


5.¦C¥þ¿ï
³o­ÓSHEET §i¶D§Ú­Ì:²Ä¤@¦¸¸Ñ°£Äæ¦CÁôÂîɥi¥HÅã¥Ü¦C¥þ¿ïÀx¦s®æ¡A´N¥u¦³³æ¤@¦C©Î´X¦C
5.jpg
2013-1-4 09:51


6.ÁY¤pÄæ¦C¼e
³o­ÓSHEET §i¶D§Ú­Ì:²Ä¤@¦¸¸Ñ°£Äæ¦CÁôÂîɥi¥HÅã¥ÜÁY¤pÄæ¦C¼eÀx¦s®æ¡A´NÁY¤pÄæ¦C¼e®É·|¦³¬Æ»òª¬ªp
6.jpg
2013-1-4 09:54


7.­º­¶
³o­ÓSHEET §i¶D§Ú­Ì:
1.¦b¨÷¶bÃä©Ô°Ê¤À³Î½u®É¥i¥H¨Ì¦Û¤v·N«ä½Õ¾ã¡A¤£·|¶K»ôÀx¦s®æ®æ½u§Þ¥©[­ì³Ð] ¯S®í¤À³Îµøµ¡«O±KÁôÂÃÀx¦s®æ
2.[­ì³Ð] «DÄæ¦CÁôÂ桪ºÄæ¦CÁôÂäèªk
3.¤ô¥­±²¶bÁôÂäu§@ªí¼ÐÅҥΨä¥L¤èªk«OÅ@¤u§@ªí#12¥H«á»¡©ú

7.jpg
2013-1-4 09:54

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-1-5 23:55 ½s¿è

¦^´_ 46# lin

²Ä¤@­Ó°ÝÃD¼Ó¤W²Ä¤C¶µ¤w¦³°µ¸Ô²Óªº¦^ÂÐ
²Ä¤G­Ó°ÝÃD³o­Ó¥Ø¿ý¦p¦ó»s°µ¡A­º¥ý³o­Ó¬O¦Û»s¤u¨ã¨ä¤¤ªº¤@­Ó²M³æ¥Ø¿ý¡A¬O¤j¬ù2002¦~¡Aªü¦Nªº½m²ß¶µ¥Ø¡A«OÅ@«O±K¼W¯q¶°¡A¦³¤@­Ó·Qªk¦pªG§Ú°µªº¤u¨ã¤£¬O¥u¦³¤u¨ã¦C¡A¦Ó¬O¯à§e²{²M³æ¡A¯à½Æ¿ï¡A¨º会«Ü¦n¥Î¡A©Ò¥H§Ú°µ¤F¤£¦Pªº´ú¸Õ¡A­ì¥ý·Q»¡§â©Ò¦³ªº«OÅ@«O±K¥\¯à¶°¦¨¤@­Ó档¡A³Ì«áµo²{¦U¦Û©î¦¨¤@­Ó¤u¨ã¤~¯à§ó¦nªºµo´§¥\¯à¡A¶°¦X¦X¦¨¤@²Õ¥\¯à±j¤jªº«OÅ@«O±K¤u¨ã²Õ¡A»¡¯uªº¥Ø«e§Ú¦bµØ»y°Ïªººô­¶¤¤¡A¨S¬Ý¹L¤ñ³o²Õ¥\¨ã§ó±j¤jªº¨¾Å@¤u¨ã ¡C
¦p¦ó»s§@¡G­º¥ý±z¤F¸Ñ¥\¯à»P»Ý¨D¡A¦p¤u§@ªí.ÁôÂáA§Ú­Ìª¾¹D¥L¦³¤TºØ¤è¦¡Åã¥Ü¡AÁôÂáA«D±`ÁôÂáA©Ò¥H¦b²M³æªºÅã¥Ü¤W¦Ü¤Ö¦³4Ïú¡AµM«á¤~¬O³]©wªº³¡¥÷¡AÆ[©À¥Ã»·¤ñµ{¦¡­«­n¡A¦³图­n³]­p会²³æªº¦h¡AÄÝ©ó¦U¤jª©ª©¥D¦Û»s¯}¸Ñ»P¨¾Å@¥\¨ãªº¤@Àô¡A³o¤£¬OÉó±K¤]¤£¬O«ÜÃøªº§Þ¥©¦ý§Ú§ó§Æ±æªº¬O¦³¿³½ìªº¤H¡A¦³°ÝÃD®É¯à´£¨Ñ¤@­Ó·Qªk»P¥b¦¨«~¡A§@¥XÄÝ©ó¦Û¤vªº¤u¨ã¡A¹ê§@¤~¬O¤ý¹D¡C½Ð§ä¨ìªü¦N¤@½gExcel SQL ¤u¨ã¡A°µ°Ñ¦Ò会¦³±z»Ý­nªº¤j³¡¤À§Þ¥©

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD