Excel tus sau tus kov yog ntau lub hom phiaj, me me dub dot lossis square hauv qab sab xis ntawm lub xov tooj ntawm tes uas tuaj yeem txuag koj lub sijhawm thiab kev siv zog thaum nws siv los luam cov ntsiab lus ntawm ib lossis ntau lub hlwb rau cov hlwb nyob ib sab hauv ib daim ntawv ua haujlwm.
Cov lus qhia no siv rau Excel rau Microsoft 365 thiab Excel versions 2019, 2016, 2013, thiab 2010.
Ua Haujlwm Nrog Excel Sau Ua Haujlwm
Tus tuav tuav ua haujlwm nrog tus nas. Kev siv cov khoom siv suav nrog:
- Luam cov ntaub ntawv thiab formatting
- copy formulas
- Sau cov hlwb nrog cov lej, xws li khib lossis tus lej
- Ntxiv cov hnub ntawm lub limtiam lossis lub hli rau hauv daim ntawv ua haujlwm
- Ntxiv cov npe kev cai ntawm cov ntaub ntawv uas nquag siv, xws li cov npe chaw haujlwm lossis cov npe qhia, rau daim ntawv ua haujlwm
Sim ua piv txwv yooj yim hauv koj tus kheej daim ntawv Excel.
- Highlight lub xov tooj ntawm tes uas muaj cov ntaub ntawv yuav tsum tau theej lossis, nyob rau hauv rooj plaub, txuas ntxiv.
-
Tso tus nas pointer rau ntawm qhov chaw sau. Tus pointer hloov mus rau ib qho me me dub ntxiv kos npe (+).
Image -
Nias thiab tuav lub sab laug nas khawm, ces luag tus puv tes mus rau qhov chaw ntawm tes.
Copy Cov Ntaub Ntawv Tsis muaj formatting
Thaum koj luam cov ntaub ntawv nrog tus tuav, los ntawm lub neej ntawd, txhua hom kev siv rau cov ntaub ntawv tau theej thiab. Koj tuaj yeem luam cov ntaub ntawv yam tsis tau luam cov formatting. Tom qab luam cov ntaub ntawv nrog rau tus tuav, Excel qhia lub Auto Fill Options khawm hauv qab thiab mus rau sab xis ntawm cov hlwb tshiab.
Xaiv tus AutoFill Options khawm qhib cov npe ntawm cov kev xaiv uas suav nrog:
- Copy cells
- Fill formatting xwb
- Fill yam tsis muaj formatting
- Flash sau
Xaiv Fill yam tsis muaj formatting yuav luam cov ntaub ntawv nrog cov ntawv sau tab sis tsis yog qhov formatting.
Copy Formulas
Cov qauv theej theej siv tus lej sau yuav hloov kho kom siv cov ntaub ntawv hauv lawv qhov chaw tshiab yog tias koj tsim lawv siv cov ntaub ntawv xovtooj.
Cell references yog cov kab ntawv thiab kab zauv ntawm lub xov tooj ntawm tes uas cov ntaub ntawv siv nyob rau hauv cov mis, xws li A1 los yog D23. Piv txwv li:
Siv tus lej tiag rau hauv cov qauv hauv H1 los tsim cov qauv no,
=11 + 21
siv cov ntaub ntawv xovtooj hloov pauv, thiab cov qauv ua:
=F1 + G1
Nyob rau hauv ob qho qauv, cov lus teb hauv xovtooj H1 yog 32, tab sis vim tias tus qauv thib ob siv cov ntaub ntawv xovtooj, koj tuaj yeem luam nws siv tus lej sau rau cov hlwb H2 thiab H3,thiab nws yuav muab cov txiaj ntsig raug rau cov ntaub ntawv hauv cov kab ntawd.
Tau Cells
Yog Excel lees paub cov ntsiab lus ntawm tes ua ib feem ntawm cov koob, nws yuav auto-fill lwm lub 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 obs, uas koj xav siv.
Ntawm no yog ib qho piv txwv tseem ceeb ntawm Excel's auto-fill feature:
- Tau tus lej 2 hauv xovtooj D1 thiab nias lub Enter.
- Tau tus lej 4 hauv xovtooj D2 thiab nias Enter.
- Select cells D1 thiab D2 los qhia rau lawv.
-
Click thiab tuav tus nas pointer rau ntawm fill handle hauv qab sab xis ntawm lub xov tooj D2.
Image -
Dag tus sau tus tuav mus rau ntawm tes D6.
Image -
Cells D1 to D6 yuav tsum muaj tus lej: 2, 4, 6, 8, 10, 12.
Image
Ntxiv cov ntsiab lus preset rau Cells
Excel tseem muaj cov npe teev npe, hnub ntawm lub limtiam, thiab lub hli ntawm lub xyoo, uas tuaj yeem muab ntxiv rau hauv daim ntawv ua haujlwm uas siv tus lej sau. Ua piv txwv, ntawm no yog qhov koj tuaj yeem ntxiv cov hnub ntawm lub limtiam hauv koj daim ntawv ua haujlwm.
Excel tseem muaj cov npe teev ua ntej ntawm cov ntawv luv rau hnub ntawm lub limtiam xws li Hnub, Mon, thiab lwm yam. nrog rau cov npe tag nrho thiab lub hli luv - Lub Ib Hlis, Lub Ob Hlis, Lub Peb Hlis, thiab Lub Ib Hlis, Lub Ob Hlis, Peb Hlis uas tuaj yeem muab ntxiv rau hauv daim ntawv ua haujlwm siv cov kauj ruam teev tseg.
- Type Sunday into cell A1.
- Nias lub Enter tus yuam sij ntawm cov keyboard.
- Click rau ntawm tes A1 rov ua kom nws lub cell ua haujlwm.
- Tau qhov tus taw tes hla tus fill handle nyob rau hauv qab sab xis ntawm lub active cell.
- Tus nas pointer yuav hloov mus rau ib qho me me dub ntxiv rau kos npe (+) thaum koj muaj nws hla tus tuav.
- Thaum tus nas pointer hloov mus rau lub cim ntxiv, nias thiab tuav cia tus nas khawm.
- Txhob rub tus tuav tes rau ntawm tes G1 txhawm rau pib sau cov hnub ntawm lub limtiam txij hnub Monday txog Saturday.
Ntxiv ib daim ntawv teev kev cai rau lub Fill Handle
Excel tseem tso cai rau koj ntxiv koj cov npe ntawm cov npe xws li cov npe chaw haujlwm lossis cov ntawv sau ua haujlwm rau kev siv nrog tus lej sau. Koj tuaj yeem ntxiv ib daim ntawv teev npe rau hauv daim ntawv sau los ntawm kev ntaus cov npe ntawm tus kheej lossis los ntawm kev luam tawm ntawm cov npe uas twb muaj lawm hauv daim ntawv ua haujlwm.
- Xaiv tus File tab ntawm kab.
-
Xaiv Options txhawm rau nqa Excel Options dialog box.
Image -
Xaiv lub Advanced tab nyob rau sab laug tes.
Image - Scroll rau General ntu ntawm cov npe xaiv nyob rau sab xis sab xis.
-
Xaiv tus Kho Cov Ntawv Teev Npe khawm nyob rau sab xis sab xis kom qhib lub Custom List dialog box.
Image -
Hloov cov npe tshiab hauv Tswj nkag qhov rais.
Image - Xaiv Add txhawm rau ntxiv cov npe tshiab rau Daim Ntawv Teev Npe qhov rai nyob rau sab laug tes pane.
- Xaiv OK ob zaug kom kaw tag nrho cov thawv sib tham thiab rov qab mus rau daim ntawv ua haujlwm.
Ntshuam ib daim ntawv teev npe AutoFill los ntawm Spreadsheet
Yog tias koj tab tom nrhiav import cov npe autofill kev cai raws li cov ntsiab lus ntawm koj daim ntawv nthuav qhia, ua raws cov kauj ruam no rau kev siv tes ua ntau dua:
-
Highlight qhov ntau ntawm cov hlwb hauv daim ntawv ua haujlwm uas muaj cov npe, xws li A1 rau A7.
Image - Follow steps 1 to 5 saum toj no los qhib lub Custom List dialog box.
-
Qhov ntau ntawm cov hlwb uas tau xaiv yav dhau los yuav tsum muaj nyob rau hauv daim ntawv ntawm cov ntaub ntawv tseem ceeb, xws li $A$1:$A$7 hauv Ntshuam daim ntawv teev npe los ntawm cov hlwb lub npov hauv qab ntawm lub dialog box.
Image - Xaiv tus Import khawm.
- Daim ntawv teev npe AutoFill tshiab tshwm nyob rau hauv Cov Ntawv Teev Npe qhov rais.
- Xaiv OK ob zaug kom kaw tag nrho cov thawv sib tham thiab rov qab mus rau daim ntawv ua haujlwm.
