Ivikela amaseli ekushintsheni ku-Excel

Imvamisa, ngenxa yezizathu ezahlukahlukene, abasebenzisi babhekana nomsebenzi wokuvikela izici ezithile zesipredishithi se-Excel kuzinguquko ezingaba khona. Isibonelo, lawa kungaba amaseli anamafomula, noma amaseli abandakanyeka ekubaleni, futhi okuqukethwe kwawo akukwazi ukulungiswa. Lokhu kuyiqiniso ikakhulukazi uma abanye abantu bekwazi ukufinyelela ithebula. Ngezansi sizobona ukuthi ungabhekana kanjani nomsebenzi.

Vula ukuvikelwa kweseli

Ngeshwa, i-Excel ayinikezi umsebenzi ohlukile okhiya amaseli ukuze uwavikele, nokho, ngalezi zinhloso, ungasebenzisa ukuvikelwa kweshidi lonke. Lokhu kungenziwa ngezindlela ezahlukene.

Indlela 1: Sebenzisa Imenyu Yefayela

Ukuze unike amandla ukuvikela, yenza okulandelayo:

1. Okokuqala udinga ukukhetha konke okuqukethwe kweshidi. Ukuze wenze lokhu, chofoza unxande ezimpambanweni zamaphaneli wokuxhumanisa. Ungacindezela futhi inhlanganisela yezinkinobho Ctrl + A (uma iseli elingaphandle kwetafula eligcwalisiwe likhethiwe, kabili uma iseli elingaphakathi kwalo likhethiwe).
2. Chofoza kwesokudla noma yikuphi endaweni ekhethiwe bese ukhetha ohlwini lokudonsela phansi "Ifomethi Yeseli".
3. Efasiteleni lokufometha kweseli elivulekayo, kuthebhu "Ukuvikela" susa ukumaka inketho “Iseli elivikelwe”, bese ucindezela OK.
4. Manje, nganoma iyiphi indlela elula (ngokwesibonelo, ngokucindezela inkinobho yegundane kwesokunxele), khetha indawo yamaseli esifuna ukuwavikela ezinguqukweni. Esimweni sethu, lena ikholomu enamafomula. Ngemva kwalokho, chofoza kwesokudla ebangeni elikhethiwe ukuze ushayele imenyu yokuqukethwe bese ukhetha into futhi "Ifomethi Yeseli".
5. Ngokuya kuthebhu "Ukuvikela" maka ibhokisi eduze kwenketho “Iseli elivikelwe” bese uchofoza OK.
6. Manje udinga ukwenza kusebenze ukuvikela kweshidi. Ngemuva kwalokho, sizoba nethuba lokulungisa wonke amaseli eshidi, ngaphandle kwalawo afakwe ebangeni elikhethiwe. Ukuze wenze lokhu, vula imenyu "Fayela".
7. Ngakwesokudla sokuqukethwe kwesigaba "Intelligence" cindezela inkinobho “Vikela Incwadi”. Uhlu lwemiyalo luzovuleka, phakathi kwakho udinga inketho - “Vikela ishidi lamanje”.
8. Izinketho zokuvikela amashidi ziboniswa esibukweni. Inketho ephikisayo “Vikela ishidi nokuqukethwe kwamaseli avikelwe” ibhokisi likaqhwishi kufanele lihlolwe. Izinketho ezisele ezingezansi zikhethwa ngokuvumelana nezifiso zomsebenzisi (ezimweni eziningi, imingcele ihlala ingathinteki). Ukuze uvikele ishidi, udinga ukufaka iphasiwedi endaweni eklanyelwe lokhu (kuzodingeka kamuva ukuyivula), ngemva kwalokho ungachofoza. KULUNGILE.
9. Ewindini elincane elilandelayo, udinga ukuphinda iphasiwedi efakwe ngaphambilini bese ucindezela inkinobho futhi OK. Lesi silinganiso sizosiza ukuvikela umsebenzisi kuma-typos akhe lapho esetha iphasiwedi.
10. Konke sekulungile. Manje ngeke ukwazi ukuhlela okuqukethwe kwamaseli esikunikeze amandla okuvikeleka ezinkethweni zokufometha. Izinto ezisele zeshidi zingashintshwa ngokubona kwethu.

Indlela yesi-2: Sebenzisa amathuluzi wethebhu yokubuyekeza

Indlela yesibili yokunika amandla ukuvikelwa kweseli ihlanganisa ukusebenzisa amathuluzi wethebhu "Buyekeza". Nansi indlela okwenziwa ngayo:

1. Silandela izinyathelo 1-5 ezichazwe endleleni 1, okungukuthi susa ukuvikela kulo lonke ishidi futhi sihlehliselwe emuva kumaseli akhethiwe kuphela.
2. Eqenjini lamathuluzi "Ukuvikela" amathebhu "Buyekeza" cindezela inkinobho “Vikela Ishidi”.
3. Iwindi elijwayelekile elinezinketho zokuvikela ishidi lizovela. Bese silandela izinyathelo ezifanayo nasekusetshenzisweni kwendlela echazwe ngenhla.

Qaphela: Uma iwindi lohlelo liminyanisiwe (ngokuvundlile), ibhokisi lamathuluzi "Ukuvikela" iyinkinobho, ngokucindezela okuzovula uhlu lwemiyalo etholakalayo.

Susa isivikelo

Uma sizama ukwenza izinguquko kunoma yimaphi amaseli avikelwe, uhlelo luzokhipha umlayezo wolwazi ofanelekile.

Ukuze uvule ukukhiya, kufanele ufake iphasiwedi:

1. Ithebhu "Buyekeza" eqenjini lamathuluzi "Ukuvikela" cindezela inkinobho “Ishidi elingavikelekile”.
2. Iwindi elincane lizovuleka ngenkambu eyodwa lapho kufanele ufake khona iphasiwedi eshiwo lapho uvimba amaseli. Icindezela inkinobho OK sizosusa isivikelo.

Isiphetho

Naphezu kweqiniso lokuthi i-Excel ayinawo umsebenzi okhethekile oklanyelwe ukuvikela amaseli athile ekuhleleni, ungakwenza lokhu ngokuvula ukuvikelwa kweshidi lonke, ngemva kokusetha imingcele edingekayo yamaseli akhethiwe.