Kev luam tawm ntawv sau hauv Microsoft Excel

Feem ntau lub hom phiaj qhov kawg ntawm kev ua haujlwm ntawm daim ntawv Excel yog los luam nws. Tab sis, hmoov tsis, tsis yog txhua tus neeg siv paub yuav ua li cas tus txheej txheem no, tshwj xeeb tshaj yog tias koj yuav tsum luam tawm tsis yog txhua cov ncauj lus ntawm phau ntawv, tab sis tsuas yog qee nplooj ntawv xwb. Cia peb pom yuav ua li cas luam daim ntawv hauv Excel.

Tso zis rau lub tshuab luam ntawv

Ua ntej koj pib luam tawm cov ntaub ntawv, koj yuav tsum paub tseeb tias lub tshuab luam ntawv tau txuas nrog koj lub khoos phis tawm thiab cov kev teeb tsa tsim nyog tau tsim nyob rau hauv Windows operating system. Ib qho ntxiv, lub npe ntawm cov khoom siv uas koj npaj yuav luam tawm yuav tsum pom nws dhau ntawm Excel interface. Txhawm rau txhawm rau paub tseeb tias kev sib txuas thiab chaw teeb tsa yog, mus rau hauv lub tab Cov ntaub ntawvCov. Tom ntej no, tsiv mus rau ntu "Luam Tawm"Cov. Nyob rau hauv nruab nrab ib feem ntawm lub qhov rais qhib hauv lub thaiv "Luam Ntawv" lub npe ntawm cov khoom siv uas koj npaj siab yuav luam tawm cov ntaub ntawv yuav tsum pom.

Tab sis txawm hais tias lub cuab yeej raug tso tawm kom raug, qhov no tsis tuaj yeem lav tias nws txuas nrog. Qhov tseeb no tsuas txhais tau hais tias nws raug kho kom raug nyob hauv txoj haujlwm. Yog li no, ua ntej luam ntawv, nco ntsoov tias lub tshuab luam ntawv tau txuas nrog lub network thiab txuas nrog lub khoos phis tawm ntawm cable lossis wireless network.

Txoj Kev 1: luam tawm tag nrho cov ntawv

Tom qab qhov kev sib txuas tau lees tias, koj tuaj yeem txuas ntxiv mus luam tawm cov ncauj lus ntawm Excel ntawv. Qhov yooj yim tshaj plaws los luam tawm tag nrho cov ntawv. Nov yog qhov peb yuav pib.

1. Mus rau hauv lub tab Cov ntaub ntawv.



2. Tom ntej no peb tsiv mus rau ntu "Luam Tawm"los ntawm nyem rau ntawm cov khoom sib nug hauv cov ntawv qhia hauv sab laug ntawm lub qhov rai uas qhib.



3. Lub tshuab luam ntawv pib. Tom ntej no, mus rau qhov kev xaiv ntawm ntaus ntawv. Hauv dab teb "Luam Ntawv" Lub npe ntawm cov cuab yeej uas koj npaj yuav luam tawm yuav tsum pom. Yog tias lub npe ntawm lwm lub tshuab luam ntawv muaj nyob rau ntawd, koj yuav tsum nyem nws thiab xaiv cov kev xaiv uas haum rau koj los ntawm daim ntawv teev cia.



4. Tom qab ntawd, peb tsiv mus rau cov chaw thaiv nyob hauv qab. Txij li peb xav tau luam tawm txhua yam ntawm cov ntawv, nyem rau thawj qhov chaw thiab xaiv los ntawm cov npe uas tshwm "Luam tawm tag nrho phau ntawv".



5. Hauv daim teb txuas ntxiv, koj tuaj yeem xaiv cov ntawv luam tawm twg los ua:
   • Ib Leeg Ntawv Ib Leeg;
   • Muab ob tog tso nrog ib qho ntxeev ntawm txoj ntug ntev heev;
   • Muab ob tog tso nrog ib qho ntxeev ntawm txoj kev ntug luv.

   Ntawm no nws yog twb tsim nyog los ua tus xaiv raws li cov hom phiaj tshwj xeeb, tab sis thawj qhov kev xaiv tau teeb tsa los ntawm lub neej ntawd.



6. Hauv cov ntawv txuas ntxiv, koj yuav tsum xaiv seb yuav sau cov ntawv luam rau peb lossis tsis sau. Hauv thawj kis, yog tias koj luam ob peb daim ntawv ntawm tib daim ntawv, txhua daim ntawv yuav luam tawm tam sim hauv kev txiav txim: thawj daim ntawv, tom qab ntawv thib ob, thiab lwm yam. Hauv rooj plaub thib ob, lub tshuab luam ntawv luam tawm tam sim txhua daim ntawv luam ntawm thawj daim ntawv ntawm txhua daim ntawv luam, tom qab ntawv thib ob, thiab lwm yam. Qhov kev xaiv no muaj txiaj ntsig tshwj xeeb tshaj yog tias tus neeg siv luam tawm ntau cov ntawv luam ntawm daim ntawv, thiab yuav pab txhawb rau kev txheeb ntawm nws cov ntsiab lus. Yog tias koj luam ib daim ntawv luam tawm, tom qab ntawd cov chaw teeb tsa no tsis tseem ceeb rau tus neeg siv khoom.



7. Ib qho chaw teeb tsa tseem ceeb heev Kev Cob QhiaCov. Daim teb no txiav txim siab seb qhov twg cov kev teeb tsa yuav luam tawm ua: hauv duab kos lossis toj roob hauv pes. Hauv thawj kis, qhov siab ntawm daim ntawv yog ntau dua nws qhov dav. Hauv cov kab ke toj roob hauv pes, qhov dav ntawm daim ntawv yog qhov ntau dua li qhov siab.



8. Daim teb tom ntej txiav txim siab qhov loj ntawm nplooj ntawv luam tawm. Qhov kev xaiv ntawm daim ntawv no feem ntau yog nyob ntawm qhov loj ntawm daim ntawv thiab qhov muaj peev xwm ntawm lub tshuab luam ntawv. Feem ntau, siv hom ntawv A4Cov. Nws tau teev nyob rau hauv qhov chaw pib. Tab sis qee zaum koj yuav tsum siv lwm qhov ntau thiab tsawg.



9. Hauv lub tshav pob tom ntej, koj tuaj yeem tsim qhov loj me me teb. Tus nqi qub yog "Teb teb"Cov. Nyob rau hauv hom kev teeb tsa no, qhov loj me rau thaj chaw qaum thiab thaj yog 1.91 cmlaug thiab sab xis 1.78 cmCov. Ib qho ntxiv, nws yog qhov tsim tau los tsim cov hom hauv qab no:
   • Dav;
   • Nqaim;
   • Kawg kev cai nqi.

   Kuj, qhov loj me ntawm daim teb tuaj yeem tsim tau manually, raws li peb yuav tham txog hauv qab no.



10. Hauv daim teb txuas ntxiv, daim ntawv yog luam. Cov kev xaiv hauv qab no yog muaj rau xaiv cov lus no:
    • Tam Sim No (cov ntawv luam tawm ntawm nplooj ntawv nrog qhov loj me) - los ntawm neej ntawd;
    • Haum cov ntawv rau ib nplooj;
    • Haum rau txhua kab ntawm ib nplooj ntawv;
    • Haum rau txhua kab ntawm ib nplooj ntawv.



11. Ntxiv rau, yog tias koj xav teeb tsa tus kheej los ntawm kev teeb tsa tus nqi tshwj xeeb, tab sis tsis tas yuav siv cov kev teeb tsa saum toj no, koj tuaj yeem mus Kev Xaiv Scaling Xaiv.

    

    Hloov pauv, koj tuaj yeem nyem rau ntawm cov ntawv sau Nplooj Ntawv Chaw, uas yog nyob rau hauv qab heev kawg ntawm daim ntawv teev npe chaw.



12. Nrog ib qho ntawm cov yeeb yam saum toj no, kev hloov pauv mus rau lub qhov rais hu ua Nplooj Ntawv ChawCov. Yog tias nyob hauv cov chaw saum toj saud nws tuaj yeem xaiv los ntawm cov kev teeb tsa ua ntej, tom qab ntawd tus neeg siv muaj lub sijhawm los kho cov zaub ntawm cov ntawv raws li nws xav tau.

    Hauv thawj kab ntawv ntawm lub qhov rais no, uas hu ua "Nplooj ntawv" koj tuaj yeem kho qhov nplai los ntawm kev qhia tseeb nws feem pua, kev qhia (duab lossis toj roob hauv pes), daim ntawv loj thiab cov ntawv luam tawm tau zoo (lub neej ntawd 600 dpi).



13. Nyob hauv tab "Liaj teb" kev hloov kho zoo ntawm daim teb yog tus nqi. Nco ntsoov, peb tau hais txog qhov tshwj xeeb me ntsis. Ntawm no koj tuaj yeem tsim qhov tseeb, qhia nyob rau hauv cov lus hais meej, tsis txwv ntawm txhua daim teb. Tsis tas li ntawd, koj tuaj yeem tsim kho tam sim no mus rau kab rov tav lossis nruab nrab.



14. Nyob hauv tab "Headers thiab footers" Koj tuaj yeem tsim footers thiab kho lawv qhov chaw nyob.



15. Nyob hauv tab Ntawv ntawv Koj tuaj yeem kho cov zaub ntawm cov kab, uas yog, cov kab uas yuav muab luam tawm rau txhua daim ntawv hauv qhov chaw tshwj xeeb. Tsis tas li, koj tuaj yeem hloov kho tam sim ntawd ib theem zuj zus ntawm cov nplooj ntawv tawm mus rau lub tshuab luam ntawv. Nws tseem muaj peev xwm luam tawm kab sib chaws ntawm daim ntawv nws tus kheej, uas los ntawm lub neej ntawd tsis luam tawm, kab ntawv thiab kem kab ntawv, thiab qee yam khoom.



16. Tom qab lub qhov rais Nplooj Ntawv Chaw txhua lub sijhawm ua tiav, tsis txhob hnov ​​qab nias lub khawm "OK" nyob rau hauv nws qhov qis qis hauv seem txhawm rau kom txuag tau lawv rau kev luam ntawv.



17. Peb rov qab mus txog ntu "Luam Tawm" tab Cov ntaub ntawvCov. Qhov saib ua ntej yog nyob ntawm sab xis ntawm lub qhov rais uas qhib. Nws qhia txog feem ntawm cov ntaub ntawv uas tau tshwm rau ntawm lub tshuab luam ntawv. Los ntawm lub neej ntawd, yog tias koj tsis tau ua ib qho kev hloov pauv ntxiv rau ntawm cov chaw, tag nrho cov ntsiab lus ntawm cov ntawv yuav tsum luam tawm, uas txhais tau tias tag nrho cov ntaub ntawv yuav tsum tshwm nyob hauv thaj chaw saib ua ntej. Txhawm rau kom paub tseeb txog qhov no, koj tuaj yeem kos cov kab ntawv scroll.



18. Tom qab kev teeb tsa uas koj xav tias tsim nyog tau teeb tsa tau qhia, nyem rau ntawm lub pob "Luam Tawm"nyob rau hauv tib seem ntawm seem Cov ntaub ntawv.



19. Tom qab ntawd, txhua yam txheem ntawm cov ntawv yuav luam tawm ntawm lub tshuab luam ntawv.

Muaj lwm txoj kev xaiv rau luam ntawv teeb tsa. Nws tuaj yeem ua los ntawm kev mus rau lub tab Nplooj Phaj NtawvCov. Cov ntawv luam tawm cov khoom luam tawm muaj nyob rau hauv lub thawv ntawv. Nplooj Ntawv ChawCov. Raws li koj tuaj yeem pom, lawv yuav luag zoo tib yam li hauv daim kab ntawv Cov ntaub ntawv thiab raug tswj hwm los ntawm tib lub hauv paus ntsiab lus.

Txhawm rau mus rau hauv lub qhov rais Nplooj Ntawv Chaw koj yuav tsum nyem rau lub cim nyob hauv daim ntawv ntawm ib tus xub oblique nyob rau hauv qis sab xis ntawm cov block ntawm tib lub npe.

Tom qab ntawd, lub kaw lus twb paub lawm lub qhov rai yuav tsim tawm, uas koj tuaj yeem ua raws li cov teeb meem saum toj no.

Txoj Kev 2: luam tawm ntau cov nplooj ntawv

Qhov saum toj no, peb tau saib yuav ua li cas teeb tsa luam ntawv ntawm ib phau zuj zus, thiab tam sim no cia saib seb yuav ua li cas thiaj ua tau li no rau qee tus neeg yog tias peb tsis xav sau tag nrho cov ntawv.

1. Ua ntej tshaj plaws, peb yuav tsum txiav txim siab seb nplooj ntawv twg hauv tus account yuav tsum luam tawm. Txhawm rau kom ua tiav txoj haujlwm no, mus rau nplooj ntawv hom. Qhov no tuaj yeem ua los ntawm txhaj rau lub cim. "Nplooj ntawv", uas yog nyob rau ntawm bar xwm txheej hauv nws sab xis.

   

   Kuj tseem muaj lwm txoj kev hloov. Ua li no, mus rau ntawm lub tab "Saib"Cov. Tom ntej no nyem rau ntawm lub pob Nplooj Hom, uas yog nyob rau ntawm txoj xov ntawm lub xov thaiv Phau Ntawv Saib Cov Qauv.



2. Tom qab ntawd, nplooj ntawv saib hom ntawv ntawm daim ntawv pib. Raws li koj tuaj yeem pom, hauv nws cov ntawv txheeb tau sib cais los ntawm sib txawv los ntawm ciam teb dashed, thiab lawv tus lej pom tau pom tom qab ntawm cov ntaub ntawv keeb kwm yav dhau los. Tam sim no koj yuav tsum nco ntsoov tus lej ntawm cov nplooj ntawv uas peb tab tom luam.



3. Raws li lub sijhawm dhau los, txav mus rau ntawm lub tab Cov ntaub ntawvCov. Tom qab ntawd mus rau ntu ntawd "Luam Tawm".



4. Muaj ob daim teb nyob rau hauv cov chaw NploojCov. Hauv thawj daim ntawv peb qhia thawj nplooj ntawv ntawm ntau yam uas peb xav luam tawm, thiab hauv qhov thib ob - tom kawg.

   

   Yog tias koj xav sau ib nplooj ntawv xwb, tom qab ntawd nyob rau ob kab ntawv koj yuav tsum qhia nws tus lej.



5. Tom qab ntawd, yog tias tsim nyog, peb ua txhua txoj kev teeb tsa uas tau sib tham thaum siv Txoj Kev 1Cov. Ntxiv mus, nyem rau ntawm lub pob "Luam Tawm".



6. Tom qab ntawd, lub tshuab luam ntawv luam tawm cov kab ntawv ntawm nplooj ntawv lossis ib daim ntawv teev nyob hauv cov chaw.

Txoj Kev 3: luam tawm ib nplooj ntawv

Tab sis dab tsi yog tias koj yuav tsum luam tawm tsis yog ib chav, tab sis ob peb thaj tsam ntawm nplooj ntawv lossis ob peb daim ntawv sib txawv? Yog hais tias nyob hauv cov nplooj ntawv nplooj thiab cov kab lus yuav tau teev nrog cov tsis nco qab, tom qab ntawd hauv Excel tsis muaj qhov kev xaiv zoo li no. Tab sis tseem muaj txoj hauv kev tawm ntawm qhov xwm txheej no, thiab nws nyob ntawm ib qho cuab yeej hu ua "Luam Cheeb Tsam".

1. Peb hloov mus rau Excel nplooj ntawv hom kev ua haujlwm siv ib qho ntawm cov qauv qhia saum toj no. Tom ntej no, sau lub pob ntawm sab laug thiab xaiv cov thaj tsam ntawm cov nplooj ntawv uas peb yuav luam. Yog tias koj yuav tsum xaiv ntau qhov ntau, ces nyem tam sim ntawm nws lub hauv paus (qib siab), tom qab ntawd mus rau lub xovtooj kawg ntawm qhov ntau thiab nyem rau nws nrog sab laug nas khawm thaum tuav cia Ua haujlwmCov. Ua li no, koj tuaj yeem xaiv ob peb nplooj ntawv sib law liag ntawm ib zaug. Yog tias, ntxiv rau qhov no, peb xav sau ntau tus lej lossis kab ntawv, peb xaiv cov ntawv tsim nyog nrog khawm nias XuasCov. Yog li, txhua qhov tsim nyog yuav tsum tau tseem ceeb.



2. Tom qab ntawd, tsiv mus rau ntawm lub tab Nplooj Phaj NtawvCov. Hauv lub thawv Nplooj Ntawv Chaw rau ntawm txoj hlua khi, nyem rau ntawm lub pob "Luam Cheeb Tsam"Cov. Tom qab ntawd cov ntawv qhia me me tuaj. Xaiv cov khoom hauv nws "Teeb".



3. Tom qab qhov kev ua no, peb rov qab mus rau saum lub tab Cov ntaub ntawv.



4. Tom ntej no peb tsiv mus rau ntu "Luam Tawm".



5. Hauv cov nqis hauv qhov tsim nyog teb, xaiv "Luam Ntawv Xaiv".



6. Yog tias tsim nyog, peb ua lwm qhov chaw, uas tau piav qhia txhua yam hauv Txoj Kev 1Cov. Tom qab ntawd, nyob hauv thaj chaw saib ua ntej, peb saib zoo ib yam twg cov ntawv luam tawm. Yuav tsum muaj tsuas yog cov tawg tsam uas peb tau qhia meej hauv thawj kauj ruam ntawm hom no.



7. Tom qab tag nrho cov nqis nkag mus rau thiab qhov tseeb ntawm lawv cov zaub, koj tau ntseeg ntawm lub qhov rais saib ua ntej, nyem rau ntawm lub pob "Luam Tawm".



8. Tom qab qhov kev txiav txim no, cov ntawv xaiv tau yuav tsum tau muab luam tawm ntawm lub tshuab luam ntawv txuas nrog rau lub khoos phis tawm.

Los ntawm txoj kev, tib txoj kev, los ntawm kev teeb tsa thaj chaw xaiv, koj tuaj yeem luam tsis tsuas cov ntawv ib leeg, tab sis tseem sau cov kab ntawm cov hlwb lossis cov rooj hauv cov ntawv. Lub hauv paus ntsiab lus ntawm kev sib cais nyob rau hauv cov ntaub ntawv no tseem zoo ib yam li nyob rau hauv cov xwm txheej tau piav qhia saum toj no.

Tshooj: Yuav ua li cas teev thaj chaw luam hauv Excel 2010

Raws li koj tuaj yeem pom, txhawm rau teeb tsa kev luam tawm ntawm cov khoom tsim nyog hauv Excel hauv daim ntawv uas koj xav tau, koj yuav tsum tau tinker me ntsis. Ib nrab ntawm cov teeb meem, yog tias koj xav sau tag nrho cov ntawv, tab sis yog tias koj xav sau nws cov ntsiab lus ib qho (ntu, nplooj ntawv, thiab lwm yam), ces cov teeb meem pib. Txawm li cas los xij, yog tias koj paub zoo txog cov cai rau luam ntawv cov ntaub ntawv hauv cov ntawv pov thawj no, koj tuaj yeem daws cov teeb meem zoo. Zoo, thiab hais txog cov hau kev ntawm kev daws teeb meem, hauv kev tshwj xeeb los ntawm teeb tsa thaj chaw luam tawm, kab lus no tsuas yog qhia.