Mukasindikiza matebulo ndi deta ina, chikalata cha Excel nthawi zambiri chimakhala chopitilira malire a pepalalo. Ndizosasangalatsa makamaka ngati tebulo silikhala lolondola. Zowonadi, pankhaniyi, mayina a zingwe azikhala gawo limodzi la chikalata chosindikizidwa, ndi kung'alulana kwina. Ngakhale zokhumudwitsa kwambiri, ngati pang'ono zidakhala ndi malo okwanira kuti ayikenso tebulo patsamba. Koma kutuluka kuchokera ku malowa kulipo. Tiyeni tiwone momwe mungasindikize deta pa pepala limodzi m'njira zosiyanasiyana.
Sindikizani pa pepala limodzi
Musanasinthe funso la momwe mungagwiritsire ntchito deta pa pepala limodzi, muyenera kusankha kuti muchite izi. Tiyenera kumvetsetsa kuti njira zambiri zomwe zidzafotokozeredwe pansipa, nenani kuchepa kwa sikelo kuti muwayenere pa chinthu chimodzi. Ngati malire a tsamba ndi ochepa kukula, ndizovomerezeka. Koma ngati chidziwitso chokwanira sichingakhale chokwanira, ndiye kuti kuyesako zonse pa pepala limodzi kungapangitse kuti adzachepetsedwa kwambiri mpaka adzachepetsedwa. Poterepa, pankhaniyi, zotulutsa zabwino kwambiri zidzasindikiza tsambalo pamtundu wokulirapo, magulu awiri kapena kupeza njira ina.Chifukwa chake wosuta ayenera kudziwa ngati kuli koyenera kukwaniritsa deta kapena ayi. Tipita ku malongosoledwe a njira zina.
Njira 1: Sinthani masitepe
Njirayi ndi imodzi mwanjira zomwe zafotokozedwa pano, zomwe simuyenera kuchita kuti muchepetse pamlingo. Koma ndizoyenera pokhapokha chikalatacho chili ndi mizere yaying'ono, kapena kuti wogwiritsa ntchito siofunikira kwambiri kuti zikhala patsamba limodzi, ndipo zidzakhala zokwanira kuti deta ipezeka patsamba lalitali.
- Choyamba, muyenera kuwona ngati tebulo limayikidwa m'malire a pepala losindikizidwa. Kuti muchite izi, sinthani ku "Tsamba la Tsamba". Pofuna kupanga chidutswa cha chithunzi chomwe chili ndi dzina lomweli, lomwe lili pa bar.
Mutha kupitanso ku "Onani" tabu ndikudina batani patsamba lolemba ", lomwe limapezeka pa tepi mu" Buku Loona Lida.
- Mwanjira iliyonse izi, pulogalamuyi imalowetsa mtundu wa tsamba. Pankhaniyi, malire a chinthu chilichonse chikuwoneka. Monga tikuwona, kwa ife, tebulo limatembenukira mozungulira mapepala awiri osiyana, omwe sangakhale ovomerezeka.
- Kuti muthe kukonza vutoli, pitani patsamba "Tab. Tadina batani la "Internation", lomwe limapezeka pa tepi mu "masamba a masamba" ndi mndandanda wocheperako womwe umawonekera, sankhani "album".
- Pambuyo pazochitika pamwambapa, tebulo limakwanira papepala, koma kusinthidwa kwake kunasinthidwa kuchoka m'buku la paderalo.
Palinso mtundu wina wa kusintha kwa masamba.
- Pitani ku "fayilo" tabu. Kenako, pitani gawo "" kusindikiza ". Mu gawo lalikulu lazenera lomwe limatsegula zenera ndi mawonekedwe osindikizira. Dinani pa dzina "buku la buku". Pambuyo pake, mndandanda womwe uli ndi kuthekera kusankha njira ina. Sankhani dzinalo "kukweza majini".
- Monga tikuwona, pokonzekera zochitika pamwambapa, pepalali lidasinthiratu pamtunda ndipo tsopano deta yonse imaphatikizidwa ndi gawo limodzi la chinthu chimodzi.
Kuphatikiza apo, mutha kusintha mayendedwe kudzera pazenera.
- Kukhala mu "Fayilo" tabu, mu gawo la "kusindikiza" gawo lolemba patsamba lolemba ", lomwe lili kumapeto kwa makonda. Pazenera lazenera, muthanso kudutsa zina, koma tikambirana mwatsatanetsatane za kufotokoza kwa njira 4 mwatsatanetsatane.
- Zenera la paramu limayamba. Pitani ku tabu yake yotchedwa "tsamba". Mu "okonda", timakonzanso kusinthaku kuchokera ku "buku" malo a "malo". Kenako dinani batani la "OK" pansi pazenera.
Kuyanjana kwa chikalatacho kudzasinthidwa, ndipo, chifukwa chake, malo a chinthu chosindikizidwa akukulitsidwa.
Phunziro: Momwe Mungapangire Lemba Lamalo ku Exale
Njira 2: Kusintha kwa malire a maselo
Nthawi zina zimachitika kuti malo ogulitsira agwiritsidwa ntchito osakwanira. Ndiye kuti, mumitundu ina pali malo opanda kanthu. Izi zimachulukitsa kukula kwa tsambalo m'lifupi mwake, chifukwa chake zimawawonetsera zopitilira malire a pepala limodzi. Pankhaniyi, zimakhala zomveka kuti muchepetse kukula kwa maselo.
- Tikukhazikitsa cholozera pagawo logwirizana pamalire a mizamu kumanja kwa mzati womwe mumaona kuti ndi wothetsa. Pankhaniyi, chotemberera chiyenera kutembenuka mtanda ndi mivi womwe umatsogolera mbali ziwiri. Tsekani batani lamanzere la mbewa ndikusuntha malire kumanzere. Kuyenda uku kukupitiliza mpaka malire kumafika pachiwonetsero cha khungu la mzati wa mzati wa mzati wa mzati, womwe wadzazidwa kwambiri kuposa ena.
- Ntchito yotereyi imachitika ndi mizati yonse. Pambuyo pake, zikuwonjezeka kwambiri mwayi woti deta yonse ya magome azikhala ndi chinthu chimodzi, chifukwa tebulo lenileni limakhala lopaka.
Ngati ndi kotheka, opaleshoniyo imatha kuchitika ndi mizere.
Choyipa cha njirayi ndikuti sichimagwira ntchito nthawi zonse, koma pokhapokha ngati malo ogwirira ntchito a Excel omwe amagwiritsidwa ntchito satha. Ngati chidziwitsocho chili ngati chotheka, koma sichidayikidwapo pazinthu zomwe mungagwiritse ntchito zomwe tisankha.
Njira 3: Zosindikiza
Ndizotheka kupanga zonse zomwe zimasindikizidwa pa chinthu chimodzi, muthanso kuyika kusindikiza mwa kufooka. Koma pankhaniyi, ndikofunikira kulingalira kuti zomwe zakhala nazo zidzachepetsedwa.
- Pitani ku "fayilo" tabu. Kenako, pitani gawo "" kusindikiza ".
- Kenako samalaninso ndi zosindikizira zosindikizira m'chigawo chapakati pazenera. Pansi pali munda wouma. Mwachisawawa, payenera kukhala gawo la "tsopano". Dinani pamunda wotchulidwa. Mndandandawo umatsegulidwa. Sankhani pamalowo "Lowani pepala patsamba limodzi".
- Pambuyo pake, pochepetsa kukula kwake, deta yonse mu chikalata chapano lizikidwa pa chinthu chimodzi, chomwe chitha kuwonedwa mu zenera lowonetsera.
Komanso, ngati palibe choyenera kuchepetsa mizere yonse pa pepala limodzi, mutha kusankha "gawo lililonse patsamba" m'magawo a shop. Pankhaniyi, deta ya tebulo ikhala yoyang'ana kwambiri pa chinthu chimodzi, koma molunjika kuti chitsogozo sichoncho.
Njira 4: Panja la masamba
Ikani deta pa chinthu chimodzi chikhoza kukhalanso kugwiritsa ntchito zenera lomwe limatchedwa "masamba osindikizidwa".
- Pali njira zingapo zoyambira tsamba la Tsamba la Tsamba. Oyamba a iwo ndikusinthana ndi "Tsamba la Tsamba" Tab. Kenako, muyenera kudina chithunzichi mu mawonekedwe a muvi wosakhazikika, womwe umayikidwa pakona yakumanja ya "masamba okhazikika".
Zofananazo ndi kusinthaku kuzenera kuti zikhala ngati mukudina pakona yomweyo pakona yakumanja kwa "fit" pagulu.
Palinso njira yoti mulowe mu zenera ili kudzera mu makonda osindikiza. Pitani ku "fayilo" tabu. Kenako, dinani pa dzina "kusindikiza" patsamba lakumanzere kwa zenera lotseguka. Mu zoikamo, zomwe zimapezeka pakati pa zenera, dinani pa "magawo a masamba", omwe ali pansi.
Pali njira ina yoyambira pazenera. Kusunthira gawo la "kusindikiza" fayilo ya fayilo. Kenako, dinani pa gawo la zigawo. Mwa kusala, gawo la "latsopano" latchulidwa. Pa mndandanda womwe umatsegulidwa, sankhani chinthucho "makonda a chiwonetsero cha chizolowezi ...".
- Ndi iti mwazomwe zafotokozedwa pamwambapa, simunasankhe, "makonda" adzatseguka pamaso panu. Timasamukira ku "Tsamba" Tab ngati zenera lidatsegulidwa mu tabu ina. Mu "Scale" zosintha, timayika kusintha kwa "malo osaposa" malo. M'munda "Tsamba M'lifupi "ndi" p. Okwera "ayenera kuyikidwa" 1 "manambala. Ngati izi sizili choncho, muyenera kukhazikitsa zambiri za nambala yomwe ili mu gawo lolingana. Pambuyo pake, kotero kuti zoikamo zidatengedwa ndi pulogalamuyi kuti ithe, dinani batani la "Ok", lomwe lili pansi pazenera.
- Pambuyo pochita izi, zonse zomwe zili m'bukuli zidzakonzedwa kuti zisindikizo pa pepala limodzi. Tsopano pitani gawo la "kusindikiza" la "fayilo" ndikudina batani lalikulu lotchedwa "kusindikiza". Pambuyo pake, zinthu zimasindikizidwa pa chosindikizira papepala limodzi.
Monga mwa njira yapitayi, pawindo la parameter, mutha kupanga zosintha momwe deta iyikitsire pa pepalalo lokhalo lolowera, ndipo malirewo sangakhale. Pazifukwa izi, zimafunikira kuti musinthenso kusinthira kukhala "Posachedwa kuposa" m'munda wamasamba " M'lifupi "Khazikitsani mtengo" 1, ndi munda " Kutalika "Siyani kanthu.
Phunziro: Momwe mungasindikizire tsamba
Monga mukuwonera, pali njira zambiri zogwirizira deta yonse yosindikiza patsamba limodzi. Komanso, zosankha zotchulidwa ndizosiyana kwambiri. Kufunikira kwa kugwiritsa ntchito njira iliyonse kuyenera kuwuzidwa ndi ziwonetsero za zizindikiritso. Mwachitsanzo, ngati muchoka m'malo okwanira opanda kanthu mumitundu, ndiye kuti njira yabwino kwambiri imangolekeretsa malire awo. Komanso, ngati vutolo sikuyenera kuyika tebulo limodzi m'litali, koma m'lifupi mwake, ndiye kuti zingakhale zomveka kulinganiza kusintha kwa mawonekedwe a mawonekedwe. Ngati zosankha izi sizoyenera, mutha kugwiritsa ntchito njira zomwe zimagwirizanitsidwa ndi kuchepa kwa kukula, koma pakadali pano kukula kwa data kudzachepetsedwa.