Kunezimo lapho idokhumenti idinga ukufaka esikhundleni somlingisi oyedwa (noma iqembu labalingiswa) ngolunye. Izizathu zingaba eziningi, kusukela kulesi siphambeko se-banal, nokuphela ngokuguqulwa kwesifanekiso noma ukususwa kwezikhala. Ake sithole ukuthi singasheshe sithathe kanjani izinhlamvu ku-Microsoft Excel.
Izindlela zokufaka esikhundleni sabalingiswa ku-Excel
Yiqiniso, indlela elula yokufaka umlingisi oyedwa nomunye ukuhlela ngesandla amaseli. Kodwa, njengoba umkhuba ubonisa, le ndlela ikude neze njalo elula ematafuleni amakhulu, lapho inani lezinhlamvu ezifanayo ezidinga ukuguqulwa zingafinyelela inombolo enkulu kakhulu. Ngisho nokusesha amaseli adingekayo kungasetshenziswa isikhathi esiningi, singasho isikhathi esichithwa ekuhleleni ngamunye wabo.
Ngenhlanhla, i-Excel inesitoreji sokuthola nokubeka esikhundleni kuhlelo oluzokusiza ukuthi uthole ngokushesha amaseli okudingayo uphinde ufake izinhlamvu kuzo.
Faka esikhundleni usesho
Ukususwa okulula ngokusesha kuhilela ukufaka isethi yezinhlamvu ezilandelanayo kanye nezihleliwe (izinombolo, amagama, abalingiswa, njll) nomunye ngemuva kwalokhu kubalingiswa betholakala besebenzisa ithuluzi elikhethekile elakhelwe kuloluhlelo.
- Chofoza inkinobho "Thola futhi uqokomise"elitholakala kuthebhu "Ikhaya" ebhokisini lesethingi Ukuhlela. Kulolu hlu oluvela emva kwalokhu senza ushintsho entweni "Faka esikhundleni".
- Iwindi ivula "Thola futhi ushintshe" kuthebhu "Faka esikhundleni". Ensimini "Thola" faka inombolo, amagama noma izinhlamvu ofuna ukuzithola futhi uzibeke esikhundleni. Ensimini "Faka esikhundleni" yenza idatha yokufaka, eyothathwa esikhundleni.
Njengoba ungabona, phansi kwefasitela kukhona izinkinobho zokufaka esikhundleni - "Faka konke" futhi "Faka esikhundleni", kanye nezinkinobho zokusesha - "Thola konke" futhi "Thola okulandelayo". Sicindezela inkinobho "Thola okulandelayo".
- Emva kwalokho, usesho lwenziwa kudokhumenti yegama elifunayo. Ngokuzenzakalelayo, isiqondiso sokusesha senziwe umugqa ngomugqa. Isikhombi siyeka umphumela wokuqala ohambelana. Ukuze ushintshe okuqukethwe kokuchofoza kweseli ku-inkinobho "Faka esikhundleni".
- Ukuqhubeka usesho lwemininingwane, chofoza futhi inkinobho. "Thola okulandelayo". Ngendlela efanayo, sishintsha umphumela olandelayo, njll.
Ungathola yonke imiphumela eyanelisayo ngesikhathi esisodwa.
- Ngemuva kokungena kombuzo wokusesha nokufaka izinhlamvu chofoza inkinobho "Thola konke".
- Ukufuna wonke amaseli afanele. Uhlu lwabo, lapho inani nekheli leseli ngalinye likhonjisiwe, livula ngaphansi kwefasitela. Manje ungachofoza kunoma yiliphi lamaseli lapho sifuna ukwenza khona, bese uchofoza inkinobho "Faka esikhundleni".
- Ukuguqula inani kuzokwenziwa, futhi umsebenzisi angaphinde afune imiphumela ekusesheni umphumela oyifunayo wenqubo yesibili.
Ukushintshwa okuzenzakalelayo
Ungakwazi ukufaka okuzenzakalelayo ngokucindezela inkinobho eyodwa kuphela. Ukwenza lokhu, ngemuva kokufaka amanani amanani, futhi izindinganiso kufanele zithathelwe indawo, cindezela inkinobho "Faka konke".
Inqubo yenziwa cishe masinyane.
Izinzuzo zale ndlela zishesha futhi zilula. Okungalungile okuyinhloko ukuthi kufanele uqiniseke ukuthi izinhlamvu ezifakiwe zidinga ukushintshwa kuwo wonke amaseli. Uma ezindleleni zangaphambilini kwakukhona ithuba lokuthola nokukhetha amangqamuzana adingekayo ekuguquleni, bese usebenzisa le ndlela kungenzeka ukuthi lokhu kungabandakanywa.
Isifundo: indlela yokufaka esikhundleni sokuma okugcwele nge-comma ku-Excel
Izinketho eziphambili
Ngaphezu kwalokho, kukhona ithuba lokusesha okuthuthukisiwe kanye nokufaka esikhundleni semingcele eyengeziwe.
- Esikhathini "Faka esikhundleni" ithebhu, ku-"Thola futhi Ubeke endaweni" iwindi, chofoza inkinobho yeParameters.
- Ifasitela yezilungiselelo eziphambili zivula. Cishe ifana nefasitela lokusesha eliphambili. Umehluko kuphela ukukhona kwezilungiselelo zokuvimba. "Faka esikhundleni".
Yonke phansi kwefasitela inesibopho sokuthola idatha edinga ukushintshwa. Lapha ungabeka lapho ungabheka khona (kushidi noma kulo lonke ibhuku) nokuthi ungasesha kanjani (ngemigqa noma ngamakholomu). Ngokungafani nokuseshwa okujwayelekile, ukusesha indawo kungenziwa kuphela ngamafomula, okungukuthi, ngamagugu aboniswa kubha yamasombululi uma iseli likhethiwe. Ngaphezu kwalokho, khona-ke, ngokubeka noma ukungahloli amabhokisi wokuhlola, ungacacisa ukuthi kufanele ucabangele uma ucwaninga uma kwenzeka izinhlamvu, kungakhathaliseki ukuthi ufuna umdlalo oqondile emaseli.
Futhi, ungacacisa phakathi kwamaseli okufomathi azoseshwa. Ukuze wenze lokhu, chofoza inkinobho ethi "Fometha" ngokuphambene ne "Thola" ipharamitha.
Ngemuva kwalokho iwindi lizovuleka lapho ungacacisa khona ifomethi yamaseli okucinga.
Ukuphela kwendlela yokufakelwa kuyoba yifomethi yeseli efanayo. Ukuze ukhethe ifomethi yenani elifakiwe, chofoza inkinobho yegama elifanayo ngokuphambene nendawo ethi "Faka esikhundleni ...".
Ivula iwindi elifanayo ngqo njengalesi simo esedlule. Ibeka ukuthi amangqamuzana azofomatha kanjani emva kokufaka idatha yabo esikhundleni. Ungabeka ukulungiswa, amafomethi wezinombolo, umbala weselula, imingcele, njll.
Futhi ngokuchofoza into ehambelanayo ohlwini lokudonsa phansi ngaphansi kwenkinobho "Fometha", ungabeka ifomethi ukuba ifane nanoma yisiphi iseli ekhethiwe eshadini, nje ngokwanele ukuyikhetha.
Umkhawulo owengeziwe wokusesha ungaba yinkomba yamaseli, okuzokwenziwa kuyo lapho kusesha nokushintshwa khona. Ukuze wenze lokhu, mane ukhethe uhla olufunayo ngesandla.
- Ungakhohlwa ukufaka amanani afanele ku-"Thola" futhi "Faka esikhundleni ..." amasimu. Uma zonke izilungiselelo zicacisiwe, khetha indlela yokwenza inqubo. Noma uchofoze inkinobho ethi "Faka konke", futhi ukushintshwa kwenzeke ngokuzenzekelayo, ngokusho kwedatha efakiwe, noma uchofoze kunkinobho ethi "Thola konke", futhi ngokwehlukana senza esikhundleni seseli ngayinye ngokusho kwe-algorithm echazwe ngenhla.
Isifundo: Indlela yokwenza usesho ku-Excel
Njengoba ubona, i-Microsoft Excel inikeza ithuluzi elisebenzayo elihle lokuthola nokufaka idatha ematafuleni. Uma udinga ukuthatha indawo yonke yamagugu ahlobo olulodwa ngezwi elithile, lokhu kungenziwa ngokucindezela inkinobho eyodwa kuphela. Uma isampula idinga ukwenziwa ngokuningiliziwe, leli thuba linikezwe ngokugcwele kule prosesa ye-tabular.
