Mirayiridzo yeExcel 2003 - 2016
Kuva nematombo akajeka nemitsetse, kusarudza mano, uye kuiswa kwezvinhu, Dhase ingangodaro kushandiswa kwakakwana kwekupinda nekuchengetedza ruzivo sekutumira mazita. Kana ukangodaro wakanyora rondedzero yakawanda, unogona kuishandisa nemamwe mahofisi eMicrosoft Office emabasa akawanda. Nee mail pakusanganiswa muSMS Word, unogona kudhinda mazita ekunyora kubva kuExcel munyaya yemaminitsi. Dzidza kuti ungadhinda sei mabhii kubva kuExcel zvichienderana neshanduro yehofisi yaunoshandisa.
Excel 2016, Excel 2013, Excel 2010 kana Excel 2007
Gadzirira Pepa Rokushanda
Kuti uite mabhii emareta kubva kuExcel, pepa rako repasiti rinofanira kuiswa zvakanaka. Nyora musimboti mukutanga kese ye column imwe neimwe inotsanangura data iri mumutsara zvakajeka uye pfupi. Ita korona yezvinhu chimwe nechimwe waunoda kuisa pane mavara. Somuenzaniso, kana iwe uchida kuumba mavara emareta kubva kuExcel, unogona kunge uine zvinyorwa zvinotevera:
- Tsamba (Mr./Ms./Dr.)
- Zita rokutanga
- Zita rokupedzisira
- chikero chemugwagwa
- Guta
- State
- Zipi kodhi
Pinda Data
Tora mazita neateri kana imwe dhesi yaunoda apo iwe unonyora mabhii kubva kuExcel. Ita kuti chokwadi chimwe nechimwe chiri muhombe yakarurama. Dzivisa kusiya zvinyorwa zvisina ruvara kana mitsetse mukati memutsara. Chengetedza pepa rebasa kana wapedza.
Tsimbisa Purogiramu Format
Nenguva yekutanga paunosangana neExpcel worksheet kubva paShoko, unofanirwa kugadzirisa hurongwa hunokubvumira kuti uchinje mafaira pakati pezvirongwa zviviri.
- MuShoko, chengetera paFiri yebhu uye sarudza Options pane ezasi reboshwe pane.
- Dzvanya Zvakadzama muchokumucheto chekumanheru kweShoko Options window uye zvino pfugama pasi kusvika kune Zvose zvikamu .
- Iva nechokwadi chekuti Simbisa Purogiramu Yekushandurwa Kwefaira paWorld yakasarudzwa uye chovha OK .
Isai Mavarai muShoko
- Vhura bhuku reShoko risina chinhu.
- Endai kuMavhudziro eMavhura , sarudza Kutanga Mail Merge uye chengeta Mavara .
- Sarudza mararamiro muTeti Vendors bhokisi uye osarudza nhamba yemagetsi, iyo yakanyorwa pane pepa reraire. Unogonawo kusarudza New Label kana iwe uchida kupinda maitiro emakero emhando.
- Dzvanya OK kana wakagadzirira kuenderera mberi.
Unganidza Purogiramu Yebasa kune Mavara
Usati waita kubatanidza kudhinda maekai ekero kubva kuExcel, unofanira kubatanidza chikwata cheShoko pane pepa rekushandira rine chinyorwa chako.
- Pamusoro peTextings tab, sarudza Sarudza Vakagamuchira muboka reMexico Merge uye shandisa Shanduro Inowanikwa .
- Dzokera kune Excel worksheet ine uwandu yako pane Select Data Source window iyo inovhura uye chovha Open .
- Dzvanya OK kuti uone kuti unoda kushandisa urongwa uye bhura OK zvakare kuti usarudze tafura ine chinyorwa chako. Peji yacho ikozvino ichazadzwa nemateera anoti " Next Record" .
Wedzera Mail Merge Fields
Iyi ndiyo iyo misoro iyo yaunowedzera pane yako Excel worksheet ichauya yakakodzera.
- Dzvanya pane pepa rekutanga peji uye osarudza Address Block muchikamu chekunyora & Insert Fields cheTe Mailings.
- Dzvanya pakatarisana neMat Fields bhokisi pane Insert Address Block dialog box inowanikwa.
- Iva nechokwadi chekuti misoro yako inoenderana neminda inodiwa. Kana mumwe wavo asina kukodzera, shandisa museve unodonha pedyo nawo kuti ufanane kusvika kune yakakodzera munda.
- Dzvanya OK . Dzvanya OK zvakare kuti uvhare bhokisi rebhokisi uye bhura Update Labels muchikamu cheku Write & Insert Fields cheTe Mailings.
Ita kubatana
Kana uchinge wava neExcel spreadsheet uye chigwaro cheShoko chakasimudzwa, unogona kuyananidza ruzivo uye kudhinda mavara ako.
- Dzvitsa Pedza & Gadzira muboka raKupedzisira paTextingsings tab.
- Dzvanya Hora Zvinyorwa Zvose kuti uone kuti mabhii ako akadhindwa achaonekwa sei. Sarudza Zvose uye tora OK .
Chimwe chitsva chinotanga nemavhesi ekutumira kubva pane yako Excel worksheet. Iwe unogona kuchinja, kunyora uye kuchengetedza mavara sezvamunoda chero rimwe dhidhi reShoko.
Excel 2003
Kana uri kushandisa Microsoft Office 2003, matanho ekuita mabhii ekero kubva kuExcel akasiyana zvakasiyana.
Gadzirira Pepa Rokushanda
Kuti uite mabhii emareta kubva kuExcel, pepa rako repasiti rinofanira kuiswa zvakanaka. Nyora musimboti mukutanga kese ye column imwe neimwe inotsanangura data iri mumutsara zvakajeka uye pfupi. Ita korona yezvinhu chimwe nechimwe waunoda kuisa pane mavara. Somuenzaniso, kana iwe uchida kuumba mavara emareta kubva kuExcel, unogona kunge uine zvinyorwa zvinotevera:
- Tsamba (Mr./Ms./Dr.)
- Zita rokutanga
- Zita rokupedzisira
- chikero chemugwagwa
- Guta
- State
- Zipi kodhi
Pinda Data
- Tora mazita neateri kana imwe dhesi yaunoda apo iwe unonyora mabhii kubva kuExcel.
- Ita kuti chokwadi chimwe nechimwe chiri muhombe yakarurama. Dzivisa kusiya zvinyorwa zvisina ruvara kana mitsetse mukati memutsara.
- Chengetedza pepa rebasa kana wapedza.
Tanga Kubatana
- Vhura dhidhi idzva reShoko.
- Enda kune Zvinyorwa menyu, taura ma Letters uye Mailings uye sarudza Mail Unganidza kuzarura Mail Merge task pane.
- Sarudza Mavara uye chengeta Zvimwe: Kutanga Dhidhiyo .
- Dzvanya Dhinda Zvokusarudza kuti uzarure Label Options dialog box.
Sarudza Mavara Ako
- Sarudza mararamiro muTeti Vendors bhokisi uye osarudza nhamba yemagetsi, iyo yakanyorwa pane pepa reraire. Unogonawo kusarudza New Label kana iwe uchida kupinda maitiro emakero emhando.
- Dzvanya OK kana wakagadzirira kuenderera mberi.
Sarudza Mhepo Yako
- Dhinda Uchishandisa Pepa Rokutanga pasi peChitsvaga Vagashiri uye zvino bhura Browse .
- Dzokera kune Excel worksheet ine uwandu yako pane Select Data Source window iyo inovhura uye chovha Open . Mafiriji eMexico Merge Vanowanikwa mahwindo anotanga.
- Iva nechokwadi chokuti data yako inoratidzika yakarurama uye chovha OK .
Rongedza Mavara
- Dhinda Zvichiitika: Saronga Mavara Edzi .
- Sarudza Address Block .
- Dzvanya pakatarisana neMat Fields bhokisi pane Insert Address Block dialog box inowanikwa.
- Iva nechokwadi chekuti misoro yako inoenderana neminda inodiwa. Kana mumwe wavo asina kukodzera, shandisa museve unodonha pedyo nawo kuti ufanane kusvika kune yakakodzera munda. Dzvanya OK .
- Dzvanya Bhurai Mavara Ese pasi peKubvaira Mavara muBhokisi Rekubatanidza Mail.
Kuongorora uye Kupedzisa
- Shandisa miseve iri pasi peZvinoona Mavara Ako kuti uone kuti dzinoonekwa zvakanaka.
- Dhinda Uchitevera: Isaza Kubatana .
- Kana iwe uchida kuita chero shanduko, tsvaga Chengeta Mavara Mavara.
- Paunenge wagutsikana nekubatana, chinyora Dhinda kuti udhindise mazita emareta enyu kubva kuExcel.