Nrhiav thiab Hloov hauv Excel yog lub cuab yeej muaj zog thiab yooj yim uas tso cai rau koj nrhiav, thiab, yog tias tsim nyog, hloov cov ntaub ntawv ntawm daim ntawv ua haujlwm. Raws li ib feem ntawm zaj lus qhia no, koj yuav kawm yuav ua li cas tshawb nrhiav hauv ib cheeb tsam ntawm Excel daim ntawv, nrog rau kev hloov cov ntaub ntawv pom rau tus nqi xav tau.
Thaum ua haujlwm nrog ntau cov ntaub ntawv hauv Excel, qee zaum nyuaj nrhiav cov ntaub ntawv tshwj xeeb. Thiab, raws li txoj cai, xws li kev tshawb nrhiav yuav siv sijhawm ntev heev. Excel muaj cov cuab yeej tshawb nrhiav zoo. Koj tuaj yeem pom cov ntaub ntawv yooj yim uas koj xav tau hauv Excel phau ntawv ua haujlwm siv Find command, uas tseem tso cai rau koj hloov cov ntaub ntawv siv Find and Replace tool.
Nrhiav cov ntaub ntawv hauv Excel Cells
Hauv peb qhov piv txwv, peb yuav siv cov lus txib Nrhiav kom pom lub npe xav tau hauv cov npe ntev ntawm cov neeg ua haujlwm.
Yog tias koj xaiv ib lub xovtooj ua ntej siv cov lus txib Nrhiav, Excel yuav tshawb nrhiav tag nrho cov ntawv ua haujlwm. Thiab yog hais tias qhov ntau ntawm cov cell, ces tsuas yog nyob rau hauv no ntau yam
- Ntawm Lub Tsev tab, siv qhov Nrhiav thiab Xaiv cov lus txib, thiab tom qab ntawd xaiv Nrhiav los ntawm daim ntawv teev npe.
- Qhov Nrhiav thiab Hloov dialog box tshwm. Sau cov ntaub ntawv yuav tsum tau tshawb. Hauv peb qhov piv txwv, peb yuav sau tus neeg ua haujlwm lub npe.
- Nyem Nrhiav Tom ntej. Yog tias cov ntaub ntawv muaj nyob rau ntawm daim ntawv, nws yuav raug qhia.
- Yog tias koj nyem qhov Nrhiav Next khawm dua, koj yuav pom qhov kev xaiv nrhiav tom ntej. Koj tuaj yeem xaiv Nrhiav Tag Nrho kom pom tag nrho cov kev xaiv uas Excel tau pom rau koj.
- Thaum koj ua tiav kev tshawb nrhiav, siv lub khawm Kaw kom tawm ntawm Nrhiav thiab Hloov dialog box.
Koj tuaj yeem nkag mus rau Nrhiav cov lus txib nrog cov keyboard shortcut Ctrl + F.
Txhawm rau pom ntxiv Nrhiav thiab Hloov cov kev xaiv, nyem qhov Options khawm hauv Nrhiav thiab Hloov dialog box.
Hloov cov ntsiab lus ntawm tes hauv Excel
Muaj qee zaus thaum ua yuam kev uas tau rov ua dua thoob plaws hauv Excel phau ntawv. Piv txwv li, ib tug neeg lub npe raug sau tsis raug, lossis ib lo lus lossis kab lus yuav tsum tau hloov mus rau lwm tus. Koj tuaj yeem siv cov cuab yeej Nrhiav thiab Hloov Kho kom sai sai. Hauv peb qhov piv txwv, peb yuav siv Replace hais kom kho cov npe ntawm email chaw nyob.
- Ntawm Lub Tsev tab, nyem Nrhiav thiab Xaiv, thiab tom qab ntawd xaiv Hloov los ntawm cov npe poob.
- Qhov Nrhiav thiab Hloov dialog box tshwm. Nkag mus rau cov ntawv koj tab tom nrhiav rau hauv Nrhiav teb.
- Ntaus cov ntawv koj xav hloov cov ntawv pom nyob rau hauv Hloov nrog lub thawv. Thiab ces nyem Nrhiav Next.
- Yog tias pom tus nqi, lub xov tooj ntawm tes uas muaj nws yuav raug qhia.
- Saib cov ntawv nyeem thiab xyuas kom tseeb tias koj pom zoo hloov nws.
- Yog tias koj pom zoo, xaiv ib qho ntawm cov kev xaiv hloov pauv:
- Hloov: Kho ib qho nqi ntawm ib lub sijhawm.
- Hloov Txhua Yam: Kho txhua qhov sib txawv ntawm cov ntawv tshawb nrhiav hauv phau ntawv ua haujlwm. Hauv peb qhov piv txwv, peb yuav siv qhov kev xaiv no kom txuag tau sijhawm.
- Lub dialog box yuav tshwm sim paub meej tias muaj pes tsawg tus hloov pauv yuav tsum tau ua. Nyem OK mus ntxiv.
- Cov ntsiab lus ntawm cov hlwb yuav raug hloov.
- Thaum ua tiav, nyem Kaw kom tawm ntawm Nrhiav thiab Hloov dialog box.
