Ukufakwa esikhundleni kwezimpawu ku-Excel

Kunezimo lapho kubhalwe phansi udinga ukufaka esikhundleni umlingiswa owodwa (noma iqembu lezinhlamvu) kwelinye. Izizathu zingaba isethi, ezisukela ngephutha lebhanali, futhi, ziphela ngethempulethi ekude noma okususa izikhala. Ake sibheke ukuthi uzobuyisela kanjani emuva ngokushesha izinhlamvu ku-Microsoft Excel.

Izindlela Zokubuyisela Izinhlamvu ku-Excel

Vele, indlela elula yokubuyisela umlingiswa owodwa kwelinye amaseli wokuhlela wezandla. Kepha, njengoba ukuzijwayeza, hhayi njalo le ndlela kulula kakhulu ematafuleni amakhulu, lapho inani lezinhlamvu ezidinga ukuguqulwa lingafinyelela inani elikhulu kakhulu. Ngisho nokusesha amaseli afanele kungachithwa isikhathi esibalulekile, kungasasho isikhathi esichithwa ekuhleleni ngakunye.

Ngenhlanhla, uhlelo lwe-Excel lune- "thola futhi lusebenzise khona ithuluzi", elizosiza ukuthola ngokushesha amaseli adingekayo, futhi lizothatha izimpawu kuzo.

Sesha ngokubuyiselwa

Ukubuyiselwa okulula ngosesho kufaka ukufakwa esikhundleni sesethi eyodwa ye-serial kanye ne-medimed ofhlamvu

1. Chofoza inkinobho ethi "Thola nokugqamisa", okutholakala kuthebhu "Yasekhaya" ku-Inkundla Yezilungiselelo Zokuhlela. Kuluhlu oluvele ngemuva kwalolu hlu, senza ukuguqulwa ku "Faka esikhundleni".



2. "Thola bese ubeka esikhundleni" iwindi livula kuthebhu Faka esikhundleni. Ensimini ethi "Thola", sifaka inombolo, amagama noma izimpawu ofuna ukuzithola bese zingena esikhundleni. Ku- "Faka esikhundleni" ensimini ", yenza idatha yokufaka esikhundleni lapho izokwenziwa.

   Njengoba ubona, ezansi kwewindows kukhona izinkinobho zokubuyiselwa emuva - "Faka okunye esikhundleni" futhi "buyisela" izinkinobho zokusesha - "Thola konke" futhi "Thola Okulandelayo". Chofoza inkinobho ethi "Thola Okulandelayo".



3. Ngemuva kwalokho, ukusesha kwedokhumenti kufiswa. Ngokuzenzakalelayo, ukuqondiswa kokusesha kwenziwe umugqa. Isikhombisi sima kumphumela wokuqala ohambisana. Ukushintsha okuqukethwe kweseli, chofoza inkinobho ethi "Faka esikhundleni".



4. Ukuze uqhubeke nokucinga idatha, sichofoza inkinobho ethi "Thola Okulandelayo". Ngendlela efanayo, sishintsha umphumela olandelayo, njll.

Ungathola yonke imiphumela eyanelisa imiphumela ngokushesha.

1. Ngemuva kokungena kumbuzo wokusesha bese ufaka izinhlamvu, chofoza inkinobho ethi "Thola Yonke".



2. Sesha wonke amaseli afanele. Uhlu lwabo lapho inani liboniswa khona nekheli leseli ngalinye, livula phansi kwewindi. Manje usungachofoza kunoma yimaphi amaseli esifuna ukuwubuyisela kuwo, bese uqhafaza inkinobho ethi "Faka esikhundleni".



3. Ukufaka esikhundleni senani kuzokwenziwa, futhi umsebenzisi angaqhubeka nokuqhubeka emiphumeleni yokucinga ukubheka umphumela wenqubo ye-RE-REFORT.

Ukubuyiselwa okuzenzakalelayo

Ungangena esikhundleni sokucindezela inkinobho eyodwa nje. Ukuze wenze lokhu, ngemuva kokungena kumanani angenakushintshwa, futhi amanani afakwa esikhundleni esenziwe, chofoza inkinobho ethi "Faka kabusha yonke".

Inqubo yenziwa cishe ngokushesha.

Izinzuzo zale ndlela - ijubane kanye nokulula. I-minus eyinhloko ukuthi kufanele uqiniseke ukuthi izinhlamvu ezifakiwe zidinga ukushintshwa kuwo wonke amaseli. Uma ngezindlela zangaphambilini kungenzeka ukuthola bese ukhetha amaseli adingekayo ukuze ushintshe, lapho-ke usebenzisa le nketho, lelo thuba likhishwe.

Isifundo: Ungayifaka kanjani esikhundleni sephuzu kukhefana nge-Excel

Izinketho Ezengeziwe

Ngaphezu kwalokho, kukhona ukusesha okwengeziwe kanye nokubuyiselwa kwamapharamitha angeziwe.

1. Ukuba sethebhu "Faka esikhundleni", ku- "Thola bese ubeka esikhundleni se" Window ", chofoza inkinobho yepharamitha.



2. Kuvulwe iwindi lamapharamitha angeziwe. Kucishe kufane newindi lokusesha elithuthukisiwe. Umehluko kuphela ubukhona be-Izilungiselelo Block "buyisela ku-".

   

   Yonke indawo ephansi yewindi ibhekele ukusesha idatha, ukufakwa esikhundleni okufanele kwenziwe. Lapha ungasetha, lapho ungasesha khona (ephepheni noma kuyo yonke incwadi) nokuthi ungasesha kanjani (ngomugqa noma ngamakholomu). Ngokungafani nokusesha okujwayelekile, ukusesha okunye kungenziwa kwenziwa kuphela ngamafomula, okungukuthi, amanani achazwe emgqeni wamafomula ngesikhathi sokukhethwa kweseli. Ngaphezu kwalokho, ngokushesha, ngokufaka noma ukususa amabhokisi okuhlola, ngingakwazi ukucacisa ukuthi kufanele ngicabangele icala lezincwadi, lifune ukulandelwa okuqondile kumaseli.

   Futhi, ungacacisa phakathi kwamaseli wokuthi iyiphi ifomethi izoseshwa. Ukuze wenze lokhu, chofoza inkinobho ethi "format" okuphambene nenketho ethi "Thola".

   

   Emva kwalokho, iwindi lizovuleka lapho ungacacisa indlela yamaseli okusesha.

   

   Ukuphela kokubekwa kwenani lokufaka kuzoba yifomethi yeseli efanayo. Ukukhetha ifomethi yenani elifakiwe, sichofoza inkinobho yegama elifanayo eliphambene "buyisela esikhundleni ..." ipharamitha.

   

   Ivula ngqo iwindi elifanayo nakwicala eledlule. Kufakwe ukuthi amaseli azofomethwa kanjani ngemuva kokufaka esikhundleni idatha yawo. Ungasetha ukuqondanisa, amafomethi ezinombolo, umbala weseli, imingcele, njll.

   

   Futhi, ngokuchofoza entweni efanelekile kusuka ohlwini olwehliswayo ngaphansi kwenkinobho ye- "format", ungabeka ifomethi efana naliphi iseli elikhethiwe eshidini, kwanele ukuqhogqase.

   

   Umkhawulo ongezelelweyo wokusesha ungaba yinkomba yohlu lwamaseli, phakathi kwalo oluzokhethwa futhi luthathelwe indawo. Kulokhu, kwanele ukugqamisa ububanzi obufunayo ngesandla.

3. Ungakhohlwa enkundleni "thola" futhi "buyisela emuva ..." ukufaka amanani ahambisanayo. Lapho zonke izilungiselelo zichaziwe, khetha indlela yokwenziwa kwenqubo. Cishe chofoza inkinobho ethi "Faka esikhundleni yonke", futhi okunye esikhundleni kwenzeka ngokuzenzakalelayo, ngokuya ngemininingwane efakiwe, noma chofoza ngokwahlukana kwe-algorithm esitokisini ngasinye ngokwe-algorithm.

Isifundo: Ungasenza kanjani usesho ku-Excel

Njengoba ukwazi ukubona, iMicrosoft Excel ihlinzeka ngethuluzi elisebenza kahle nelilungele ukusesha nokubuyisela idatha kumatafula. Uma udinga ukufaka esikhundleni lonke uhlobo olufanayo nenkulumo ethile, khona-ke lokhu kungenziwa ngokucindezela inkinobho eyodwa kuphela. Uma kwenzeka isampula kufanele yenziwe ngemininingwane eminingi, khona-ke lesi sici sinikezwe ngokuphelele kule prosessor ye-tabular.