Uzibonisa njani zonke iiseli ezifihlakeleyo kwi-Excel

I-Excel sisixhobo esisebenza ngeendlela ezininzi nesinamandla esinika uluhlu olubanzi lwemisebenzi kunye neempawu ukwenza lula kunye nokukhawulezisa ukusebenza ngedatha. Nangona kunjalo, ngamanye amaxesha kunokuba nzima ukuchonga nokujonga zonke iiseli ezifihliweyo. kwiphepha yokubala. Kule nqaku, siza kufunda indlela yokubonisa zonke iiseli ezifihliweyo kwi-Excel, usebenzisa iindlela ezilula nezisebenzayo. Ukuba ungumsebenzisi wezobugcisa ojonge ukwandisa ukusebenza kakuhle kuhlalutyo lwakho lwedatha kunye nemisebenzi yokukhohlisa, idatha kwi-excel, eli nqaku liya kuba luncedo kakhulu kuwe.

1. Intshayelelo yendlela yokubonisa zonke iiseli ezifihliweyo kwi-Excel

Kwi-Excel, ngamanye amaxesha kunokuba nzima ukufumana kwaye ubonise zonke iiseli ezifihliweyo kwi-spreadsheet. Nangona kunjalo, kukho iindlela ezininzi zoku sombulula le ngxaki kwaye kweli nqaku siza kukubonisa indlela yokwenza Inyathelo nenyathelo.

1. Ukusebenzisa "Khangela kwaye Khetha" umsebenzi:
Ukufumana zonke iiseli ezifihliweyo kwi-Excel, ungasebenzisa umsebenzi othi "Fumana kwaye ukhethe". Eli nqaku likuvumela ukuba ukhangele umxholo othile kwi-spreadsheet kwaye ukhethe zonke iiseli ezihlangabezana naloo migaqo. Ukusebenzisa eli nqaku, landela la manyathelo:
- Cofa iqhosha elithi "Qala" kwiribhoni ye-Excel.
Kwiqela elithi "Hlela", cofa iqhosha elithi "Fumana kwaye Khetha".
-Khetha "Khangela" ukhetho kwimenyu eyehlayo.
Kwibhokisi yencoko ethi “Khangela”, shiya indawo yokukhangela ingenanto kwaye ucofe iqhosha elithi “Khetha”.
-Khangela ibhokisi ethi "IiNqobo ezifihlakeleyo" kwaye ucofe iqhosha elithi "Kulungile".
- Cofa iqhosha elithi "Fumana Konke" ukuze ubone uluhlu lwazo zonke iiseli ezifihliweyo kwi-spreadsheet.

2. Ukusebenzisa indlela emfutshane yebhodi yezitshixo "Ctrl + Shift + 0":
Enye indlela ekhawulezayo yokubonisa zonke iiseli ezifihliweyo kwi-Excel kukusebenzisa i-"Ctrl + Shift + 0" indlela emfutshane yekhibhodi. Esi sinqumli sebhodi yezitshixo sikuvumela ukuba ubonise yonke imiqolo efihliweyo kwi-spreadsheet. Ukuba ufuna ukubonisa imiqolo efihliweyo ngokunjalo, ungasebenzisa indlela emfutshane ye-keyboard "Ctrl + Shift + 9". Ukusebenzisa ezi ndlela zimfutshane zebhodi yezitshixo, khetha ngokulula iiseli ofuna ukuzibonisa kwaye ucinezele indibaniselwano yeqhosha elihambelanayo.

3. Ukusebenzisa imenyu ethi "Format":
Ungabonisa kwakhona zonke iiseli ezifihliweyo kwi-Excel usebenzisa imenyu ethi "Format". Ukuze wenze oku, landela la manyathelo:
-Khetha iiseli ofuna ukuzibonisa.
-Cofa ekunene kwiiseli ezikhethiweyo kwaye ukhethe "IiSeli zokuFomatha" kwimenyu yomxholo.
Kwisithuba “soKhuseleko”, sukukhangela ibhokisi ethi “Efihliweyo” kwaye ucofe iqhosha elithi “Kulungile”.
-Iiseli ezikhethiweyo ebezifihliwe ziya kubonakala ngoku.

Ngokulandela la manyathelo, uya kuba nakho ukubonisa zonke iiseli ezifihliweyo kwi-spreadsheet ye-Excel ngokulula nangokukhawuleza. Khumbula ukusebenzisa "Fumana kwaye Khetha" umsebenzi, i-"Ctrl + Shift + 0" kunye ne "Ctrl + Shift + 9" iindlela ezimfutshane zekhibhodi, okanye imenyu ethi "Format" ngokuxhomekeke kwizinto ozikhethayo kunye neemfuno zakho. Azisekho iiseli ezifihlakeleyo!

2. Uchonga njani kwaye ukhethe iiseli ezifihliweyo kwi-Excel

Ukuchonga nokukhetha iiseli ezifihliweyo kwi-Excel, kukho amanyathelo amaninzi anokulandelwa. Ngezantsi yinkqubo elula nesebenzayo:

Inyathelo lesi-1: Vula i Ifayile ye-Excel apho ufuna ukuchonga kwaye ukhethe iiseli ezifihliweyo.

Inyathelo lesi-2: Nje ukuba ifayile ivuliwe, khetha zonke iiseli zayo ngokucinezela indibaniselwano yesitshixo "Ctrl + A" okanye ucofe iqhosha elingunxantathu elibekwe kwikona ephezulu ngasekhohlo yespreadsheet. Oku kuya kuvumela naziphi na iiseli ezifihliweyo ukuba zikhethwe kunye nezibonakalayo.

Inyathelo lesi-3: Emva koko, ukuchonga iiseli ezifihliweyo, kufuneka ubeke ingqalelo kulo naluphi na utshintsho ekukhethweni. Iiseli ezifihlakeleyo ziya kuboniswa ngolwandlalo olunamachaphaza endaweni yolwandlalo oluqhelekileyo. Ngokuchonga ezi seli zifihliweyo, unokwenza izinto ezahlukeneyo, njengokuzibonisa, ukuzicima, okanye ukutshintsha ifomathi yazo.

3. Iindlela zokubonisa zonke iiseli ezifihliweyo kwi-Excel

1. Ukubonisa zonke iiseli ezifihliweyo kwi-Excel, uneendlela ezimbini ezinokwenzeka. Eyokuqala kukwenza ngesandla, ngelixa okwesibini kufuna ukusetyenziswa komsebenzi obonelelwe yi-Excel. Kuzo zombini iimeko, amanyathelo alula kwaye unokukhetha ukhetho olulungele iimfuno zakho.

2. Indlela yoku-1: Ukubonisa iiseli ezifihliweyo ngesandla, landela la manyathelo:
- Khetha Zonke uluhlu lweeseli apho ukrokrela ukuba kukho iiseli ezifihliweyo.
Cofa ekunene kwiiseli ezikhethiweyo kwaye ukhethe "IiSeli zokuFomatha" kwimenyu yomxholo.
Kwisithuba “soKhuseleko”, sukukhangela inketho ethi “Efihliweyo” kwaye ucofe u-“Kulungile”. Eli nyathelo liqinisekisa ukuba iiseli ezifihliweyo ziboniswa kwi-spreadsheet.
- Ukuba awuboni iiseli ezifihliweyo emva kokwenza la manyathelo, kunokuba yimfuneko ukutshintsha ifomathi yeeseli kwifomathi ebonakalayo, efana ne "General" okanye "Umbhalo."

3. Indlela yesi-2: I-Excel ikwabonelela ngomsebenzi othi "Bonisa Konke" ongasetyenziselwa ukubonisa zonke iiseli ezifihliweyo kwi-spreadsheet. Ukusebenzisa eli nqaku, landela la manyathelo:
- Cofa kwindawo ethi "Ekhaya" kwi ibar yesixhobo evela kwi-Excel.
Kwiqela elithi "Hlela", jonga inketho ethi "Fumana kwaye ukhethe" kwaye ucofe i icon ethi "Yiya kwiSpecial".
Kwifestile ye-pop-up, khetha ukhetho "lweeseli ezifihlakeleyo" kwaye ucofe "Kulungile". I-Excel iya kuqaqambisa zonke iiseli ezifihliweyo kwi-spreadsheet.
-Ukubonisa iiseli ezifihliweyo, cofa ekunene kuyo nayiphi na iseli ephawulweyo kwaye ukhethe "Bonisa" kwimenyu yomxholo.

Ezi ndlela zikuvumela ukuba ubonise zonke iiseli ezifihliweyo kwi-Excel ngokukhawuleza kwaye kulula. Khumbula ukuba kubalulekile ukuthathela ingqalelo ubumfihlo bolwazi kwi-spreadsheet yakho phambi kokubonisa zonke iiseli ezifihliweyo.

4. Ukusebenzisa i "Format" ukhetho lokubonisa iiseli ezifihliweyo kwi-Excel

Rhoqo xa sisebenza nge-Excel, sinokuzifumana sifuna ukufihla ezinye iiseli kwi-spreadsheets zethu. Nangona kunjalo, kunokuba nzima ukujonga idatha efihliweyo kwaye wenze utshintsho kuyo. Ngethamsanqa, i-Excel isinika ukhetho olubizwa ngokuba yi "Format" evumela ukuba sibonise iiseli ezifihliweyo ngaphandle kokuzityhila ngokupheleleyo.

Ukusebenzisa olu khetho, kufuneka sikhethe iiseli eziqulethe idatha efihliweyo kwaye ucofe iqhosha lasekunene lemouse. Okulandelayo, imenyu eyehlayo iya kuvula apho kufuneka sikhethe u- "Format" ukhetho. Ngaphakathi kwimenyu yefomathi, kufuneka siye kwithebhu ethi "Iiseli" kwaye ukhethe "Efihliweyo" ukhetho. Ukukhangela olu khetho kuya kubangela ukuba idatha efihliweyo iboniswe kwifomati eyahlukileyo, iyenza kube lula ukujonga kunye nokuguqula.

Kubalulekile ukuba uqaphele ukuba xa usebenzisa i "Format" ukhetho lokubonisa iiseli ezifihliweyo, olu tshintsho luya kusetyenziswa kuphela kuxwebhu lwangoku. Ukuba ufuna ukubonisa iiseli ezifihliweyo kuwo onke amaxwebhu e-Excel, kufuneka wenze inkqubo efanayo kwifayile nganye. Olu phawu luluncedo xa usebenza kwifayile ethile kwaye awufuni ukutyhila zonke iiseli ezifihliweyo kwamanye amaxwebhu.

5. Ukusebenzisa iindlela ezimfutshane zekhibhodi ukubonisa zonke iiseli ezifihliweyo kwi-Excel

Kwi-Excel, ngamanye amaxesha kunokuba nzima ukufumana zonke iiseli ezifihliweyo kwi-spreadsheet. Nangona kunjalo, kukho iindlela ezimfutshane zekhibhodi ezikuvumela ukuba ubonise ngokukhawuleza zonke ezi seli. Nanga amanyathelo ekufuneka uwalandele:

1. Khetha zonke iiseli kwi-spreadsheet ngokucinezela i-Ctrl + A indibaniselwano yesitshixo Oku kuya kukhetha zonke iiseli ezibonakalayo nezingabonakaliyo kwiphepha.

2. Cofa ekunene nakweyiphi na iseli ekhethiweyo kwaye ukhethe u-“Fomatha iiseli” kwi-drop-down menu.

3. Phantsi kwe "Protection" thebhu, sukukhangela "Efihliweyo" ukhetho kwaye ucofe "Kulungile" ukusebenzisa utshintsho.

Nje ukuba ulandele la manyathelo, zonke iiseli ezifihliweyo kwi-spreadsheet ziya kuboniswa kwakhona. Khumbula ukuba esi sinqumli sebhodi yezitshixo siluncedo ngakumbi xa usebenza ngeespredishithi ezinkulu kwaye kufuneka ujonge zonke iiseli ezifihliweyo ngokukhawuleza nalula. Zama le ndlela imfutshane kwaye wonge ixesha emsebenzini wakho nge-Excel!

Kubalulekile ukukhankanya ukuba lo msebenzi uza kubonisa kuphela iiseli ozifihlileyo ngesandla. Ukuba uneeseli ezifihliweyo ngenxa yefomula ethile okanye ukuhluzwa kwedatha, le sinqumli yebhodibhodi ayizuzibonisa. Kwezo meko, kuya kufuneka uphonononge ifomula yakho okanye useto lokucoca ukuqinisekisa ukuba zonke iiseli eziyimfuneko zibonisiwe.

Khumbula ukugcina utshintsho lwakho emva kokubonisa zonke iiseli ezifihliweyo ukunqanda ukulahleka kwedatha. Sebenzisa le sinqumli yebhodibhodi kwi-Excel kwaye wandise umsebenzi wakho ngeespredishithi ngokufanelekileyo!

6. Ukubonisa iiseli ezifihliweyo usebenzisa i-macros kwi-Excel

Ukubonisa iiseli ezifihliweyo usebenzisa iimakhro kwi-Excel, unokulandela la manyathelo alandelayo:

1. Vula ifayile ye-Excel apho ufuna ukubonisa iiseli ezifihliweyo.

2. Cofa ithebhu ethi "Developer" kwiribhoni. Ukuba awukwazi ukuyibona le thebhu, kufuneka uyenze isebenze kwiisetingi ze-Excel.

3. Cofa iqhosha elithi “Visual Basic” ukuvula iVisual Basic Editor.

4. Kwi-Visual Basic Editor, cofa imenyu ethi "Faka" kwaye ukhethe "Imodyuli" ukufaka imodyuli entsha kwifayile.

5. Kwimodyuli entsha, bhala le khowudi ilandelayo:

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

6. Cofa iqhosha elithi "Run" okanye ucinezele iqhosha le-F5 ukuqhuba i-macro.

Nje ukuba usebenzise i-macro, zonke iiseli ezifihliweyo kwifayile ye-Excel ziya kuboniswa kwakhona. Le khowudi isisiseko sisiqalo esihle, kodwa ungayenza ngokweemfuno zakho. Umzekelo, unokongeza izihluzi ukubonisa kuphela iiseli ezifihliweyo kwiphepha elithile okanye kuluhlu oluthile lweeseli.

Khumbula ukugcina ifayile emva kokuqhuba i-macro ukuze utshintsho lusetyenziswe ngokusisigxina. Ukongeza, ukusebenzisa ii-macros kwi-Excel kunokufuna uhlengahlengiso kwiisetingi zakho zokhuseleko, ke unokufuna ukuvumela iimacros ukuba ziqhube kwifayile yakho. Zama kwaye uthathe ithuba le-Excel macros ukwenza umsebenzi wakho usebenze ngakumbi!

7. Uyibonisa njani yonke imiqolo kunye neekholamu ezifihliweyo kwi-Excel

Ngamanye amaxesha, xa sisebenza kwi-Excel, sidibana nemiqolo efihliweyo kunye neekholamu ezenza umsebenzi wethu ube nzima. Ngethamsanqa, kukho indlela elula yokubonisa yonke imiqolo efihliweyo kunye neekholamu kwi-Excel. Apha siza kuchaza indlela yokwenza inyathelo ngenyathelo:

1. Vula ifayile ye-Excel apho ufuna ukubonisa imiqolo efihliweyo kunye neekholamu.
2. Khetha ispredishithi siphela ngokucofa iqhosha elibekwe ekudibaneni koonobumba kunye namanani kumphetho ongasentla osekhohlo wephepha. Unokucinezela u-Ctrl+A ukukhetha yonke idatha.
3. Yiya kwi-"eKhaya" ithebhu kwi-toolbar ye-Excel kwaye ujonge iqela elithi "Iiseli". Cofa iqhosha elithi "Format" kwaye emva koko "Fihla kwaye ubonise." Imenyu yokuhla izakuvela.

Ukusuka kwimenyu eyehlayo, khetha "Bonisa iirowu ezifihliweyo" okanye "Bonisa iikholamu ezifihliweyo," kuxhomekeke kwinto ofuna ukuyibonisa. Yonke imiqolo efihliweyo okanye iikholamu kwi-spreadsheet iya kuboniswa ngoko nangoko.

Ukuba ufuna kuphela ukubonisa umqolo othile okanye ikholamu, endaweni yayo yonke imigca efihliweyo okanye iikholamu, ungenza njalo ngokukhetha umqolo okanye ikholamu ngokuthe ngqo kwaye ulandele amanyathelo afanayo akhankanywe ngasentla. Oku kuluncedo ukuba ufuna kuphela ukuveza ngokukhethayo ulwazi olufihliweyo.

8. Ukulungisa iingxaki eziqhelekileyo xa uzama ukubonisa iiseli ezifihliweyo kwi-Excel

Enye yeengxaki eziqhelekileyo xa uzama ukubonisa iiseli ezifihliweyo kwi-Excel kukuba idatha olindele ukuyibona ayifumaneki. Kukho izizathu ezininzi zokuba kutheni oku kunokwenzeka, kodwa ngethamsanqa kukho izisombululo ezilula zokuyicombulula. Kweli nqaku, siya kunika isikhokelo sesinyathelo ngesinyathelo ukulungisa lo mbandela kwaye siqinisekise ukuba iiseli ezifihliweyo ziboniswa ngokuchanekileyo.

Inyathelo lokuqala lokulungisa le ngxaki kukukhangela ukuba ngaba iiseli zifihlwe ngokwenene na okanye zifomathwe nje ngemvelaphi okanye ngombala wefonti ozenza zibonakale zingabonakali. Ukwenza oku, khetha iiseli ekumele ukuba zifihliwe kwaye usebenzise ukufomatha kwefonti engqindilili okanye umbala ongasemva owahlukileyo ukuze uzenze zibonakale kwakhona. Oku kudla ngokusombulula ingxaki kwiimeko ezininzi.

Ukuba iiseli azikaboniswa emva kokujonga ukufomatha, zinokufihlwa. Kule meko, ungasebenzisa i-Excel yokufumana kunye nokutshintsha umsebenzi wokufumana kunye nokubonisa iiseli ezifihliweyo. Okokuqala, vula isixhobo sokufumana kunye nokutshintsha indawo ngokucinezela i-Ctrl + F. Emva koko, nqakraza kwithebhu ethi "Buyisela" kwaye ushiye "Fumana" kwaye "Buyisela" amasimi angenanto. Cofa u-"Khetha" kwaye uqiniseke ukuba "ukufomatha okufihlakeleyo" kujongiwe. Ekugqibeleni, cofa "Buyisela Konke" kwaye iiseli ezifihliweyo ziya kuboniswa.

9. Ukusebenzisa izihluzi eziphambili ukubonisa iiseli ezifihlakeleyo kwi-Excel

Ukubonisa iiseli ezifihliweyo kwi-Excel, ukhetho oluluncedo kakhulu kukusebenzisa izihluzi eziphambili. Ezi zihluzo zikuvumela ukuba ubeke iimeko ezithile ukubonisa kuphela iiseli ezihlangabezana nezo meko. Amanyathelo ekufuneka uwalandele ukusebenzisa esi sixhobo aya kuchazwa ngezantsi.

Okokuqala, kufuneka ukhethe uluhlu lweeseli ofuna ukusebenza kuzo. Ukwenza oku, ungasebenzisa imouse ukutsala kwaye ukhethe uluhlu olufunekayo, okanye ungachwetheza ngokuthe ngqo uluhlu lwereferensi kwibha yefomula. Nje ukuba uluhlu lukhethiwe, kufuneka uye kwi "Data" tab kwaye ucofe kwiqhosha elithi "Hlunga" ukuvula izihluzi eziphambili.

I icon yecebo lokucoca elincinane liza kuvela kwikona yasekunene kwiseli nganye yentloko yomhlathi. Ngokunqakraza kolu phawu, imenu eneendlela ezahlukeneyo zokucoca iya kuboniswa. Ukubonisa iiseli ezifihliweyo, kufuneka ukhethe ukhetho "lweSiko" kwaye kwifestile ephumayo, khetha ukhetho "Bonisa" kwindawo ethi "Uhlobo lweSihluzo". Okokugqibela, kufuneka ucofe iqhosha elithi "Kulungile" ukufaka isihluzo kwaye ubonise kuphela iiseli ezifihliweyo ezihlangabezana neemeko ezimiselweyo.

10. Ukubonisa iiseli ezifihlakeleyo kwiispredishithi ezikhuselweyo kwi-Excel

Ukuba usebenza ngeespredishithi ezikhuselweyo kwi-Excel, unokuzifumana ufuna ukubonisa iiseli ezifihliweyo ukwenza imisebenzi ethile. Nangona ngokungagqibekanga i-Excel ayikuvumeli ukuba uguqule okanye ujonge iiseli ezifihliweyo kumaphepha akhuselweyo, kukho indlela onokuthi uyilandele ukusombulula le ngxaki kwaye ufikelele kwezo seli zifihliweyo uzifunayo.

Ngezantsi, sibonisa inyathelo ngenyathelo ukubonisa iiseli ezifihliweyo kwiispredishithi ezikhuselweyo kwi-Excel:

1. Vula ifayile ye-Excel ekhuselweyo kwaye ufumane ithebhu ethi "Hlaziya" kwibar yemenyu ephezulu.
2. Cofa kwindawo ethi "Tshintsha Incwadi Yokusebenzela" kwaye ukhethe "Iispreadsheets ezingakhuselwanga" kwimenyu eyehlayo.
3. Nje ukuba ukhetho lukhethiwe, iwindow entsha ephumayo iya kuvela. Kule festile, cofa i-spreadsheet ekhuselweyo ofuna ukubonisa kuyo iiseli ezifihliweyo.
4. Ekugqibeleni, cofa iqhosha elithi "Kulungile" kwifestile ye-pop-up kwaye uya kukwazi ukujonga kunye nokuguqula iiseli ezifihliweyo kwiphepha elikhuselweyo.

Ngoku ukuba uyayazi le ndlela, uya kukwazi ukufikelela kwiiseli ezifihliweyo kwiispredishithi ezikhuselweyo kwi-Excel kwaye wenze izilungiso eziyimfuneko. Khumbula ukusebenzisa isilumkiso xa usenza utshintsho kwi-spreadsheets ezikhuselweyo, njengoko oku kunokuchaphazela ingqibelelo yedatha ukuba ayiphathwa kakuhle.

11. Uzibonisa njani iiseli ezifihliweyo kwi-Excel Online

Ukuba usebenza kwi-Excel kwi-Intanethi kwaye udibana neeseli ezifihliweyo ekufuneka ungazifihli, ungakhathazeki! Apha siza kuchaza indlela ongayenza ngayo inyathelo ngenyathelo. Landela la manyathelo alula ukuveza iiseli ezifihliweyo kwi-Excel Online kwaye ube nokufikelela kulo lonke ulwazi oludingayo.

1. Okokuqala, vula uxwebhu lwe-Excel Online oluqulethe iiseli ezifihliweyo. Uya kubona ukuba ezinye iiseli azinanto kwaye aziboniswa kwi-spreadsheet. Ukuze uzibonise, kufuneka ukhethe iiseli ezikufutshane nezo zifihliweyo. Ukusebenzisa iqhosha lokulawula (Ctrl) kwikhibhodi yakho, cofa iiseli ngaphambi nasemva kweeseli ezifihliweyo.

2. Emva koko, nqakraza-ekunene nakweyiphi na yeeseli ezikhethiweyo kwaye ukhethe "Fomatha iiseli" ukhetho. Ifestile ezivelelayo ziya kuvela ezineethebhu ezininzi. Khetha ithebhu ethi "Ukhuseleko" kwaye uqiniseke ukuba ukhetho "olufihliweyo" alukhangelwanga. Cofa "Kulungile" ukusebenzisa utshintsho.

12. Ukubonisa zonke iiseli ezifihliweyo kwi-Excel ngokuzenzekelayo

Xa sisebenza kwi-Excel, ngamanye amaxesha sidibana neeseli ezifihliweyo ezenza kube nzima ukujonga idatha. Ngethamsanqa, kukho iindlela ezininzi zokubonisa zonke iiseli ezifihliweyo ngokuzenzekelayo. Nantsi indlela yesinyathelo-nge-nyathelo yokusombulula le ngxaki.

1. Indlela yethebhu "Ekhaya": Indlela ekhawulezayo nelula yokubonisa zonke iiseli ezifihliweyo kukusebenzisa ithebhu ethi "Ekhaya" kwibha yeenketho ze-Excel. Kule thebhu, uya kufumana iqela elibizwa ngokuba yi "Seli" apho kukho ukhetho lwe "Format". Ngokunqakraza kolu khetho, i menu izakuboniswa kwi Yeyiphi omele ukhethe? "Ukubonakala kweseli" kwaye emva koko "Bonisa zonke". Ulungile! Zonke iiseli ezifihlakeleyo ziya kutyhilwa ngoko nangoko.

2. Indlela enqumlayo ye-keyboard: Ukuba ukhetha ukusebenzisa indlela emfutshane ye-keyboard, ungasebenzisa le ndlela ilandelayo ukubonisa zonke iiseli ezifihliweyo. Okokuqala, khetha zonke iiseli kwi Ispredishithi se-Excel ngokucinezela "Ctrl + A". Emva koko, ubambe iqhosha elithi "Ctrl" kwaye ucinezele iqhosha elithi "Shift". ngaxeshanye. Emva koko cofa iqhosha elithi "+" kwaye ekugqibeleni ucofe iqhosha elithi "Ctrl" kwakhona. Esi sinqumli silula siza kubonisa zonke iiseli ezifihliweyo.

3. "Fumana kwaye ukhethe" Indlela yokuKhetha: I-Excel inesixhobo esinamandla esibizwa ngokuthi "Fumana kwaye ukhethe" ekuvumela ukuba ubonise zonke iiseli ezifihliweyo. Ukusebenzisa olu khetho, yiya kwithebhu ethi "Ekhaya" kwaye ufumane iqela elithi "Hlela". Kweli qela, cofa ku "Khangela kwaye ukhethe" ukhetho kwaye ukhethe "Yiya ku". Kwifestile ye-pop-up, khetha ithebhu ethi "Ebonakalayo" kwaye emva koko ucofe "Kulungile." Zonke iiseli ezifihliweyo ziya kukhethwa ngoko nangoko! Uya kukwazi ukuzibona ngokulula, kuba ziphawulwe ngombala owahlukileyo kunezinye iiseli.

Ngezi ndlela zilula kodwa ezisebenzayo, uya kuba nakho ukubonisa zonke iiseli ezifihliweyo kwi-Excel ngokuzenzekelayo. Awusayi kuphinda uchithe ixesha ukhangela iiseli ezifihlakeleyo nganye nganye. Sebenzisa la maqhinga ukukhawulezisa umsebenzi wakho kwi-Excel kunye nokuphucula imveliso yakho. Ungalibali ukugcina utshintsho lwakho emva kokutyhila iiseli ezifihliweyo ukuze uzigcine idatha yakho ihlaziyiwe!

13. Uzifumana njani iiseli ezifihliweyo kwi-Excel emva kokucoca okanye ukuhlenga

Ukufumana kwakhona iiseli ezifihliweyo kwi-Excel emva kokufaka isihluzi okanye ukuhlela, landela la manyathelo alula:

1. Vula ifayile yakho ye-Excel kwaye ukhethe ithebhu ethi "Ekhaya" phezulu ukusuka kwisikrini.
2. Kwiqela lokuHlela kwiribhoni, cofa Fumana kwaye Khetha, uze ukhethe Yiya ku... kwimenyu ehlayo.
3. Kwifestile ethi "Yiya", khetha u-"Special" kwikona esezantsi ekhohlo uze ukhethe "Iiseli ezibonakalayo kuphela" kuluhlu lwezinto onokukhetha kuzo.

Oku kuya kukhetha zonke iiseli ezibonakalayo kwi-spreadsheet sakho. Ungakopa kwaye uncamathisele ezi seli kwenye indawo okanye ngokulula usebenze nazo ngqo kwindawo yazo yoqobo.

Khumbula ukuba ungasebenzisa indibaniselwano yesitshixo "Ctrl + Shift + 9" ukubonisa imiqolo efihliweyo kunye ne "Ctrl + Shift + 0" ukubonisa iikholamu ezifihliweyo. Ezi ndlela zimfutshane zebhodi yezitshixo zinokuba luncedo ngakumbi ukuba ufuna kuphela ukubonisa inani eliqingqiweyo lemiqolo efihliweyo okanye imihlathi endaweni yazo zonke.

14. Iingcebiso ezongezelelweyo kunye namaqhinga okubonisa iiseli ezifihlakeleyo kwi-Excel

Ukuba ukhe waba neeseli ezifihliweyo kwi-Excel ofuna ukuzifihla, ungakhathazeki, zininzi iingcebiso namaqhinga amanyathelo ongezelelweyo onokuwathatha ukusombulula lo mba. Nantsi isikhokelo senyathelo nenyathelo lokubonisa iiseli ezifihliweyo kwi-Excel:

1. Okokuqala, khetha uluhlu lweeseli okrokrela ukuba kukho iiseli ezifihliweyo.
2. Emva koko, cofa ekunene phakathi koluhlu olukhethiweyo kwaye ukhethe "Iiseli zokuFomatha" ukhetho.
3. Ngaphakathi kwefestile yokufomatha kweeseli, yiya kwithebhu ethi "Ukhuseleko" kwaye ungaqwalasela ibhokisi ethi "Efihliweyo".
4. Okulandelayo, cofa u-"Yamkela" ukuze usebenzise utshintsho.

Ukuba iiseli ezifihliweyo azikaboniswa, kusenokubakho isihluzi esifakwa kwi-spreadsheet. Ukulungisa oku, landela la manyathelo:

1. Cofa utolo lwesihluzi kwikholamu equlethe iiseli ezifihliweyo kwaye ungakhangeli inketho ethi "Ayinanto" okanye naluphi na olunye ukhetho oluhluze iiseli.
2. Ukuba kukho izihluzi ezifakwe kwikholamu ezininzi, phinda inyathelo langaphambili kwikholamu nganye.
3. Nje ukuba uzicime izihluzi, iiseli ezifihliweyo kufuneka zivele kwakhona kwi-spreadsheet sakho.

Ukuba iiseli ezifihliweyo zisaboniswa, kunokuba yimfuneko ukujonga iimpawu zespredishithi. Landela la manyathelo ongezelelweyo:

1. Cofa ekunene ithebhu yespredishithi ezantsi kwefestile ye-Excel.
2. Khetha "Khangela ukuba ifihliwe" ukuqinisekisa ukuba i-spreadsheet ayifihlwanga.
3. Ukuba i-spreadsheet sifihliwe, cofa ekunene ithebhu kwakhona kwaye ukhethe u-"Bonisa" ukuyenza ibonakale.

Ngamafutshane, i-Excel inikezela ngemisebenzi eyahlukeneyo kunye neendlela zokubonisa zonke iiseli ezifihliweyo kwi-spreadsheet. Ukusuka ekusebenziseni umyalelo othi "Bonisa Konke" kwithebhu yaseKhaya ukuya ekusebenziseni izihluzi okanye ukungakhuseli iphepha, kukho iindlela ezahlukeneyo zokutyhila iiseli ezifihliweyo. Ukongezelela, kubalulekile ukuqaphela ukuba kunokubakho iimeko apho iiseli zingafihlwanga ngokwenene, kodwa kunokuba zilungiswe ngeefomula okanye iifomathi. Kwiimeko ezinjalo, kuyimfuneko ukuphonononga kunye nokulungelelanisa izicwangciso ezihambelanayo. Ngolwazi oluchanekileyo kunye nokusetyenziswa kwezixhobo ezifanelekileyo, unokuqinisekisa ukuba zonke iiseli ezifihliweyo kwi-Excel ziboniswa ngokufanelekileyo kwaye ziyabonakala.