                   qTTTTTTTTTTTTTTTTTTTTTTr                            
                   U     ==  Excelٱ9.0  ==             U                           
     qTTTTTT       114ߺ28              TTTTTr
     U            U     ȫλĹЧ               U          U
     U            tTTTTTTTTTTTTTTTTTTTTTTs          U
     U                                                                      U
     U      qr      U
     tTTTwww.downcc.com TTTs
             ts



<TTTTTTTTTTTTTTTTTT    ܽܣܹ142ܣ    TTTTTTTTTTTTTTTTTTTT>


ũ˫ѯɶ๦Բѯнڡպũ
߼λ๦ѡ񣨲ңߡѡĳֵСĳֵĳΧֵ֮ıλʱ֧ͨ԰ʽ/λ
ɫǰнɫʾͻʾݲ鿴ضɫɵɫǳͬ๤вƻɫʽճͳ֮ŵ
áùͼƸĿʾ
̡أ˽ļ
ɫܡ:ɫѡݺϼ
뱣ɾ룬˲ɡExcel 2002200320072010
ʾ˵:Excel 20072010ʾ2003ʽĲ˵ѧExcel 20072010ûҲ˵
ȡڶ󡿣ѡĴڻ߶תͼƬļɽExcel
ȡζ󡿣ѡľתͼƬļ
ȡ򡿣ѡתͼƬļ
ɾյԪ񡿣ɾѡĿյԪ񣬺Զ
תѡѡе
еáѡݺ
еáѡ
ĸСдתѡĵʡĸڴдСдĸд֮ת
Ӣ롿ѡӢ룬ѡӢתģѡתӢ
СдתдСдתɴд
дתСддתСд
ݼܡԹѡݽмܣת룬ſԲ鿴
ת塿תɷ
ת塿תɼ
ʽתֵָָĹʽתֵѡ͵ԪΧ
ݹʼ㳮ƱԱĹʼҪ100Ԫ50Ԫ......1ԪĳƱ㡣ֽʵĲ߱ر
вСԹвУ߸вУԶ
۷ָֹÿֳɵĹ¹Ƶԭ
۷֡ǰݰֳɶеΪ
ϲָļййݺϲֺϲʽÿеĹϵǰǣӦͬͬݺϲͬһСͬĴ
ıֵѡ˲תıѡı˲תֵ
ѡ򹤾ߡɸѡ򣨷д򹴵ĹߣѡȡѡҿԶ帴ǷԴӡ뵥Ԫӵȵ
䡿WordзܣʹExcelҲͬ๦ܡ̫˷Ѵӡֽʱñ߷ֳɶٴӡ
˲佫ϸɹӡüԼ幤ͷ
ɾָϸɾǰһɵĹͷָϸ
ҳСơÿҳݽСƺۼƣԶҳСƺۼÿҳĩ
ɾҳСơɾСۼƣָϸ
ϲѡһԪֵϵһȥԲ뵽ԭַ֮ǰҲԲ뵽ԭַ֮
ɻԭĺϲСϲʱԱݣָʱȡϲԭ
ϲֵͬһͬڵкϲ
ȡϲԭϲݡһкϲĵԪȡϲһָϲǰ
ϲݲơԽһֱӸƵһԪ
ϲԶС:þкϲԪԶ벻֮л
ѡϲԪ:ѡָекϲ
úϲԪҳ:ϲԪѿҳӡʱɺϲֵʾһҳУһҳհףҳʾһ֣ڵϲԪʹַͬʱʾҳ
ǿԽϲ:ѡкϲϲʱ
ϲԪ:ʹѾϲеÿԪݣӶڹʽõԪʱհ
ϲϼơ:ָУһеݺϲͬһжӦֵϼƣϼƽںϲ
ͼƬĿ¼ָļͼƬGIFPNGJPGJPEGĿ¼
ͼƬȷƥ䣩˲䵼ѡַͬͼƬԪ񣬿趨ͼƬĴСʽȫͳһ
ͼƬģƥ䣩һ߻һ£ֻȷͼƬʱԺģƥ䡣ѡšԵŵ˵Ƭ
ͼƬԶŰ棩ͼƬԶŰ棬ɶжŰ棬ָͼƬС·
ͼƬעؽͼƬ뵽עУ趨ͼƬʾС
ɾͼƬɾǰͼƬ
ΪͼƬѡ߹еͼƬJPGļPNGͼƬ
ͼƬǰǶͼƬӲгΪJPGͼƬ
ɸԻעExcelֻзע߿ֻıע۴
GIFGIF빤вţԶȡͼƬСҲֹ嶯ĴСλ
FlashFlash빤вţԶȡFlashС,ԶFlashĴСλãFlashǶ빤
ȡFlashļǶExcelWordеFlashļȡΪSwfļ
FlashļרҵĲֱѡFlashɲţҾԶ͸Ź
ȡѡΨһֵѡݣڵǰУظֵ
ظֵѡظֵɾһγֵݣ
ֹظֵָĳвظָظֵʱԶʾ
ʾظֵظֵòͬɫֱʾͬظֵòͬɫ
ɾհ׵ԪС1ɾհУпհף2ɾհ׵Ԫ
ɸѡΨһֵѡһΪΨһֵɸѡ1ɾظֵУ2ظֵ
ͬ벻ͬȡݵĹͬͲͬҲԶݵĲͬͬбʾ
ļĿ¼ָļеļĿ¼ӣԴ򿪶Ӧļ
Ŀ¼:ԵǰйĿ¼ţӣԴ򿪹
½/ƹ:½߸ƹ˲佨/1255½ʱȫԶ
ӽܡ:Թм롢루ֻԼõ룩
ƽ⹤/롿:ƽ⹤͹롣ڲ֪ǰһ
ļ:ָļļ޶ļͻ߶ļԭļǰߺƣҲ滻ԭơ
һʡ:Թʣݵǰ£ù٣Ӷٶȡ
ӡǰҳ:ӡǰҳ
˫ӡ:ӡ˫Сר
ӡ׶˱⡿:Ϊ׶˱дӡֲExcelֻж˱֮
ϵͳͼ꡿:VBAԱõĹߡԲѯExcelڲͼID
ȡID:VBAԱõĹߡԲѯExcelڲID
޸Excel:ExcelĳЩ޷ʹʱԵ޹ʶܶ˵ʱ߿˲ָExcelĬ״̬
ƽVBA롿:VBAдĳƽ⣬˲
ѯ:ѯVBAIDŶӦԭ򼰽취
VBAϢѯ:صVBAѯ¼ԡ󡢼ؼ
﷨ѯ:VBAԼصİѯ
ѡ:ѡǰδѡ
ǧ:ԪǧڡĬʾµɵ
ʽ:ǰйʽ˿ʽֻܿʽ
б߱ͷ:ExcelûWordб߱ͷߣ߿ֲ˲㡣ߡ˫߿ѡ
ټĸС:кڵԪнаټĸ䣬¼ٶ
һطʹ:Կհ˲ѡöǵǰйָʱҲֻҪ˲
ճɼ:ճ򣬽ԿɼЧ
ע:ע޸עԼעִ滻ȷƥģƥ
ʽơ:ʱԽݺ͸ʽϢһƹȥиߡпɫȵ
롿ָеִֵ룬ԶСλͶָʽͬǣ޸ֵҶָʽ޸ʾ״̬
ͼʽ:ͼϵִʽ23ϵֵָɫ
޸ļʱ䡿:޸ļĴʱ
IE롿:IE룬ͻ
汾򿪷ʽ:װ˶汾Office߿ѡExcelļĴ򿪷ʽͨļҼġ͵˵ִ
2003ʽ˵:Excel 2007Excel 2010רãԲ2003ʽĲ˵ðٱ䣨ã
ơ:ѡʱи
ɫɸѡ:Excel 2003Ҳ԰ɫɸѡݣ20072010ûҪʹá
ɫ:Excel 2003Ҳ԰ɫݣ20072010ûҪʹ
ҳϽĿ¼ʹãκι˲䷵صһ
ǩǰĹһлǩ,ڹϷͨCtrl+Shift+Tлʾ״̬,ͨҼ˵رչ
ȡıȡַеı
ȥıɾַеı
ȡĸȡַеĸ
ȥĸɾַеĸ
ȡ֡ȡַе
ȥ֡ɾַе
ȡ֡ȡַеĴС
ȡʽȡַеıʽ
ʽʽתֵӻַȡıʽ

<TTTTTTTTTTTTTTTTTT    ܽ    TTTTTTTTTTTTTTTTTTTT>
ƣsumifcol
    ɫ͡òеΪѡһΪ򣬵ڶΪɫΪ򣬼һɫڶͬ,򽫶ӦĵĵԪ͡ʡԵԵһ͡
ƣAVER
    ֺȥֵСֵ֮ƽ255Excel2003130
ƣhesum
    Һϲ͡1/2͵ֻ1.5ݺͣΪ1212㣬Ϊ1/21.5㡣
ƣNOWW
	ıĵǰʱ䡣Ҫʱʾڵʱ䣬ʱıı䡣
ƣSFZ
    ֤ϢһΪãڶ롰DQȡص롰XB򷵻Ա롰SR򷵻աԵڶĬʾ
ƣд
    תΪҽдҪһԪá
ƣע
    ȡעеֻ֡һԪá
ƣϲ
    ַϲһΪָڶΪ򡣿""ʾʹ÷ָʼΪ򣬿1254Excel2003129Ҳֱı
ƣȡ
    ıһΪԪ񣻵ڶΪѡΪ0ʡʱʾȡ֣Ϊ1ʱʾų֣Ϊ2ʱʾȡΪ3ȡҼ
ƣΨһֵ
    زظֵԶ1253Excel2003128ȡΨһֵǰΪѡΪѡһΪROWʱкȡֵ,ΪCOLUMNʱкУִСдʼΪ
ƣֵ
    ֵѡж,к֮ʽֵ.,һΪһΪš
ƣɫ
    ɫֵ͡һΪֵڶΪ
ƣɫ
    ɫ֮ͬݸһΪֵڶΪ
ƣ
    ȡһ빤ַعĹӹܡ
ƣ
    롰д෴дַתΪ֡
ƣָȡ
    ָȡһΪԪ񣬵ڶʾȡNʾָ
ƣ
    ĿǰΪ򣬵Ϊš
ƣͬ
    صһжڶûеĿǰ򣬵Ϊš
ƣʽ
    ʽȡԪеĹʽֻҪһԪá
ƣ
    㺯㵥Ԫеıʽ絥ԪΪ456+2458ֻҪһԪá
ƣʽ
    㵥ԪйʽĳȣһԪá
ƣ
    йʽβϣ˲еڶʱȻڵһΪɼ򣬵ڶΪĳɼá
ƣ
    ִ򡣶ݽִַڵһλȻνݡһΪãڶΪΣʹROW(a1)
ƣ滻
    滻NγֵַĺһΪãڶΪ滻ַΪַĲָ滻ڼγֵַΧ1256֮䡣
ƣظ
    жָǷظԪĺֻһΪãΪTrueʱʾظظ
ƣFile
ڴӵļĿ¼·ļ
ƣPZ
    ʷ¼ָеԪֵмأ޸¼ֵ޸ʱ(ÿݼ Alt+QʹעԶ)
ƣLook
    ǿѯVlookpĹܣжֵҪʱֵҿԴһߴ飬һΪֵڶΪҵã
ƣDaOrXiao
    Сд໥תһõԪ񣬵ڶʾشдǷСдֵΪTrueߺʱʾشдֵΪFalseʱʾСд

                 qTTTTTTTTTTTTTTTTTTr
                 U                                    U
       qTTTT        ߰װ              TTTTTTTr
       U        U                                    U              U
       U        tTTTTTTTTTTTTTTTTTTs              U
       U          ˫setup.exeʾ                   U
 U                                                            U
       U          ڿʼ˵ɾٱĿݷʽ                    U
       tTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTs

       qTTTTTTTT װɹԭ TTTTTTTTTTTr                            
       U  ޷װע5㣺                           U   
       U   һOFFICEɫ桢治֧COMغ      U  
       U   رExcel״̬°װɾߣװExcel   U  
       U   ԹԱûװ                                   U 
       U   ģVISTAWIN 7Ҫӿйرûʻ   U  
       U   壺װEXCELߣʱص                U              
       U                                                            U                           
       tTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTs
ڰٱ8.0°9.0¸£
_______________________________________________
Aܣ
1.ͼȡڡȡͲ3
2.Ӣ
3.ַ룺ȡıȥıȡĸȥĸȡ֡ȥ֡ȡ֡ȡʽʽ9
4.úϲԪҳ
5.λϲԪ
6.ͼƬŰ
7.ճʱ
8.汾򿪷ʽ
9.ע
10.ǿԽϲ
11.ʾ˵
12.ʽ
13.
14.IEּ
15.ȡSWFļ
16.ϲԪ
17.ϲϼ
18.ѯ
19.VBAϢѯ
20.﷨ѯ
21.ͼʽ
22.Flash
23.뱣
24.lookԶ庯
25.ǩ
26.PZԶ庯
27.һ
28.ʽתֵ
ע뱣룬ƽ⹤/롱ڼ㹤߹ı룬
________________________________________________
Bԭй
1.ͼƬ2
  1ͼƬ̫С̫ʱ޷ɹBUG
  2ļѡĹܣùָеַΪͼƬ󱣴ơ
  3Excel 2010+Windows XP޷ִе⡣
2.ͼƬѯܡ
  ʹùܿExcel 2010ʹá
3.ͼƬע
  עĳߴ綨巽ʽиĽʹͼƬȿԶ߶ֱֲΣ⻹˽ͼƬԭʼߴΪעߴѡ
4.ǿɫ͡롰ɫĹܣֱһڿƼ㷽ʽ²ԱɫɫΪձ׼
5.ԭеġд֡͡йܼºDaOrXiaoУͨƴСдתʽ
6.ɾհ׵ԪС޸ΪѡС

