Cov txheej txheem:

Yuav ua li cas hloov ib lo lus hauv Excel 2016?
Yuav ua li cas hloov ib lo lus hauv Excel 2016?

Video: Yuav ua li cas hloov ib lo lus hauv Excel 2016?

Video: Yuav ua li cas hloov ib lo lus hauv Excel 2016?
Video: Yuav ua li cas thiaj khiav dim lub ntiajteb no 2024, Plaub Hlis Ntuj
Anonim

Txhawm rau hloov cov ntsiab lus ntawm tes:

  1. Los ntawm Lub Tsev tab, nyem qhov Nrhiav thiab Xaiv cov lus txib, tom qab ntawd xaiv Hloov los ntawm cov ntawv qhia zaub mov.
  2. Nrhiav thiab Hloov dialog box yuav tshwm.
  3. Ntaus cov ntawv koj xav tau hloov nws nrog hauv Hloov nrog: teb, ces nyem Nrhiav Next.

Ntawm no, koj pom thiab hloov lo lus hauv Excel li cas?

Txhawm rau nrhiav thiab hloov cov ntaub ntawv hauv daim ntawv ua haujlwm, ua raws li cov kauj ruam no:

  1. Xaiv Nrhiav & Xaiv hauv Editing pab pawg ntawm lub Tsev tab, thiab tom qab ntawd xaiv Hloov (lossis nias Ctrl + H).
  2. Hauv qhov Nrhiav Dab Tsi, sau cov ntaub ntawv koj xav nrhiav.
  3. Nyob rau hauv Hloov Nrog lub npov, nkag mus rau cov ntaub ntawv uas koj xav hloov cov ntaub ntawv pom.

Ib yam li ntawd, kuv yuav nrhiav thiab hloov cov cim tshwj xeeb hauv Excel li cas? Txhawm rau nrhiav thiab hloov cov cim tshwj xeeb, ua raws li cov kauj ruam no:

  1. Ntawm Lub Tsev tab, hauv pawg Editing, nyem Hloov:
  2. Nyem qhov Ntxiv >> khawm:
  3. Nyem lub pob tshwj xeeb, thiab xaiv cov cim tshwj xeeb oritem koj xav nrhiav thiab cov ntawv uas koj xav tshawb nrhiav.

Tib neeg kuj nug, puas muaj qhov hloov pauv hauv Excel?

Lub Microsoft Excel REPLACE muaj nuj nqi Hloov cov cim ntawm cov cim hauv ib txoj hlua nrog lwm cov cim. Nws tuaj yeem siv ua daim ntawv ua haujlwm muaj nuj nqi (WS) in Excel . Ua daim ntawv ua haujlwm muaj nuj nqi , cov REPLACE muaj nuj nqi tuaj yeem muab faib ua ib feem ntawm a qauv hauv ib lub cell ntawm daim ntawv ua haujlwm.

Yuav ua li cas koj hloov txhua qhov tshwm sim hauv Lo Lus?

Nrhiav thiab hloov cov ntawv

  1. Mus rau Tsev> Hloov lossis nias Ctrl + H.
  2. Nkag mus rau lo lus lossis kab lus koj xav nrhiav hauv Findbox.
  3. Sau koj cov ntawv tshiab nyob rau hauv Hloov lub thawv.
  4. Xaiv Nrhiav Tom ntej kom txog rau thaum koj tuaj rau lo lus koj xav hloov tshiab.
  5. Xaiv Hloov. Txhawm rau hloov kho txhua qhov xwm txheej ib zaug, xaiv ReplaceAll.

Pom zoo: