  

            06.07|ת|ExcelΪ֪35ؼ

            ExcelΪ֪35ؼ 
            ҲѾExcelɹϰŲ񱨱ҲExcelʵֹǧεĸ㣬ҲΪExcelҲˣ⡣ƽظĵӦֵʹ÷ֻExcelȫɵİٷ֮һרExcel߰汾2002еһЩΪ֪ļ֣һ¹Excelı顣 


            һб 

            ǳҪҵ뵽УΪ˱ƵһԣáЧԡܽһб 

            1.Sheet2Уҵư硰ҵҵҵҵҵȣֱ벻ͬУһҵݿ⡣ 

            2.ѡAУҵҵУڡơڣ롰ҵҵַ󣬰سȷϡ 

            ĲBCзֱΪҵҵҵ 

            3.лSheet1УѡҪ롰ҵ𡱵УCУִСݡЧԡ򿪡ЧԡԻڡáǩУҲťѡССѡġԴУ롰ҵҵҵҵҵУԪ֮ӢĶŸȷ˳ 


            ѡҪҵƵУDУٴ򿪡ЧԡԻѡССѡڡԴ빫ʽ=INDIRECTC1ȷ˳ 


            4.ѡCⵥԪC4ҲťѡӦġҵ뵥ԪСȻѡиõԪӦDеԪD4ťɴӦҵбѡҪҵõԪС 


            ʾԺӡʱҪӡҵУѡиУһ꣬ѡءѡɡ 

            ĵ²˵ 

            ڲ˵½һĵ˵õĹĵӵУʱá 

            1.ڹհ״һ꣬ѡԶ塱ѡ򿪡Զ塱ԻڡǩУѡСµġ²˵ٽġ²˵ϵ˵ 


            ѡݡťڵ˵ġһƣ硰ĵ 

            2.ڡѡһ硰롱ѡұߡѡһ硰ӡѡϵ²˵ĵУĲ硰ʱȣһĵбơ 


            ظĲӼĵбơ 

            3.ѡСĵ˵ĳ˵硰ʱȣһ꣬ڵĿݲ˵Уѡ䳬ӡ򿪡ѡ򿪡䳬ӡԻͨҷΧҲťλӦĹ硰.xlsȣļУѡиùĵ 


            ظĲ˵ӦĹĵ 

            4.ԺҪ򿪡ĵ˵еĳĵʱֻҪչĵ˵еӦѡɡ 

            ʾǽӡѡϵˡĵ˵УӰ조롱˵Сӡ˵͡áϵġ볬ӡťĹܡ 


            òͬòͬɫʾ 

            ڹʱУôڵ2000ԪĹܶԡɫʾڵ1500ԪĹܶԡɫʾ1000ԪĹܶԡɫʾԡɫʾǿá 


            1.򿪡ʱѡСܶУִСʽʽ򿪡ʽԻ򡣵ڶҲťѡСڻڡѡںķֵ2000ʽť򿪡ԪʽԻ򣬽塱ġɫΪɫ 


            2.ӡťĲúڵ1500ΪɫС1000Ϊɫ 

            3.ɺ󣬰¡ȷť 

            ʱɣܶǲǰҪԲͬɫʾˡ 

            ġרҵš 

            ڱ༭רҵʱҪһЩרҵţΪ˷룬ǿһԼġרҵš 

            1.ִСߡ¼ºꡱ򿪡¼ºꡱԻ硰fuhao1걣ڡ˺깤УȻȷʼ¼ơѡС¼ƺꡱϵġáťȻҪ뵽ĳԪУٵ¼ƺꡱϵġֹͣťɺ¼ơ 


            Ĳһһ¼ƺŵ롰ꡱ 

            2.򿪡Զ塱ԻڡǩУ½ť½Իơרҵšȷ󣬼ڹгһ 


            лǩУѡСġꡱġԶ尴ťϵרҵšϣжٸž϶ٸť 


            3.ѡһԶ尴ťյ2ؼĵ1ǽ 

            4.һĳİť󵯳Ŀݲ˵Уѡָꡱѡ򿪡ָꡱԻѡӦĺ꣨fuhao1ȣȷ˳ 


            ظ˲ťӦĺ 

            5.رաԶ塱ԻԺʹͨһʹáרҵšԪпרҵˡ 

            塢áӡҳ 

            еĹҪӡвͬáɡ 

            1.ҪӡĹڲҪӡУУѡһֵ꣬Ŀݲ˵УѡءѡҪӡУУ 


            2.ִСͼ򿪡Ի򣬵ӡť桱Իһƣ硰ϱ󣬵ȷť 


            3.صУУʾظӡĴӡ档 

            4.ԺҪӡĳֱʱ򿪡ѡҪӡıƣʾť̰趨õĽʾáŰһ£¹ϵġӡťһоOKˡ 


            ݰ 

            ҪԱڵĲŽЩƼȵйϢǰƴ˳Ҳǰʻ˳ô?ɲԶ 

            1.ִСʽѡ򿪡ѡԻ򣬽롰ԶСǩУڡСķ벿У硰,,һ,,䡱ȣӡ͡ȷť˳ 


            2.ѡСšһԪִСݡ򿪡򡱶Ի򣬵ѡťѡԻ򣬰еťѡиղԶУΡȷťأݾͰҪ 


            ߡݳ 

            ֵԪеݲ߲ģֻýˡ 

            1.ѡҪݵĵԪ򣩣ִСʽԪ򿪡ԪʽԻڡ֡ǩġࡱѡСԶ塱ѡȻұߡ͡ķ롰Ӣ״̬µķֺţ 


            2.лǩ£ѡеġءѡȷť˳ 

            3.ִСߡ򿪡Իú󣬡ȷء 

            ԺԪеݲʾʹExcel͸ҲΡ 

            ʾڡǩ£벻Ҫǰ渴ѡеġšţԷֹɾݡ 

            ˡСӢ뷨ܻس 

            ڱ༭ʱеĵԪҪӢģеĵԪҪģл뷨ʵڲ㣬βһ£뷨ܻص? 

            ѡҪĵĵԪִСݡЧԡ򿪡ЧԡԻл뷨ģʽǩ£ģʽҲťѡС򿪡ѡ󣬡ȷ˳ 


            ԺѡҪĵĵԪһԪʱ뷨뷨беĵ1뷨Զ򿪣ѡԪʱ뷨Զرա 


            šáԶͳһı 

            ǲǾΪĳЩ̶ı硶Ա?Ǿ¿ɡ 

            1.ִСߡԶ򿪡ԶԻ 

            2.ڡ滻ķ롰pcwҲַpcwСдڡ滻Ϊķ롰Աٵӡ͡ȷť 


            3.ԺҪıʱֻҪ롰pcwַʱԲǡpcwĴСдȻȷһ¾ͳˡ 

            ʮExcelԶ庯 

            ExcelȻḻǵҪǿԶһһЩض㡣棬ǾԶһĺ 


            1.ִСߡVisual Basic༭˵򰴡Alt+F11ݼVisual Basic༭ڡ 


            2.ڴУִСģ顱˵һµģ顪ģ1 

            3.ұߵġ봰ڡ´룺 

            Function Va,b,h 
            V = h*a+b/2 
            End Function 

            4.رմڣԶ庯ɡ 

            ԺʹúһʹԶ庯 

            ʾ淽ԶĺֻͨӦĹʹá 

            ʮһͷͼƬ 

            Ϊӵıǳģֻܲڱͷ? 

            1.ִСʽ򿪡ԻѡҪΪͼƬ󣬰¡롱ťͼƬ档 


            2.ڰסCtrlͬʱڲҪͼƬĵԪͬʱѡЩԪ򣩡 

            3.ʽϵġɫҲťֵġɫ塱УѡСɫ 
            ԺµĵԪͼƬѡеĵԪûгͼƬˣʵͼƬɫڸˣ 

            ʾڵԪͼƬǲִ֧ӡġ 

            ʮַ&ϲı 

            뽫еݺϲһУҪúһССַ&ܽ㶨˴ٶBCDкϲһУ 

            1.DкУEFУȻD1Ԫ빫ʽ=B1&C1&D1 

            2.ٴѡD1ԪáʽƵDĵԪУBCDеݼϲEжӦĵԪС 

            3.ѡEУִСơȻѡFУִС༭ѡճ򿪡ѡճԻѡеġֵѡ¡ȷťEеݣǹʽƵFС 


            4.BCDEɾɺϲ 

            ʾɵ12ĲϲЧѾʵ֣ʱɾBCDУʽִ󡣹е3ʽתΪġֵ 


            ʮٴӡѧɼ 

            ʡδӡɼ⣬в˲ȡ¼ƺVBAķʵ֣ڳѧ˵һѶȡڴֿǣһúʵֵļ㷽 


            ˴ٶѧɼSheet1A1G64ԪУе1Ϊ⣬2Ϊѧơ 

            1.лSheet2УѡA1Ԫ빫ʽ=IFMODROW3=0壬IF0MODROW3=1sheet1A$2INDEXsheet1$A$GINTROW+4/3+1COLUMN 


            2.ٴѡA1ԪáʽƵB1G1ԪУȻͬʱѡA1G1ԪáʽƵA2G185ԪС 


            ˣɼͣһ¡ 

            3.иߺпͬʱѡA1G2Ԫ򣨵1λѧĳɼ򣩣ʽ߿Ҳťֵı߿бУѡСпߡѡΪѡеӱ߿Ҫ߿򣬿Բд˲Ĳ 


            4.ͬʱѡA1G3Ԫ򣬵áϵġʽˢťȻסA4G186ԪΪеĳɼӱ߿ 


            ӡťɽɼӡ


                  רشŻݣһcom/net/org/cn/com.cn+200M֧ASPPHPHTML=99Ԫ
            ĵַ http://bbs.100free.net/read.php?tid=96596 
             
            µʱįʱʱҺʱǡQQ 

            http://bbs.100free.net/?a=330790798 
            http://bbs.100free.net/?u=144056 

            ӭµһϢ



            [¥ ] | Posted: 2006-06-07 11:23 AM 


      ls0349 





        
      : Ա
      : 0 
      : 599
      : ˮ
      ѫ:7 
      ż: 
      : 332 
      ұ: 108 
      : 40 
      עʱ:2005-09-28
      ¼:2006-09-05       



            ֪ʶ,ѧϰ


                  רشŻݣһcom/net/org/cn/com.cn+200M֧ASPPHPHTML=99Ԫ
             
            ӭ֮ҡΪѷսշѡ
            ֺõģ͵ΪңΪ!סǵַ:http://bbs.100free.net 

            [1 ¥] | Posted: 2006-06-08 08:53 AM 


       


            
      aiwo.com.cn
        
      : ܰ
      : 21 
      : 16821
      : 0 ˮԤ
      ѫ:ˮ 
      ż: Ƽˮ2327
      : 27585 
      ұ: 9508 
      : 61 
      СȺ: Ժ
      עʱ:2005-03-12
      ¼:2006-09-11      



            ѧϰ


                  רشŻݣһcom/net/org/cn/com.cn+200M֧ASPPHPHTML=99Ԫ
             
            רشŻݣһcom/net/org/cn/com.cn+200M֧ASPPHPHTML=99Ԫ 


            [2 ¥] | Posted: 2006-06-08 11:15 AM 


      flydream 





        
      : ˳
      : 0 
      : 15
      : ˮ
      ѫ:2 
      ż: 
      : 2 
      ұ: 36 
      : 0 
      עʱ:2006-06-16
      ¼:2006-06-27      



            ãѧϰ״̬


                  רشŻݣһcom/net/org/cn/com.cn+200M֧ASPPHPHTML=99Ԫ
             
            ӭ֮ҡΪѷսշѡ
            ֺõģ͵ΪңΪ!סǵַ:http://bbs.100free.net 

            [3 ¥] | Posted: 2006-06-17 10:10 AM 


      gzhgy999 



        
      : мԱ
      : 0 
      : 599
      : ˮ
      ѫ:7 
      ż: 
      : 225 
      ұ: 162 
      : 0 
      עʱ:2005-09-28
      ¼:2006-09-09      



            ת|ExcelΪ֪35ؼ

            ExcelΪ֪35ؼ 
            ҲѾExcelɹϰŲ񱨱ҲExcelʵֹǧεĸ㣬ҲΪExcelҲˣ⡣ƽظĵӦֵʹ÷ֻExcelȫɵİٷ֮һרExcel߰汾2002еһЩΪ֪ļ֣һ¹Excelı顣 


            һб 

            ǳҪҵ뵽УΪ˱ƵһԣáЧԡܽһб 

            1.Sheet2Уҵư硰ҵҵҵҵҵȣֱ벻ͬУһҵݿ⡣ 

            2.ѡAУҵҵУڡơڣ롰ҵҵַ󣬰سȷϡ 

            ĲBCзֱΪҵҵҵ 

            3.лSheet1УѡҪ롰ҵ𡱵УCУִСݡЧԡ򿪡ЧԡԻڡáǩУҲťѡССѡġԴУ롰ҵҵҵҵҵУԪ֮ӢĶŸȷ˳ 


            ѡҪҵƵУDУٴ򿪡ЧԡԻѡССѡڡԴ빫ʽ=INDIRECTC1ȷ˳ 


            4.ѡCⵥԪC4ҲťѡӦġҵ뵥ԪСȻѡиõԪӦDеԪD4ťɴӦҵбѡҪҵõԪС 


            ʾԺӡʱҪӡҵУѡиУһ꣬ѡءѡɡ 

            ĵ²˵ 

            ڲ˵½һĵ˵õĹĵӵУʱá 

            1.ڹհ״һ꣬ѡԶ塱ѡ򿪡Զ塱ԻڡǩУѡСµġ²˵ٽġ²˵ϵ˵ 


            ѡݡťڵ˵ġһƣ硰ĵ 

            2.ڡѡһ硰롱ѡұߡѡһ硰ӡѡϵ²˵ĵУĲ硰ʱȣһĵбơ 


            ظĲӼĵбơ 

            3.ѡСĵ˵ĳ˵硰ʱȣһ꣬ڵĿݲ˵Уѡ䳬ӡ򿪡ѡ򿪡䳬ӡԻͨҷΧҲťλӦĹ硰.xlsȣļУѡиùĵ 


            ظĲ˵ӦĹĵ 

            4.ԺҪ򿪡ĵ˵еĳĵʱֻҪչĵ˵еӦѡɡ 

            ʾǽӡѡϵˡĵ˵УӰ조롱˵Сӡ˵͡áϵġ볬ӡťĹܡ 


            òͬòͬɫʾ 

            ڹʱУôڵ2000ԪĹܶԡɫʾڵ1500ԪĹܶԡɫʾ1000ԪĹܶԡɫʾԡɫʾǿá 


            1.򿪡ʱѡСܶУִСʽʽ򿪡ʽԻ򡣵ڶҲťѡСڻڡѡںķֵ2000ʽť򿪡ԪʽԻ򣬽塱ġɫΪɫ 


            2.ӡťĲúڵ1500ΪɫС1000Ϊɫ 

            3.ɺ󣬰¡ȷť 

            ʱɣܶǲǰҪԲͬɫʾˡ 

            ġרҵš 

            ڱ༭רҵʱҪһЩרҵţΪ˷룬ǿһԼġרҵš 

            1.ִСߡ¼ºꡱ򿪡¼ºꡱԻ硰fuhao1걣ڡ˺깤УȻȷʼ¼ơѡС¼ƺꡱϵġáťȻҪ뵽ĳԪУٵ¼ƺꡱϵġֹͣťɺ¼ơ 


            Ĳһһ¼ƺŵ롰ꡱ 

            2.򿪡Զ塱ԻڡǩУ½ť½Իơרҵšȷ󣬼ڹгһ 


            лǩУѡСġꡱġԶ尴ťϵרҵšϣжٸž϶ٸť 


            3.ѡһԶ尴ťյ2ؼĵ1ǽ 

            4.һĳİť󵯳Ŀݲ˵Уѡָꡱѡ򿪡ָꡱԻѡӦĺ꣨fuhao1ȣȷ˳ 


            ظ˲ťӦĺ 

            5.رաԶ塱ԻԺʹͨһʹáרҵšԪпרҵˡ 

            塢áӡҳ 

            еĹҪӡвͬáɡ 

            1.ҪӡĹڲҪӡУУѡһֵ꣬Ŀݲ˵УѡءѡҪӡУУ 


            2.ִСͼ򿪡Ի򣬵ӡť桱Իһƣ硰ϱ󣬵ȷť 


            3.صУУʾظӡĴӡ档 

            4.ԺҪӡĳֱʱ򿪡ѡҪӡıƣʾť̰趨õĽʾáŰһ£¹ϵġӡťһоOKˡ 


            ݰ 

            ҪԱڵĲŽЩƼȵйϢǰƴ˳Ҳǰʻ˳ô?ɲԶ 

            1.ִСʽѡ򿪡ѡԻ򣬽롰ԶСǩУڡСķ벿У硰,,һ,,䡱ȣӡ͡ȷť˳ 


            2.ѡСšһԪִСݡ򿪡򡱶Ի򣬵ѡťѡԻ򣬰еťѡиղԶУΡȷťأݾͰҪ 


            ߡݳ 

            ֵԪеݲ߲ģֻýˡ 

            1.ѡҪݵĵԪ򣩣ִСʽԪ򿪡ԪʽԻڡ֡ǩġࡱѡСԶ塱ѡȻұߡ͡ķ롰Ӣ״̬µķֺţ 


            2.лǩ£ѡеġءѡȷť˳ 

            3.ִСߡ򿪡Իú󣬡ȷء 

            ԺԪеݲʾʹExcel͸ҲΡ 

            ʾڡǩ£벻Ҫǰ渴ѡеġšţԷֹɾݡ 

            ˡСӢ뷨ܻس 

            ڱ༭ʱеĵԪҪӢģеĵԪҪģл뷨ʵڲ㣬βһ£뷨ܻص? 

            ѡҪĵĵԪִСݡЧԡ򿪡ЧԡԻл뷨ģʽǩ£ģʽҲťѡС򿪡ѡ󣬡ȷ˳ 


            ԺѡҪĵĵԪһԪʱ뷨뷨беĵ1뷨Զ򿪣ѡԪʱ뷨Զرա 


            šáԶͳһı 

            ǲǾΪĳЩ̶ı硶Ա?Ǿ¿ɡ 

            1.ִСߡԶ򿪡ԶԻ 

            2.ڡ滻ķ롰pcwҲַpcwСдڡ滻Ϊķ롰Աٵӡ͡ȷť 


            3.ԺҪıʱֻҪ롰pcwַʱԲǡpcwĴСдȻȷһ¾ͳˡ 

            ʮExcelԶ庯 

            ExcelȻḻǵҪǿԶһһЩض㡣棬ǾԶһĺ 


            1.ִСߡVisual Basic༭˵򰴡Alt+F11ݼVisual Basic༭ڡ 


            2.ڴУִСģ顱˵һµģ顪ģ1 

            3.ұߵġ봰ڡ´룺 

            Function Va,b,h 
            V = h*a+b/2 
            End Function 

            4.رմڣԶ庯ɡ 

            ԺʹúһʹԶ庯 

            ʾ淽ԶĺֻͨӦĹʹá 

            ʮһͷͼƬ 

            Ϊӵıǳģֻܲڱͷ? 

            1.ִСʽ򿪡ԻѡҪΪͼƬ󣬰¡롱ťͼƬ档 


            2.ڰסCtrlͬʱڲҪͼƬĵԪͬʱѡЩԪ򣩡 

            3.ʽϵġɫҲťֵġɫ塱УѡСɫ 
            ԺµĵԪͼƬѡеĵԪûгͼƬˣʵͼƬɫڸˣ 

            ʾڵԪͼƬǲִ֧ӡġ 

            ʮַ&ϲı 

            뽫еݺϲһУҪúһССַ&ܽ㶨˴ٶBCDкϲһУ 

            1.DкУEFУȻD1Ԫ빫ʽ=B1&C1&D1 

            2.ٴѡD1ԪáʽƵDĵԪУBCDеݼϲEжӦĵԪС 

            3.ѡEУִСơȻѡFУִС༭ѡճ򿪡ѡճԻѡеġֵѡ¡ȷťEеݣǹʽƵFС 


            4.BCDEɾɺϲ 

            ʾɵ12ĲϲЧѾʵ֣ʱɾBCDУʽִ󡣹е3ʽתΪġֵ 


            ʮٴӡѧɼ 

            ʡδӡɼ⣬в˲ȡ¼ƺVBAķʵ֣ڳѧ˵һѶȡڴֿǣһúʵֵļ㷽 


            ˴ٶѧɼSheet1A1G64ԪУе1Ϊ⣬2Ϊѧơ 

            1.лSheet2УѡA1Ԫ빫ʽ=IFMODROW3=0壬IF0MODROW3=1sheet1A$2INDEXsheet1$A$GINTROW+4/3+1COLUMN 


            2.ٴѡA1ԪáʽƵB1G1ԪУȻͬʱѡA1G1ԪáʽƵA2G185ԪС 


            ˣɼͣһ¡ 

            3.иߺпͬʱѡA1G2Ԫ򣨵1λѧĳɼ򣩣ʽ߿Ҳťֵı߿бУѡСпߡѡΪѡеӱ߿Ҫ߿򣬿Բд˲Ĳ 


            4.ͬʱѡA1G3Ԫ򣬵áϵġʽˢťȻסA4G186ԪΪеĳɼӱ߿ 


            ӡťɽɼӡ


               

    