Excel ua kom yooj yim rau luam koj cov lej hla tag nrho kab lossis kab, tab sis koj tsis tas yuav tau txais cov txiaj ntsig uas koj xav tau. Yog tias koj ua tiav nrog cov txiaj ntsig tsis tau xav txog, lossis cov phem #REF thiab /DIV0 yuam kev, nws tuaj yeem ua rau muaj kev ntxhov siab heev. Tab sis tsis txhob txhawj-koj yuav tsis xav tau kho koj li 5,000 kab ntawv kab ntawv ntawm ib-ntawm-cell. Qhov wikiHow no qhia koj txoj hauv kev yooj yim rau luam cov qauv rau lwm lub cell.
Cov kauj ruam
Txoj Kev 1 ntawm 4: Siv Nrhiav thiab Hloov Mus Luam Cov Qauv Kom Zoo Li Cas
Kauj Ruam 1. Qhib koj phau ntawv ua haujlwm hauv Excel
Qee zaum, koj muaj daim ntawv nthuav dav loj uas muaj cov qauv, thiab koj xav theej lawv ncaj qha. Hloov txhua yam mus rau cov ntaub ntawv hais txog xov tooj ntawm tes yuav tsis txaus siab, tshwj xeeb yog tias koj tsuas yog xav hloov lawv rov qab los tom qab. Siv txoj hauv kev no txhawm rau txav cov qauv sai nrog cov txheeb ze ntawm tes ntawm lwm qhov uas tsis hloov pauv cov ntawv xa mus. Hauv peb cov ntawv piv txwv, peb xav luam cov qauv ntawm kab C mus rau kab D yam tsis hloov dab tsi.
| Kab A. | Kab B | Kab C | Kab D | |
|---|---|---|---|---|
| qab 1 | 944 | Qav | = A1/2 | |
| riav 2 | 636 | Toads | = A2/2 | |
| qab 3 | 712 | Newts | = A3/2 | |
| qab 4 | 690 | Cov nab | A4/2 |
Yog tias koj tab tom sim luam cov qauv hauv ib lub xov tooj ntawm tes, hla mus rau theem kawg ("Sim lwm txoj hauv kev") hauv ntu no
Kauj Ruam 2. Nias Ctrl+H qhib qhov Nrhiav Qhov rai
Qhov luv yog tib yam ntawm Windows thiab macOS.
Kauj Ruam 3. Nrhiav thiab hloov "=" nrog lwm tus cim
Ntaus "=" rau hauv "Nrhiav dab tsi" teb, thiab tom qab ntawd ntaus tus cim sib txawv rau hauv "Hloov nrog" lub thawv. Nyem Hloov Txhua tig tag nrho cov qauv (uas ib txwm pib nrog qhov sib npaug kos npe) rau hauv kab ntawv pib nrog qee lwm tus cim. Ib txwm siv tus cwj pwm uas koj tsis tau siv hauv koj daim ntawv nthuav tawm.
Piv txwv, hloov nws nrog #lossis &, lossis cov hlua ntev ntawm cov cim, xws li ## &.
| Kab A. | Kab B | Kab C | Kab D | |
|---|---|---|---|---|
| qab 1 | 944 | Qav | ## & A1/2 | |
| riav 2 | 636 | Toads | ## & A2/2 | |
| qab 3 | 712 | Newts | ## & A3/2 | |
| qab 4 | 690 | Cov nab | ## & A4/2 |
Tsis txhob siv cov cim * lossis?, Vim cov no yuav ua rau cov kauj ruam tom ntej nyuaj dua
Kauj Ruam 4. Luam thiab muab tshuaj txhuam cov cell
Qhia cov cell uas koj xav theej, thiab tom qab ntawd nyem Ctrl + C. (PC) lub Cmd + C. (Mac) los theej lawv. Tom qab ntawd, xaiv cov cell koj xav muab tshuaj txhuam rau hauv, thiab nias Ctrl + V. (PC) lub Cmd + V. (Mac) rau muab tshuaj txhuam. Txij li thaum lawv tsis raug txhais ua cov qauv, lawv yuav raug theej raws nraim.
| Kab A. | Kab B | Kab C | Kab D | |
|---|---|---|---|---|
| qab 1 | 944 | Qav | ## & A1/2 | ## & A1/2 |
| riav 2 | 636 | Toads | ## & A2/2 | ## & A2/2 |
| qab 3 | 712 | Newts | ## & A3/2 | ## & A3/2 |
| qab 4 | 690 | Cov nab | ## & A4/2 | ## & A4/2 |
Kauj Ruam 5. Siv Nrhiav & Hloov dua kom thim qhov kev hloov pauv
Tam sim no koj muaj cov qauv uas koj xav tau, siv "Hloov Txhua Yam" dua los thim koj qhov kev hloov pauv. Hauv peb qhov piv txwv, peb yuav saib kab ntawv "## &" thiab hloov nws nrog "=" dua, yog li cov cell ua cov qauv ib zaug ntxiv. Tam sim no koj tuaj yeem txuas ntxiv kho koj daim ntawv teev npe li ib txwm muaj:
| Kab A. | Kab B | Kab C | Kab D | |
|---|---|---|---|---|
| qab 1 | 944 | Qav | = A1/2 | = A1/2 |
| riav 2 | 636 | Toads | = A2/2 | = A2/2 |
| qab 3 | 712 | Newts | = A3/2 | = A3/2 |
| qab 4 | 690 | Cov nab | A4/2 | A4/2 |
Kauj Ruam 6. Sim lwm txoj hauv kev
Yog tias txoj hauv kev piav qhia saum toj no tsis ua haujlwm rau qee qhov laj thawj, lossis yog tias koj txhawj xeeb txog qhov hloov pauv lwm cov ntsiab lus ntawm tes nrog "Hloov tag nrho" kev xaiv, muaj ob peb lwm yam uas koj tuaj yeem sim:
- Txhawm rau luam ib lub xovtooj ntawm tes yam tsis hloov pauv cov ntaub ntawv, xaiv lub xovtooj, tom qab ntawv theej cov mis uas tau qhia hauv cov qauv mis ze rau saum lub qhov rais (tsis yog ntawm lub xovtooj ntawm nws tus kheej). Xovxwm Esc kom kaw cov qauv mis, tom qab ntawv muab cov mis tso rau txhua qhov chaw koj xav tau.
- Xovxwm Ctrl thiab ` (feem ntau nyob ntawm tus yuam sij tib yam li ~) txhawm rau muab daim ntawv nthuav tawm hauv cov qauv pom. Luam cov qauv thiab muab tshuaj txhuam rau hauv cov ntawv sau xws li Notepad lossis TextEdit. Luam lawv dua, tom qab ntawv muab lawv rov qab rau hauv daim ntawv teev npe ntawm qhov chaw xav tau. Tom qab ntawd, nias Ctrl thiab ` dua los hloov rov qab mus rau hom saib tsis tu ncua.
Txoj Kev 2 ntawm 4: Sau Ib Kab lossis Kab nrog Cov Qauv
Kauj Ruam 1. Ntaus ib lub mis rau hauv lub cell dawb paug
Excel ua kom yooj yim rau kev nthuav tawm cov lej hauv kab lossis hla kab los ntawm "sau" cov hlwb. Raws li nrog ib qho qauv twg, pib nrog ib qho = kos npe, tom qab ntawd siv qhov twg los xij lossis cov lej koj xav tau. Peb yuav siv daim ntawv piv txwv yooj yim, thiab ntxiv kab A thiab kab B ua ke. Xovxwm Nkag mus los yog Rov qab los xam cov mis.
| Kab A. | Kab B | Kab C | |
|---|---|---|---|
| qab 1 | 10 | 9 | 19 |
| riav 2 | 20 | 8 | |
| qab 3 | 30 | 7 | |
| qab 4 | 40 | 6 |
Kauj Ruam 2. Nyem rau sab xis sab xis ntawm lub xovtooj nrog cov qauv koj xav luam
Tus cursor yuav dhau los ua tus siab tawv + kos npe.
Kauj Ruam 3. Nyem thiab rub tus cursor hla kab lossis kab uas koj tab tom theej rau
Cov mis koj tau nkag yuav cia li nkag mus rau hauv cov cell koj tau hais tseg. Cov txheeb ze ntawm tes txheeb ze yuav hloov kho tshiab kom xa mus rau lub xov tooj ntawm tes nyob hauv tib txoj haujlwm tsis yog nyob zoo ib yam. Nov yog peb qhov piv txwv ntawm daim ntawv nthuav qhia, qhia cov qauv siv thiab cov txiaj ntsig pom:
| Kab A. | Kab B | Kab C | |
|---|---|---|---|
| qab 1 | 10 | 9 | IB = A1+B1 |
| riav 2 | 20 | 8 | IB = A2+B2 |
| qab 3 | 30 | 7 | = A3+IB 3 |
| qab 4 | 40 | 6 | = A4+B4 |
| Kab A. | Kab B | Kab C | |
|---|---|---|---|
| qab 1 | 10 | 9 | 19 |
| riav 2 | 20 | 8 | 28 |
| qab 3 | 30 | 7 | 37 |
| qab 4 | 40 | 6 | 46 |
- Koj tseem tuaj yeem nyem ob npaug rau qhov kos npe ntxiv los sau tag nrho kab ntawv tsis txhob rub. Excel yuav tsum tsis txhob sau cov kab ntawv yog tias nws pom lub cell khoob. Yog tias cov ntaub ntawv siv muaj qhov sib txawv, koj yuav tsum rov ua cov kauj ruam no txhawm rau sau kab hauv qab qhov sib txawv.
- Lwm txoj hauv kev los sau tag nrho cov kab lus nrog tib lub mis yog xaiv cov cell ncaj qha hauv qab ib qho uas muaj cov mis thiab tom qab ntawd nias Ctrl + D..
Txoj Kev 3 ntawm 4: Luam Tus Qauv rau Ntau Lub Cells los ntawm Pasting
Kauj Ruam 1. Ntaus cov mis rau hauv ib lub cell
Raws li nrog ib qho qauv twg, pib nrog ib qho = kos npe, tom qab ntawd siv qhov twg los xij lossis cov lej koj xav tau. Peb yuav siv daim ntawv piv txwv yooj yim, thiab ntxiv kab A thiab kab B ua ke. Thaum koj nias Nkag mus los yog Rov qab los, cov mis yuav xam.
| Kab A. | Kab B | Kab C | |
|---|---|---|---|
| qab 1 | 10 | 9 | 19 |
| riav 2 | 20 | 8 | |
| qab 3 | 30 | 7 | |
| qab 4 | 40 | 6 |
Kauj Ruam 2. Xaiv lub cell thiab nias Ctrl+C. (PC) lub ⌘ Command+C (Mac).
Qhov no theej cov qauv rau koj cov ntawv teev cia.
Kauj Ruam 3. Xaiv cov cell uas koj xav theej cov mis rau
Nyem rau ntawm ib qho thiab rub nce lossis nqis los siv koj tus nas lossis cov xub xub. Tsis zoo li kab lus lossis kab ntawv sau kab, cov cell koj tau theej cov qauv tsis tas yuav tsum nyob ib sab ntawm lub xovtooj uas koj theej los ntawm. Koj tuaj yeem tuav lub Tswj qhov tseem ceeb thaum xaiv los theej cov cell uas tsis nyob ib sab thiab ntau yam.
Kauj Ruam 4. Nias Ctrl+V (PC) lub ⌘ Command+V (Mac) los muab tshuaj txhuam.
Cov qauv tam sim no tshwm sim hauv cov cell xaiv.
Txoj Kev 4 ntawm 4: Siv Cov Txheeb Ze thiab Tsis Siv Cov Xov Tooj Ntawm Tes
Kauj Ruam 1. Siv tus txheeb ze ntawm tes siv hauv tus lej
Hauv ib qho qauv Excel, "xov tooj ntawm tes" yog qhov chaw nyob ntawm tes. Koj tuaj yeem ntaus cov no hauv tus kheej, lossis nyem rau ntawm lub xovtooj uas koj xav siv thaum koj nkag mus rau tus lej. Piv txwv li, daim ntawv nthuav tawm hauv qab no muaj cov qauv uas hais txog cell A2:
| Kab A. | Kab B | Kab C | |
|---|---|---|---|
| riav 2 | 50 | 7 | = A2*2 |
| qab 3 | 100 | ||
| qab 4 | 200 | ||
| qab 5 | 400 |
Kauj Ruam 2. Nkag siab tias vim li cas lawv thiaj hu ua cov txheeb ze txheeb ze
Hauv ib qho qauv Excel, kev txheeb xyuas txheeb ze siv txoj haujlwm txheeb ze ntawm chaw nyob ntawm tes. Hauv peb qhov piv txwv, C2 muaj cov qauv "= A2", uas yog txheeb ze txheeb ze rau tus nqi ob lub cell rau sab laug. Yog tias koj theej cov qauv rau hauv C4, ces nws tseem yuav xa mus rau ob lub cell rau sab laug, tam sim no qhia "= A4".
| Kab A. | Kab B | Kab C | |
|---|---|---|---|
| riav 2 | 50 | 7 | = A2*2 |
| qab 3 | 100 | ||
| qab 4 | 200 | A4*2 | |
| qab 5 | 400 |
Qhov no ua haujlwm rau cov cell sab nraud ntawm tib kab thiab kab ib yam nkaus. Yog tias koj theej cov qauv ib txwm los ntawm cell C1 rau hauv cell D6 (tsis qhia tawm), Excel yuav hloov qhov kev siv "A2" mus rau ib kab xov tooj ntawm ib sab mus rau sab xis (C → D) thiab 5 kab hauv qab (2 → 7), lossis " IB 7"
Kauj Ruam 3. Siv qhov siv tsis tau hloov pauv
Cia peb hais tias koj tsis xav kom Excel hloov pauv koj cov mis. Hloov chaw ntawm kev siv cov txheeb ze ntawm tes, koj tuaj yeem ua tau meej los ntawm kev ntxiv tus cim $ nyob rau hauv ntej ntawm kab lus lossis kab uas koj xav kom zoo ib yam, tsis muaj teeb meem qhov twg koj luam cov qauv ib yam nkaus. Nov yog qee qhov piv txwv daim ntawv nthuav qhia, qhia tus lej qub hauv cov ntawv loj, cov ntawv tuab, thiab qhov tshwm sim thaum koj luam-muab nws tso rau lwm lub cell:
-
Tus txheeb ze txheeb ze, Kab Tsis Txaus Siab (B $ 3):
Cov mis muaj qhov tsis siv rau kab 3, yog li nws ib txwm hais txog kab 3:
Kab A. Kab B Kab C qab 1 50 7 = IB $ 3 riav 2 100 = $ 3 ib = $ 3B qab 3 200 = $ 3 ib = $ 3B qab 4 400 = $ 3 ib B = 3 hli -
Kab Tsis Zoo, Txheeb Ze ($ B1):
Cov mis muaj qhov siv tsis tseeb rau kab B, yog li nws ib txwm hais txog kab B.
Kab A. Kab B Kab C qab 1 50 7 = $ B1 riav 2 100 = $ B2B = $ B2B qab 3 200 = $ B3 = $ B3 qab 4 400 = $ B4 = $ B4 -
Tsis Muaj Kab & Kab ($ B $ 1):
Cov mis muaj qhov tseeb siv rau kab B ntawm kab 1, yog li nws ib txwm hais txog kab B ntawm kab 1.
Kab A. Kab B Kab C qab 1 50 7 = $ B $ 1 riav 2 100 = $ B $ 1 = $ B $ 1 qab 3 200 = $ B $ 1 = $ B $ 1 qab 4 400 = $ B $ 1 = $ B $ 1 
579572 17 3 Kauj Ruam 4. Siv tus yuam sij F4 los hloov ntawm qhov tseeb thiab tus txheeb ze
Ua kom pom cov xov tooj ntawm tes nyob hauv tus lej los ntawm txhaj nws thiab nias F4 kom cia li ntxiv lossis tshem $ cov cim. Nias nias F4 kom txog rau thaum tsis muaj tseeb lossis txheeb ze cov ntaub ntawv koj xav tau raug xaiv, tom qab ntawd nyem Nkag mus los yog Rov qab los.
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Yog tias koj theej cov qauv rau lub cell tshiab thiab pom daim duab peb sab ntsuab, Excel tau kuaj pom qhov ua yuam kev. Txheeb xyuas cov mis kom zoo saib yog tias muaj dab tsi tsis raug.
- Yog tias koj yuam kev puas tau hloov tus = cim nrog? lossis * hauv "kev luam cov qauv raws nraim" txoj hauv kev, tshawb nrhiav "?" lossis "*" yuav tsis muab cov txiaj ntsig koj xav tau. Kho qhov no los ntawm kev tshawb nrhiav "~?" lossis rau "~*" xwb.
- Xaiv ib lub xovtooj thiab nias Ctrl '(apostrophe) txhawm rau sau nws nrog cov mis ncaj qha saum toj no.
