Yuav Ua Li Cas Luam Tawm Cov Ntawv Nthuav Dav Hauv Excel Ntawm Ib Daim Ntawv

Yuav Ua Li Cas Luam Tawm Cov Ntawv Nthuav Dav Hauv Excel Ntawm Ib Daim Ntawv
Yuav Ua Li Cas Luam Tawm Cov Ntawv Nthuav Dav Hauv Excel Ntawm Ib Daim Ntawv

Video: Yuav Ua Li Cas Luam Tawm Cov Ntawv Nthuav Dav Hauv Excel Ntawm Ib Daim Ntawv

Video: Yuav Ua Li Cas Luam Tawm Cov Ntawv Nthuav Dav Hauv Excel Ntawm Ib Daim Ntawv
Video: Yuav ua li cas thiaj thov tau daim ntawv tso cai los qhib business nyob rau lub nroog Minneapolis 2024, Hlis ntuj nqeg
Anonim

Ib lub rooj tsim hauv Excel feem ntau ntau dua qhov loj ntawm A4 ntawv ntawv. Txawm li cas los xij, koj tuaj yeem tsim kho cov chaw hauv cov program no kom luam lub rooj loj ntawm ib daim ntawv.

Yuav ua li cas luam tawm cov ntawv nthuav dav hauv Excel ntawm ib daim ntawv
Yuav ua li cas luam tawm cov ntawv nthuav dav hauv Excel ntawm ib daim ntawv

Txhawm rau ua kom lub rooj haum rau ntawm ib daim ntawv, koj tuaj yeem txo qhov font hauv cov hlwb thiab txo qhov dav ntawm kab ntawv. Tab sis qhov no yog qhov cuam tshuam heev thiab tsis yog tag nrho, vim hais tias thaum cov ntaub ntawv pauv, koj yuav tau rov ua qhov txheej txheem no tag nrho. Qhov kev xaiv me dua yog los teeb tsa qhov tsim nyog luam tawm lossis hloov me ntsis ntawm cov ntawv teeb tsa.

Nws yuav tsum nco ntsoov tias hauv Excel, koj tuaj yeem txo qhov nplai tsuas yog qee qhov kev txwv - qhov no yog 10% ntawm qhov loj me. Ntawd yog, yog tias koj lub rooj muaj, piv txwv li 5000 lossis 10000 kab, tom qab ntawd nws yuav lub cev tsis tuaj yeem luam tawm ntawm ib daim ntawv.

1 txoj kev

Hauv Microsoft Excel 2010 thiab tom qab ntawd, luam tawm tau teeb raws li hauv qab no:

1. Koj yuav tsum pib luam tawm qhov rais. Txhawm rau ua li no, nias "Ctrl" + "P" sib xyaw tseem ceeb lossis xaiv "Cov Ntawv" -> "Luam" hauv cov ntawv qhia zaub mov tseem ceeb ntawm txoj haujlwm.

Duab
Duab

2. Hauv seem "Chaw" muaj lub teb uas muaj kev xaiv xaiv los ua kev cais. Hauv nws koj yuav tsum xaiv "Cov ntawv ntim ntawm ib nplooj ntawv".

Duab
Duab

Qhov kev teeb tsa no tso cai rau koj luam tawm Excel daim ntawv ntawm ib daim ntawv. Hauv qhov saib ua ntej lub qhov rais, koj tuaj yeem pom tias qhov kev zov me nyuam tau txais ncaj qha mus tawm lub rooj li cas.

3. Nyem rau "Luam" khawm los xa daim ntawv xa mus rau lub tshuab luam ntawv.

Duab
Duab

2 txoj kev

Yog tias qhov loj me ntawm lub rooj me me tsuas yog me dua li qhov loj ntawm cov ntawv, tom qab ntawd koj tuaj yeem sim hloov qhov loj ntawm cov npoo.

Hauv lub qhov rais luam tawm, koj tuaj yeem xaiv ib qho ntawm cov qauv txheej txheem (cov npoo tsis tu ncua, cov npoo dav, nqaim npoo me me), lossis koj tuaj yeem nkag mus rau koj tus kheej qhov tseem ceeb.

Duab
Duab

Xaiv Cov Nchuav Teb kom nkag mus rau koj cov nqi. Lub qhov rai yuav qhib rau qhov uas koj tuaj yeem txo qhov luaj li cas ntawm 4 daim teb kom tsawg kawg nkaus.

Duab
Duab

Tom qab qhia meej cov nqis, nyem rau "OK".

3 txoj kev

Ntawm toolbar, xaiv "Saib" -> "Page Nplooj Ntawv".

Duab
Duab

Koj yuav pom cov kab xiav ntsug uas yog nplooj txuas. Ntawm no yog ib qho piv txwv:

Duab
Duab

Txhawm rau luam ob nplooj ntawv ua ke, koj yuav tsum rub tus kab xiav sau rau sab xis, ntua kom kawg.

Duab
Duab

Raws li qhov tshwm sim, cov ntawv sau "Nplooj 1" yuav nyob, thiab cov ntawv sau "Nplooj 2" yuav ploj mus. Qhov no txhais tau tias tag nrho cov lus yuav muab tso rau ntawm ib daim ntawv.

Pom zoo: