Microsoft Office Excel cov ntaub ntawv tshaj tawm yog tsim los ua haujlwm nrog cov cov ntaub ntawv me me uas tsis tas yuav tsum tsuas muaj cov txiaj ntsig suav nrog. Cov lus, kab lus thiab txawm hais tias qhov tawg tsam muaj peev xwm muab tso rau hauv cov hlwb ntawm pob ntawv. Los ua cov ntaub ntawv ntawm hom no, ntxiv rau cov zauv ntawm cov hlwb, cov qauv kuj tau siv. Hauv kev tshwj xeeb, cov ntawv tshaj tawm kev hloov kho muaj cov haujlwm rau kev sib txuas (sau tawm) ob peb lub xov tooj ntawv.
Tsim nyog
Microsoft Office Excel cov ntawv teev lus tshaj tawm
Cov Lus Qhia
Kauj ruam 1
Pib Excel thiab thauj khoom ntawm qhov xav yam rau nws. Xaiv lub xov tooj ntawm qhov koj xav tso cov ntawv sib xyaw.
Kauj ruam 2
Mus rau "Ntxig" tab nyob rau hauv qhov kev pab cuam ntawv xaiv thiab qhib daim ntawv teev nco-npe sau "Ntawv" - nws muab tso rau hauv "Cov Tsev Haujlwm Qiv Qiv" cov lus txib pab pawg. Cov ntawv teev npe muaj ntau dua ob lub kaum rau kev ua haujlwm rau kev ua haujlwm nrog cov ntawv hloov pauv, txheeb raws cov niam ntawv-ntuav-nqes mus rau cov kab pib nrog tus tsiaj ntawv "C" thiab xaiv "CONCATENATE" muaj nuj nqi. Qhov no yuav tso qhov Kev Raug Qhov Tseeb Kev Tsim Tsa lub thawv tshiab, uas koj yuav tau sau rau ntau daim foos.
Kauj ruam 3
Qhia meej qhov chaw nyob ntawm tus xov tooj ntawm kab ntawv uas muaj cov kab ntawv uas yuav tsum tau pib ntawm kab xov tooj ntawm tes. Nws yuav tsum tau nkag mus rau hauv manually hauv "Text1" teb, lossis los ntawm txhaj cov xov tooj ntawm qhov xav tau ntawm lub rooj nrog tus nas cursor. Tom qab ntawv rov ua tib yam yeeb yam rau " Text2 "teb - ntawm no koj yuav tsum tau muab qhov chaw nyob ntawm tes nrog cov ntawv sau uas yuav tsum tau ntxiv rau yam dhau los. Thaum koj tsiv mus rau los teb cov teb thib ob, Excel yuav ntxiv qhov thib peb hauv rooj plaub - koj tuaj yeem siv nws yog tias koj xav tsim lub txiaj ntsig los ntawm peb lossis ntau lub hlwb qub. Ib txoj kab tshiab yuav raug txuas ntxiv tas li raws li cov kab dhau los.
Kauj ruam 4
Nco ntsoov tias txoj haujlwm yuav concatenate cov nqi ntawv nyeem raws li lawv tau, yam tsis tau ntxiv ib yam dab tsi raws li tus cais tawm. Yog tias koj xav tau ntxig qhov chaw, kab, lossis ib lo lus nruab nrab ntawm lawv, tom qab ntawd siv kab hauv kab ntawv ntawm tus qauv tsim kom muaj tus qauv - nkag rau cov cim tsim nyog rau hauv nws, muab lawv rau hauv cov ntawv cim. Piv txwv li, yog tias koj qhia qhov txuas rau thawj lub xov tooj ntawm "Text1" teb, nkag mus "," hauv "Text2" teb, thiab cov ntawv txuas rau tus xovtooj thib ob hauv "Text3", tom qab ntawd ces tsis nco qab thiab thaj chaw yuav tso nruab nrab ntawm daim ntawv lo.
Kauj ruam 5
Nyem OK thiab lub cell yuav tso saib nqi uas muaj cov ntawv sau ua ke ntawm cov hlwb koj teev.
Kauj Ruam 6
Tus yam ntxwv ntawm Cov Qauv Tsim Tus Qauv Tsa tuaj yeem hu ua yam uas tsis tas yuav mus rau Formulas tab. Txhawm rau ua li no, cia li nyem rau ntawm kab lus mis qhia qhov cim uas nyob sab saud rau sab laug ntawm kab lus xaiv. Tom qab ntawd xaiv kab "Ntawv" hauv daim ntawv xaiv "xaiv" thiab hauv teb "Xaiv ib qho haujlwm" nrhiav "concatenate". Los ntawm txhaj OK koj yuav qhib lub qhov rai nrog daim ntawv uas tau hais saum toj no.
