Qhov wikiHow qhia koj li cas ntxiv ntu "ceg" rau hauv qab ntawm daim ntawv ua haujlwm kom luam tawm hauv Microsoft Excel. Cov ntu no tuaj yeem suav nrog ntau cov ntaub ntawv, suav nrog hnub tim, nplooj ntawv nplooj ntawv, lub npe ntaub ntawv, thiab txawm tias muaj duab me me.
Kauj ruam
Kauj Ruam 1. Qhib daim ntawv ua haujlwm hauv Excel
Koj tuaj yeem nyem ob npaug rau lub npe ntawm koj lub computer kom qhib nws.
Kauj Ruam 2. Nyem rau daim ntawv uas koj xav ntxiv ntu ntu
Koj tuaj yeem pom daim ntawv ua haujlwm los ntawm txhaj rau daim ntawv tab nyob hauv qab ntawm lub qhov rai Excel.
- Yog tias koj xav ntxiv ntu ntu rau txhua nplooj ntawv hauv phau ntawv ua haujlwm, txoj cai-nyem rau ib daim ntawv ua haujlwm tab, tom qab ntawv xaiv " Xaiv Txhua Daim Ntawv "Los ntawm cov ntawv qhia zaub mov.
- Txhawm rau xaiv ntau dua ib daim ntawv ua haujlwm (tab sis tsis yog txhua yam), tuav Ctrl (PC) lossis Command (Mac) thaum nyem rau txhua daim ntawv tab uas koj xav tau.
Kauj Ruam 3. Nyem rau Page Layout tab
Cov ntawv no yog nyob rau sab saum toj ntawm Excel qhov rai, ntawm sab laug.
Kauj Ruam 4. Qhib Nplooj Ntawv Teeb tsa lub npov
Yog tias koj siv lub khoos phis tawj Mac, nyem lub cim uas sau tias " Teeb Nplooj "Hauv lub cim icon nyob rau sab saum toj ntawm lub vijtsam. Yog tias koj siv lub khoos phis tawj Windows, nyem lub xwmfab me nrog cov xub nyob hauv qab ntawm "Nplooj Ntawv Teeb" pane.
Kauj Ruam 5. Nyem rau Header/Footer tab
Nws yog ib lub tab nyob saum lub qhov rai.
Kauj Ruam 6. Xaiv cov ntu ntu ko taw los ntawm cov ntawv qhia zaub mov "Footer"
Cov kev xaiv hauv cov ntawv qhia no yog cov kev xaiv ua ntej uas feem ntau ua tau raws li qhov xav tau ntawm cov neeg siv feem ntau. Yog tias cov kev xaiv tsis haum koj cov kev xav tau (lossis koj xav ntxiv cov ntaub ntawv kev cai), txav mus rau theem tom ntej.
Kauj Ruam 7. Nyem Cov Cai Ncaj Ncees los tsim koj tus kheej ntu ntu
Yog tias koj xaiv tus qauv tsim los ntawm Excel cov kev xaiv ua hauv, koj tuaj yeem hla cov kauj ruam no. Qhov kev xaiv no qhia txog peb lub thawv khoob (sab laug, nruab nrab, hauv qab) uas hais txog thaj chaw nyob hauv qab ntawm txhua nplooj ntawv. Ua raws cov theem no txhawm rau ntxiv cov ntaub ntawv koj xav tau:
- Ntaus cov ntawv koj xav pom hauv ib lub thawv (lossis txhua lub thawv). Koj tuaj yeem nyem lub pob " A"Txhawm rau kho qhov font loj, tsos, thiab style.
- Txhawm rau ntxiv cov lej nplooj ntawv, nyem rau lub npov xav tau, tom qab ntawd nyem lub pob thib ob (ib daim ntawv nrog " #"). Txhawm rau tso saib tag nrho cov nplooj ntawv, nyem lub pob thib peb (ntau daim ntawv nyuaj nrog" #").
- Txhawm rau ntxiv hnub thiab/lossis sijhawm, nyem rau thaj tsam xav tau, tom qab ntawd nyem daim ntawv qhia hnub (rau hnub tim) thiab/lossis lub moos (rau lub sijhawm) cov cim.
- Txhawm rau ntxiv lub npe cov ntaub ntawv, nyem lub pob khawm daj (tag nrho qhov chaw nyob ntawm cov ntawv), lub pob ntawv nthuav tawm nrog ntsuab thiab dawb "X" (npe lub npe nkaus xwb), lossis lub pob ntawv nthuav tawm nrog ob lub tab hauv qab nws (daim ntawv npe nkaus xwb).
- Txhawm rau ntxiv cov duab, nyem lub pob duab (khawm thib ob los ntawm qhov kawg) thiab ua raws cov lus qhia ntawm lub vijtsam kom pom thiab xaiv cov duab. Nyem cov xim tuaj yeem ua lub cim ntawm qhov kawg ntawm kab kom kho cov duab.
- Nyem " OK "Thaum ua tiav rov qab mus rau" Page Setup "window.
Kauj Ruam 8. Nyem Luam Ntawv Ua Ntej kom pom tias ntu ntu zoo li cas
Cov ntu tshiab yuav tshwm raws li nws tshwm ntawm daim luam ntawm daim ntawv ua haujlwm.
Kauj Ruam 9. Nyem rau khawm rov qab txhawm rau nkag mus rau nplooj ntawv "Teeb Nplooj"
Yog tias ceg ntu tsis zoo li qhov koj xav tau, koj tuaj yeem xaiv lwm qhov tsim lossis nyem " Kev cai footer… "Los kho koj tus qauv.
Koj tuaj yeem hloov kho ntu ntu thaum twg xav tau los ntawm txhaj " Headers & Footers "hauv tabs" Ntxig "Nyob rau sab saud ntawm Excel qhov rai.
Kauj ruam 10. Kho cov nplooj ntawv chaw teeb tsa (yeem)
Yog tias koj xav tau, koj tuaj yeem tso saib ntu sib txawv ntawm cov nplooj ntawv txawm thiab khib, thiab/lossis lwm ntu ntawm thawj nplooj ntawv. Ua raws cov theem no:
- Txheeb xyuas qhov "Txawv txawv thiab txawm tias nplooj ntawv" xaiv los tsim ntu ntu thib ob rau nplooj ntawv tom ntej (tus qauv yuav rov ua dua). Koj tseem tuaj yeem xaiv "Sib txawv thawj nplooj ntawv" los tsim cov ntu sib txawv tshwj xeeb rau thawj nplooj ntawv ntawm daim ntawv.
- Nyem lub pob " Kev Cai Ncauj Lus " Koj yuav pom tabs rau txhua ntu xaiv ntu (" qhov sib txawv ”, “ Txawm, thiab/lossis " Thawj nplooj ntawv ”).
- Nyem rau tab uas koj xav kho, tom qab ntawd tsim ceg ntu siv cov lus qhia hauv qib 6. Rov ua cov txheej txheem no rau txhua nplooj ntawv tshwj xeeb.
- Nyem " OK "Rov qab mus rau" Page Setup "window.
Kauj ruam 11. Nyem OK
Cov ntu ntu tau ntxiv thiab yuav tshwm nyob rau hauv qab ntawm txhua daim ntawv luam tawm.
