Kunezimo lapho kudokhumenti udinga ukufaka umlingiswa munye (noma iqembu lezinhlamvu) komunye. Kungaba nezizathu eziningi, kusukela ngephutha elincane, futhi kuphele ngokuhlela kabusha ithempulethi noma ukususa izikhala. Ake sibheke ukuthi singazishintsha kanjani izinhlamvu ngokushesha kuMicrosoft Excel.
Ungazishintsha kanjani izinhlamvu ku-Excel
Impela, indlela elula yokushintsha uhlamvu olulodwa nolunye ukuhlela amaseli ngesandla. Kepha, njengoba ukuzijwayeza kukhombisa, le ndlela akuyona elula ngaso sonke isikhathi kumatafula amakhulu, lapho inani lezimpawu zohlobo olufanayo oludinga ukuguqulwa lungafinyelela inani elikhulu kakhulu. Ngisho nokuthola amaseli afanele kungathatha isikhathi eside, kungasaphathwa isikhathi esithathiwe sokuhlela ngakunye.
Ngenhlanhla, ithuluzi le-Excel linethuluzi le-Thola neFaka esikhundleni elikusiza ngokushesha ukuthola amaseli owadingayo futhi wenze ukufakwa kwezinhlamvu kuwo.
Sesha ngokufaka okunye
Ukufakwa esikhundleni esilula ngokuseshwayo kubandakanya ukufaka esikhundleni sezinhlamvu ezilandelanayo nezingaguquki (izinombolo, amagama, izinhlamvu, njll.) Nenye ngemuva kokuthi lezi zinhlamvu zitholwe zisebenzisa ithuluzi lohlelo olakhelwe ngaphakathi.
- Chofoza inkinobho Thola nokugqamisaetholakala kuthebhu "Ikhaya" kwibhlokhi yezilungiselelo "Ukuhlela". Uhlu olubonakala ngemuva kwalokhu, iya entweni Faka esikhundleni.
- Kuvulwa iwindi Thola bese Ufaka esikhundleni kuthebhu Faka esikhundleni. Ensimini Thola faka inombolo, amagama noma izinhlamvu ofuna ukuzithola bese ushintsha. Ensimini "Faka esikhundleni no" senza ukufakwa kwedatha okuzokwenziwa okunye ukushintshwa.
Njengoba ukwazi ukubona, phansi kwewindi kunezinkinobho zokufaka esikhundleni - Shintsha Konke futhi Faka esikhundleni, nezinkinobho zokucinga - Thola Konke futhi "Thola ngokulandelayo". Chofoza inkinobho "Thola ngokulandelayo".
- Ngemuva kwalokho, idokhumenti liyaseshwa igama eliseshile. Ngokuzenzakalelayo, isiqondisi sokucinga senziwa umugqa ngomugqa. Isikhombisi siyama ngomphumela wokuqala ohambelana. Ukufaka okunye okuqukethwe kuseli, chofoza inkinobho Faka esikhundleni.
- Ukuqhubeka nokusesha idatha, chofoza futhi inkinobho "Thola ngokulandelayo". Ngendlela efanayo, siguqula umphumela olandelayo, njll.
Ungathola yonke imiphumela eyanelisa umbuzo wakho ngaso leso sikhathi.
- Ngemuva kokufaka umbuzo wokusesha nezinhlamvu ezifakiwe, chofoza inkinobho Thola Konke.
- Onke amaseli athintekayo ayaseshwa. Uhlu lwabo, olukhombisa ukubaluleka nekheli leseli ngayinye, luvula ngezansi kwewindi. Manje usungachofoza kunoma yiliphi iseli esifuna ukwenza elinye esikhundleni salo, bese uchofoza inkinobho Faka esikhundleni.
- Inani lizothathelwa indawo, futhi umsebenzisi angaqhubeka nokusesha emiphumeleni yokucinga ukuze afune umphumela awudinga wenqubo ephindaphindwayo.
Buyisela Ngokuzenzakalelayo
Ungenza okunye esikhundleni sokuzenzakalela ngokucindezela kwenkinobho eyodwa. Ukuze wenze lokhu, ngemuva kokufaka amanani okufanele afakwe esikhundleni, namavelu atshintshiwe, cindezela inkinobho Esikhundleni Sonke.
Inqubo yenziwa cishe khona manjalo.
Izinzuzo zale ndlela ijubane futhi kube lula. Ukhiye oyinhloko ukuthi kufanele uqiniseke ukuthi izinhlamvu ezifakiwe zidinga ukushintshwa kuwo wonke amaseli. Uma ezindleleni ezedlule kungenzeka ukuthola nokukhetha amaseli adingekayo wokushintsha, lapho-ke lapho usebenzisa le ndlela, lokhu kungenzeka kungahlanganisiwe.
Isifundo: ungalifaka kanjani iphuzu ngekhofana eliku-Excel
Izinketho ezingeziwe
Ngaphezu kwalokho, kukhona amathuba okusesha okuthuthukile futhi okunye esikhundleni sawo ngamapharamitha angeziwe.
- Ukuba kuthebhu ethi "Faka okunye esikhundleni sakho", ewindini le- "Thola uphinde ungene esikhundleni", chofoza inkinobho yezinketho.
- Iwindows izinketho ezithuthukile ziyavula. Kucishe kufane nefasitela lokusesha elithuthukile. Umehluko kuphela ukuba khona kwebhulokhi yezilungiselelo. "Faka esikhundleni no".
Ngaphansi kwewindi kunesibopho sokuthola idatha edinga ukushintshwa. Lapha ungabeka ukuthi ungasesha kuphi (ephepheni noma kuyo yonke incwadi) nokuthi ungasesha kanjani (ngomugqa noma ikholamu). Ngokungafani nokusesha okujwayelekile, ukusesha okufakiwe kungenziwa kuphela ngamafomula, okungukuthi, ngamanani lawo akhonjiswe kubha yefomula lapho ukhetha iseli. Ngaphezu kwalokho, khona lapho, ngokubheka noma ukuyekisa amabhokisi, ungacacisa ukuthi ungasesha yini izinhlamvu ezibucayi amacala noma ucishe ukufana kwemidlalo kumaseli.
Futhi, ungacacisa phakathi kwamaseli lapho ukucinga kuzokwenziwa khona. Ukuze wenze lokhu, chofoza inkinobho ethi "Fomatha" okuphambene nepharamitha "Thola".
Ngemuva kwalokho, kuzovuleka iwindi lapho ungacacisa khona uhlobo lwamaseli okufanele ulufune.
Ukuhlelwa kuphela kwenani elizofakwa kuzoba yifomethi yeseli efanayo. Ukukhetha ifomethi yenani elifakiwe, chofoza inkinobho enegama elifanayo elimelene nepharamitha "Faka okunye nge ...".
Iwindows efanayo iyavula njengasesimweni esedlule. Lokhu kusetha ukuthi amaseli azofakwa kanjani ngemuva kokufaka idatha yawo. Ungasetha ukuqondanisa, amafomethi ezinombolo, umbala weseli, imingcele, njll.
Futhi, ngokuchofoza entweni ehambelana nayo kusuka ohlwini olwehliswayo ngaphansi kwenkinobho "Ifomathi", ungabeka ifomethi ifane kunoma yisiphi iseli elikhethiwe eshidini, vele ulikhethe.
Isishumeli esingeziwe sosesho singaba inkomba yebanga lamaseli lapho usesho nokufakwa okunye kuzokwenziwa. Ukuze wenze lokhu, mane ukhethe uhla olufunayo ngesandla.
- Ungakhohlwa ukufaka amanani afanele emikhakheni "Thola" nethi "Faka esikhundleni ...". Lapho wonke amasethingi ekhonjisiwe, sikhetha indlela yenqubo. Kuphakathi kwalokho chofoza inkinobho ethi "Buyisela Konke", bese ukufaka esikhundleni kwenzeka ngokuzenzakalela, ngokuya ngemininingwane efakiwe, noma chofoza inkinobho ethi "Thola Konke", bese ubeka eceleni iseli ngalinye ngokwe-algorithm echazwe ngenhla.
Isifundo: Ungasesha kanjani e-Excel
Njengoba ukwazi ukubona, iMicrosoft Excel inikela ngethuluzi elisebenza kahle nelisebenzayo lokuthola nokufaka idatha esikhundleni sayo kumatafula. Uma udinga ukufaka esikhundleni sawo wonke amanani afanayo ngenkulumo ethile, khona-ke lokhu kungenziwa ngokucindezela inkinobho eyodwa kuphela. Uma ukukhetha kudinga ukwenziwa ngemininingwane eminingi, khona-ke lesi sici sinikezwe ngokuphelele kule processor yetafula.
