01 ntawm 05
Xauv cov kab thiab cov kab hauv Excel nrog Cov Txib Nkoog
Tej zaum kuj nyuaj nyeem thiab to taub cov ntaub ntawv loj heev. Thaum koj nqes dhau deb mus rau sab xis los yog qis, koj poob cov hau lus uas nyob rau saum toj thiab sab laug sab ntawm daim ntawv ua haujlwm . Yog tsis muaj lub hau lus, nws yuav tsis yooj yim kom khiav ntawm cov kab twg los yog kab ntawm cov ntaub ntawv koj tab tom saib.
Kom tsis txhob siv qhov teeb meem no siv qhov khov ntim panes hauv Microsoft Excel. Nws tso cai rau koj kom "khov" qee qhov chaw los yog qhov chaw ntawm daim ntawv khom nqi kom lawv nyob pom txhua lub sijhawm thaum tig mus rau sab xis lossis nqis. Ua cov npe ntawm qhov screen ua kom yooj yim nyeem koj cov ntaub ntawv thoob plaws hauv tag nrho spreadsheet.
Nyeem txog kev nyeem ntawv: Excel 2007/2010 Cov Rooj Noj Mov .
02 ntawm 05
Cov Nkoog Nkoog Siv Cov Npe Ntawm Lub Cev
Thaum koj qhib Cov Ntsiab Tsi hauv Excel, tag nrho cov kab saum toj ntawm lub xov tooj ntawm tes thiab tag nrho cov kab rau sab laug ntawm lub xov tooj ntawm tes ua khov kho.
Kom khov tsuas yog cov kab thiab cov kab uas koj xav nyob twj ywm hauv npo, nias ntawm lub xovtooj mus rau sab xis ntawm cov kab thiab cia li qis dua cov kab uas koj xav nyob twj ywm hauv npo.
Piv txwv - khaws kab 1,2, thiab 3 ntawm qhov screen thiab kab A thiab B, nias ntawm tes C4 nrog nas. Tom qab ntawd xaiv Qhov Ncauj> Txav Nkev Los ntawm cov ntawv qhia zaub mov, raws li muaj nyob hauv daim duab saum toj no.
Xav tau ib co kev pab ntxiv?
Tom ntej no, yog ib kauj ruam me me los ntawm kauj ruam piv txwv uas qhia koj yuav siv lub ntsiab li cas hauv Microsoft Excel.
03 ntawm 05
Siv Excel Pib Sau
Ua kom peb cov pane pane ua yeeb yam me ntsis ntxiv, peb yuav ceev nrooj nkag qee cov ntaub ntawv uas siv Auto Fill kom cov nyom ntawm cov khov khov yooj yim pom.
Lus Cim: Tus nyeem Customizing Excel Auto Fill qhia koj li cas ntxiv rau koj cov npe kom pib sau.
- Ntaus "Lub Ib Hlis" nyob rau ntawm tes D3 thiab nias qhov ENTER yawm ntawm cov ntawv.
- Xaiv cov xov tooj ntawm tes D3 thiab siv daim ntawv tuav hauv qab ntawm kaum sab xis ntawm D3 rau nws pib lub hlis ntawm lub xyoo xaus nrog Lub Kaum Hli hauv cell M3.
- Ntaus hnub "Monday" hauv xovtooj C4 thiab nias tus ENTER yawm sij.
- Xaiv lub xovtooj ntawm C4 thiab siv daim ntawv tuav kom pib rau hnub pib ntawm lub limtiam tag nrog hnub Tuesday hauv xovtooj C12.
- Ntaus ib tug "1" ntawm D4 thiab ib "2" ntawm D5 cell.
- Xaiv ob lub hlwb D4 thiab D5.
- Siv daim ntawv tuav ntawm D5 cell rau nws pib sau rau D12
- Tso tus nas khawm.
- Siv tus ntawv tuav hauv D12 rau nws pib hla mus rau ntawm M12.
Cov zauv 1 txog 9 yuav tsum tau sau txhua kab D mus rau M.
04 ntawm 05
Cia kom khov lub Panes
Tam sim no rau qhov yooj yim ib feem:
- Nyem ntawm tes D4
- Xaiv Qhov Rais> Khaws Dej Tseg ntawm cov zaub mov
Ib txoj kab dub ntsug yuav tshwm ntawm kab C thiab D thiab ib txoj kab ntawm kab 3 thiab 4.
Kab 1 mus rau 3 thiab kab A rau C yog qhov chaw khov ntawm qhov screen.
05 ntawm 05
Tshawb xyuas cov ntsiab lus
Siv cov sub scroll mus saib cov nyhuv ntawm cov thawv khov rau ntawm ib qho kev tshaj tawm.
Scroll Down
- Siv cov voj scroll xub hauv Excel kom scroll. Cov kab 1 mus rau 3 yuav tsum nyob twj ywm rau hauv kev tshuaj ntsuam, nrog rau lub hlis ntawm lub xyoo thaum cov zauv 1 txog 9 tawm ntawm nplooj ntawv tshaj tawm.
Rov qab mus rau ntawm D4
- Nias rau ntawm Lub Thawv Npe saum toj kem kem A
- Hom D4 hauv lub Thawv Npe thiab nias qhov ENTER yawm ntawm cov ntawv. Tus xov tooj ntawm tes ua D4 ib zaug dua.
Scroll Across
- Siv cov kab rov tav hla mus rau sab xis. Kem A yuav tsum tau nyob twj ywm ntawm qhov screen, nrog rau cov zauv, thaum lub hlis ntawm lub xyoo tawm ntawm spreadsheet page.