Phau ntawv ua haujlwm hauv Microsoft Office Excel zoo rau kev tsim cov ntxhuav, vim nws yog Ameslikas tsim nyob rau hauv daim ntawv ntawm cov kem thiab kab. Txawm li cas los xij, qhov no tsis txaus. Txhawm rau tsim cov ntawv nthuav qhia hauv Excel, koj yuav tsum muaj tsawg kawg yog qhov kev paub tsawg ntawm cov cuab yeej tsim muaj thiab cov peev txheej ntawm qhov program.
Cov Lus Qhia
Kauj ruam 1
Thaum cov kev pab cuam pib, phau ntawv dawb yog tsim thiab xov tooj ntawm tes A1 yog qhib, nws yog ib puag ncig ntawm tus ncej - xov tooj ntawm tes. Yog tias koj npaj yuav muab lub npe rau koj lub rooj, tawm ob peb ntawm cov kab saum toj kawg nkaus pub dawb, koj tuaj yeem rov qab los rau lawv tom qab koj txiav txim siab ntawm cov naj npawb ntawm kem. Yog tias qhov no tsis tsim nyog, pib nkag mus rau cov ntaub ntawv tam sim ntawd.
Kauj ruam 2
Sau cov kem thiab kab npe rau koj cov lus. Siv tus cwj mem nas lossis cov sub rau ntawm koj lub keyboard txav dhau lub hlwb. Yuav kom paub tseeb tias qhov kawg ntawm cov ntaub ntawv nkag mus thiab txav ib qho ntawm tes, siv tus sau sau. Yog tias koj xav tau tshem tawm cov xov tooj ntawm tes, xaiv nws nrog tus taw qhia thiab nias tus yuam sij Delete.
Kauj ruam 3
Txhawm rau tshem tawm ib lossis ntau cov ntawv sau tawm, nyem ob npaug rau sab laug nas khawm hauv lub xov tooj ntawm tes, muab tus cursor rau hauv qhov chaw xav tau thiab lwv cov cim nrog Backspace lossis Delete yuam.
Kauj ruam 4
Yog tias cov txiaj ntsig hauv koj cov lus qhia muaj cov npe ntawm hnub ntawm lub limtiam, hli ntawm lub xyoo, cov naj npawb ib txwm, lossis lwm cov ntaub ntawv uas nquag siv, xa mus rau cov haujlwm ua tiav. Nkag mus rau hauv thawj lub cell, piv txwv li, hnub ntawm lub limtiam "Monday", xaiv lub xovtooj ntawm nrog tus pointer.
Kauj ruam 5
Txav tus cursor mus rau sab xis kaum ntawm tus pointer thiab tuav tus nas sab laug. Tsis tas yuav tso tawm, cab tus qauv sab nraud ntawm tus pointer rau lub hlwb rau qis lossis mus rau sab xis - cov hnub seem ntawm lub lis piam yuav cia li tshwm sim hauv cov khoob.
Kauj Ruam 6
Thaum cov ntaub ntawv hauv cov hlwb sib tshooj rau ib leeg, koj yuav tau kho cov kab ntawv dav thiab kab siab. Txav tus cursor rau sab saum toj ntawm daim ntawv ua haujlwm thaj chaw thiab muab nws tso nruab nrab ntawm cov npe ntawv ntawm ob kab ntawv uas nyob ib sab. Lub cim tsa ncauj yuav hloov nws qhov tsos. Tuav hauv lub khawm laug nas thiab txav tus cursor rau sab xis kom txog thaum tag nrho cov ntawv nyeem tshwm hauv lub xov tooj ntawm tes.
Kauj Ruam 7
Tsis tas li ntawd, qhov loj me ntawm txhua kab tuaj yeem ua raws li lub xoom tshaj. Txhawm rau ua qhov no, tsuas yog nyem ob sab khawm sab laug ntawm cov npe ntawm ob kab ntawv. Lub hauv paus ntsiab lus zoo ib yam rau kev muab cov kab teeb sib txawv: tsis yog ib daim teb uas muaj cov npe tsiaj ntawv, ua haujlwm nyob rau thaj chaw uas muaj cov lej kab.
Kauj ruam 8
Txhawm rau ua kom muaj ciam teb ntawm rooj, xaiv cov kab uas yuav tsum muaj thiab kab nrog nas. Nyob rau ntawm "Tsev" tab hauv seem "Font", nyem rau ntawm "Ciam Tebchaws" khawm nyob rau hauv daim ntawv ntawm cov sketched square. Hauv cov ntawv qhia zaub mov nco, xaiv ib qho kev xaiv tsim qauv ciam teb ntawm lub hlwb thiab lub rooj nws tus kheej.
Kauj Ruam 9
Txhawm rau hloov cov ntsej muag ntawm lub xov tooj ntawm tes, xaiv nws thiab nyem rau ntawm "Cell Xov Xwm" khawm hauv seem "Cuam Tshuam". Xaiv cov qauv tsim nyog hauv cov ntawv qhia zaub mov los ntawm txhaj rau nws nrog sab laug nas khawm.
Kauj ruam 10
Nyob rau hauv rooj plaub koj yuav tsum ntxiv (rho tawm) lub xov tooj ntawm tes, kab lossis kem, siv lub pob "Insert" ("Delete") hauv qhov "Cell" ntawm lub "Tab" tab. Txhawm rau muab ob peb lub hlwb sib piv (piv txwv, kom ua tau lub npe ntawm lub rooj), xaiv cov xov tooj uas yuav tsum muaj thiab nyem rau ntawm lub pob "Sib Sau thiab Center". Lub khawm no nyob hauv Alignment ntu ntawm Lub Tsev tab thiab zoo li lub xwmfab nrog tsab ntawv "a" nyob hauv plawv.
