Thaum koj pib daim ntawv nthuav qhia tus thawj tswj hwm Micrsoft Office Excel, ib daim ntawv cia li tau tsim nrog cov ntawv npaj tiav-los ntawm qhov ua daim ntawv tshiab ntawm lub rooj tshiab. Ntawd yog, tsis muaj kev tshwj xeeb yuav tsum tsim lub rooj khoob. Ntxiv rau qhov kev ua haujlwm no rau kev tsim cov ntxhuav hauv Excel, muaj cov haujlwm rau xaiv qee qhov ntawm lub hlwb ntawm ib lub rooj uas twb muaj lawm mus rau hauv lub rooj ywj pheej.
Cov Lus Qhia
Kauj ruam 1
Xaiv cov kab ke ntawm cov hlwb ntawm daim ntawv uas koj xav tuaj nthuav tawm ua qhov rooj cais. Tom qab ntawv, mus rau "Ntxig" tab nyob rau hauv daim ntawv teev cov khoos phis tawm thiab hauv "Ntxhuav" pawg lus txib nyem khawm "Cov lus". Txoj haujlwm no tau raug rau nias rau tus lej luv + CTRL + T lossis CTRL + L.
Kauj ruam 2
Kos rau kem “Table nrog headers” hauv kem qhib uas yog thawj kab ntawm cov kab koj xaiv tau muaj kab ntawv npe rau kab koj tab tom tsim. Txwv tsis pub, lub hauv paus ntawv pib yuav raug siv - Kem 1, Kem 2, thiab lwm yam. Tom qab ntawd nias lub khawm "OK" thiab lub rooj yuav tsim nrog qhov ua kom tsis zoo thiab kev xav.
Kauj ruam 3
Ua qhov hloov pauv uas tsim nyog rau lub rooj tsim tau siv cov kev tswj hwm uas tso rau ntawm kab ntxiv "Tsim" ntxiv rau cov tab uas twb muaj lawm ntawm daim ntawv qhia ua zaub mov. Ntawm no koj tuaj yeem xaiv cov xim sib txawv xim sib txawv, ntxiv cov kab sib npaug, tag nrho cov ntsiab lus sab nraud, thiab lwm yam
Kauj ruam 4
Siv cov cais qhov muaj peev xwm cais ntawm cov rooj sau siab no sib cais ntawm lub rooj dav dav - qhov no yog lub hom phiaj tseem ceeb ntawm kev ua haujlwm. Yog tias koj xav tau nthuav tawm cov lus, txav tus cursor dhau dot daim ntawv lo rau hauv qab ces kaum hauv qab ntawm lub rooj thiab, los ntawm nias lub khawm sab laug, rub nws mus rau ciam teb tshiab.
Kauj ruam 5
Muaj lwm txoj hauv kev los tsim cov ntxhuav no. Txhawm rau siv nws, tom qab xaiv cov kab xav ntawm cov hlwb, nyem "Format as Table" khawm hauv "Styles" pab pawg cov lus txib ntawm "Tsev" tab ntawm Excel cov zaub mov. Hauv daim ntawv xaiv tsa hauv kev xaiv tsim, xaiv ib qho uas haum rau koj zoo tshaj plaws, lossis nyem khawm "Tsim Rooj ແບບ" thiab tsim koj tus kheej. Tom qab ntawd, lub npov xov xwm piav qhia hauv kauj ruam thib ob yuav qhib, thiab tom qab ntawd cov txheej txheem tsim thiab kho lub rooj yuav tsis txawv ntawm qhov tau piav qhia hauv cov kauj ruam dhau los.
