Cov txheej txheem:

Yuav ua li cas qhib Cov Kev Hloov Pauv hauv Excel?
Yuav ua li cas qhib Cov Kev Hloov Pauv hauv Excel?

Video: Yuav ua li cas qhib Cov Kev Hloov Pauv hauv Excel?

Video: Yuav ua li cas qhib Cov Kev Hloov Pauv hauv Excel?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Tej zaum
Anonim

Txhawm rau qhib Cov Kev Hloov Pauv:

  1. Los ntawm Kev Tshawb Fawb tab, nyem qhov Taug kev Hloov hais kom ua, ces xaiv Highlight Hloov los ntawm cov ntawv qhia zaub mov.
  2. Qhov Tseem Ceeb Hloov dialog box yuav tshwm.
  3. Yog tias muaj lus nug, nyem OK kom tso cai Excel txuag koj phau ntawv ua haujlwm.
  4. Taug kev Hloov yuav qhib.

Ntxiv mus, koj yuav taug qab cov kev hloov pauv hauv Excel 2019 li cas?

Nov yog cov kauj ruam los pab kom taug qab cov kev hloov pauv hauv Excel:

  1. Mus rau ntawm Kev Tshawb Fawb tab.
  2. Hauv Pab Pawg Kev Hloov, nyem rau ntawm Txoj Kev Hloov Cov Kev Xaiv thiab xaiv Cov Kev Hloov Siab.
  3. Nyob rau hauv lub Highlight Changes dialog box, kos cov kev xaiv – 'Track hloov thaum kho. Qhov no kuj qhia koj phau ntawv ua haujlwm'.
  4. Nyem OK.

Tsis tas li ntawd, kuv yuav piv ob cov npe hauv Excel li cas? Ib qho yooj yim thiab lom zem txoj hauv kev los sib piv 2 cov npe

  1. Xaiv cov cell hauv ob lub npe (xaiv thawj daim ntawv teev npe, tom qab ntawd tuav CTRL tus yuam sij thiab tom qab ntawd xaiv qhov thib ob)
  2. Mus rau Conditional Formatting > Highlight Cells Rules > Duplicate Values.
  3. Nias ok.
  4. Tsis muaj dab tsi ua ntawm no. Tawm mus thiab ua si!

Yog li ntawd, vim li cas kuv thiaj tsis tuaj yeem siv cov kev hloov pauv hauv Excel?

Txhawm rau ua qhov no, rov qab mus rau "Tshawb Xyuas Pab Pawg", thiab mus rau " Taug kev Hloov ”pab. Nyem rau ntawm "Highlight Hloov ”thiab tsuas yog uncheck lub thawv uas tau khij dhau los uas sau tias “ Taug kev Hloov thaum kho…”

Yuav ua li cas koj co sau hauv Excel?

Lawv ua tau co - tus sau hauv Excel rau lub vev xaib tam sim ntawd los ntawm nias Kho kom raug Workbook> Kho kom raug hauv Browser. Yog lawv xav siv ib tug Excel app thiab tsis yog Excel rau lub vev xaib co - tus sau , lawv tuaj yeem nyem Kho Phau Ntawv Ua Haujlwm> Kho kom raug Excel.

Pom zoo: