Yuav Nrhiav Li Cas Sab Nraud Txuas Hauv Excel hauv PC lossis Mac: 9 Kauj Ruam

Cov txheej txheem:

Yuav Nrhiav Li Cas Sab Nraud Txuas Hauv Excel hauv PC lossis Mac: 9 Kauj Ruam
Yuav Nrhiav Li Cas Sab Nraud Txuas Hauv Excel hauv PC lossis Mac: 9 Kauj Ruam

Video: Yuav Nrhiav Li Cas Sab Nraud Txuas Hauv Excel hauv PC lossis Mac: 9 Kauj Ruam

Video: Yuav Nrhiav Li Cas Sab Nraud Txuas Hauv Excel hauv PC lossis Mac: 9 Kauj Ruam
Video: yuav coj li cas kom luag nyiam 2024, Tej zaum
Anonim

Cov app no qhia koj yuav ua li cas thiaj nrhiav tau lwm qhov txuas hauv Excel. Koj tuaj yeem yooj yim tshawb nrhiav txuas uas siv Kev Tshawb Nrhiav thiab Hloov Hloov hauv Excel.

Cov kauj ruam

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 1
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 1

Kauj Ruam 1. Qhib Excel

Nws yog lub app uas muaj lub cim ntsuab uas zoo ib yam li phau ntawv teev npe.

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 2
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 2

Kauj Ruam 2. Qhib Excel daim ntawv nthuav qhia

Muaj cov npe ntawm Excel cov ntaub ntawv nthuav tawm tsis ntev los no hauv kab ntawv mus rau sab laug. Yog tias koj tsis pom daim ntawv uas koj xav qhib hauv cov npe, nyem "Qhib lwm phau ntawv ua haujlwm". Nkag mus rau daim ntawv nthuav qhia koj xav qhib, thiab nyem rau nws.

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 3
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 3

Kauj Ruam 3. Nias Ctrl+F

Qhov no yuav qhib Nrhiav thiab Hloov Cov Cuab Yeej.

Nias Control+F ntawm Mac

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 4
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 4

Kauj Ruam 4. Nyem Xaiv

Nws yog nyob rau sab xis hauv qab ob kab ntawv.

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 5
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 5

Kauj Ruam 5. Ntaus.xl ib sab ntawm "Nrhiav Dab Tsi"

Lub thawv "Nrhiav Dab Tsi" yog nyob rau sab saum toj ntawm cov popup hauv qab "Nrhiav" tab.

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 6
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 6

Kauj Ruam 6. Xaiv phau ntawv ua haujlwm tom ntej "Tsis pub dhau:

". Siv cov ntawv qhia zaub mov hauv lub thawv ntawv" Tsis pub dhau "los xaiv" Phau Ntawv Ua Haujlwm ".

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 7
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 7

Kauj Ruam 7. Xaiv Cov Qauv tom ntej ntawm "Saib Hauv:

". Siv cov ntawv qhia zaub mov hauv lub thawv ntawv" Saib Hauv "los xaiv" Cov Qauv ".

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 8
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 8

Kauj Ruam 8. Nyem Nrhiav Txhua Qhov

Nws nyob saum lub npov npe hauv qab ntawm qhov "Nrhiav thiab Hloov" kev sib tham.

Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 9
Nrhiav Sab Nraud Txuas Hauv Excel hauv PC lossis Mac Kauj Ruam 9

Kauj Ruam 9. Nyem rau cov qauv ntawm cov cell hauv daim ntawv teev npe

Txhawm rau xaiv qhov txuas, nyem rau tus lej ntawm tus lej hauv kab ntawv.

Pom zoo: