Txhawm rau cov ntaub ntawv xa mus rau Excel kom faib nws tus kheej rau kab thiab kem tom qab ntxig, koj yuav tsum xub teeb tsa lawv kom raug. Koj tuaj yeem ua qhov no los ntawm ntxiv cov tabs thiab cov kab tawg rau rov ua cov cim. Thiab qee zaum kev rov ua dua tshiab ntawm cov ntaub ntawv nthuav tawm xav tau - sib txuas ntawm txhua ntawm kab ntawm ib kab mus rau ib kab.
Cov Lus Qhia
Kauj ruam 1
Txog kev tawm tswv yim ua ntej ntawm cov ntawv nyeem nrog cov ntaub ntawv, koj tuaj yeem siv Microsoft Word lo lus processor paub rau peb feem ntau ntawm cov chaw ua haujlwm ntawm cov ntawv thov. Txawm li cas los xij, nws zoo dua los siv qhov yooj yim "Notepad" lossis cov ntawv sau sib xws - piv txwv li, NoteTab. Qhov tseeb yog hais tias Advanced Word sim kho cov ntawv nyeem hauv hom tsis siv neeg, nkag nws tus kheej cov cim npe rau hauv nws, hloov cov ntaub ntawv ntawm cov cim, thiab lwm yam, thiab hauv kev ua haujlwm tom ntej nws yog ntshaw kom muaj kev tswj hwm txhua qhov ntawm kev hloov kho.
Kauj ruam 2
Khaws cov kab kawg qhov twg koj xav kom cov kab ntawv luam koj muab theej rau hauv cov editor. Txhawm rau ua qhov no, siv cov haujlwm ua haujlwm autocorrect thiab rov hais dua tus cim tom kawg (lossis pib) ntawm txhua kab ntawm cov kab ntawv nyeem. Cov kab ntawv tsis tuaj yeem sau tseg thaum tso cov ntawv theej rau hauv Excel yuav txhais tau tias ib kab ntawm cov lus hlwb xaus ntawm qhov no thiab lwm qhov pib.
Kauj ruam 3
Tib txoj kev, koj tuaj yeem npaj thiab rhuav cov ntaub ntawv hauv kab rau hauv nyias lub hlwb - rau qhov no, cov cais tawm (piv txwv li, ob lossis peb qhov chaw hauv ib kab) yuav tsum tau hloov nrog tabs.
Kauj ruam 4
Thaum txhua tus kab kawg thiab cov tab nyob hauv qhov chaw, xaiv tag nrho cov ntawv sau nrog cov ntaub ntawv (Ctrl + A) thiab luam nws (Ctrl + C). Tom qab ntawd hloov mus rau lub table editor lub rooj, xaiv thawj lub xov tooj ntawm lub rooj yav tom ntej thiab muab cov ntawv ntawm cov ntawv los teev cia - nias kev sib txuas nrog Ctrl + V.
Kauj ruam 5
Ntawm cov Excel tswj muaj ib lub pob "Ua Ke los ntawm Rows", lub hom phiaj uas yog txhawm rau txhawm rau txhawm rau xaiv txhua lub hlwb hauv ib kab rau hauv ib. Yog tias koj xav muab tag nrho cov lus los ntawm kab, xaiv nws saum toj no (Ctrl + A), thiab tom qab ntawd qhib daim ntawv "drop-down" sib tshuam thiab muab tso rau hauv qhov chaw "los ntawm cov pab pawg ntawm cov lus txib" Dlhos "ntawm" Lub Tsev "tab Cov. Hauv cov npe no, xaiv kab "Ua Ke los ntawm Kab", tab sis nco ntsoov tias txoj haujlwm no yuav lwv tag nrho cov ntaub ntawv xov tooj ntawm tes tshwj tsis yog rau thawj tus hauv txhua kab.
Kauj Ruam 6
Txhawm rau kom tsis txhob poob cov ntaub ntawv hauv kev ua haujlwm ntawm theem ua ntej, hloov nws nrog lwm tus txheej txheem. Txhawm rau txoj kab ntawm thawj kab, ntxiv ib qho ntxiv ntawm tes nrog "Concatenate" ua haujlwm tso rau hauv nws, hauv uas sau txhua lub hlwb nrog cov ntaub ntawv ntawm kab no - piv txwv, = CONCATENATE (A1; B1; C1). Tom qab ntawv theej lub cell thiab sau rau tag nrho kem nrog cov qauv no rau qhov siab ntawm lub rooj. Koj yuav xaus rau ntawm kem uas muaj raws nraim qhov koj npaj siab - rooj sib tham. Tom qab ntawv xaiv tag nrho kab ntawv no, luam (Ctrl + C) sab xis-xaiv xaiv thiab hauv seem "Paste Tshwj Xeeb" ntawm cov ntawv qhia zaub mov xaiv "Paste Qhov tseem ceeb". Tom qab ntawd, txhua lwm kab ntawm lub rooj tuaj yeem muab tshem tawm, lawv tsis siv nyob rau hauv cov qauv lawm.
