Ungawabonisa kanjani Wonke Amaseli Afihliwe ku-Excel

I-Excel iyithuluzi elisebenziseka ngezindlela eziningi futhi elinamandla elinikeza inhlobonhlobo yemisebenzi nezici ukwenza lula nokusheshisa ukusebenza ngedatha. Nokho, ngezinye izikhathi kungase kube nzima ukubona nokubuka wonke amaseli afihliwe. eshidini wokubala. Kulesi sihloko, sizofunda ukuthi singabonisa kanjani wonke amaseli afihliwe ku-Excel, sisebenzisa izindlela ezilula nezisebenzayo. Uma ungumsebenzisi wezobuchwepheshe ofuna ukukhulisa ukusebenza kahle ekuhlaziyeni idatha yakho nemisebenzi yokukhohlisa, idatha ku-excel, lesi sihloko sizoba usizo kakhulu kuwe.

1. Isingeniso sendlela yokubonisa wonke amaseli afihliwe ku-Excel

Ku-Excel, ngezinye izikhathi kungase kube nzima ukuthola nokubonisa wonke amaseli afihliwe kuspredishithi. Nokho, kunezindlela eziningana xazulula le nkinga futhi kulesi sihloko sizokukhombisa ukuthi ungakwenza kanjani isinyathelo ngesinyathelo.

1. Ukusebenzisa umsebenzi othi “Sesha bese ukhetha”:
Ukuze uthole wonke amaseli afihliwe ku-Excel, ungasebenzisa umsebenzi othi “Thola bese ukhetha”. Lesi sici sikuvumela ukuthi useshe okuqukethwe okuthile kusipredishithi bese ukhetha wonke amaseli ahlangabezana naleyo mibandela. Ukuze usebenzise lesi sici, landela lezi zinyathelo:
- Chofoza inkinobho ethi "Qala" kuribhoni ye-Excel.
- Eqenjini elithi "Ukuhlela", chofoza inkinobho ethi "Thola futhi Khetha".
- Khetha inketho ethi "Sesha" kumenyu yokudonsela phansi.
- Ebhokisini lengxoxo elithi "Sesha", shiya indawo yokusesha ingenalutho bese uchofoza inkinobho ethi "Izinketho".
- Hlola ibhokisi elithi "Amanani Afihliwe" bese uchofoza inkinobho ethi "KULUNGILE".
– Chofoza inkinobho ethi “Thola Konke” ukuze ubone uhlu lwawo wonke amaseli afihliwe kusipredishithi.

2. Ukusebenzisa isinqamuleli sekhibhodi “Ctrl + Shift + 0”:
Enye indlela esheshayo yokubonisa wonke amaseli afihliwe ku-Excel ukusebenzisa isinqamuleli sekhibhodi esithi “Ctrl + Shift + 0”. Lesi sinqamuleli sekhibhodi sikuvumela ukuthi ubonise wonke amakholomu afihliwe kusipredishithi. Uma ufuna ukukhombisa imigqa efihliwe, ungasebenzisa isinqamuleli sekhibhodi “Ctrl + Shift + 9”. Ukuze usebenzise lezi zinqamuleli zekhibhodi, vele ukhethe amaseli ofuna ukuwabonisa bese ucindezela inhlanganisela yokhiye ehambisanayo.

3. Ukusebenzisa imenyu ethi "Fometha":
Ungaphinda ubonise wonke amaseli afihliwe ku-Excel usebenzisa imenyu ethi "Fometha". Ukuze wenze kanjalo, landela lezi zinyathelo:
- Khetha amaseli ofuna ukuwabonisa.
- Chofoza kwesokudla kumaseli akhethiwe bese ukhetha inketho ethi "Fometha Amaseli" kumenyu yokuqukethwe.
- Kuthebhu ethi "Ukuvikela", susa ukumaka ibhokisi elithi "Kufihliwe" bese uchofoza inkinobho ethi "KULUNGILE".
- Amaseli akhethiwe abefihliwe manje azobonakala.

Ngokulandela lezi zinyathelo, uzokwazi ukukhombisa wonke amaseli afihliwe kusipredishithi se-Excel kalula futhi ngokushesha. Khumbula ukusebenzisa umsebenzi othi “Thola futhi Khetha”, izinqamuleli zekhibhodi “Ctrl + Shift + 0” kanye “Ctrl + Shift + 9”, noma imenyu ethi “Fometha” kuye ngokuncamelayo nezidingo zakho. Awasekho amaseli afihliwe!

2. Indlela yokubona nokukhetha amaseli afihliwe ku-Excel

Ukukhomba nokukhetha amaseli afihliwe ku-Excel, kunezinyathelo ezimbalwa ezingalandelwa. Ngezansi inqubo elula nephumelelayo:

Isinyathelo se-1: Vula Ifayela le-Excel ofuna ukukhomba futhi ukhethe amaseli afihliwe.

Isinyathelo se-2: Uma ifayela selivuliwe, khetha wonke amaseli alo ngokucindezela inhlanganisela yokhiye "Ctrl + A" noma ngokuchofoza inkinobho engunxantathu esekhoneni eliphezulu kwesokunxele lesipredishithi. Lokhu kuzovumela noma yimaphi amaseli afihliwe ukuthi akhethwe kanye nalawo abonakalayo.

Isinyathelo se-3: Khona-ke, ukukhomba amaseli afihliwe, udinga ukunaka noma yiziphi izinguquko ekukhethweni. Amaseli afihliwe azovezwa ngohlaka olunamachashazi esikhundleni sohlaka oluvamile. Ngokukhomba lawa maseli afihliwe, ungenza izenzo ezihlukahlukene, njengokuwabonisa, ukuwasusa, noma ukushintsha ifomethi yawo.

3. Izindlela zokubonisa wonke amaseli afihliwe ku-Excel

1. Ukukhombisa wonke amaseli afihliwe ku-Excel, unezindlela ezimbili ongazisebenzisa. Owokuqala uwukwenza mathupha, kanti owesibili udinga umsebenzi ohlinzekwe yi-Excel. Kuzo zombili izimo, izinyathelo zilula futhi ungakhetha inketho evumelana nezidingo zakho.

2. Indlela yoku-1: Ukukhombisa amaseli afihliwe mathupha, landela lezi zinyathelo:
- Khetha konke ububanzi beseli lapho usola ukuthi kunamaseli afihliwe.
- Chofoza kwesokudla kumaseli akhethiwe bese ukhetha "Fometha Amaseli" kumenyu yokuqukethwe.
- Kuthebhu ethi "Ukuvikela", susa ukumaka inketho "Efihliwe" bese uchofoza okuthi "KULUNGILE". Lesi sinyathelo siqinisekisa ukuthi amaseli afihliwe ayaboniswa kusipredishithi.
– Uma ungawaboni amaseli afihliwe ngemva kokwenza lezi zinyathelo, kungase kudingeke ukuthi uguqule ifomethi yamaseli ibe yifomethi ebonakalayo, njengokuthi "Okuvamile" noma "Umbhalo."

3. Indlela yesi-2: I-Excel iphinde inikeze ngomsebenzi obizwa ngokuthi “Bonisa Konke” ongasetshenziswa ukubonisa wonke amaseli afihliwe kusipredishithi. Ukuze usebenzise lesi sici, landela lezi zinyathelo:
- Chofoza kuthebhu ethi "Ekhaya". ibha yamathuluzi kwe-Excel.
- Eqenjini elithi "Hlela", bheka inketho ethi "Thola bese ukhetha" bese uchofoza isithonjana "Yiya kokuthi Okukhethekile".
- Efasiteleni le-pop-up, khetha inketho ethi "Amaseli Afihliwe" bese uchofoza okuthi "KULUNGILE". I-Excel izogqamisa wonke amaseli afihliwe kusipredishithi.
- Ukuze ubonise amaseli afihliwe, mane uchofoze kwesokudla kunoma iyiphi iseli egqanyisiwe bese ukhetha "Bonisa" kumenyu yokuqukethwe.

Lezi zindlela zikuvumela ukuthi ubonise wonke amaseli afihliwe ku-Excel ngokushesha futhi kalula. Khumbula ukuthi kubalulekile ukunaka ukugcinwa kuyimfihlo kolwazi kusipredishithi sakho ngaphambi kokubonisa wonke amaseli afihliwe.

4. Ukusebenzisa inketho ethi “Fometha” ukuze ubonise amaseli afihliwe ku-Excel

Ngokuvamile lapho sisebenza ne-Excel, singase sizithole sidinga ukufihla amaseli athile kumaspredishithi ethu. Nokho, kungase kube nzima ukubuka idatha efihliwe futhi wenze izinguquko kuyo. Ngenhlanhla, i-Excel isinikeza inketho ebizwa ngokuthi "Ifomethi" esivumela ukuthi sibonise amaseli afihliwe ngaphandle kokuthi siwaveze ngokuphelele.

Ukusebenzisa le nketho, kufanele sikhethe amaseli aqukethe idatha efihliwe bese uchofoza inkinobho yegundane engakwesokudla. Okulandelayo, imenyu yokudonsela phansi izovuleka lapho kufanele sikhethe khona inketho ethi "Fometha". Ngaphakathi kwemenyu yefomethi, kufanele siye kuthebhu ethi "Amaseli" bese ukhetha inketho "Efihliwe". Ukuhlola le nketho kuzobangela idatha efihliwe ukuthi iboniswe ngefomethi ehlukile, okwenza kube lula ukuyibuka nokuyilungisa.

Kubalulekile ukuqaphela ukuthi uma usebenzisa inketho ethi "Fometha" ukuze ubonise amaseli afihliwe, lezi zinguquko zizosetshenziswa kuphela kudokhumenti yamanje. Uma ufuna ukukhombisa amaseli afihliwe kuwo wonke amadokhumenti e-Excel, kufanele wenze inqubo efanayo kufayela ngalinye. Lesi sici siwusizo uma usebenza ngefayela elithile futhi ungafuni ukuveza wonke amaseli afihliwe kwamanye amadokhumenti.

5. Ukusebenzisa izinqamuleli zekhibhodi ukuze ubonise wonke amaseli afihliwe ku-Excel

Ku-Excel, kwesinye isikhathi kungaba nzima ukuthola wonke amaseli afihliwe kuspredishithi. Nokho, kukhona izinqamuleli zekhibhodi ezikuvumela ukuthi ubonise ngokushesha wonke lawa maseli. Nazi izinyathelo okufanele uzilandele:

1. Khetha wonke amaseli kusipredishithi ngokucindezela inhlanganisela yokhiye u-Ctrl + A Lokhu kuzokhetha wonke amaseli abonakalayo nangabonakali eshidini.

2. Chofoza kwesokudla noma iyiphi iseli ekhethiwe bese ukhetha “Fometha Amaseli” kumenyu yokudonsela phansi.

3. Ngaphansi kwethebhu ethi "Ukuvikela", susa ukumaka inketho ethi "Kufihliwe" bese uchofoza okuthi "KULUNGILE" ukuze usebenzise izinguquko.

Uma usulandele lezi zinyathelo, wonke amaseli afihliwe kusipredishithi azoboniswa futhi. Khumbula ukuthi lesi sinqamuleli sekhibhodi siwusizo ikakhulukazi uma usebenza namaspredishithi amakhulu futhi udinga ukubuka wonke amaseli afihliwe ngokushesha futhi kalula. Zama lesi sinqamuleli futhi wonge isikhathi emsebenzini wakho nge-Excel!

Kubalulekile ukusho ukuthi lo msebenzi uzobonisa kuphela amaseli owafihlile mathupha. Uma unamaseli afihliwe ngenxa yefomula ethile noma ukuhlunga idatha, lesi sinqamuleli sekhibhodi ngeke siwabonise. Kulezo zimo, uzodinga ukubuyekeza ifomula yakho noma izilungiselelo zokuhlunga ukuze uqiniseke ukuthi wonke amaseli adingekayo ayaboniswa.

Khumbula ukulondoloza izinguquko zakho ngemva kokubonisa wonke amaseli afihliwe ukuze ugweme ukulahleka kwedatha. Sebenzisa lesi sinqamuleli sekhibhodi ku-Excel futhi ulungiselele umsebenzi wakho ngamaspredishithi kahle!

6. Ukubonisa amaseli afihliwe kusetshenziswa amamakhro ku-Excel

Ukuze ubonise amaseli afihliwe usebenzisa ama-macros ku-Excel, ungalandela lezi zinyathelo ezilandelayo:

1. Vula ifayela le-Excel ofuna ukukhombisa amaseli afihliwe.

2. Chofoza ithebhu ethi “Unjiniyela” kuribhoni. Uma ungeke ukwazi ukubona le thebhu, kufanele uyenze isebenze kuzilungiselelo ze-Excel.

3. Chofoza inkinobho ethi “Visual Basic” ukuze uvule Isihleli Esibonakalayo Esiyisisekelo.

4. Ku-Visual Basic Editor, chofoza imenyu ethi “Faka” bese ukhetha “Imojula” ukuze ufake imojuli entsha efayeleni.

5. Kumojula entsha, bhala ikhodi elandelayo:

Sub MostrarCeldasOcultas()
    Cells.EntireRow.Hidden = False
    Cells.EntireColumn.Hidden = False
End Sub

6. Chofoza inkinobho ethi "Run" noma cindezela inkinobho ethi F5 ukuze usebenzise i-macro.

Uma usuyisebenzisile i-macro, wonke amaseli afihliwe kufayela le-Excel azoboniswa futhi. Le khodi eyisisekelo iyisiqalo esihle, kodwa ungayenza ngezifiso izidingo zakho. Isibonelo, ungakwazi ukwengeza izihlungi ukuze ubonise amaseli afihliwe kuphela eshidini elithile noma ebangeni elithile lamaseli.

Khumbula ukulondoloza ifayela ngemuva kokusebenzisa i-macro ukuze izinguquko zisetshenziswe unomphela. Ukwengeza, ukusebenzisa ama-macros ku-Excel kungadinga ukulungiswa kuzilungiselelo zakho zokuphepha, ngakho-ke kungase kudingeke uvumele ama-macros ukuthi asebenze kufayela lakho. Linga futhi usebenzise amamakhro e-Excel ukuze wenze umsebenzi wakho usebenze kahle!

7. Ungabonisa kanjani yonke imigqa namakholomu ku-Excel

Kwesinye isikhathi, lapho sisebenza ku-Excel, sihlangana nemigqa namakholomu afihliwe enza umsebenzi wethu ube nzima. Ngenhlanhla, kunendlela elula yokubonisa yonke imigqa namakholomu afihliwe ku-Excel. Lapha sizochaza indlela yokwenza isinyathelo ngesinyathelo:

1. Vula ifayela le-Excel ofuna ukukhombisa kulo imigqa namakholomu afihliwe.
2. Khetha sonke isipredishithi ngokuchofoza inkinobho etholakala ezimpambanweni zezinhlamvu nezinombolo phezulu kwesokunxele seshidi. Ungaphinda ucindezele u-Ctrl+A ukuze ukhethe yonke idatha.
3. Yiya kuthebhu ethi “Ekhaya” kubha yamathuluzi ye-Excel bese ubheka iqembu elithi “Amaseli”. Chofoza inkinobho ethi “Fometha” bese uthi “Fihla futhi Bonisa.” Imenyu yokudonsela phansi izovela.

Kumenyu yokudonsela phansi, khetha okuthi “Bonisa imigqa efihliwe” noma “Bonisa amakholomu afihliwe,” kuye ngokuthi yini ofuna ukuyibonisa. Yonke imigqa noma amakholomu afihliwe kusipredishithi azoboniswa ngokushesha.

Uma ufuna kuphela ukukhombisa umugqa noma ikholomu ethile, esikhundleni sayo yonke imigqa efihliwe noma amakholomu, ungakwenza lokho ngokukhetha umugqa noma ikholomu ngokuqondile futhi ulandele izinyathelo ezifanayo ezishiwo ngenhla. Lokhu kuyasiza uma ufuna ukuveza ngokukhetha ulwazi olufihliwe.

8. Ukulungisa izinkinga ezivamile lapho uzama ukubonisa amaseli afihliwe ku-Excel

Enye yezinkinga ezivame kakhulu lapho uzama ukukhombisa amaseli afihliwe ku-Excel ukuthi idatha olindele ukuyibona ayitholakali. Kunezizathu eziningana zokuthi kungani lokhu kungenzeka, kodwa ngenhlanhla kunezixazululo ezilula zokukuxazulula. Kulesi sihloko, sizohlinzeka ngomhlahlandlela wesinyathelo ngesinyathelo ukulungisa le nkinga futhi siqinisekise ukuthi amaseli afihliwe aboniswa ngendlela efanele.

Isinyathelo sokuqala sokulungisa le nkinga ukuhlola ukuthi ingabe amaseli afihliwe ngempela noma umane afomethwe ngombala wangemuva noma wefonti owenza abonakale engabonakali. Ukuze wenze lokhu, khetha amaseli okufanele afihlwe bese usebenzisa ukufometha kwefonti egqamile noma umbala ohlukile wangemuva ukuze uwenze abonakale futhi. Lokhu kuvame ukuxazulula inkinga ezimweni eziningi.

Uma amaseli engakaboniswa ngemva kokuhlola ukufometha, angase afihlwe ngempela. Kulokhu, ungasebenzisa umsebenzi wokuthola nokufaka esikhundleni se-Excel ukuze uthole futhi ubonise amaseli afihliwe. Okokuqala, vula ithuluzi lokuthola bese ulishintsha ngokucindezela u-Ctrl + F. Bese, uchofoza kuthebhu ethi “Faka esikhundleni” bese ushiya izinkambu ezithi “Thola” kanye “Nokubuyisela” zingenalutho. Chofoza okuthi “Izinketho” bese uqinisekisa ukuthi “Ukufometha Okufihliwe” kuthikhiwe. Ekugcineni, chofoza okuthi “Faka esikhundleni Konke” futhi amaseli afihliwe azovezwa.

9. Ukusebenzisa izihlungi ezithuthukisiwe ukuze ubonise amaseli afihliwe ku-Excel

Ukubonisa amaseli afihliwe ku-Excel, inketho ewusizo kakhulu ukusebenzisa izihlungi ezithuthukile. Lezi zihlungi zikuvumela ukuthi usethe izimo ezithile ukuze ubonise kuphela amaseli ahlangabezana naleyo mibandela. Izinyathelo okufanele uzilandele ukusebenzisa leli thuluzi zizochazwa ngezansi.

Okokuqala, udinga ukukhetha uhla lwamaseli ofuna ukusebenza kuwo. Ukuze wenze lokhu, ungasebenzisa igundane ukuze uhudule futhi ukhethe ububanzi obufunekayo, noma ungathayipha ngokuqondile ireferensi yobubanzi kubha yefomula. Lapho ibanga selikhethiwe, kufanele uye kuthebhu ethi “Idatha” bese uchofoza inkinobho ethi “Hlunga” ukuze wenze kusebenze izihlungi ezithuthukile.

Isithonjana sesihlungi esincane sizobe sesivela ekhoneni elingakwesokudla leseli ngayinye yekholomu. Ngokuchofoza lesi sithonjana, imenyu enezinketho ezahlukene zokuhlunga izoboniswa. Ukuze ubonise amaseli afihliwe, kufanele ukhethe inketho ethi "Custom" bese efasiteleni le-pop-up, khetha inketho ethi "Bonisa" kunkambu ethi "Uhlobo Lokuhlunga". Ekugcineni, kufanele uchofoze inkinobho ethi "KULUNGILE" ukuze usebenzise isihlungi futhi ubonise amaseli afihliwe kuphela ahlangabezana nemibandela emisiwe.

10. Ibonisa amaseli afihliwe kumaspredishithi avikelwe ku-Excel

Uma usebenza ngamaspredishithi avikelwe ku-Excel, ungase uzithole udinga ukubonisa amaseli afihliwe ukuze wenze imisebenzi ethile. Nakuba ngokuzenzakalelayo i-Excel ingakuvumeli ukuthi uguqule noma ubuke amaseli afihliwe kumakhasi avikelwe, kunendlela ongayilandela ukuze uxazulule le nkinga futhi ufinyelele kulawo maseli afihliwe owadingayo.

Ngezansi, sethula isinyathelo ngesinyathelo ukuze sibonise amaseli afihliwe kumaspredishithi avikelwe ku-Excel:

1. Vula ifayela le-Excel elivikelwe bese uthola ithebhu ethi “Buyekeza” kubha yemenyu ephezulu.
2. Chofoza inketho ethi “Shintsha Incwadi Yokusebenzela” bese ukhetha “Amaspredishithi Angavikelwe” kumenyu yokudonsela phansi.
3. Uma inketho isikhethiwe, kuzovela iwindi elisha le-pop-up. Kuleli windi, chofoza isipredishithi esivikelwe ofuna ukukhombisa amaseli afihliwe.
4. Ekugcineni, chofoza inkinobho ethi "KULUNGILE" efasiteleni le-pop-up futhi uzokwazi ukubuka futhi ulungise amaseli afihliwe eshidini elivikelwe.

Manje njengoba usuyazi le ndlela, uzokwazi ukufinyelela amaseli afihliwe kumaspredishithi avikelwe ku-Excel futhi wenze izinguquko ezidingekayo. Khumbula ukusebenzisa ukuqapha lapho wenza izinguquko kumaspredishithi avikelekile, njengoba lokhu kungase kuthinte ubuqotho bedatha uma ingaphathwa kahle.

11. Ungawakhombisa kanjani amaseli afihliwe ku-Excel Online

Uma usebenza ku-Excel Online futhi uhlangabezana namaseli afihliwe okudingeka ungawafihli, ungakhathazeki! Lapha sizochaza ukuthi ungakwenza kanjani isinyathelo ngesinyathelo. Landela lezi zinyathelo ezilula ukuze uveze amaseli afihliwe ku-Excel Online futhi ube nokufinyelela kulo lonke ulwazi oludingayo.

1. Okokuqala, vula idokhumenti ye-Excel Online equkethe amaseli afihliwe. Uzobona ukuthi amanye amaseli awanalutho futhi awavezwa kusipredishithi. Ukuze uwabonise, kufanele ukhethe amaseli aseduze nalawo afihliwe. Usebenzisa ukhiye wokulawula (Ctrl) kukhibhodi yakho, chofoza amaseli ngaphambi nangemuva kwamaseli afihliwe.

2. Bese, uchofoza kwesokudla kunoma yimaphi amaseli akhethiwe bese ukhetha inketho ethi “Fometha Amaseli”. Iwindi le-pop-up lizovela elinamathebhu amaningana. Khetha ithebhu "Ukuvikela" futhi uqiniseke ukuthi inketho "Efihliwe" ayihloliwe. Chofoza okuthi "KULUNGILE" ukuze usebenzise izinguquko.

12. Ukubonisa wonke amaseli afihliwe ku-Excel ngokuzenzakalelayo

Uma sisebenza ku-Excel, kwesinye isikhathi sihlangana namaseli afihliwe akwenza kube nzima ukubuka idatha. Ngenhlanhla, kunezindlela ezimbalwa zokubonisa wonke amaseli afihliwe ngokuzenzakalelayo. Nansi indlela yesinyathelo ngesinyathelo yokuxazulula le nkinga.

1. Indlela yethebhu “Ekhaya”: Indlela esheshayo nelula yokubonisa wonke amaseli afihliwe ukusebenzisa ithebhu ethi “Ekhaya” kubha yezinketho ze-Excel. Kuleli thebhu, uzothola iqembu elibizwa ngokuthi "Amaseli" lapho inketho ethi "Fometha" ikhona. Ngokuchofoza le nketho, imenyu izovezwa ku- Iyiphi okufanele uyikhethe? "Ukubonakala kweseli" bese "Bonisa konke". Ilungile! Wonke amaseli afihliwe azovezwa khona manjalo.

2. Indlela yesinqamuleli sekhibhodi: Uma ukhetha ukusebenzisa izinqamuleli zekhibhodi, ungasebenzisa le ndlela elandelayo ukuze ubonise wonke amaseli afihliwe. Okokuqala, khetha wonke amaseli ku- Ishidi le-Excel ngokucindezela "Ctrl + A". Bese ucindezela inkinobho ethi "Ctrl" bese ucindezela "Shift". ngasikhathi sinye. Bese ucindezela inkinobho ethi "+" bese ekugcineni ucindezela u-"Ctrl" futhi. Lesi sinqamuleli sekhibhodi esilula sizobonisa wonke amaseli afihliwe.

3. “Thola Futhi Khetha” Indlela Yokukhetha: I-Excel inethuluzi elinamandla elibizwa ngokuthi “Thola Futhi Khetha” elikuvumela ukuthi ubonise wonke amaseli afihliwe. Ukuze usebenzise le nketho, hamba kuthebhu "Ekhaya" futhi uthole iqembu "Ukuhlela". Kuleli qembu, chofoza inketho ethi "Sesha bese ukhetha" bese ukhetha okuthi "Hamba ku". Ewindini le-pop-up, khetha ithebhu ethi "Okubonakalayo" bese uchofoza "Kulungile." Wonke amaseli afihliwe azokhethwa khona manjalo! Uzokwazi ukuzibona kalula, njengoba zigqanyiswe ngombala ohlukile kunawo wonke amaseli.

Ngalezi zindlela ezilula kodwa ezisebenzayo, uzokwazi ukukhombisa wonke amaseli afihliwe ku-Excel ngokuzenzakalelayo. Ngeke kusadingeka uchithe isikhathi usesha amaseli afihliwe ngamunye ngamunye. Sebenzisa lawa maqhinga ukusheshisa umsebenzi wakho ku-Excel futhi uthuthukise ukukhiqiza kwakho. Ungakhohlwa ukulondoloza izinguquko zakho ngemva kokuveza amaseli afihliwe ukuze uwagcine idatha yakho ibuyekeziwe!

13. Ungawathola kanjani kabusha amaseli afihliwe ku-Excel ngemva kokuhlunga noma ukuhlunga

Ukubuyisela amaseli afihliwe ku-Excel ngemva kokufaka isihlungi noma ukuhlunga, landela lezi zinyathelo ezilula:

1. Vula ifayela lakho le-Excel bese ukhetha ithebhu ethi “Ekhaya” phezulu kwesikrini.
2. Eqeqebeni lokuhlela kuribhoni, chofoza okuthi Thola bese ukhetha, bese ukhetha Iya ku... kumenyu yokudonsela phansi.
3. Efasiteleni elithi "Iya ku-", khetha "Okukhethekile" ekhoneni elingezansi kwesokunxele bese ukhetha "Amaseli abonakalayo kuphela" ohlwini lwezinketho.

Lokhu kuzokhetha wonke amaseli abonakalayo kusipredishithi sakho. Ungakopisha futhi unamathisele lawa maseli kwenye indawo noma umane usebenze nawo ngqo endaweni yawo yangempela.

Khumbula ukuthi ungasebenzisa futhi inhlanganisela yokhiye “Ctrl + Shift + 9” ukuze ubonise imigqa efihliwe kanye no-“Ctrl + Shift + 0” ukuze ubonise amakholomu afihliwe. Lezi zinqamuleli zekhibhodi zingaba usizo ikakhulukazi uma udinga kuphela ukubonisa inombolo elinganiselwe yemigqa efihliwe noma amakholomu esikhundleni sawo wonke.

14. Amacebiso Angeziwe Namasu Okubonisa Amaseli Afihliwe ku-Excel

Uma uke waba namaseli afihliwe ku-Excel ofuna ukuwafihla, ungakhathazeki, maningi amathiphu namasu izinyathelo ezengeziwe ongazithatha ukuxazulula le nkinga. Nansi inkomba yesinyathelo ngesinyathelo yokubonisa amaseli afihliwe ku-Excel:

1. Okokuqala, khetha ububanzi bamaseli osola ukuthi kunamaseli afihliwe.
2. Bese, uchofoza kwesokudla phakathi kwebanga elikhethiwe bese ukhetha inketho ethi “Fometha Amaseli”.
3. Ngaphakathi kwewindi lokufometha kweseli, yiya kuthebhu ethi “Ukuvikela” bese ususa ukumaka ibhokisi elithi “Kufihliwe”.
4. Bese uchofoza "KULUNGILE" ukuze usebenzise izinguquko.

Uma amaseli afihliwe angakaboniswa, kungase kube nesihlungi esisetshenziswa kusipredishithi. Ukuze ulungise lokhu, landela lezi zinyathelo:

1. Chofoza umcibisholo wesihlungi kukholamu equkethe amaseli afihliwe futhi ususe ukumaka inketho ethi “Akunalutho” nanoma iyiphi enye inketho ehlunge amaseli.
2. Uma kukhona izihlungi ezisetshenziswa kumakholomu amaningi, phinda isinyathelo sangaphambilini sekholomu ngayinye.
3. Uma usukhubaze izihlungi, amaseli afihliwe kufanele avele futhi kusipredishithi sakho.

Uma amaseli afihliwe engakaboniswa, kungase kudingeke ukuthi uhlole izici zesipredishithi. Landela lezi zinyathelo ezengeziwe:

1. Chofoza kwesokudla ithebhu yesipredishithi ezansi kwewindi le-Excel.
2. Khetha okuthi “Hlola ukuthi kufihliwe yini” ukuze uqiniseke ukuthi isipredishithi asifihliwe.
3. Uma isipredishithi sifihliwe, mane uchofoze kwesokudla ithebhu futhi bese ukhetha "Bonisa" ukuze usenze sibonakale.

Ngamafuphi, i-Excel inikeza imisebenzi ehlukahlukene namasu okukhombisa wonke amaseli afihliwe kuspredishithi. Kusukela ekusebenziseni umyalo othi “Bonisa Konke” kuthebhu yasekhaya ukuya ekusebenziseni izihlungi noma ukungavikeli ishidi, kunezindlela ezihlukene zokuveza amaseli afihliwe. Ukwengeza, kubalulekile ukuqaphela ukuthi kungase kube nezimo lapho amaseli engafihlwanga ngempela, kodwa kunalokho akhonswe amafomula noma amafomethi. Ezimweni ezinjalo, kuyadingeka ukubuyekeza futhi ulungise izilungiselelo ezihambisanayo. Ngolwazi olufanele nokusetshenziswa kwamathuluzi alungile, ungaqinisekisa ukuthi wonke amaseli afihliwe ku-Excel aboniswa kahle futhi ayabonakala.