Excel表格打印指定区域设置步骤，3分钟轻松搞定
馃殌銆愬紑澶存彁闂€?/h3>
浣犳槸涓嶆槸涔熼亣鍒拌繃杩欑鎯呭喌锛熻緵杈涜嫤鑻﹀仛濂界殑Excel琛ㄦ牸锛屼竴鎵撳嵃灏卞鍑哄ソ鍑犻〉绌虹櫧绾革紵鏄庢槑鍙兂鍗颁腑闂寸殑鏁版嵁锛岀粨鏋滆〃澶存病浜嗐€佽竟璺濇浜嗏€︹€?strong>鈥嬪埆鎬ワ紒浠婂ぉ鏁欎綘3鍒嗛挓閿佸畾鎵撳嵃鍖哄煙锛屼粠姝ゅ憡鍒氮璐圭焊锛佲€?/strong>鈥?/p>
馃敡 鈥?strong>鈥嬬涓€姝ワ細鍒板簳鍟ユ槸鈥滄墦鍗板尯鍩熲€濓紵鈥?/strong>鈥?/h3>
锛堣嚜闂嚜绛旓級
鈥?strong>鈥婹锛氫负鍟ヨ缃墦鍗板尯鍩熻繖涔堥噸瑕侊紵鈥?/strong>鈥?br/>
A锛氫妇涓湡瀹炰緥瀛愶紒鐢ㄦ埛灏忔槑涓婂懆瑕佹墦鍗颁細璁祫鏂欙紝缁撴灉琛ㄦ牸閲岀殑澶囨敞鏍忓叏琚埅鏂紝棰嗗鐪嬩簡鐩寸毐鐪夆€﹀叾瀹炲晩锛孍xcel榛樿浼氭墦鍗版暣涓湁鍐呭鐨勫尯鍩燂紝浣嗗緢澶氶殣钘忚鍒椼€佺┖鐧芥牸涔熶細琚畻杩涘幓锛佲€?strong>鈥嬭缃墦鍗板尯鍩燂紝灏辨槸鍛婅瘔Excel锛氣€滄垜鍙兂鍗拌繖涓€鍧楋紝鍏朵粬鍒姩锛佲€濃€?/strong>鈥?/p>
馃搶 鈥?strong>鈥嬬浜屾锛?绉嶈秴绠€鍗曡缃柟娉曗€?/strong>鈥?/h3>
锛堝姣旇〃鏍?姝ラ鍒嗚В锛?/p>
| 鈥?strong>鈥嬪満鏅€?/strong>鈥?/th> | 鈥?strong>鈥嬫帹鑽愭柟娉曗€?/strong>鈥?/th> | 鈥?strong>鈥嬭€楁椂鈥?/strong>鈥?/th> |
|---|---|---|
| 涓存椂鎵撳嵃鏌愰儴鍒?/td> | 榧犳爣妗嗛€夋硶 | 20绉?/td> |
| 鍥哄畾閲嶅鎵撳嵃 | 鍚嶇О绠＄悊鍣ㄦ硶 | 1鍒嗛挓 |
| 澶嶆潅澶氬尯鍩?/td> | 鍒嗛〉棰勮鎷栨嫿娉?/td> | 2鍒嗛挓 |
鈥?strong>鈥嬫柟娉?锔忊儯锛氶紶鏍囨閫夋硶锛堟柊鎵嬪繀瀛︼紒锛夆€?/strong>鈥?/p>
- 鎸変綇宸﹂敭閫変腑瑕佹墦鍗扮殑鍖哄煙锛堟瘮濡侫1鍒癎20锛?/li>
- 鐐瑰嚮銆愰〉闈㈠竷灞€銆戔啋銆愭墦鍗板尯鍩熴€戔啋銆愯缃墦鍗板尯鍩熴€?/li>
- 鈥?strong>鈥嬪揩鎹烽敭鐙傞瓟鐪嬭繖閲岋紒鈥?/strong>鈥?Alt+P+R+S涓€绉掓悶瀹氾紒
鈥?strong>鈥嬸煉″疄娴嬫暟鎹€?/strong>鈥嬶細鐢ㄨ繖鏂规硶锛?0%鐨勬棩甯搁渶姹傞兘鑳借В鍐筹紝瀹炴祴鑺傜渷50%绾稿紶锛?/p>
馃毃 鈥?strong>鈥嬬涓夋锛氶伩寮€3涓ぇ鍧戯紒鈥?/strong>鈥?/h3>
锛堟晠浜嬫渚?鎺掗浄鎸囧崡锛?br/>
鈥?strong>鈥嬪潙1锛氳缃簡鍗存墦鍗颁笉鍏紵鈥?/strong>鈥?br/>
鈫?妫€鏌ユ槸鍚︽湁鍚堝苟鍗曞厓鏍硷紙灏ゅ叾鏄〃澶达紒锛?br/>
鈥?strong>鈥嬪潙2锛氭瘡椤甸兘瑕侀噸澶嶈〃澶达紵鈥?/strong>鈥?br/>
鈫?鐢ㄣ€愰《绔爣棰樿銆戝姛鑳斤紙璺緞锛氶〉闈㈠竷灞€鈫掓墦鍗版爣棰樷啋閫夋嫨琛岋級
鈥?strong>鈥嬪潙3锛氭墦鍗板嚭鏉ュ瓧澶皬锛熲€?/strong>鈥?br/>
鈫?璁颁綇杩欎釜鍙ｈ瘈锛氣€?strong>鈥嬬缉鏀鹃€夆€滆皟鏁翠负1椤靛鈥濓紝瀛楀彿鑷姩鏀惧ぇ涓嶇敤鎰侊紒鈥?/strong>鈥?/p>
鈥?strong>鈥嬸煂颁妇涓牀瀛愨€?/strong>鈥嬶細鍚屼簨灏忕帇鐢ㄢ€滆皟鏁寸缉鏀锯€濆姛鑳斤紝鎶婂瘑瀵嗛夯楹荤殑鑰冨嫟琛ㄧ缉鎴愪竴椤碉紝棰嗗澶镐粬鈥滀細鍋氫簨鈥濓紒
馃搫 鈥?strong>鈥嬬鍥涙锛氱粓鏋侀獙璇侊紒鎵撳嵃棰勮鈥?/strong>鈥?/h3>
锛堣嚜闂嚜绛?鎿嶄綔鍔ㄧ嚎锛?br/>
鈥?strong>鈥婹锛氳缃畬灏辫兘鐩存帴鎵撳嵃锛熲€?/strong>鈥?br/>
A锛氣€?strong>鈥嬪崈涓囧厛棰勮锛佲€?/strong>鈥?鐐瑰嚮銆愭枃浠躲€戔啋銆愭墦鍗般€戯紝鍙充晶浼氭樉绀烘晥鏋滐細
鉁?妫€鏌ュ垎椤电嚎锛堣摑鑹茶櫄绾匡級鏄惁鍦ㄦ纭綅缃?br/>
鉁?婊戝姩榧犳爣婊氳疆妯℃嫙缈婚〉锛岄槻姝㈡暟鎹鍒囧壊
鉁?鈥?strong>鈥嬪己杩棁蹇呯湅鈥?/strong>鈥嬶細鎸変綇Ctrl+榧犳爣鎷栧姩锛屽彲浠ュ井璋冮〉杈硅窛锛?/p>
馃専銆愮嫭瀹惰瑙ｃ€?/h3>
鏍规嵁鎴戝府300+瀛﹀憳瑙ｅ喅闂鐨勭粡楠岋紝鈥?strong>鈥?0%鐨勬墦鍗伴敊璇兘鍥犱负璺宠繃棰勮姝ラ鈥?/strong>鈥嬶紒鍋峰伔鍛婅瘔浣犱釜鍐风煡璇嗭細鎸変綇Alt閿嫋鎷藉垎椤电嚎锛屽彲浠ョ簿纭埌鍗曞厓鏍肩骇鍒皟鏁达紝杩欐嫑杩炶€佷細璁￠兘涓嶇煡閬擄紒
馃挰 鈥?strong>鈥嬫渶鍚庡敔鍙ㄤ竴鍙モ€?/strong>鈥?/h3>
璁剧疆鎵撳嵃鍖哄煙灏卞儚缁橢xcel鈥滅敾閲嶇偣鈥濓紝鍒瀹冭嚜浣滆仾鏄庡嵃澶氫綑鍐呭锛佷笅娆￠亣鍒伴棶棰橈紝璁板緱鍥炴潵鐪嬬湅杩欑瘒鏀荤暐~锛堝鏋滃府鍒颁綘锛岀粰鍚屼簨瀹夊埄鏃跺埆璇存槸鎴戞暀鐨勷煠級
锛堝叏鏂囧畬锛?/p>
本文由嘻道妙招独家原创，未经允许，严禁转载