Yuav Paub
- Mus rau View tab, xaiv Page Break Preview, ces luag dotted xiav kab los kho qhov chaw koj xav luam tawm.
- Yog tias koj tsuas xav luam ib feem ntawm daim ntawv ua haujlwm, taw qhia thaj chaw koj xav luam tawm, tom qab ntawd mus rau File tab thiab xaiv Print.
- Txhawm rau teeb tsa thaj chaw luam tawm rau daim ntawv mus tas li, mus rau Page Layout tab, taw qhia thaj chaw koj xav luam tawm, tom qab ntawd xaiv Print Area.
Kab lus no piav qhia yuav ua li cas tshem nplooj ntawv hauv Excel. Cov lus qhia siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, Excel 2013, thiab Excel 2010.
Yuav ua li cas rho cov nplooj ntawv tsis xav tau hauv Excel
Page so yog cov ciam teb hauv daim ntawv ua haujlwm uas txiav txim siab seb cov ntsiab lus twg mus rau ntawm koj nplooj ntawv luam tawm. Excel xaiv cov no rau koj tau txais, siv koj cov ntawv me me thiab cov npoo npoo. Koj tuaj yeem kho cov nplooj ntawv tsis siv neeg tawg los ntawm kev ntsuas koj cov ntawv luam me me (tsawg dua 100 feem pua) lossis loj dua (ntau dua 100 feem pua) dua li koj daim ntawv ua haujlwm.
Ntxig, rho tawm lossis txav nplooj ntawv so hauv Excel kom paub tseeb tias cov nplooj ntawv luam tawm raws li qhov xav tau.
-
Qhib daim ntawv ua haujlwm uas koj xav rho tawm nplooj ntawv thiab xaiv qhov View tab.
Image -
Xaiv Page Break Preview nyob rau hauv pawg Workbook Views.
Koj tuaj yeem hloov kho nplooj ntawv tawg hauv Ntawm saib hauv Excel, tab sis nws yooj yim dua los siv Page Break Preview ua haujlwm ntawm nplooj ntawv tawg layout. Hom kev saib ua ntej qhia tau hais tias koj hloov pauv li cas rau kab lossis kab cuam tshuam rau nplooj ntawv tsis siv neeg tawg.
Image -
Nrog Nplooj Ntawv Tso Saib Ua Ntej tau qhib, koj tuaj yeem pom kab dotted sawv cev rau nplooj ntawv tsis siv neeg tawg, nrog rau txhua nplooj ntawv tus lej.
Koj tuaj yeem xaiv ib qho ntawm cov kab xiav (ob qho tib si dotted thiab khoom) los kho qhov chaw luam tawm.
Image -
Xaiv thiab luag cov kab xiav dotted (ib qho kev luam tawm tsis siv neeg) los kho qhov chaw koj xav luam tawm. Cov kab hloov pauv, hloov mus rau nplooj ntawv phau ntawv so.
Image -
Thaum koj ua tiav kho cov nplooj ntawv so, xaiv Nomhauv pawg Workbook Views.
Image
Yuav ua li cas los teeb koj thaj chaw luam hauv Excel
Tsim cov nplooj ntawv tawg yog ib txoj hauv kev zoo los tswj cov ntaub ntawv loj dua, tab sis ua li cas yog tias koj xav luam ib daim duab ntawm cov ntsiab lus thiab tsis yog tag nrho cov ntawv ua haujlwm? Koj tuaj yeem siv lub tshuab luam ntawv xaiv los luam ib cheeb tsam uas tau xaiv los ntawm kev ua raws cov kauj ruam no.
Kev luam ntawv ib zaug:
-
Xaiv thiab rub kom pom qhov chaw ntawm daim ntawv ua haujlwm uas koj xav luam tawm.
Image -
Xaiv lub File tab.
Image -
Choose Print.
Image -
Xaiv Print Selection hauv cov npe hauv qab Settings.
Image
Hloov chaw luam ntawv Permanently
Yog tias koj yuav luam thaj chaw xaiv ntau dua ib zaug thiab xav teeb tsa thaj chaw luam tawm rau daim ntawv mus tas li, koj tuaj yeem ua li no.
-
mus rau Page Layout tab.
Image -
Highlight thaj chaw uas koj xav luam tawm, tom qab ntawd xaiv Print Area nyob rau hauv pab pawg Nplooj Ntawv.
Image -
Xaiv Teem Thaj Chaw Sau Npe.
Image -
Koj yuav pom cov qauv me me uas qhia txog thaj chaw luam tawm tshiab. Yog tias koj xav tau hloov qhov chaw luam tawm, xaiv Thaj Chaw Sau> Thaj Chaw Luam Tawm.
Image
