Kutsitsa deta kuchokera ku 1c ku Excel: Njira 5 zogwirira ntchito

Palibe chinsinsi kuti pakati pa ofesi ya ofesi, makamaka omwe akuchita nawo malo okhalamo ndi ndalama, mapulogalamu a Excel ndi 1C ndiwotchuka kwambiri. Chifukwa chake, nthawi zambiri pamafunika kusinthanitsa deta pakati pa mapulogalamu. Koma, mwatsoka, si ogwiritsa ntchito onse omwe angadziwe momwe angapangire mwachangu. Tiyeni tiwone momwe mungakhalire ndi deta kuchokera ku 1c kuti ikhale chikalata chatsopano.

Kuyika chidziwitso kuchokera ku 1c ku Excel

Ngati katundu wa deta kuchokera ku Excel mu 1c ndi njira yovuta yovuta, mutha kusintha njira zolumikizirana ndi gawo limodzi, kenako kutsitsa kwa 1c kuti zitheke. Itha kukwaniritsidwa mosavuta kugwiritsa ntchito zida zomangidwa mu mapulogalamu ali pamwambawa, ndipo mutha kuchita izi m'njira zingapo, kutengera zomwe wogwiritsa ntchito ayenera kusamutsidwa. Ganizirani momwe zimachitikira pazitsanzo zapadera mu 1c mtundu wa 8.3.

Njira 1: Koperani zikhalidwe zam'manja

Chigawo chimodzi cha deta chili mu 1C cell. Itha kusamutsidwa kuti muwonjezere njira yopezera njira.

1. Tikutsindika khungu mu 1c, zomwe mukufuna kuti mukope. Dinani pa batani la mbewa. Pa mndandanda wazosankha, sankhani "Copy". Muthanso kugwiritsa ntchito njira yapadziko lonse yomwe imagwiritsa ntchito m'mapulogalamu ambiri omwe amayenda pa Windows OS: ingosankha zomwe zili mu cell ndi lembani kuphatikiza kwakukulu pa kiyibodi ya CTRL.



2. Tsegulani mndandanda wopanda pake kapena chikalata chomwe mungafune kuyika zomwe zili. Ndi batani la mbewa lamanja ndi mndandanda womwe umapezeka mu magawo, sankhani mawu oti "sungani mawu" omwe akuwonetsedwa mu mawonekedwe a kalata yayikulu "A".

   

   M'malo mwake, kuchitapo chingagwiritsidwe ntchito mutasankha foni pomwe tabu ya "kunyumba", dinani pa "Inter", yomwe ili pa tepi mu clipboard.

   

   Muthanso kugwiritsa ntchito njira yachilengedwe chonse ndikuimba Ctrl + v pa kiyibodi mukamaliza foni.

Zomwe zili mu cell 1c iikidwa pa Excel.

Njira 2: Kuyika mndandanda mu buku lomwe lilipo kale

Koma njira yomwe ili pamwambapa imangokwanira ngati mukufuna kusamutsa deta kuchokera ku cell imodzi. Mukafuna kusintha mndandanda wonse, muyenera kugwiritsa ntchito njira ina, chifukwa kukopera chinthu chimodzi kumatenga nthawi yambiri.

1. Tsegulani mndandanda uliwonse, Log kapena Reference mu 1c. Dinani pa batani "Zochita zonse", zomwe ziyenera kupezeka pamwamba pa zomwe zidakonzedwa. Menyu imayambitsidwa. Sankhani mgawoli "chowonetsera".



2. Zenera laling'ono lotseguka. Apa mutha kupanga zosintha zina.

   Gawo la "Wowonetsera B" lili ndi mfundo ziwiri:

   • Chikalata chambiri;
   • Chikalata.

   Kusakhazikika ndi njira yoyamba. Pofuna kusamutsa deta kuti ikwaniritse, ndizoyenera, ndiye pano sitisintha kalikonse.

   Mu "ojambula owonetsa" block, mutha kutchula omwe amalankhula kuchokera pamndandanda womwe mukufuna kumasulira kuti uziyenda bwino. Ngati muchita zonse zomwe mungachite, simumakhudzanso izi. Ngati mukufuna kutembenuka popanda mzati kapena mizati ingapo, ndiye kuti muchotse zojambula pamafayilo ofanana.

   Zikhazikiko zitatha, dinani batani la "OK".



3. Kenako mndandandawo umawonetsedwa mu mawonekedwe akotawa. Ngati mukufuna kusinthitsa fayilo yopambana, ingosankhani deta yonseyo ndi cholembera kumanzere, kenako dinani batani lamanzere ndikusankha "Copy" mu menyu yotseguka. Muthanso kugwiritsa ntchito makiyi otentha ctrl s.



4. Kutsegula pepala la Microsoft Excel ndipo sankhani mitundu yamitundu yakumanzere yomwe deta iikidwe. Kenako dinani batani la "phala" pa tepi mu tabu yakunyumba kapena lembani ctrl + v zazikulu.

Mndandanda wayikidwa mu chikalatacho.

Njira 3: Kupanga buku latsopano kwambiri ndi mndandanda

Komanso, mndandanda wa pulogalamu ya 1C ikhoza kuwonetsedwa nthawi yomweyo fayilo yatsopano.

1. Timakwaniritsa njira zonse zomwe zidafotokozedwa mu njira yapitayi musanapange mndandanda mu 1c mu mtundu wophatikizika. Pambuyo pake, timadina batani la foni, lomwe lili pamwamba pa zenera mu mawonekedwe a makola a lalanje. Mu menyu othamanga, tengani sefano ndi "Sungani monga ...".

   

   Ndizosavuta kuti kusinthana ndi batani la "Sungani", zomwe zili ndi mawonekedwe a flopppy ndipo ili mu 1c chida pamwamba pa zenera. Koma kusankha uku kumapezeka kokha kwa ogwiritsa ntchito omwe amagwiritsa ntchito pulogalamu ya 8.3 pulogalamu. M'matembenuzidwe akale, mutha kugwiritsa ntchito njira yapitayo.

   

   Komanso munjira zilizonse za pulogalamuyi kuti muyambitse pazenera lopulumutsa, mutha kujambulitsa lalikulu la CTRL.

2. Zenera lopulumutsa fayilo limayamba. Pitani ku chikwangwani chomwe tikukonzekera kupulumutsa bukulo ngati malowo sakhutitsidwa ndi malo osakhazikika. Mu gawo la fayilo, kusakhazikika ndi "kalata ya pagoli (* .mxl)". Sichitikwanira, ndiye kuti mumasankha kuchokera pamndandanda wotsika "Wopambana (*. Ngati mukufuna, mutha kusankha mitundu yakale kwambiri - "Excel 95" kapena "Greatch 97". Pambuyo pa zosungunuka zimapangidwa, dinani batani la "Sungani".

Mndandanda wonsewo udzapulumutsidwa ndi buku lina.

Njira 4: Kutengera magawo kuchokera ku mndandanda wa 1c kuti akwaniritse

Pali zochitika mukafuna kusamutsa osati mndandanda wonse, koma mizere yokha kapena malo. Njira iyi imathandiziranso kwathunthu ndi zida zopangidwa ndi zomangidwa.

1. Sankhani zingwe kapena zingapo mwatsatanetsatane pamndandanda. Kuti muchite izi, kwezani batani la Sinthani ndikudina batani lakumanzere pamzerewu kuti musamutsidwe. Dinani pa batani "Zochita zonse". Mumenyu zomwe zikuwoneka, sankhani "mndandanda wa" zomwe zili ".



2. NJIRA YOPHUNZITSIRA IMANENA. Zosintha mkati mwake zimapangidwa chimodzimodzi monga njira ziwiri zapitazo. Nthano yokha ndi yomwe muyenera kukhazikitsa zojambula za "gawo lodzipereka chabe. Pambuyo pake, dinani batani la "OK".



3. Monga mukuwonera, mndandanda wokhala ndi mizere yomwe yasankhidwa imachokera. Komanso, tifunika kuchita zomwezo zomwezo monga momwe munjira ya 2 kapena mu njira 3, kutengera ngati tikuwonjezera mndandanda wa buku la expll omwe alipo kapena pangani chikalata chatsopano.

Njira 5: Kusunga Zikalata Zoyenera Mtundu wa Excel

Kupambana, nthawi zina muyenera kupulumutsa mindandanda yokha, komanso kupangidwanso zikalata 1C (maakaunti, zolipira zolipira zolipira, etc.). Izi ndichifukwa choti ogwiritsa ntchito ambiri amasintha chikalatacho ndikosavuta ku Excel. Kuphatikiza apo, mutha kuchotsa deta yomalizidwa bwino ndipo, kusindikiza chikalatacho, gwiritsani ntchito ngati kuli kofunikira ngati fomu ya kudzazidwa pamanja.

1. Mu 1c mu mawonekedwe a chikalata chilichonse pali batani losindikiza. Ili ndi chithunzi mu mawonekedwe a chithunzi cha chosindikizira. Chikalatacho chikalowa mu chikalatacho ndipo chimasungidwa, dinani chithunzichi.



2. Mawonekedwe osindikizidwa amatsegula. Koma ife, tikamakumbukira, muyenera kusindikiza chikalata, koma kuti tisinthire bwino. Njira yosavuta mu mtundu 1c 8.3 imachitika podina batani la "Sungani" mu mawonekedwe a floppy disk.

   

   Kwa mabaibulo akale, timagwiritsa ntchito makiyi owotcha Ctrl + s kapena ndikukakamiza batani lazotulutsa mu mawonekedwe a pazenera, timatsatira fayilo "fayilo" ndi "Sungani".



3. Zenera lopulumutsa chikalata limatseguka. Monga momwe munjira zam'mbuyomu, zimafunikira kutchula malo omwe ali fayilo yosungidwa. Mu gawo lamtundu wa fayilo, muyenera kutchulanso mtundu wa mawonekedwe abwino. Musaiwale kupatsa dzina la chikalatacho mu "fayilo ya fayilo". Pambuyo pochita makonda onse, dinani batani la "Sungani".

Chikalatacho chidzasungidwa mu mawonekedwe a Exel. Fayilo iyi itha kutsegulidwa mu pulogalamuyi, ndipo kukonzanso kwawo kuli kale.

Monga mukuwonera, kutsitsa zambiri kuchokera ku 1c pa excel mtundu sikovuta. Ndikofunikira kudziwa za anzeru chabe, chifukwa, mwatsoka, sizomvetsa bwino za ogwiritsa ntchito onse. Pogwiritsa ntchito zida zomangidwa 1c ndi Excel, mutha kukopera zomwe zili m'maselo, mndandanda ndi magawo kuchokera koyamba ku pulogalamu yachiwiri, komanso ndalama zosunga m'mabuku osiyana. Zosankha zoteteza ndizovuta kwambiri ndipo kuti wogwiritsa ntchitoyo athe kupeza zoyenera, palibe chifukwa chosinthira pulogalamu ya chipani chachitatu kapena kugwiritsa ntchito mitundu yovuta.