Txais tos rau txhua qhov ntawm blog.
Cov ntawv xov xwm niaj hnub no tau mob siab rau saum rooj, nrog uas feem ntau yuav tsum tau ua haujlwm thaum ua haujlwm ntawm lub koos pis tawj (Kuv thov zam lub tautology).
Coob tus neeg siv cov novice feem ntau nug tib lo lus nug: "... tab sis yuav ua li cas los tsim lub rooj hauv Excel nrog qhov ntev txog li ib centimeter. Txhua yam hauv Lo Lus yooj yim dua," coj "tus pas ntsuas, pom tus ncej ntawm daim ntawv thiab kos nws ...".
Qhov tseeb, txhua yam yog qhov yooj yim dua hauv Excel, thiab koj tuaj yeem kos lub rooj sib txig sib luag, tab sis kuv yuav tsis tham txog dab tsi cov lus qhia hauv Excel (nws yuav nthuav dav rau cov neeg pib) ...
Thiab yog li, hauv kev qhia ntau txog txhua kauj ruam ...
Kev tsim rooj
Kauj ruam 1: pab kom cov nplooj ntawv ciam teb + chaw hom
Peb xav tias koj nyuam qhuav qhib Excel 2013 (txhua qhov kev ua yuav luag zoo ib yam hauv cov qauv xyoo 2010 thiab 2007).
Thawj yam uas hem ntau yam yog qhov tsis muaj kev pom ntawm nplooj ntawv ciam: i.e. nws tsis pom qhov twg nplooj ciam teb ze ntawm nplooj ntawv (Lo lus tam sim ntawd nthuav tawm cov ntawv qhia toj roob hauv pes).
Txhawm rau pom cov ciam teb ntawm ib daim ntawv, nws yog qhov zoo tshaj plaws xa cov ntawv luam tawm rau kev luam ntawv (rau saib), tab sis tsis txhob luam nws. Thaum koj tawm ntawm hom luam tawm, koj yuav pom kab nyias nyias nyob hauv kab ntawv - qhov no yog ciam teb ntawm daim ntawv.
Sau hom hauv Excel: txhawm rau pab, mus rau "ntawv / luam ntawv" ntawv qhia zaub mov. Tom qab nws tawm, daim ntawv yuav muaj ciam teb ntawm daim ntawv.
Txog qhov muaj tseeb tshaj txheej txheem, mus rau "Saib" cov ntawv qhia zaub mov thiab tig rau hom "Page Layout" hom. Tus “pas ntsuas” yuav tsum tshwm nyob ntawm koj xub ntiag (saib cov xub grey hauv lub screenshot hauv qab no) + daim album yuav tshwm nrog ciam teb raws li Lo Lus.
Cov nplooj ntawv nplooj hauv Excel 2013.
Kauj ruam 2: xaiv cov ntawv xaiv (A4, A3 ...), txheej (toj roob hauv pes, duab kos).
Ua ntej koj pib tsim lub rooj, koj yuav tsum xaiv cov ntawv hom thiab nws qhov chaw nyob. Qhov no yuav ua piv txwv zoo tshaj plaws 2 daim duab hauv qab no.
Kev taw qhia cov ntawv: mus rau ntawm "nplooj ntawv txheej" ntawv qhia zaub mov, xaiv cov khoom "kev xaiv".
Nplooj ntawv loj: los hloov cov nplooj ntawv los ntawm A4 rau A3 (lossis lwm tus), mus rau "ntawv txheej txheem" ntawv qhia zaub mov, tom qab ntawd xaiv cov khoom "loj" thiab xaiv cov hom ntawv xav tau hauv cov ntawv qhia tom qab.
Kauj Ruam 3: tsim lub rooj (teeb duab)
Tom qab txhua yam npaj, koj tuaj yeem pib kos cov rooj. Qhov no tau yooj yim dua los siv "ntawm ciam teb" muaj haujlwm. Hauv qab no yog qhov screenshot nrog piav qhia.
Txhawm rau kos lub rooj: 1) mus rau ntu "lub ntsiab"; 2) qhib cov ntawv qhia ua "ciam teb"; 3) xaiv qhov xaiv "kos ciam teb" hauv cov ntawv qhia zaub mov.
Kem Loj
Qhov ntev ntawm cov kab yog yooj yim kho raws li tus pas ntsuas, uas yuav qhia qhov loj me me hauv centimeters (saib).
Yog tias koj rub tawm qhov swb, hloov qhov dav ntawm kab ntawv, tom qab ntawd tus pas ntsuas yuav qhia nws qhov dav hauv cm.
Kab loj
Cov kab ntau leej tuaj yeem muab kho kom zoo ib yam nkaus. Pom daim duab hauv qab no.
Txhawm rau hloov qhov siab ntawm kab: 1) xaiv cov kab uas xav tau; 2) nyem rau ntawm lawv nrog cov khawm xis; 3) Hauv cov ntawv qhia zaub mov, xaiv "kab qhov siab"; 4) Teeb qhov siab uas xav tau.
Tus ntawd yog txhua yam. Los ntawm txoj kev, qhov kev xaiv yooj yim dua rau kev tsim lub rooj tau txheeb rau hauv ib daim ntawv me me: //pcpro100.info/kak-sozdat-tablitsu-v-excel/.
Hmoov zoo rau txhua tus!