Qhov wikiHow qhia koj yuav tsim daim ntawv hauv Microsoft Excel ntawv li cas. Daim ntawv nthuav tawm daim ntawv tso cai rau koj nkag mus sai cov ntaub ntawv loj rau hauv lub rooj lossis cov npe ntawm cov cell. Yog tias koj xav tsim daim ntawv uas lwm tus neeg tuaj yeem sib cuam tshuam, koj tuaj yeem siv cov kev xaiv pom ntawm tus tsim tawm tab ntawm Excel los ua li ntawd. Nco ntsoov tias cov ntaub ntawv nkag teb chaws cov yam ntxwv tsuas yog muaj nyob hauv Excel rau Windows khoos phis tawj.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Tsim Daim Ntawv Nkag Rau Cov Ntaub Ntawv
Kauj Ruam 1. Qhib Excel
Nyem lossis ob npaug nyem rau Excel lub cim app, uas zoo ib yam li dawb "X" ntawm qhov tsaus ntuj-ntsuab keeb kwm yav dhau.
Kauj Ruam 2. Nyem Phau ntawv ua haujlwm dawb paug
Nws nyob rau sab saud sab laug ntawm nplooj ntawv.
Kauj Ruam 3. Ntxiv khawm "Daim Ntawv" rau Excel
Los ntawm lub neej ntawd, khawm "Daim Ntawv" tsis suav nrog hauv Excel. Koj tuaj yeem ntxiv nws rau Excel cov npe ntawm "Kev Nkag Mus Ceev" cov cim uas tshwm nyob rau sab saum toj-sab laug ntawm lub qhov rais los ntawm kev ua cov hauv qab no:
- Nyem Cov ntaub ntawv.
- Nyem Kev xaiv hauv qab-sab laug ntawm lub qhov rais.
- Nyem Kev Nkag Mus Ceev ntawm sab laug ntawm lub qhov rais.
- Nyem rau "Xaiv cov lus txib" los ntawm lub npov uas nyob saum lub qhov rais.
- Nyem Txhua Cov Lus txib.
- Scroll cia kom txog thaum koj mus txog Daim ntawv, ces nyem nws.
- Nyem Ntxiv >> nyob nruab nrab ntawm lub qhov rais.
- Nyem OK.
Kauj Ruam 4. Nkag mus rau koj kab ntawv kab taub hau
Ntaus lub npe ntawm kab ntawv uas koj xav ntxiv cov ntaub ntawv rau sab saum toj ntawm txhua lub kem koj xav siv.
Piv txwv li, yog tias koj tab tom tsim ib daim ntawv uas teev cov khoom sib txawv, koj tuaj yeem ntaus "Pumpkin Bread" rau hauv xovtooj A1, "Muffins" rau hauv cell B1, thiab ntxiv rau.
Kauj Ruam 5. Xaiv koj kab ntawv kab taub hau
Nyem thiab tuav sab laug-feem ntau kab ntawv kab ntawv, tom qab ntawd rub koj tus nas mus rau sab xis-feem ntau kab ntawv kab ntawv. Koj tuaj yeem tso koj tus nas khawm.
Kauj Ruam 6. Nyem rau "Daim Ntawv" khawm
Nws yog lub npov zoo li lub cim nyob rau sab saud sab laug ntawm lub qhov rais Excel, tsuas yog sab xis ntawm txoj cai-tig "Rov ua dua" khawm.
Kauj Ruam 7. Nyem OK thaum hais kom sai
Ua li ntawd qhib lub Form pop-up window.
Kauj Ruam 8. Sau cov ntaub ntawv rau koj thawj kab
Ntaus txhua yam koj xav ntxiv rau hauv txhua kab ntawv kab ntawv lub taub hau kab ntawv.
Kauj Ruam 9. Nyem Tshiab
Nws yog nyob rau sab saud-sab xis ntawm lub qhov rai pop-up. Ua qhov no yuav cia li nkag koj cov ntaub ntawv ntaus rau hauv daim ntawv nthuav tawm hauv qab kab ntawv tsim nyog.
Kauj Ruam 10. Nkag mus rau kab tom ntej ntawm cov ntaub ntawv
Txhua lub sijhawm koj ua tiav kev sau cov ntaub ntawv nkag teb, nyem Tshiab yuav nkag mus rau koj cov ntaub ntawv thiab pib kab tshiab.
Kauj Ruam 11. Kaw cov ntaub ntawv nkag teb chaws
Nyem Kaw ntawm sab xis ntawm lub qhov rais kom ua li ntawd. Tam sim no koj cov ntaub ntawv yuav tsum tau ua kom tiav hauv qab kab ntawv tsim nyog headers.
Txoj Kev 2 ntawm 2: Tsim Tus Qauv Tshwj Xeeb
Kauj Ruam 1. Qhib Excel
Nyem lossis ob npaug nyem rau Excel lub cim app, uas zoo ib yam li dawb "X" ntawm qhov tsaus ntuj-ntsuab keeb kwm yav dhau.
Kauj Ruam 2. Nyem Phau ntawv ua haujlwm dawb paug
Nws nyob rau sab saud sab laug ntawm nplooj ntawv.
Kauj Ruam 3. Pab kom tus tsim tawm tab
Cov Tsim tawm tab yog qhov uas koj yuav pom qhov kev xaiv rau ntxig daim ntawv khawm, tab sis nws tsis suav nrog hauv Excel los ntawm lub neej ntawd. Txhawm rau pab nws, ua cov hauv qab no:
- Windows - Nyem Cov ntaub ntawv, nyem Kev xaiv, nyem Customize Ribbon, khij lub npov "Developer", thiab nyem rau OK.
- Mac - Nyem Excel, nyem Nyiam …, nyem Sau ntawv hauv qab "Saib" nqe lus, thiab nyem Tus tsim tawm tab. Koj tuaj yeem kaw lub qhov rais.
Kauj Ruam 4. Sau koj daim ntawv cov ntaub ntawv
Ntaus cov ntaub ntawv twg los xij koj xav kom cov neeg siv tuaj yeem xaiv hauv koj daim ntawv.
Cov kauj ruam no yuav txawv nyob ntawm cov ntaub ntawv koj xav siv hauv koj daim ntawv
Kauj Ruam 5. Nyem rau Tus Tsim Tawm tab
Nws nyob rau sab saum toj ntawm Excel qhov rai.
Kauj Ruam 6. Nyem Ntxig
Qhov kev xaiv no nyob hauv ntu "Tswj" ntawm Tsim tawm toolbar. Nyem rau nws ua kom cov ntawv qhia zaub mov nco-down tshwm.
Hla qhov kauj ruam no ntawm Mac
Kauj Ruam 7. Xaiv daim ntawv tswj
Nyem hom kev tswj hwm uas koj xav siv rau koj daim ntawv teev npe.
Piv txwv li, yog tias koj xav ntxiv lub npov rau koj daim ntawv, koj yuav nyem lub cim cim cim
Kauj Ruam 8. Nyem qhov twg ntawm daim ntawv nthuav tawm
Ua li ntawd yuav tso koj lub khawm tswj ntawm daim ntawv nthuav qhia.
Koj tuaj yeem nyem thiab rub koj txoj kev tswj hwm mus rau qhov chaw uas koj xav thauj nws
Kauj Ruam 9. Right-click daim ntawv tswj lub cim
Cov ntawv qhia zaub mov nco-down yuav tshwm.
Ntawm Mac, tuav tswj thaum nyem lub cim
Kauj ruam 10. Nyem Format Control…
Nws nyob hauv qab ntawm cov ntawv qhia zaub mov nco-down.
Kauj Ruam 11. Kho koj daim ntawv tswj khawm
Nyob ntawm lub pob uas koj xaiv, koj cov kev xaiv yuav txawv; Feem ntau, koj yuav tuaj yeem xaiv lub xov tooj ntawm tes lossis lub hom phiaj ntawm tes los ntawm txhaj rau xub sab xis ntawm "Cell range" lossis "Target cell" text box thiab tom qab ntawd xaiv cov cell (lossis cell) uas muaj koj li. cov ntaub ntawv cov ntaub ntawv.
Piv txwv li, yog tias koj xav tsim cov ntawv qhia zaub mov nco nrog cov npe ntawm cov lej, koj yuav nyem lub xub xub mus rau sab xis ntawm kab ntawv "Cell range" thiab tom qab ntawd nyem thiab rub koj tus nas hauv kab ntawm cov lej hauv koj daim ntawv nthuav tawm
Kauj ruam 12. Nyem OK
Nws nyob hauv qab ntawm lub qhov rais. Ua li ntawd txuag koj cov chaw thiab siv lawv rau koj daim ntawv teev npe.
Txij ntawm no mus, koj tuaj yeem txuas ntxiv nrog lwm daim ntawv khawm rau koj daim ntawv nthuav dav
Kauj Ruam 13. Tiv thaiv koj daim ntawv teev npe
Thaum koj tau ua tiav ntxiv cov khawm khawm rau koj daim ntawv teev npe, koj tuaj yeem tiv thaiv tib neeg los ntawm kev txav lossis tshem cov nyees khawm los ntawm kev tiv thaiv daim ntawv nthuav tawm:
- Windows - Nyem Ntsuam xyuas hauv Excel toolbar, nyem rau Tiv Thaiv Ntawv, nco ntsoov tias ib qho kev xaiv uas tsis yog "Xaiv cov cell xauv" thiab "Xaiv cov cell xauv" tsis raug txheeb xyuas, sau tus password kom qhib daim ntawv, thiab nyem OK. Tom qab ntawv koj tuaj yeem rov nkag tus password thaum hais kom ua tiav xauv daim ntawv.
- Mac - Nyem Cov cuab yeej nyob rau sab saum toj ntawm qhov screen, xaiv Kev tiv thaiv, nyem Tiv Thaiv Ntawv nyob rau hauv cov ntawv qhia zaub mov pop-out, nco ntsoov tias ib qho kev xaiv uas tsis yog "Xaiv cov cell xauv" thiab "Xaiv lub xauv lub xov tooj" tsis raug txheeb xyuas, sau tus password kom qhib daim ntawv, thiab nyem OK. Tom qab ntawv koj tuaj yeem rov nkag tus password thaum hais kom ua tiav xauv daim ntawv.