Kawirikawiri cholinga chachikulu chogwiritsira ntchito ndondomeko ya Excel ndikusindikiza. Koma, mwatsoka, sikuti aliyense wogwiritsa ntchito amadziwa momwe angachitire, makamaka ngati mukufuna kusindikiza zonse zomwe zili m'bukuli, koma masamba ena okha. Tiyeni tione momwe tingasindikizire chikalata ku Excel.
Onaninso: Zolemba zojambula mu MS Word
Ndondomeko yotulutsidwa kwa osindikiza
Musanayambe kusindikiza chikalata chilichonse, muyenera kuonetsetsa kuti chosindikizacho chikugwirizanitsidwa bwino ndi kompyuta yanu ndipo makonzedwe ake oyenera akugwiritsidwa ntchito mu Windows. Kuphatikizanso, dzina la chipangizo chimene mukukonzekera chiyenera kusindikizidwa kudzera mu mawonekedwe a Excel. Kuti muonetsetse kuti kugwirizana ndi zoikidwiratu zili zolondola, pitani ku tabu "Foni". Kenaka, pita ku gawo "Sakani". Pakatikatikati mwazenera lotseguka pazenera "Printer" Dzina la chipangizo chimene mukukonzekera kusindikiza ziyenera kuwonetsedwa.
Koma ngakhale chipangizocho chikuwonetsedwa bwino, sichikutsimikiziranso kuti chikugwirizana. Izi zimangotanthauza kuti zimakonzedweratu pulogalamuyi. Choncho, musanayambe kusindikiza, onetsetsani kuti chosindikizacho chatsekedwa ndipo chikugwirizanitsidwa ndi makompyuta pogwiritsa ntchito makina osakaniza kapena opanda waya.
Njira 1: Sindikizani chikalata chonsecho
Pambuyo kugwirizana kukutsimikiziridwa, mukhoza kupitiriza kusindikiza zomwe zili mu felelo ya Excel. Njira yosavuta ndiyo kusindikiza chikalata chonsecho. Kuchokera apa tikuyamba.
- Pitani ku tabu "Foni".
- Kenaka, pita ku gawo "Sakani"mwa kuwonekera pa chinthu chofanana ndicho kumanzere kwawindo lawindo lomwe limatsegulidwa.
- Window yosindikiza ikuyamba. Chotsatira, pitani ku chisankho cha chipangizo. Kumunda "Printer" Dzina la chipangizo chimene mukukonzekera kusindikiza chiyenera kuwonetsedwa. Ngati dzina la printer wina liwonetsedwa pamenepo, muyenera kulijambula pazimenezo ndipo sankhani kusankha komwe kukukhutitsani kuchokera pa ndondomeko yotsika pansi.
- Pambuyo pake timasamukira ku malo omwe ali pansipa. Popeza tikufunika kusindikiza zonse zomwe zili mu fayilo, timakani pa gawo loyamba ndikusankha kuchokera pandandanda yomwe imatsegulidwa "Lindikirani bukhu lonse".
- M'masamba otsatirawa, mungasankhe mtundu wa printout kuti muwathandize:
- Kusindikiza kumodzi;
- Zonsezi zimakhala ndi mbali ziwiri;
- Zokambirana zogwirizana ndi mapepala ochepa chabe.
Pali kale chosowa kusankha kusankha molingana ndi zolinga, koma chosasintha ndicho choyamba.
- Pa ndime yotsatira tikuyenera kusankha ngati titasindikizira mabuku athu kapena ayi. Pachiyambi choyamba, ngati mumasindikiza makope angapo a chidziwitso chomwecho, mapepala onse adzasindikizidwa mwamsanga: kopi yoyamba, kenako yachiwiri, ndi zina zotero. Pachiwiri chachiwiri, makinawo amasindikiza pomwepo makope onse a mapepala onse, kenako chachiwiri, ndi zina zotero. Njirayi ndi yothandiza makamaka ngati wogwiritsa ntchito malembawo akupanga mapepala ambiri, ndikuthandizira kupanga zinthu zake. Ngati mumasindikiza kopi imodzi, izi zakhala zosafunikira kwambiri kwa wosuta.
- Chofunika kwambiri ndi "Malingaliro". Mundawu umatsimikizira kuti kusindikiza kudzapangidwe kotani: mu zojambula kapena malo. Pachiyambi choyamba, kutalika kwa pepala kulikulu kuposa kukula kwake. M'machitidwe a malo, chiwerengero cha pepalacho n'choposa kukula kwake.
- Munda wotsatira umatanthauzira kukula kwa pepala lofalitsidwa. Kusankhidwa kwa ndondomekoyi, choyamba, kumadalira kukula kwa pepala ndi mphamvu za wosindikiza. Nthaŵi zambiri, gwiritsani ntchito mawonekedwe A4. Imaikidwa mu zosintha zosasinthika. Koma nthawi zina mumayenera kugwiritsa ntchito miyeso ina.
- Mu gawo lotsatira mukhoza kuyika kukula kwa minda. Phindu lokhazikika liri "M'minda Yonse". Ndi mawonekedwe a mtundu uwu, kukula kwa malo apamwamba ndi apansi ndi 1.91 cm, kumanja ndi kumanzere - 1.78 cm. Kuwonjezera pamenepo, n'zotheka kukhazikitsa mitundu ikuluikulu ya kukula kwake:
- Wide;
- Mphindi;
- Chizolowezi chomaliza chamtengo wapatali.
Komanso, kukula kwa munda kumatha kukhazikitsidwa mwaluso, monga tidzakambirana pansipa.
- Munda wotsatira umapereka chiwerengero cha pepala. Pali njira zoterezi posankha njirayi:
- Pakali pano (kusindikiza kwa mapepala ndi kukula kwenikweni) - mwachinsinsi;
- Lembani pepala pa tsamba limodzi;
- Lembani zipilala zonse pa tsamba limodzi.;
- Lembani mzere wonse pa tsamba limodzi..
- Kuonjezerapo, ngati mukufuna kukhazikitsa msinkhu, ndikuika mtengo wapadera, koma osagwiritsa ntchito makonzedwe apamwambawa, mukhoza kudutsa "Zosankha zamakono zokhazikika".
Monga njira ina, mukhoza kudinkhani pamutuwu "Makhalidwe a Tsamba"yomwe ili pansi pomwe pamapeto a mndandanda wa masewera.
- Pa chilichonse mwazochitika, kusintha kumapezeka pawindo lotchedwa "Makhalidwe a Tsamba". Ngati mwadongosolo pamwambapa mutha kusankha pakati pa zosankhidwazo, ndiye kuti wogwiritsa ntchitoyo ali ndi mwayi wokonda kusonyeza chikalata chomwe akufuna.
Mu tabu yoyamba yawindo ili, lotchedwa "Tsamba" Mungathe kusintha malingalirowo poyesa mtengo wake wokhawokha, peresenti (zojambula kapena malo), kukula kwa pepala, ndi khalidwe la kusindikiza (osasintha 600 madontho pa inchi).
- Mu tab "Minda" Kukonza bwino kwazomwe mumunda. Kumbukirani, tinakambirana za mwayi umenewu pang'ono. Pano mukhoza kuyika ndondomeko yeniyeni, yofotokozera muyeso yeniyeni, magawo a munda uliwonse. Kuphatikiza apo, mungathe kukhazikitsa mwangwiro kapena kutsindika.
- Mu tab "Zolemba" Mukhoza kulenga mutu ndi mapazi.
- Mu tab "Mapepala" Mukhoza kusintha mawonedwe a mapeto a mapeto, ndiko kuti, mizere yomwe idzasindikizidwa pa pepala lililonse pamalo enaake. Kuphatikizanso, mutha kukonza mwatsatanetsatane ndondomeko ya mapepala opangidwira ku printer. N'zotheka kusindikiza galasi la pepala lokha, lomwe mwachisawawa silingasindikize, mzere ndi mitu yamutu, ndi zina zina.
- Kamodzi pawindo "Makhalidwe a Tsamba" potsirizira zonse, musaiwale kuti tisiyeni pa batani "Chabwino" pansi pake kuti muwapulumutse kuti asindikizidwe.
- Timabwerera ku gawolo "Sakani" tabu "Foni". Kumanja kwanja lazenera lotseguka ndi malo oyang'ana. Imaonetsa gawo la chikalata chimene chimaperekedwa kwa wosindikiza. Mwachikhazikitso, ngati simunapange kusintha kwina pazowonongeka, fayilo yonse iyenera kusindikizidwa, zomwe zikutanthauza kuti chikalata chonsecho chiyenera kuwonetsedwa pamalo akuwonetserako. Kuti muwatsimikizire izi, mukhoza kutsegula mpukutu wamapukutu.
- Pambuyo pazomwe maofesi omwe mukuwona kuti ndizofunika kuziyika, awonani pa batani "Sakani"ili m'buku la dzina lomwelo "Foni".
- Pambuyo pake, zonse zomwe zili mu fayilo zidzasindikizidwa pa printer.
Palinso njira ina yosinthira. Zingatheke pita ku tabu "Tsamba la Tsamba". Zowonetsera zojambula zimapezeka mu bokosi lazamasamba. "Makhalidwe a Tsamba". Monga momwe mukuonera, iwo ali ofanana ndi omwe ali mu tab "Foni" ndipo amalamulidwa ndi mfundo zomwezo.
Kuti mupite kuwindo "Makhalidwe a Tsamba" Muyenera kujambula pa chithunzicho mwa mawonekedwe a mzere wa oblique m'makona a kumunsi kwa malo omwewo.
Pambuyo pake, mawindo azitali, omwe tidziwa kale, adzayambitsidwa, momwe mungathe kuchita ntchito pogwiritsa ntchito ndondomekoyi.
Njira 2: kusindikiza masamba osiyanasiyana
Pamwamba, tinayang'ana momwe tingasinthire kusindikiza kwa buku lonse, ndipo tsopano tiyeni tione momwe tingachitire izi pazinthu zapadera ngati sitifuna kusindikiza chikalata chonsecho.
- Choyamba, tiyenera kudziwa masamba ati pa akaunti ayenera kusindikizidwa. Kuti muchite ntchitoyi, pitani ku tsamba loyang'ana. Izi zingatheke podutsa pazithunzi. "Tsamba"yomwe ili pa barreti yoyenera pa mbali yoyenera ya iyo.
Palinso njira ina yosinthira. Kuti muchite izi, sungani ku tabu "Onani". Kenako, dinani pakani "Mafilimu"yomwe imayikidwa pa kaboni mu bokosi lokhalamo "Zojambula Zamabuku".
- Zitatha izi zimayambitsa ndondomeko ya tsamba poyang'ana chikalatacho. Monga momwe tikuonera, mmenemo mapepala akulekanitsidwa ndi malire, ndipo chiwerengero chawo chikuwonekera pambuyo pa chilembedzerocho. Tsopano mukuyenera kukumbukira chiwerengero cha masamba omwe tidzasindikiza.
- Monga mmbuyomu, yendani ku tabu "Foni". Ndiye pitani ku gawolo "Sakani".
- Pali madera awiri muzokonzedwa. "Masamba". Mu gawo loyambirira timasonyeza tsamba loyambirira la zolemba zomwe tikufuna kusindikiza, ndipo lachiwiri - lomaliza.
Ngati mukufuna kusindikiza pepala limodzi, ndiye kuti muzinthu zonsezi muyenera kufotokoza nambala yake.
- Pambuyo pake, ngati kuli kotheka, timachita zonse zomwe takambirana zomwe tinkakambirana Njira 1. Kenako, dinani pakani "Sakani".
- Pambuyo pake, wosindikiza amasindikiza mapepala omwe adatchulidwa kapena pepala limodzi lofotokozedwa m'makonzedwe.
Njira 3: Sindikani mapepala payekha
Koma chiyani choti muchite ngati mukufuna kusindikiza kamodzi, koma mapepala angapo kapena mapepala angapo osiyana? Ngati mu malemba, mapepala ndi mzere angatanthauzidwe kuti apatulidwe ndi makasitomala, ndiye palibe njira yotereyi mu Excel. Komabe, pali njira yothetsera vutoli, ndipo ili ndi chida chotchedwa "Malo Osindikizira".
- Kusamukira ku Excel pagulu ndi njira imodzi yomwe tinayankhulira pamwambapa. Kenaka, gwiritsani batani lamanzere ndi kusankha mndandanda wamasamba omwe timasindikiza. Ngati mukufuna kusankha lalikulu, kenaka dinani pazomwe zili pamwamba (selo), kenako pitani ku selo lotsiriza lazitsulo ndikuikani pa batani lamanzere pamene muli ndi batani Shift. Mwanjira iyi, mukhoza kusankha masamba angapo otsatizana. Ngati tikufunanso kusindikiza zigawo zina kapena mapepala, timasankha mapepala omwe timafunayo ndi batani lomwe linagwiritsidwa ntchito. Ctrl. Choncho, zinthu zonse zofunika zidzakambidwe.
- Pambuyo pake kusamukira ku tabu "Tsamba la Tsamba". M'kati mwa zipangizo "Makhalidwe a Tsamba" pa tepicho dinani batani "Malo Osindikizira". Ndiye pulogalamu yaing'ono ikuwonekera. Sankhani chinthu mmenemo "Khalani".
- Pambuyo pachitanso ichi pitani ku tab "Foni".
- Kenaka, pita ku gawo "Sakani".
- Muzipangidwe mu malo oyenera, sankhani chinthucho "Kusankhidwa kusindikiza".
- Ngati ndi kotheka, timapanga zochitika zina zomwe zimafotokozedwa mwatsatanetsatane Njira 1. Pambuyo pake, mu malo akuwonetserako, tikuyang'ana ma pepala omwe amasindikizidwa. Payenera kukhala pali zidutswa zomwe tazizindikira mu njira yoyamba ya njira iyi.
- Pambuyo pokonza zonsezo mutalowa ndipo mutsimikiza kuwona kwawonekera kwawo pawindo lowonetsera, dinani pa batani. "Sakani".
- Pambuyo pazimenezi, mapepala osankhidwa ayenera kusindikizidwa pa wosindikiza okhudzana ndi kompyuta.
Mwa njira, mofananamo, poika malo osankhidwa, simungasindikize mapepala okhaokha, komanso mndandanda wa maselo kapena matebulo mkati mwa pepala. Mfundo yodzipatula imakhala yofanana ndi momwe tafotokozera pamwambapa.
Phunziro: Momwe mungakhalire malo osindikiza ku Excel 2010
Monga momwe mukuonera, kuti musinthire kusindikiza zinthu zofunikira ku Excel mwa mawonekedwe omwe mukufuna, muyenera kuyimitsa pang'ono. Mavuto osauka, ngati mukufuna kusindikiza chikalata chonsecho, koma ngati mukufuna kusindikiza zigawo zake (mapepala, mapepala, etc.), mavuto ayamba. Komabe, ngati mukudziŵa malamulo a zolemba zosindikiza mu pulojekitiyi, mukhoza kuthetsa vutoli. Chabwino, nkhaniyi ikufotokoza momwe mungathetsere, makamaka, poika malo osindikiza.
