在excel 粘貼選擇的內容
![](/ima/jixie/448.jpg)
如左圖(tu)(tu)中(zhong)(zhong)的(de)(de)excel2013版本中(zhong)(zhong)選(xuan)擇性粘(zhan)貼(tie)(tie)中(zhong)(zhong)沒(mei)(mei)有(you)數(shu)值(zhi)(zhi)那一(yi)(yi)項(xiang),右圖(tu)(tu)是其(qi)他低版本的(de)(de)中(zhong)(zhong)有(you)數(shu)值(zhi)(zhi)那一(yi)(yi)項(xiang)藍圈. 如左圖(tu)(tu)中(zhong)(zhong)的(de)(de)excel2013版本中(zhong)(zhong)選(xuan)擇性粘(zhan)貼(tie)(tie)中(zhong)(zhong)沒(mei)(mei)有(you)數(shu)值(zhi)(zhi)那一(yi)(yi)項(xiang),右圖(tu)(tu)是其(qi)他低選(xuan)擇性粘(zhan)貼(tie)(tie)/數(shu)值(zhi)(zhi)與(yu)選(xuan)擇性粘(zhan)貼(tie)(tie)/值(zhi)(zhi)和(he)數(shu)字格式(shi)有(you)什么(me)不同/在Excel表格中(zhong)(zhong),對某區域復制后,在選(xuan)擇性粘(zhan)貼(tie)(tie)中(zhong)(zhong),數(shu)值(zhi)(zhi)與(yu)值(zhi)(zhi)和(he)數(shu)字格式(shi)有(you)什么(me)不同 "在Exc
![](/ima/jixie/1024.jpg)
和你復制(zhi)(zhi)的內容有關,必須(xu)是(shi)(shi)office認可(ke)的文(wen)件才能(neng)復制(zhi)(zhi)后粘(zhan)(zhan)(zhan)貼(tie)(tie)鏈接(jie),一般excel只認可(ke)office的文(wen)件,不(bu)(bu)信你拿word文(wen)檔(dang)試試,選(xuan)擇(ze)粘(zhan)(zhan)(zhan)貼(tie)(tie)連接(jie)不(bu)(bu)是(shi)(shi)灰(hui)色的了,而(er)ie上復制(zhi)(zhi)的東(dong)西不(bu)(bu)行(xing)【excel選(xuan)擇(ze)性(xing)粘(zhan)(zhan)(zhan)貼(tie)(tie)】excel為(wei)什么(me)不(bu)(bu)能(neng)跨(kua)表選(xuan)擇(ze)性(xing)粘(zhan)(zhan)(zhan)貼(tie)(tie)?/excel為(wei)什么(me)不(bu)(bu)能(neng)跨(kua)表選(xuan)擇(ze)性(xing)粘(zhan)(zhan)(zhan)貼(tie)(tie)?可(ke)以的,兩(liang)個(ge)Excel文(wen)件之間可(ke)以"選(xuan)擇(ze)性(xing)粘(zhan)(zhan)(zhan)貼(tie)(tie)"。你是(shi)(shi)不(bu)(bu)是(shi)(shi)在復制(zhi)(zhi)以后、粘(zhan)(zhan)(zhan)貼(tie)(tie)之前(qian)將
![](/ima/jixie/947.jpg)
在excel 粘貼選擇的(de)(de)內容,這樣復制再選擇性(xing)粘貼另(ling)一工作簿的(de)(de)單元(yuan)格時,才會有你(ni)想要的(de)(de)選項(xiang)。原因是(shi)2007版本 這說明你(ni)復制的(de)(de)內容并不(bu)(bu)是(shi)excel單元(yuan)格或者(zhe)你(ni)是(shi)復制的(de)(de)excel里的(de)(de)內容,但是(shi)你(ni)是(shi)雙擊單excel選擇性(xing)粘貼不(bu)(bu)能用如(ru)圖所示,我的(de)(de)數(shu)值(zhi)來源的(de)(de)確(que)是(shi)來自excel,只不(bu)(bu)過不(bu)(bu)是(shi)來自同(tong)一個表而(er)已(yi)。現在要如(ru)何設置,來自同(tong)一個exlce不(bu)(bu)會出現這問(wen)題。告訴你(ni)為(wei)什么:你(ni)打開(kai)