Excel Fill Handle

Luam Ntaub Ntawv, Formula, Formatting thiab Ntau

Kev ua tus kav yog qhov ntau, qhov dub me me lossis lub xwm fab xwm yeem hauv qab ntawm kaum sab xis ntawm lub xovtooj ntawm tes uas yuav txuag tau koj lub sijhawm thiab kev rau siab thaum nws raug siv los luam cov ntsiab lus ntawm ib lossis ntau lub hlwb rau cov hlwb nyob ib sab hauv daim ntawv ua haujlwm .

Nws siv xws li:

• Luam cov ntaub ntawv thiab kev hloov
• Kev luam daim qauv
• Sau cov cim nrog cov lej, xws li khib los yog cov xov tooj
• Ntxiv cov hnub ntawm lub limtiam lossis lub hlis npe rau ib daim ntawv ua haujlwm
• Ntxiv cov npe ntawm cov ntaub ntawv uas siv rau feem ntau, xws li cov tuam tsev haujlwm lossis daim ntawv qhia lub npe, rau ib daim ntawv ua haujlwm

Ua haujlwm rau kev ua haujlwm

Tus tuav daim ntawv ua haujlwm nrog tus nas. Siv nws:

1. Tshaj tawm cov xovtooj (cell) uas muaj cov ntaub ntawv yuav tsum tau theej los yog, thaum nyob rau hauv cov ntaub ntawv ntawm ib tug series, ncua.
2. Muab tus pointer poias hla kev tuav-tus pointer hloov mus rau me me dub ntxiv rau daim ntawv ( + ).
3. Nias thiab tuav lub pob nyem khawm.
4. Luag lub npuaj kab rau cov hom phiaj ntawm tes (s).

Luam Cov Ntaub Ntawv Uas Tsis Muaj Ntawv Teev Npe

Thaum cov ntaub ntawv muab luam tawm nrog tus tuav daim ntawv, yog lub neej ua ntej cov ntaub ntawv siv rau cov ntaub ntawv, xws li txiaj, kos npe los yog ntawv nyeem, los yog ntawm cov xim ntawm tes los sis font xim, tau muab luam tawm thiab.

Los luam cov ntaub ntawv tsis muaj kev luam tawm formatting, tom qab luam cov ntaub ntawv nrog tus tuav daim, Excel qhia txog Auto Fill Options khawm hauv qab no thiab mus rau sab xis ntawm lub hlwb tshiab.

Nias ntawm lub pob no qhib ib daim ntawv teev cov kev xaiv uas muaj xws li:

• Luam hlwb
• Sau cov lus cim xwb
• Sau tsis muaj formatting

Txhawm rau ntawm kev sau tsis tau cov ntawv luam tawm yuav luam cov ntaub ntawv nrog daim ntawv tuav, tiam sis tsis yog qhov formatting.

Piv txwv

1. Ntaus tus naj npawb formatted-xws li $ 45.98- ntawm lub cell A1 ntawm daim ntawv ua haujlwm.
2. Nyem ntawm tes A1 dua los ua nws lub xovtooj ntawm tes.
3. Muab tus nas pointer hla kev tuav (me me dub teev rau hauv qab yog kaum ntawm tes A1).
4. Tus po po yuav hloov mus rau ib qho dub dub ntxiv rau daim ntawv ( + ) thaum koj muaj nws txoj kev tuav.
5. Thaum tus nas pointer hloov mus rau qhov kos npe rau ntxiv, nias thiab puag tus nas khawm.
6. Luag tus tuav daim ntawv rau xovtooj A4 kom luam tus naj npawb $ 45.98 thiab cov cim rau lub hlwb A2, A3, thiab A4.
7. Cov kab A1 rau A4 yuav tsum tam sim no txhua tus muaj cov naj npawb formatted $ 45.98.

Luam Cov Qauv

Cov qauv uas tau muab luam tawm uas siv daim ntawv tuav yuav hloov tshiab kom siv cov ntaub ntawv hauv lawv qhov chaw tshiab yog tias lawv tau raug tsim los ntawm kev siv xov tooj ntawm tes.

Xov tooj ntawm tes yog cov ntawv sau qhia kab thiab kab ntawm kab xovtooj ntawm qhov chaw uas cov ntaub ntawv siv hauv hom mis, xws li A1 lossis D23.

Hauv daim duab saum toj no, lub H1 cell muaj ib hom mis uas ntxiv cov zauv hauv ob lub hlwb mus rau sab laug.

Siv qhov tseeb cov zauv rau hauv tus qauv hauv H1 los tsim cov qauv no,

= 11 + 21

Xov tooj ntawm tes yog siv los ua thiab cov mis mos:

= F1 + G1

Hauv ob qhov qauv, lo lus teb ntawm H1 yog: 32, tab sis ob hom mis, vim nws tau tsim siv cov xov tooj ntawm tes nws tuaj yeem siv theej kev siv lub hlwb kom H2 thiab H3 thiab nws yuav muab qhov tseeb ntawm cov ntaub ntawv hauv cov kab.

Piv txwv

Qhov piv txwv no siv xov tooj ntawm cov qauv hauv cov qauv, yog li txhua tus xov tooj ntawm cov xov tooj ntawm cov qauv qub tau muab kho kom pom zoo rau lawv qhov chaw tshiab.

1. Ntxiv cov ntaub ntawv uas pom hauv daim duab saum toj no rau cov hlwb F1 rau G3 hauv tsab ntawv ua haujlwm.
2. Nyem ntawm tes H1.
3. Ntaus qhov formula: = F1 + G1 rau hauv G1 thiab nias tus Sau rau ntawm tus keyboard.
4. Cov lus teb 32 yuav tsum tshwm sim ntawm tes H1 (11 + 21).
5. Nias ntawm H1 rov los ua nws lub xovtooj ntawm tes.
6. Muab lub pointer fuas hla kev tuav (me me dub teev hauv qab ntawm kaum sab xis ntawm tes H1).
7. Tus pointer mouse yuav hloov mus rau ib qho dub dub ntxiv rau daim ntawv ( + ) thaum uas koj muaj nws tshaj tus tuav kov ..
8. Thaum tus nas pointer hloov mus rau qhov kos npe ntxiv, nias thiab puag hauv pob nyem khawm.
9. Tsum lub npas kab rau H3 mus luam cov mis rau hlwb H2 thiab H3.
10. Cov kab H2 thiab H3 yuav tsum muaj cov lej 72 thiab 121 ntsig txog - cov txiaj ntsim ntawm cov qauv uas tau muab luam rau cov qe ntshav.
11. Yog tias koj nias ntawm tes H2 qhov formula = F2 + G2 tuaj yeem pom hauv qhov formula formula saum toj daim ntawv.
12. Yog tias koj nias ntawm tes H3 qhov formula = F3 + G3 tuaj yeem pom nyob hauv lub mis.

Ntxiv Txheeb Zauv Cov Naj Npawb rau Cov Hlwb

Yog hais tias Excel pom cov khoom hauv cell raws li ib feem ntawm ib tug series, nws yuav pib sau lwm cov hlwb xaiv nrog cov khoom tom ntej hauv koob.

Ua li no, koj yuav tsum nkag mus rau cov ntaub ntawv txaus los qhia Excel tus qauv, xws li suav los ntawm ob lub, uas koj xav siv.

Thaum koj tau ua tiav qhov no lawm, tus tuav daim ntawv yuav siv tau rov ua dua qhov qub raws li qhov xav tau.

Piv txwv

1. Ntaus tus naj npawb 2 hauv xov tooj ntawm tes D1 thiab nias tus Enter nkag rau ntawm cov keyboard.
2. Sau tus naj npawb 4 hauv xov tooj D2 thiab nias sau.
3. Xaiv cov hlwb D1 thiab D2 los saib lawv.
4. Nyem thiab puag tus nas pointer ntawm tus tes tuav hauv qab ntawm kaum sab xis ntawm tes D2.
5. Luag lub npuaj daim pib rau ntawm tes D6.
6. Cov hlwb D1 rau D6 yuav tsum muaj cov lej: 2, 4, 6, 8, 10, 12.

Ntxiv Hnub ntawm lub Limtiam

Excel muaj preset cov npe ntawm cov npe, cov hnub ntawm lub limtiam thiab lub hli ntawm lub xyoo, uas tuaj yeem raug ntxiv rau ib daim ntawv ua haujlwm uas siv tus tuav.

Ntxiv cov npe rau ib daim ntawv ua haujlwm, koj tsuas yog yuav tsum qhia rau Excel uas sau koj xav ntxiv thiab qhov no yog ua los ntawm sau thawj lub npe ntawm daim ntawv teev npe.

Ntxiv hnub ntawm lub lim tiam piv txwv,

1. Teem hnub Sunday rau cov menyuam yaus A1.
2. Nias tus yuam sij Enter rau ntawm cov keyboard.
3. Nyem ntawm tus xov tooj ntawm tes A1 rov ua kom nws lub xovtooj ntawm tes.
4. Muab tus pointer ntawv hla tus tes tuav rau sab hauv qab ntawm txoj cai ntawm tes.
5. Tus po po yuav hloov mus rau ib qho dub dub ntxiv rau daim ntawv ( + ) thaum koj muaj nws txoj kev tuav.
6. Thaum tus nas pointer hloov mus rau qhov kos npe rau ntxiv, nias thiab puag tus nas khawm.
7. Luag lub npuaj kom tiav rau ntawm G1 rau nws pib sau hnub ntawm lub lim tiam txij hnub Monday mus hnub vas xaum.

Excel kuj muaj cov npe luv rau cov hnub ntawm lub lim piam xws li Tshaj Xo , Mon , thiab lwm yam zoo li lub npe tag nrho thiab luv luv lub hli - Lub Ib Hlis, Lub Ob Hlis, Lub Peb Hlis thiab Lub Hlis, Lub Hlis, Lub Plaub Hlis Ntuj ntxiv rau ib daim ntawv ua haujlwm uas siv cov kauj ruam teev tseg saum toj saud.

Mus Ntxiv Cov Kev Sau Npe Mus Rau Kev Sau Npe

Excel kuj tso cai rau koj ntxiv koj lub npe ntawm cov npe xws li cov tuam tsev npe lossis cov ntawv ua haujlwm rau kev siv nrog tus tuav daim ntawv. Ib daim ntawv yuav muab ntxiv rau qhov seem ntawm cov ntawv sau los ntawm kev sau npe ntawm cov npe los yog luam tawm ntawm daim ntawv teev npe hauv daim ntawv ua haujlwm.

Ntaus Tus Tshiab Pib Sau Sau Koj Tus Kheej

1. Nias rau ntawm Daim Ntawv Txhab ntawm cov Ribbon (Excel 2007 nias rau ntawm Office khawm).
2. Nias rau Cov kev xaiv kom coj mus rau Excel xaiv dialog box .
3. Nyem ntawm qhov Advanced tab ( Excel 2007 - Nrov tab) nyob rau sab laug tes.
4. Tshooj mus rau seem ntawm cov kev xaiv sau nyob rau sab xis xis ( Excel 2007 - Sab saum toj xaiv cov lus nyob rau sab saum toj ntawm lub pane ).
5. Nias qhov Kho Tshais Nchuav Nias hauv khawm txoj cai pane mus qhib Qhib Qhia Npe sib tham.
6. Ntaus daim ntawv teev npe tshiab hauv cov ntawv sau npe qhov rai.
7. Ndliv ntxiv ntxiv rau daim ntawv teev npe tshiab rau cov Npe Xaiv Tsa hauv qhov chaw nyob sab laug.
8. Nyem OK ob zaug kom kaw txhua lub thawv kev sib tham thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm.
9. Xeem daim ntawv teev npe tshiab los ntawm sau tus thawj lub npe ntawm daim ntawv thiab tom qab ntawd ces siv daim ntawv sau npe ntxiv kom tas cov npe rau ntawm daim ntawv ua haujlwm.

Mus Ntshuam Tus Sau Daim Ntawv Sau Ntiag Npe Sau Los Ntawm Koj Cov Lus Qhia

1. Highlight lub ntau ntawm cov hlwb nyob hauv daim ntawv uas muaj cov npe sau, xws li A1 rau A5.
2. Ua raws li cov kauj ruam ntawm 1 mus rau 5 sab saud kom qhib tau Daim Ntawv Teev Npe Dialog.
3. Qhov ntau ntawm cov hlwb xaiv yav tas los yuav tsum muaj nyob rau hauv daim ntawv ntawm cov xov tooj ntawm cov xov tooj tsis meej , xws li $ A $ 1: $ A $ 5, hauv daim ntawv teev cov npe ntawm lub thawv hlwb hauv qab ntawm lub thawv dialog.
4. Nyem khawm ntshuam .
5. Tus pib Auto Fill List tshwm nyob rau hauv Piav Qhia Piav Qhia.
6. Nyem OK ob zaug kom kaw txhua lub thawv kev sib tham thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm.
7. Xeem daim ntawv teev npe tshiab los ntawm sau tus thawj lub npe ntawm daim ntawv thiab tom qab ntawd ces siv daim ntawv sau npe ntxiv kom tas cov npe rau ntawm daim ntawv ua haujlwm.