Khupha idatha ukusuka kwi-1C kwi-Excel: Iindlela ezi-5 zomsebenzi

Akukho mfihlakalo yokuba phakathi kwabasebenzi base-ofisini, ngakumbi abo babandakanyekayo kwindawo yokuhlala kunye nendawo yezemali, iinkqubo ze-Excel kunye ne-1C zithandwa kakhulu. Ke ngoko, ihlala iyimfuneko ukutshintsha idatha phakathi kwezi zicelo. Kodwa, ngelishwa, ayingabo bonke abasebenzisi bayazi ukuba bayenza njani ngokukhawuleza. Masifumanise ukuba ungayifaka njani idatha ukusuka kwi-1c kuxwebhu lwe-Excel.

Ngenisa ulwazi ukusuka kwi-1c kwi-Excel

Ukuba umthwalo wedatha ovela kwi-Excel kwi-1c yinkqubo enzima kakhulu, ungazenzela izisombululo zeqela lesithathu, emva koko inkqubo eguqukayo, eyi-I-UNCIRT ukuya kwi-Excel yentshukumo yezenzo ezilula. Inokufezekiswa ngokulula usebenzisa izixhobo ezakhelwe ezi nkqubo zilapha ngasentla, kwaye unokukwenza oku ngeendlela ezininzi, kuxhomekeke kwinto ekufuneka idluliselwe ngumsebenzisi. Cinga ngendlela eyenziwe ngayo kwimizekelo ethile kwi-1c Version 8.3.

Indlela yoku-1: Khuphela umxholo weseli

Iyunithi enye yedatha iqulathwe kwiseli ye-1C. Ingadluliselwa ukuba iphumelele ngendlela eqhelekileyo yokukhuphela.

1. Sibonisa iseli kwi-1c, imixholo yento ofuna ukuyikhuphela. Cofa kuyo kwiqhosha le mouse lasekunene. Kwimenyu yokujonga umxholo, khetha i "Khuphela". Unokusebenzisa kwakhona indlela ye-Universal esebenza kwiinkqubo ezininzi eziqhuba kwiWindows OS: Khetha ukuqulatha isisele kwaye uchwetheze umdibaniso ophambili kwi-Ctrl + C ikhibhodi ye-CTRL.



2. Vula uluhlu olungenanto lwe-Excel okanye uxwebhu apho kufuneka ufake khona imixholo. Ngeqhosha lasekunene lemouse nakwimenyu yemeko ebonakalayo kwiiparamitha zokufakwa, khetha "Gcina kuphela i-Toub" yento, eboniswayo ngohlobo lwencwadi enkulu "a".

   

   Endaweni yoko, inyathelo linokusetyenziswa emva kokukhetha iseli ngelixa "ikhaya", cofa kwi "Faka" i-icon, ekhoyo kwitheyiphu kwibhloko yebhodi eqhotyoshwayo.

   

   Unokusebenzisa indlela kwaye ucofe indlela ye-CTRL + VIYs kwikhibhodi emva kokuba iselfowuni ibalaselisiwe.

Iziqulatho zeseli ye-1C ziya kufakwa kwi-Excel.

Indlela 2: Ukufaka uluhlu lwencwadi esele ikho

Kodwa le ndlela ingentla iya kuhambelana kuphela ukuba ufuna ukuhambisa idatha kwiseli enye. Xa kufuneka wenze ugqithiso loluhlu olupheleleyo, kuya kufuneka usebenzise enye indlela, kuba ukukopa enye into iya kuthatha ixesha elininzi.

1. Vula naluphi na uluhlu, ilog okanye incwadi yesalathiso kwi-1c. Cofa kwiqhosha "Zonke Izenzo", ekufuneka zibekwe phezulu kwi-dat yoluhlu lwedatha. Imenyu iqalile. Khetha kuyo le "yoluhlu lwezinto".



2. Iwindows encinci yokuphumeza ivulwa. Apha unokwenza useto.

   Indawo "yokubonisa b" inamaxabiso amabini:

   • Uxwebhu lwe-tabul;
   • Uxwebhu lwesicatshulwa.

   Ukungagqibeki kukhetho lokuqala. Ukutshintshela idatha kwi-Excel, kufanelekile, apha ke asitshintshi nantoni na.

   Kwi "Sheeikers" ibhloko "ibhloko, ungazichaza ukuba zeziphi izithethi ezivela kuluhlu ofuna ukuguqulela ukuze i-Excel. Ukuba uza kwenza yonke idatha, awuyichukumisi esi sicwangciso. Ukuba ufuna ukwenza uguquko ngaphandle kwekholamu ethile okanye iikholamu ezininzi, emva koko susa uphawu kwizinto ezihambelana nazo.

   Emva kokuba kusenziwa useto, cofa iqhosha u "Kulungile".



3. Emva koko uluhlu luboniswe kwifom ye-tabus. Ukuba ufuna ukuyidlulisela kwifayile ye-Excel eyenziwe nge-Excel, ukhethe nje yonke idatha kuyo ngesikhombisi ngeqhosha lasekhohlo leqhosha, emva koko nqakraza kwiqhosha leqhosha lasekunene kwaye ukhethe i "Khuphela" kwimenyu evuliweyo. Unokusebenzisa indibaniselwano yeqhosha elishushu Ctrl + s.



4. Ukuvula iphepha leMicrosoft Excel kwaye ukhethe uluhlu oluphezulu loluhlu apho idatha iya kufakwa khona. Emva koko cofa iqhosha "Paste" kwiteyiphu kwithebhu yasekhaya okanye uhlobo lwe-CTRL + V.

Uluhlu lufakiwe kuxwebhu.

Indlela 3: Ukwenza incwadi entsha ye-Excel ngoluhlu

Uluhlu lwenkqubo ye-1C lunokuboniswa kwangoko kwifayile entsha ye-Excel.

1. Senza onke la manyathelo ebekiweyo kwiNdlela yangaphambili ngaphambi kokwenza uluhlu kwi-1c kwinguqulelo ye-tabuster. Emva koko, cofa kwiqhosha lokufowuna kwimenyu, elibekwe phezulu kwifestile ngohlobo lonxantathu olubhalwe kwisangqa se-orenji. Kwimenyu yokuqhuba kwemenyu, ngokulandelelana yiya kwi "Ifayile" kwaye "Gcina njenge ...".

   

   Kulula ukwenza utshintsho ngokunqakraza kwiqhosha "longa", elinembono yefloppy kwaye ibekwe kwi-1C Toolbar ephezulu yefestile. Kodwa olu khetho lufumaneka kuphela kubasebenzisi abasebenzisa inguqulelo 8.3. Kwiinguqulelo zangaphambili, unokusebenzisa ukhetho lwangaphambili.

   

   Kwakhona naziphi na iinguqulelo zenkqubo ukuqala ukugcina iwindow, unokucofa umdibaniso ophambili we-CTRL.

2. Iwindows yokonga ifayile iqala. Yiya kwisikhombisi apho siceba ukugcina incwadi ukuba indawo ayonelisekanga yindawo emiselweyo. Kwicandelo lohlobo lwefayile, okungagqibekanga 'luxwebhu lwetafile yetafile (* .mxl) ". Ayisingqinelani, ke ukhetha uLuhlu lweDrop-ezantsi "I-Excel (* .xls) iphepha okanye" Iphepha le-Excel "... (* .xlsx)." Ukuba unqwenela, unokukhetha iifomathi ezindala ezindala - "I-Excel 95" okanye "i-Excel 97 iphepha 97". Emva kokuba ugcino lwenziwa, nqakraza kwiqhosha "longa".

Olu luhlu luphela luya kusindiswa yincwadi eyahlukileyo.

Indlela yesi-4: Ukukhuphela uluhlu oluvela kuluhlu lwe-1C ukuze uphumelele

Kukho iimeko apho kufuneka ugqithise uLuhlu luphela, kodwa kuphela kwimigca okanye uluhlu lwedatha kuphela. Olu khetho luya kuqwalasela ngokupheleleyo izixhobo ezakhiweyo.

1. Khetha imitya okanye uluhlu lwedatha kuluhlu. Ukwenza oku, kuqhuma iqhosha le-Shift kwaye ucofe iqhosha lemouse lasekhohlo kwimigca ukuze idluliselwe. Cofa kwiqhosha "Zonke iintshukumo". Kwimenyu ebonakalayo, khetha uhlobo "lodidi ..." into.



2. Uluhlu lwefestile yemveliso luqale. Useto ngaphakathi luveliswa ngendlela efanayo nakwiindlela ezimbini ezidlulileyo. Ekuphela kwengqondo kukuba kufuneka ufake uphawu malunga ne "iparameter kuphela. Emva koko, cofa kwiqhosha "Kulungile".



3. Njengoko ubona, uluhlu olubandakanya ukubanjiswa ngokukodwa kwimigca ekhethiweyo. Ngokubhekele phaya, kuya kufuneka senze izenzo ezifanayo njengakwindlela 2 okanye kwindlela 3, ngokuxhomekeke ekubeni siya kongeza uluhlu lwencwadi ekhoyo ye-Excel okanye wenze uxwebhu olutsha.

Indlela yesi-5: Ukugcina amaxwebhu kwifomathi ye-Excel

I-Excel, ngamanye amaxesha kufuneka usindise kungekuphela nje uluhlu oluthile, kodwa luyenziwe kumaxwebhu e-1c (iiakhawunti, ngaphezulu kwee-odolo zentlawulo, njl. Njl.). Oku kungenxa yokuba kubasebenzisi abaninzi bahlele uxwebhu lulula kakhulu. Ukongeza, unokucima idatha egqityiweyo kwi-Excel kwaye, uprinta uxwebhu, yisebenzise ukuba kukho imfuneko njengefom yokugcwalisa.

1. Kwi-1C ngohlobo lokudala naluphi na uxwebhu kukho iqhosha lokuprinta. Iqulethe i icon ngohlobo lomfanekiso womshicileli. Emva kokuba uxwebhu lungeniswe kuxwebhu kwaye lugcinwe, cofa kule icon.



2. Ifom yokuprinta ivula. Kodwa thina, njengoko sikhumbula, kufuneka uprinte uxwebhu, kodwa ukuguqula ukuze iphumelele. Eyona ndlela ilula kwinguqulelo ye-1C 8.3 yenziwa ngokunqakraza kwiqhosha "longa" kwifom yediski yefloppy.

   

   Kwiinguqulelo zangaphambili, sisebenzisa indibaniselwano yeqhosha elishushu Ctrl + okanye ngokucinezela iqhosha lemenyu kwifom yefestile ephezulu efestileni, silandela ifayile "yefayile" kwaye "Gcina".



3. Ifestile yokugcina uxwebhu ivuliwe. Njengakwindlela edlulileyo, kufuneka ikhankanya indawo yefayile egciniweyo. Kwicandelo lohlobo lwefayile, kuya kufuneka uchaze enye yeefomati ze-Excel. Ungalibali ukunika igama loxwebhu kwicandelo "legama lefayile". Emva kokwenza konke useto, cofa iqhosha u "Gcina".

Olu xwebhu luzakugcinwa kwifomathi ye-EX. Le fayile ngoku inokuvulwa kule nkqubo, kwaye iyaqhuba ngakumbi kuyo.

Njengoko ubona, ukuphenkce ulwazi ukusuka kwi-1c kwifomathi ye-Excel akunzima. Kuyimfuneko ukwazi kuphela i-algorithm yezenzo, kuba, ngelishwa, ayiqondwanga ngabantu bonke abasebenzisi. Sebenzisa izixhobo ezakhiweyo 1c kunye ne-Excel, unokukopa imixholo yeeseli, udwelise umxholo weseli, kuluhlu lokuqala isicelo kunye noluhlu lweencwadi ezahlukeneyo. Iinketho zolondolozo zininzi kakhulu kwaye ukuze umsebenzisi afumane ifanelekile imeko yayo, akukho sidingo sokubhenela ekusebenziseni isoftware ye-orche yeqela okanye isebenzise indibaniselwano enzima yezenzo.