表格圖片如何換為透明色

❶ excel鍥劇墖閫忔槑搴﹁皟鑺傛暀紼

Excel璁劇疆鍥劇墖閫忔槑搴︽ラゅ備笅璁劇疆鍥劇墖閫忔槑姝ラ1寮Excel杞浠訛紝鍗曞嚮ldquo鎻掑叆rdquomdashmdash鍥劇墖錛屽傚浘鎵紺鴻劇疆鍥劇墖閫忔槑姝ラ2鍦ㄥ脊鍑虹殑瀵硅瘽妗嗕腑鎵懼埌鍥劇墖騫舵彃鍏ワ紝鍥劇墖灝辨彃鍏ュソ浜嗭紝濡傚浘鎵紺鴻劇疆鍥劇墖閫忔槑姝ラ3銆
1棣栧厛鎵撳紑excel錛岀偣鍑燴滄彃鍏モ濋夐」閲岀偣鍑燴滃艦鐘垛濆悗閫夋嫨闇瑕佺殑褰㈢姸2鐒跺悗鍦ㄨラ〉闈涓鐐瑰嚮鈥滃艦鐘跺～鍏呪濋夐」涓鐨勨滃浘鐗団3涔嬪悗鍦ㄨラ〉闈涓鐐瑰嚮鈥滄潵鑷鏂囦歡鈥濋夐」4鐒跺悗鍦ㄨラ〉闈涓瀵煎叆鍥劇墖鍚庡湪鈥滈忔槑搴︹濆彸渚ф柟妗嗛噷杈撱
1鎵撳紑闇瑕佹搷浣滅殑EXCEL琛ㄦ牸錛屽湪鎻掑叆宸ュ叿鏍忔壘鍒板苟鐐瑰嚮褰㈢姸錛屽苟鍦ㄥ叾涓嬫媺閫夐」涓閫夋嫨鈥滅煩褰⑩2鍦ㄨ〃鏍間腑鐢誨嚭涓涓闇瑕佸～鍏呭浘鐗囩殑鍚堥傚ぇ灝忕殑鐭╁艦錛岀劧鍚庡湪緇樺浘宸ュ叿涓鐐瑰嚮鈥滃艦鐘跺～鍏呪濆苟閫夋嫨鈥滃浘鐗団3鎵懼埌闇瑕佷綔涓鴻儗鏅鐨勫浘鐗囥
1鍦‥XCEL琛ㄦ牸涓錛岀偣鍑燴滄彃鍏モ濋夐」鍗′腑鐨勨滃艦鐘垛濆苟閫夋嫨鈥滅煩褰⑩2鎵嬪姩鍦ㄨ〃鏍間腑鐢誨嚭涓涓澶у皬鍚堥傜殑鐭╁艦妗嗭紝鐐瑰嚮緇樺浘宸ュ叿鐨勨滃艦鐘跺～鍏呪濆苟閫夋嫨鈥滃浘鐗団3鐐瑰嚮閫夋嫨鐩稿叧鍥劇墖錛屽苟鐐瑰嚮涓嬫柟鐨勨滄彃鍏モ濇寜閽4鍦ㄥ浘鐗囦笂銆

鍦‥xcel鏂囨。褰撲腑錛屽傛灉瑕佽劇疆鍥劇墖鐨勫睘鎬э紝浣垮浘鐗囧彉鎴愰忔槑鑹茬殑鑳屾櫙錛岄偅涔堝彲浠ュ備笅鎿嶄綔錛岄栧厛閫変腑鍥劇墖錛岀劧鍚庣偣鍑婚紶鏍囧彸閿騫跺湪寮瑰嚭寮忚彍鍗曞綋涓閫夋嫨鍥劇墖灞炴э紝鐒跺悗鍦ㄥ浘鐗囧睘鎬х晫闈㈠綋涓淇鏀瑰浘鐗囩殑搴曡壊錛屽皢搴曡壊鐨勯忔槑搴﹁句負鐧懼垎涔嬩竴鐧撅紝鏈鍚庛

1棣栧厛鎵撳紑excel琛ㄦ牸錛屽彲浠ョ湅鍒板湪琛ㄦ牸涓鎻掑叆鐨勫浘鐗囦細灝嗚緭鍏ョ殑瀛楃﹂伄鎸′綇錛岄渶瑕佸皢璇ュ浘鐗囪劇疆涓鴻〃鏍艱儗鏅2鐐瑰嚮宸ュ叿鏍忎腑鐨勨滈〉闈㈠竷灞鈥濋夐」錛屽湪鍏朵腑鐐瑰嚮鈥滆儗鏅鍥劇墖鈥3鐒跺悗鍦ㄦ墦寮鐨勫硅瘽妗嗕腑閫変腑涓庢彃鍏ュ浘鐗囩浉鍚岀殑鍥劇墖錛岀偣鍑匯
鐒跺悗閫変腑鎻掑叆鐨勫浘鐗囷紝鎴戜滑鍐嶆壘鍒扳滅粯鍥懼伐鍏封濓紝鐐瑰嚮涓嬮潰鐨勨滃艦鐘跺ぇ灝忊濆瑰浘鐗囪繘琛岃劇疆榪欎釜鏃跺欐垜浠浼氬彂鐜扳滈滆壊涓庣嚎鏉♀濅笅闈㈠氨鏈変竴涓鈥滈忔槑搴︹濊劇疆鐒跺悗鎴戜滑灝辯Щ鍔ㄨ繖涓鈥滈忔槑搴︹濇潯鏉ラ夋嫨鎴戜滑鎯寵佺殑鍚堥傞忔槑搴︼紝榪欎釜鍙浠ュ弽澶嶃
鈥滆劇疆閫忔槑鑹測2鍦ㄤ笓涓氱殑鍥懼儚澶勭悊杞浠朵腑錛屽侾S錛屽勭悊濂介忔槑鍥撅紝瀛樹負PNG鏍煎紡錛屾垨GIF鏍煎紡錛屽湪Excel涓瀵煎叆娉≒NG鏀鎸佷笉閫忔槑鐨勬棤鎹熷浘鐗囨牸寮忥紝GIF鏀鎸佷笉閫忔槑鐨256鑹詫紝鍗冧竾涓嶈兘瀛樹負JPG鏍煎紡錛屽洜涓篔PG涓嶆敮鎸侀忔槑搴︺
璇︾粏姝ラゅ備笅1鍘熷浘鏍 2鍙抽敭錛岃劇疆鍥炬爣鍖哄煙鏍煎紡 3閫夋嫨鈥滃浘鐗囨垨綰圭悊濉鍏呪4鐒跺悗閫忔槑搴﹁劇疆涓100 5灝辯湅鍒伴忔槑鑳屾櫙鐨勫浘琛ㄤ簡銆
鍙鑳借劇疆閫忔槑鎴栬呬笉閫忔槑錛岃佷箞璁劇疆瀵規瘮搴﹀拰浜搴︼紝濡傛灉鐪熶笉鐢樺績錛屽氨PS涓涓嬩簡璁劇疆閫忔槑濡備笅鎻掑叆鍥劇墖浠ュ悗錛屼細鏈変竴涓鈥滃浘鐗団濆伐鍏鋒爮錛屽傛灉娌℃湁鍙浠ュ湪 瑙嗗浘宸ュ叿鏍忓浘鐗 璋冨嚭錛 宸ュ叿鏍 鐨勫掓暟絎浜屼釜鎸夐挳 灝辨槸銆
闇瑕佸埗浣滄垚PNG閫忔槑鑳屾櫙鐨勫浘鐗囨牸寮忔墠鍙浠ュ疄鐜板湪Excel琛ㄦ牸涓鑳屾櫙閫忔槑鐨勬牱寮忥紝鍙浠ヤ嬌鐢ㄧ編鍥劇縐榪涜屾搷浣滄搷浣滄柟娉1棣栧厛鍦ㄧ編鍥劇縐涓灝嗗嵃絝犲浘鐗囨墦寮錛屽苟鐐瑰嚮宸︿晶鐨勨滄姞鍥劇瑪鈥2鐒跺悗閫夋嫨鈥滆嚜鍔ㄦ姞鍥鋸濆苟鍦ㄧ孩鑹插浘絝犵殑浣嶇疆鐢諱竴銆
浣犳彃鍏ョ殑鏄浠涔堝浘鐗囷紵濡傛灉鏄鏉ヨ嚜鏂囦歡鐨勶紝閭ｅ氨寰楀湪photoshop閲屽彉鎴愰忔槑鐨勫啀鎻掑叆錛屽傛灉鎻掑叆鐨勬槸鑷閫夊浘褰錛岄偅灝卞彲浠ラ変腑鍥懼艦鐐瑰彸閿錛宷uot璁劇疆鑷閫夊浘褰㈡牸寮弎uot鏉ヤ慨鏀瑰浘褰㈢殑濉鍏呰壊涓烘棤濉鍏呭嵆鍙銆
1鎵撳紑Excel琛ㄦ牸錛岀劧鍚庣偣鍑繪彃鍏ワ紝鎺ョ潃閫夋嫨鍥劇墖錛屾壘鍒拌嚜宸辨兂瑕佸幓闄よ儗鏅鐨勫浘鐗囷紝鐩存帴鎻掑叆鍗沖彲2鐒跺悗鐐瑰嚮瀵艱埅鏍忎笂鐨勬牸寮忥紝鎺ョ潃閫夋嫨鍒犻櫎鑳屾櫙錛岃繖鏍峰氨鑳藉皢鍥劇墖鐨勮儗鏅鐩存帴鍒犻櫎鎺変簡錛岃繖鏄闈炲父濂界殑鏂規硶3鎺ョ潃灝嗚嚜宸遍渶瑕佷繚鐣欑殑銆
鐐瑰浘鐗囷紝鍑虹幇鍥劇墖宸ュ叿妗嗭紝鐐歸滆壊涓嬫媺鑿滃崟錛屼笅闈㈡湁璁劇疆閫忔槑搴︼紝鐐瑰嚮瑕侀忔槑鐨勫湴鏂瑰氨鍙浠ュ彲浠ュ氭″皾璇曘
鍦‥xcel涓鏈夋椂鎴戜滑鎻掑叆鐨勬枃鏈妗嗕細鐩栦綇浜嗕笅闈Excel涓鐨勬枃瀛楀唴瀹癸紝榪欐椂灝辨湁蹇呰佽劇疆Excel鏂囨湰妗嗛忔槑錛岄偅涔堬紝Excel鏂囨湰妗嗛忔槑搴﹀備綍璁劇疆鐨勫憿1鎵撳紑speedoffice琛ㄦ牸2榧犳爣宸﹂敭鍗曞嚮欏剁鐨勨滄彃鍏モ濓紝鎵懼埌鈥滄枃鏈妗嗏濆浘鏍囷紝鎻掑叆涓銆
鐐瑰浘鐗囷紝閫夋嫨璁劇疆鍥劇墖鏍煎紡錛嶉滆壊涓庣嚎鏉★紞棰滆壊錛嶅啀璁劇疆鍥劇墖閫忔槑搴︺
鎵撳紑Excel杞浠訛紝鍗曞嚮鈥滄彃鍏モ濆浘鐗囷紝鍦ㄥ脊鍑虹殑瀵硅瘽妗嗕腑鎵懼埌鍥劇墖騫舵彃鍏ワ紝鍥劇墖灝辨彃鍏ュソ浜嗭紝鍙樿儗鏅涓洪忔槑鑹 鍙屽嚮鎻掑叆鐨勫浘鐗囷紝鍦ㄢ滄牸寮忊濅笅闈㈤夋嫨鈥滈噸鏂扮潃鑹測濓紝鐜板湪鍦ㄢ滈噸鏂扮潃鑹測濈殑涓嬫媺鍒楄〃涓閫夋嫨鈥滆劇疆閫忔槑鑹測濓紝姝ゆ椂鐢ㄩ紶鏍囥
鍦ㄥ浘琛ㄤ笂鐐瑰彸閿錛岀偣璁劇疆鍥捐〃鏍煎紡鐐硅儗鏅鍚э紝鐐規棤濉鍏呰壊銆

❷ excel鎬庝箞鎶婂叕絝犲彉鎴愰忔槑鐨

婕旂ず鏈哄瀷錛氬崕涓篗ateBook X緋葷粺鐗堟湰錛歸in10APP鐗堟湰錛歟xcel2013

1銆佹墦寮宸ヤ綔鏍瘋〃錛屽仛濂藉噯澶囩殑宸ヤ綔銆傛彃鍏ヤ竴涓宸茬粡鍒朵綔濂界殑鐢靛瓙鍥劇珷鍥劇墖銆

2銆佸湪瀵艱埅鏍忎笂鎵懼埌鏍煎紡鏍囩撅紝濡傛灉娌℃湁錛岃峰乏閿鐐瑰嚮鍥劇珷鍥劇墖錛屽嵆鍙鎵懼埌銆

3銆佺偣鍑婚滆壊蹇鎹烽敭錛岄夋嫨璁劇疆閫忔槑鑹層

4銆侀紶鏍囧彉鎴愮瑪鐘跺悗錛岀偣鍑誨浘鐗囩櫧鑹插尯鍩燂紝鑳屾櫙鍗沖彉鎴愰忔槑鑹詫紝縐誨姩鍥劇珷鍒板悎閫傜殑浣嶇疆鍗沖彲銆

Excel甯哥敤蹇鎹烽敭錛

Ctrl N 鏂板緩絀虹櫧宸ヤ綔綈

Ctrl O鎵撳紑

Ctrl S 淇濆瓨

Ctrl P 鎵撳嵃

Ctrl C/V澶嶅埗鎴栫矘璐

Ctrl F/H鏌ユ壘鎴栨浛鎹

Ctrl A鍏ㄩ夋垨寮瑰嚭鍑芥暟鍙傛暟紿楀彛錛堣緭鍏ュ嚱鏁幫紝蹇鎹烽敭寮瑰嚭鍑芥暟紿楀彛錛

Ctrl X鍓鍒

Ctrl Z鎾ら攢涓婁竴姝ユ搷浣

Ctrl Y/F4閲嶅嶄笂涓姝ユ搷浣

Ctrl G/F5瀹氫綅錛圙o to錛

Ctrl 1璁劇疆鍗曞厓鏍兼牸寮

Ctrl 鈫撯啈鈫愨啋蹇閫熷埌杈

Ctrl Shift 鈫撯啈鈫愨啋蹇閫熼夊彇

Ctrl Shift L絳涢夋垨鍙栨秷絳涢

Ctrl Enter鎵歸噺杈撳叆鍐呭

❸ 鍦‥XCEL2007涓鑳屾櫙鎬庝箞寮勯忔槑鐨勫憿錛

1銆侀栧厛鎵撳紑鎻掑叆鑳屾櫙鍥劇墖鐨凟xcel琛ㄦ牸錛屾寜鈥淐trl+A鈥濓紝鍏ㄩ夊崟鍏冩牸銆