Qhov wikiHow no qhia koj li cas kom tshem tawm cov chaw tsis xav tau los ntawm cov cell hauv daim ntawv Excel.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Siv Nrhiav thiab Hloov
Kauj Ruam 1. Qhia txog qhov ntau uas koj xav tshem tawm txhua qhov chaw
Piv txwv li, yog tias koj xav tshem qhov chaw los ntawm C2 txog C30, hais txog cov hlwb ntawd.
Kauj ruam 2. Nyem rau Kho kom raug cov zaub mov
Kauj Ruam 3. Xaiv Nrhiav
Kauj Ruam 4. Xaiv Hloov…
Lub thawv sib tham yuav tshwm sim.
Kauj Ruam 5. Nyem rau lub npov hauv qab “Nrhiav Dab Tsi
”
Kauj Ruam 6. Nias qhov chaw seem ntawm cov keyboard
Nco ntsoov nias nws ib zaug xwb.
Kauj Ruam 7. Nyem Hloov Tag Nrho
Nws yog lub pob thib ob nyob hauv qab ntawm lub qhov rais. Tam sim no cov chaw tau raug tshem tawm los ntawm cov cell xaiv. Ib qho pop-up yuav tshwm, qhia rau koj paub tias muaj pes tsawg qhov chaw raug tshem tawm.
Kauj ruam 8. Nyem OK
Txoj Kev 2 ntawm 2: Siv Txoj Haujlwm Hloov
Kauj Ruam 1. Nyem rau sab saum toj ntawm kab lus hauv kab dawb paug
Lub xovtooj ntawm tes yuav tsum nyob rau kab tib yam li thawj kab ntawm cov ntaub ntawv hauv kem nrog qhov chaw.
Piv txwv li, yog tias koj xav tshem qhov chaw los ntawm kab C, thiab C thawj kab ntawm cov ntaub ntawv nyob hauv kab 2 (C2), nyem lub xov tooj thib ob hauv koj kab ntawv khoob (piv txwv li E2, F2, G2, thiab lwm yam)
Kauj Ruam 2. Hom = Hloov Chaw
Kauj Ruam 3. Nyem rau thawj lub xovtooj ntawm kab uas muaj kab
Piv txwv li, yog tias koj xav tshem txhua qhov chaw ntawm kab C, nyem rau thawj lub npov (piv txwv li C2) hauv kab ntawv uas tsis yog lub npe.
Yog tias koj nyem cell C2, cov qauv yuav tsum tam sim no zoo li no: = Hloov chaw (C2
Kauj Ruam 4. Ntaus, (tus lej cim)
Tam sim no lub xov tooj yuav tsum zoo li no: = Hloov chaw (C2,.
Kauj Ruam 5. Ntaus "",
Muaj qhov chaw nruab nrab ntawm ob pawg ntawm cov lus hais-qhov no tseem ceeb.
Cov mis yuav tsum zoo li no: = Hloov chaw (C2, "",
Kauj Ruam 6. Ntaus "")
Lub sijhawm no, Tsis muaj qhov chaw nruab nrab ntawm cov lus hais.
Cov mis yuav tsum zoo li no: = Hloov chaw (C2, "", "")
Kauj Ruam 7. Nias ↵ Enter los yog ⏎ Rov qab los.
Tam sim no koj yuav pom cov ntsiab lus ntawm cov xov tooj uas tau xaiv (C2, hauv qhov piv txwv no) tsis muaj chaw nyob hauv kab ntawv tshiab.
Piv txwv li, yog C2 hais tias www. wikih ow.com, koj lub cell tshiab yuav hais www.wikihow.com
Kauj Ruam 8. Nyem lub xovtooj ntawm tes nrog cov qauv koj tau ntaus
Tam sim no lub xov tooj yuav tsum tau hais txog.
Kauj Ruam 9. Luag cov ntawv sau cia hla cov cell uas koj xav sau
Cov ntaub ntawv los ntawm txhua lub xovtooj sib txuas tam sim no yuav tshwm nyob rau hauv koj kab ntawv tshiab yam tsis muaj chaw nyob.
Kauj Ruam 10. Luam cov ntaub ntawv los ntawm kab ntawv tshiab mus rau kab thawj
Koj cov ntaub ntawv tsis muaj chaw tshiab yog tam sim no.