Okuqukethwe
Inzuzo enkulu yamaspredishithi e-Excel ukuthi umsebenzisi angasebenza ngawo womabili ishidi elilodwa nambalwa. Lokhu kwenza kube nokwenzeka ukuhlela ulwazi ngendlela evumelana nezimo. Kodwa ngezinye izikhathi kungase kufike nezinkinga ezithile. Nokho, kukhona zonke izinhlobo zezimo, ingase iqukathe ulwazi mayelana nezimpahla ezibalulekile zezezimali noma uhlobo oluthile lwemfihlo yokuhweba okufanele ngabe ifihliwe kubancintisana nabo. Lokhu kungenziwa ngisho nangamathuluzi ajwayelekile e-Excel. Uma umsebenzisi efihle ishidi ngephutha, sizobe sesithola ukuthi yini okufanele yenziwe ukulikhombisa. Ngakho-ke, yini okudingeka yenziwe ukuze kwenziwe kokubili isenzo sokuqala nesesibili?
Le ndlela ilula kakhulu ukuyisebenzisa ngoba inezinyathelo ezimbili.
- Okokuqala sidinga ukubiza imenyu yokuqukethwe. Ukuze wenze lokhu, udinga ukuchofoza kwesokudla noma ucindezele ngeminwe emibili ku-trackpad, ngemva kokuhambisa ikhesa endaweni oyifunayo. Inketho yokugcina yokubiza imenyu yokuqukethwe isekelwa kuphela amakhompyutha anamuhla, hhayi wonke. Nokho, iningi lezinhlelo zokusebenza zesimanje ziyayisekela, njengoba ilula kakhulu kunokucindezela inkinobho ekhethekile ku-trackpad.
- Kumenyu yokuqukethwe evelayo, bheka inkinobho ethi "Fihla" bese uchofoza kuyo.
Konke, ngokuqhubekayo leli shidi ngeke liboniswe.
Ungalifihla kanjani ishidi ku-Excel usebenzisa amathuluzi
Le ndlela ayidumile njengeyangaphambili. Nokho, likhona ithuba elinjalo, ngakho kungaba kuhle ukwazi ngakho. Kukhona ezinye izinto ezimbalwa ongazenza lapha:
- Hlola ukuthi ukuthebhu "Ekhaya" noma kwenye. Uma umsebenzisi enenye ithebhu evuliwe, udinga ukuya "Ekhaya".
- Kukhona into ethi "Amaseli". Kufanele uchofoze inkinobho ehambisanayo. Bese kuzovela ezinye izinkinobho ezintathu, esinentshisekelo kweyongakwesokudla (esayinwe ngokuthi “Ifomethi”).
- Ngemuva kwalokho, kuvela enye imenyu, lapho phakathi nendawo kuzoba khona inketho ethi "Fihla noma bonisa". Sidinga ukuchofoza "Fihla ishidi".
- Ngemva kokuqeda zonke lezi zinyathelo, ishidi lizofihlwa emehlweni abanye abantu.
Uma iwindi lohlelo likuvumela lokhu, khona-ke inkinobho ethi “Fometha” izovezwa ngqo kuribhoni. Ngeke kube khona ukuchofoza inkinobho ethi "Amaseli" ngaphambi kwalokhu, ngoba manje kuzoba ibhulokhi yamathuluzi.
Elinye ithuluzi elikuvumela ukuthi ufihle ishidi libizwa nge-Visual Basic Editor. Ukuze uyivule, udinga ukucindezela inhlanganisela yokhiye Alt + F11. Ngemva kwalokho, sichofoza ishidi esilithandayo bese sibheka iwindi lezakhiwo. Sinentshisekelo kunketho ebonakalayo.
Kunezinketho ezintathu zokwenza ngokwezifiso isibonisi seshidi:
- Ishidi liyaboniswa. Kuboniswa ikhodi -1 esithombeni esingenhla.
- Ishidi aliboniswa, kodwa lingabonakala ohlwini lwamashidi afihliwe. Kuboniswa ngekhodi 0 ohlwini lwezakhiwo.
- Iqabunga lifihlwe kakhulu. Lesi isici esiyingqayizivele somhleli we-VBA esikuvumela ukuthi ufihle ishidi ukuze lingatholakali ohlwini lwamashidi afihliwe ngokusebenzisa inkinobho ethi “Bonisa” kumenyu yokuqukethwe.
Ngaphezu kwalokho, umhleli we-VBA wenza kube nokwenzeka ukwenza inqubo ngokuzenzakalelayo kuye ngokuthi yimaphi amanani, njengenketho, aqukethwe kumaseli noma yiziphi izenzakalo ezenzekayo.
Ungawafihla kanjani amashidi amaningi ngesikhathi esisodwa
Awukho umehluko oyisisekelo phakathi kokuthi ungafihla kanjani ishidi elingaphezu kwelilodwa zilandelana noma ufihla kanjani elinye lawo. Ungamane uzifihle ngokulandelana ngendlela echazwe ngenhla. Uma ufuna ukonga isikhathi esincane, khona-ke kukhona enye indlela. Ngaphambi kokuyisebenzisa, udinga ukukhetha wonke amashidi okudingeka afihlwe. Yenza ukulandelana kwezenzo okulandelayo ukuze ususe amashidi amaningana ekubukeni ngesikhathi esisodwa:
- Uma zisondelene, sidinga ukusebenzisa ukhiye we-Shift ukuze sizikhethe. Okokuqala, sichofoza ishidi lokuqala, emva kwalokho sicindezela futhi sibambe le nkinobho kukhibhodi, ngemva kwalokho sichofoza ishidi lokugcina lalabo okudingeka sikufihle. Ngemva kwalokho, ungakwazi ukukhulula ukhiye. Ngokuvamile, akukho mehluko endleleni lezi zenzo okufanele zenziwe ngayo. Ungaqala kweyokugcina, ubambe u-Shift, bese uya kweyokuqala. Ukuze usebenzise le ndlela, udinga ukuhlela amashidi azofihlwa eduze kwamanye ngokuvele uhudule igundane.
- Indlela yesibili iyadingeka uma amashidi engekho eduze komunye nomunye. Kuzothatha isikhashana. Ukuze ukhethe eziningana ezisebangeni elithile ukusuka kwelinye, kufanele uchofoze eshidini lokuqala, bese ukhetha ngokulandelana ngalinye elilandelayo ngokhiye u-Ctrl. Ngokwemvelo, kufanele ligcinwe licindezelwe, futhi eshidini ngalinye, chofoza kanye inkinobho yegundane kwesokunxele.
Uma sesiqedile lezi zinyathelo, izinyathelo ezilandelayo ziyefana. Ungasebenzisa imenyu yokuqukethwe futhi ufihle amathebhu noma uthole inkinobho ehambisanayo kubha yamathuluzi.
Kunezindlela ezimbalwa zokubonisa amashidi afihliwe ku-Excel. Okulula kakhulu kuzo ukusebenzisa imenyu yokuqukethwe efanayo njengokuyifihla. Ukuze wenze lokhu, udinga ukuchofoza kunoma imaphi amashidi asele, uchofoze kwesokudla ngegundane (noma sebenzisa ukuthinta okukhethekile kwe-trackpad uma usuka kwikhompyutha ephathekayo yesimanje) bese uthola inkinobho ethi “Bonisa” ohlwini oluvelayo. Ngemuva kokuthi siyichofoze, kuzovela iwindi elinohlu lwamashidi afihliwe. Izoboniswa ngisho noma kuneshidi elilodwa kuphela. 
Uma ukucasha kwenziwa kusetshenziswa i-macro, ungabonisa wonke amashidi abefihlwe ngekhodi encane.
Sub OpenAllHiddenSheets()
Fiphalisa Ishidi Njengeshidi Lokusebenzela
Ngeshidi ngalinye Ku-ActiveWorkbook.Amashidi okusebenzela
Uma Ishidi.Libonakala <> xlSheetVisible Bese
Ishidi.Liyabonakala = xlSheetVisible
Qeda Uma
Olandelayo
Qeda i-Sub
Manje kusele kuphela ukusebenzisa le macro, futhi wonke amashidi afihliwe azovulwa ngokushesha. Ukusebenzisa ama-macros kuyindlela elula yokwenza ukuvulwa nokufihlwa kwamashidi kuye ngokuthi yiziphi izehlakalo ezenzeka ohlelweni. Futhi, usebenzisa ama-macros, ungabonisa inani elikhulu lamashidi ngesikhathi. Kuhlala kulula ukwenza lokhu ngekhodi.