Lus Qhia rau Excel 2003 - 2016
Muaj txhua txoj kab zoo thiab kab, cais cov peev xwm, thiab cov ntaub ntawv nkag mus, Excel yuav yog qhov zoo rau kev nkag mus thiab khaws cia cov ntaub ntawv xws li cov npe hu. Thaum koj tau tsim ib daim ntawv teev cov ncauj lus kom ntxaws, koj tuaj yeem siv nws nrog lwm cov kev siv Microsoft Office rau ntau cov dej num. Nrog txoj kev xa ntawv sib txuas lus nyob rau hauv MS Word, koj tuaj yeem sau ntawv xa ntawv tuaj ntawm Excel hauv ib qho teeb meem ntawm feeb. Kawm yuav ua li cas luam tawm cov ntawv sau los ntawm Excel nyob ntawm seb qhov twg ntawm Lub Chaw Khiav Haujlwm uas koj siv.
Excel 2016, Excel 2013, Excel 2010 lossis Excel 2007
Npaj Cov Ntawv Sau Npe
Yuav ua kom cov ntawv xa ntawv tuaj ntawm Excel, koj daim ntawv khom nqi yuav tsum teeb tsa kom zoo. Ntaus nyob hauv nqe lus hauv thawj lub xovtooj ntawm txhua kab ntawv qhia txog cov ntaub ntawv nyob rau hauv sab ntawv kom meej thiab meej kawg. Ua ib kem rau txhua lub caij koj xav muab tso rau hauv daim ntawv lo. Piv txwv li, yog tias koj xav tsim cov ntawv xa email los ntawm Excel, tej zaum koj yuav muaj cov kab lus nram qab no:
- Title (Mr./Ms./Dr.)
- Thawj Lub Npe
- Lub Xeem
- Chaw Nyob
- Nroog
- Xeev
- Zip Code
Sau cov ntaub ntawv
Sau cov npe thiab chaw nyob lossis lwm cov ntaub ntawv uas koj xav tau thaum koj luam cov ntawv sau los ntawm Excel. Nco ntsoov txhua qhov khoom nyob rau sab tseeb. Tsis txhob tawm hauv txhua kab lus los yog kab hauv daim ntawv. Txuag daim ntawv khom nqi thaum koj tau ua tas lawm.
Tshaj Tawm Cov Ntaub Ntawv Thov
Thawj lub sij hawm koj txuas mus rau ib daim ntawv ua haujlwm Excel uas yog los ntawm Lo Lus, koj yuav tsum tso cai rau koj hloov cov ntaub ntawv ntawm ob qhov kev pab cuam.
- Hauv Lo Lus, nyem rau ntawm Daim Ntawv Tab thiab xaiv Cov Kev Xaiv nyob hauv qab ntawm kab laug sab laug.
- Nias Tshawb xyuas nyob rau sab laug pane ntawm qhov Xaiv Qhov Xaiv Qhov Rooj thiab tom qab mus rau Ntu.
- Xyuas kom tseeb tias Daim Ntawv Pom Zoo Ua Ntaub Ntawv Tawm Hauv Kev Qhib Qhib Xaiv thiab nias OK .
Teeb Tsa Ntawv Sau Npe
- Qhib ib phau ntawv dawb paug.
- Mus rau hauv Mailings tab, xaiv Start Mail Merge thiab nias rau Cov Ntawv Qhia .
- Xaiv cov hom npe rau hauv lub thawv ntawv muag khoom thiab xaiv cov khoom muag, uas teev rau ntawm pob ntawv sau. Koj tuaj yeem xaiv Cov Ntawv Sau Npe Tshiab yog tias koj xav sau cov ntawv cim npe.
- Nyem OK thaum koj npaj txhij mus.
Muab cov ntawv txheeb rau cov ntawv lo
Ua ntej ua tiav qhov kev sib tshuam los sau cov chaw nyob ntawm Excel, koj yuav tsum xa daim ntawv Lo Lus mus rau daim ntawv uas muaj koj daim ntawv teev npe.
- Nyob rau hauv Daim Ntawv Xa Mus, nyem Cov Xaiv Cov Neeg Xa Ntawv hauv Kev Xa Ntawv Qhia Cov Kev Xa Ntawv thiab xaiv Cov Lus Qhia Uas Muaj Muaj .
- Next rau cov ntawv ua haujlwm Excel uas muaj koj daim ntawv teev npe hauv Xaiv Cov Ntaub Ntawv Xaiv Qhov Tseeb qhov rais qhib thiab nias Qhib .
- Nyem OK los xyuas tias koj xav siv daim ntawv thiab nyem dua los xaiv lub rooj uas muaj koj daim ntawv teev npe. Cov nplooj ntawv yuav tam sim no tau sau nrog cov ntawv sau hais tias " Daim Ntawv Sau Ntxiv Tom Qab" .
Xa Xa Mus Nkag Rau Ib Daim Teb
Qhov no yog qhov chaw uas koj tau ntxiv rau koj daim ntawv khom nqi Excel yuav tuaj yeem ua ke.
- Nias rau ntawm thawj daim ntawv ntawm nplooj ntawv thiab tom qab xaiv qhov Chaw Pov Tseg ntawm Sau Ntawv & Ntxig Cov Npe ntawm daim ntawv xa tawm.
- Nias lub Xaiv Cov Khawm Tseg rau ntawm Insert Address Block Block dialog.
- Nco ntsoov tias koj lub npe yeej muaj raws li qhov yuav tsum tau muaj. Yog tias qee leej tsis muaj tseeb, siv tus xa rov qab los ntawm nws kom sib haum mus rau qhov tseeb.
- Nyem OK . Nyem dua ib zaug ntxiv kaw lub thawv tawm thiab tom qab ntawd nias Hloov Cov Ntawv Xov Xwm hauv Sau Ntawv Sau & Sau Phaj Teb ntawm Cov Ntawv Xa Mus.
Ua tus Merge
Thaum koj muaj Excel spreadsheet thiab Word tsab ntawv teem, koj tuaj yeem ua ke cov ntaub ntawv thiab luam koj cov ntawv.
- Nyem Finish & Merge hauv Pawg Neeg Saib Xyuas Tom Tsev.
- Nyem Hloov Cov Ntaub Ntawv Tus Kheej los saib ua ntej koj cov ntawv luam tawm yuav tshwm sim. Xaiv Tag nrho thiab nias lawv xav tshuaj .
Daim ntawv tshiab qhib nrog cov ntawv xa ntawv tuaj ntawm koj cov ntawv ua haujlwm Excel. Koj tuaj yeem hloov, luam tawm thiab txuag cov ntawv sau cia li koj yuav tsum muaj lwm yam lus.
Excel 2003
Yog tias koj siv Microsoft Office 2003, cov kauj ruam los ua qhov chaw nyob ntawm Excel yog me ntsis txawv.
Npaj Cov Ntawv Sau Npe
Yuav ua kom cov ntawv xa ntawv tuaj ntawm Excel, koj daim ntawv khom nqi yuav tsum teeb tsa kom zoo. Ntaus nyob hauv nqe lus hauv thawj lub xovtooj ntawm txhua kab ntawv qhia txog cov ntaub ntawv nyob rau hauv sab ntawv kom meej thiab meej kawg. Ua ib kem rau txhua lub caij koj xav muab tso rau hauv daim ntawv lo. Piv txwv li, yog tias koj xav tsim cov ntawv xa email los ntawm Excel, tej zaum koj yuav muaj cov kab lus nram qab no:
- Title (Mr./Ms./Dr.)
- Thawj Lub Npe
- Lub Xeem
- Chaw Nyob
- Nroog
- Xeev
- Zip Code
Sau cov ntaub ntawv
- Sau cov npe thiab chaw nyob lossis lwm cov ntaub ntawv uas koj xav tau thaum koj luam cov ntawv sau los ntawm Excel.
- Nco ntsoov txhua qhov khoom nyob rau sab tseeb. Tsis txhob tawm hauv txhua kab lus los yog kab hauv daim ntawv.
- Txuag daim ntawv khom nqi thaum koj tau ua tas lawm.
Pib lub Merge
- Qhib ntawv tshiab.
- Mus rau ntawm cov ntawv qhia zaub mov, taw tes rau Cov Ntawv Xa thiab Cov Ntawv xa tawm thiab xaiv Xa Ntawv Kev Sib Koom los qhib Kev Xa Ntawv Ua Haujlwm Ua Haujlwm.
- Xaiv cov ntawv thiab nias Tom ntej: Pib Ua Ntaub Ntawv .
- Nias Daim Ntawv Qhia Txog Kev Sau Npe mus qhib Daim Ntawv Qhia Lus Xaiv Tsev.
Xaiv Koj Cov Ntawv Qhia
- Xaiv cov hom npe rau hauv lub thawv ntawv muag khoom thiab xaiv cov khoom muag, uas teev rau ntawm pob ntawv sau. Koj tuaj yeem xaiv Cov Ntawv Sau Npe Tshiab yog tias koj xav sau cov ntawv cim npe.
- Nyem OK thaum koj npaj txhij mus.
Xaiv Koj Qhov Chaw
- Nyem Siv Daim Ntawv Teev Npe hauv Cov Xaiv thiab xaiv Xauj .
- Next rau cov ntawv ua haujlwm Excel uas muaj koj daim ntawv teev npe hauv Xaiv Cov Ntaub Ntawv Xaiv Qhov Tseeb qhov rais qhib thiab nias Qhib . Tus xa ntawv tuaj yeem qhib qhov chaw xa ntawv tuaj.
- Xyuas kom koj cov ntaub ntawv muaj tseeb thiab nias lawv xav tshuaj .
Npaj cov ntawv
- Nyem Tom ntej: Teem Koj Cov Ntawv Qhia .
- Xaiv Chaw Pov Tseg .
- Nias lub Xaiv Cov Khawm Tseg rau ntawm Insert Address Block Block dialog.
- Nco ntsoov tias koj lub npe yeej muaj raws li qhov yuav tsum tau muaj. Yog tias qee leej tsis muaj tseeb, siv tus xa rov qab los ntawm nws kom sib haum mus rau qhov tseeb. Nyem OK .
- Nias Hloov Tagnrho Cov Ntawv Qhia hauv qab Hloov Cov Xovtooj hauv Xov Tooj Sib Tug Sib Tham.
Saib ua ntej thiab xaus
- Siv cov sub hauv qab Saib Ua Ntej Koj cov ntawv kom paub tseeb tias lawv pom tseeb.
- Nyem Tom ntej: Ua kom tiav qhov Merge .
- Yog tias koj xav ua ib qho kev hloov, nias Hloov Cov Ntawv Sau Npe.
- Thaum koj txaus siab rau kev sib tshuam, nyem Sau los luam koj qhov chaw nyob ntawm Excel.