Feem ntau, Excel tuaj yeem tshawb pom cov ntawv sib cais tab thiab muab nws tso rau hauv kab sib txawv. Txawm li cas los xij, yog tias qhov kev kuaj pom nws tus kheej tsis ua haujlwm thiab tag nrho cov ntawv koj tau theej tau muab tso rau hauv ib kab, koj yuav tsum tau txheeb xyuas koj li Excel teeb tsa lossis cov ntawv koj tau muab tso rau. Excel yuav raug teeb tsa kom lees txais tus yam ntxwv sib cais sib txawv, lossis cov ntawv koj muab tshuaj txhuam yuav raug cais los ntawm qhov chaw tsis yog tabs. Cov Ntawv rau Kab ua haujlwm hauv Excel tuaj yeem xaiv tus cim cais cais, thiab cais cov ntaub ntawv rau hauv kab sib txawv kom raug.
Kauj ruam
Kauj Ruam 1. Luam tag nrho tab cais cov ntawv
Tab-delimited ntawv yog hom ntawv khaws cia cov ntxhuav hauv daim ntawv ntawm cov ntawv. Txhua lub xov tooj ntawm tes tau sib cais los ntawm tabs, thiab txhua qhov nkag yog nws tus kheej kab. Xaiv cov ntawv koj xav theej rau hauv Excel, tom qab ntawv luam cov ntawv.
Kauj Ruam 2. Hauv Excel, xaiv cov xov tooj ntawm tes
Cov ntaub ntawv koj theej yuav muab tso rau hauv lub cell uas koj tau xaiv thiab cov cell hauv qab no thiab rau sab xis ntawm nws.
Kauj Ruam 3. Muab cov ntaub ntawv uas koj nyuam qhuav tau theej
Yog tias koj siv Excel tshiab, thiab yog tias koj cov ntaub ntawv tau tab-cais, cov ntaub ntawv yuav raug muab tso rau hauv cov hlwb tsim nyog. Cov tab ntawm cov ntaub ntawv yuav yog tus cim tshiab ntawm tes. Yog tias tag nrho koj cov ntaub ntawv tshwm nyob rau hauv ib kab, txheeb xyuas koj li Excel teeb tsa kom paub tseeb tias koj lees txais hom kev cais tus yam ntxwv, xws li tus lej. Koj tuaj yeem hloov tus cim cais cais los ntawm Cov Ntawv rau Kab ua haujlwm.
Kauj Ruam 4. Xaiv kab ntawv uas muaj cov ntaub ntawv
Yog tias koj cov ntaub ntawv tsis raug muab tso kom raug, koj tuaj yeem siv Excel cov ntawv ua hauv kab rau kab ua haujlwm kom ua nws.
- Nyem ib kab ntawv nyob rau sab saum toj ntawm lub qhov rais kom xaiv tag nrho kab ntawv.
- Cov Ntawv rau Kab ua haujlwm tsuas tuaj yeem lis cov ntaub ntawv hauv ib kab lus ib zaug.
Kauj Ruam 5. Nyem rau Cov Ntaub Ntawv tab, tom qab ntawd xaiv Cov Ntawv rau Kab
Qhov kev xaiv no nyob hauv ntu Cov Ntaub Ntawv Cov Ntaub Ntawv.
Yog tias koj siv Office 2003, nyem rau Cov Ntawv Qhia> Cov Ntawv rau Kab
Kauj Ruam 6. Xaiv Delimited, ces nyem Next
Excel yuav nrhiav tus xeeb ceem tshwj xeeb ua cov ntaub ntawv cais.
Kauj Ruam 7. Xaiv cov ntaub ntawv cais tus cwj pwm
Yog tias koj cov ntaub ntawv raug cais tab, txheeb xyuas Tab kev xaiv, thiab kos rau lwm qhov kev xaiv. Txheeb xyuas cov ntaub ntawv koj tau muab tso rau tus cim cais. Yog tias koj cov ntaub ntawv raug cais los ntawm ntau qhov chaw tsis yog tabs, kos rau qhov Chaw xaiv, tom qab ntawd xaiv Kho Kho tus lej sib law liag ua ib qho. Txawm li cas los xij, yog tias koj cov ntaub ntawv muaj ntau qhov chaw sib cais los ntawm qhov chaw thiab yog qhov tseeb hauv tib kab lus, txoj kev hloov pauv yuav muaj teeb meem.
Kauj Ruam 8. Xaiv thawj kab ntawv
Tom qab xaiv tus cim cais, koj tuaj yeem teev cov ntaub ntawv hom ntawv hauv txhua kab ntawv. Koj tuaj yeem xaiv ntawm General, Text, lossis Date.
- Xaiv qhov General xaiv yog tias cov ntaub ntawv koj muab tso ua lej thiab ntawv.
- Xaiv Cov Ntawv Xaiv yog tias cov ntaub ntawv koj tab tom muab tsuas yog cov ntawv, xws li lub npe.
- Xaiv Hnub Xaiv yog tias cov ntaub ntawv koj tab tom muab yog cov txheej txheem hnub tim.
Kauj Ruam 9. Rov ua qhov txheej txheem hloov dua siab tshiab rau lwm kab ntawv los ntawm xaiv kab ntawv uas xav tau thiab xaiv hom ntawv
Koj tseem tuaj yeem tsis quav ntsej qee kab lus thaum hloov cov ntaub ntawv.
Kauj ruam 10. Ua kom tiav cov txheej txheem
Tom qab koj tau teeb tsa txhua kab ntawv, nyem Ua Ntej txhawm rau siv cov kev hloov pauv. Koj cov ntaub ntawv yuav raug cais raws li qhov chaw koj tau xaiv hauv kab ntawv rau kab lus window.
