Okuqukethwe
Kwenzeka ukuthi eshidini le-Excel udinga ukufihla ulwazi oluqukethwe kwamanye amaseli, noma ufihle umugqa wonke noma ikholomu. Lokhu kungase kube uhlobo oluthile lwedatha eyisiza amanye amaseli abhekisela kulo futhi ongafuni ukuyibonisa.
Sizokufundisa ukuthi uwafihla kanjani amaseli, imigqa namakholomu kumashidi e-Excel bese uwenza abonakale futhi.
Ifihla amaseli
Ayikho indlela yokufihla iseli ukuze linyamalale ngokuphelele eshidini. Umbuzo uphakama: yini eyosala endaweni yaleli cell? Kunalokho, i-Excel ingayenza ukuze kungabikho okuqukethwe okuboniswa kulelo seli. Khetha iseli eyodwa noma iqembu lamaseli usebenzisa okhiye Shift и Ctrl, njengalapho kukhethwa amafayela amaningi ku-Windows Explorer. Chofoza kwesokudla kunoma yimaphi amaseli akhethiwe bese uchofoza kumenyu yokuqukethwe Ifomethi yeseli (Fometha Amaseli).
Ibhokisi lengxoxo legama elifanayo lizovuleka. Iya kuthebhu Inombolo (Inombolo) nasohlwini Amafomethi ezinombolo (Isigaba) khetha Wonke amafomethi (Ngokwezifiso). Enkambini yokufaka Uhlobo (Uhlobo) faka amasemikholoni amathathu – “;;;” (ngaphandle kwezingcaphuno) bese uchofoza OK.
Qaphela: Mhlawumbe, ngaphambi kokufaka ifomethi entsha kumaseli, kufanele ushiye isikhumbuzi sokuthi yimaphi amafomethi ezinombolo ayekhona kumaseli ngayinye, ukuze esikhathini esizayo ungabuyisela ifomethi endala kuseli futhi wenze okuqukethwe kwayo kubonakale futhi.
Idatha ekuseli elikhethiwe manje isifihliwe, kodwa inani noma ifomula isekhona futhi ingabonakala kubha yefomula.
Ukwenza okuqukethwe kwamaseli kubonakale, landela zonke izinyathelo ezingenhla bese usetha ifomethi yenombolo yokuqala yeseli.
Qaphela: Noma yini oyibhala kuseli enokuqukethwe okufihliwe izofihlwa ngokuzenzakalelayo lapho uchofoza Faka. Kulokhu, inani ebelikuleli seli lizothathelwa indawo inani elisha noma ifomula oyifakile.
Ifihla imigqa namakholomu
Uma usebenza ngethebula elikhulu, ungase ufune ukufihla imigqa namakholomu athile angadingeki okwamanje ukuze abukwe. Ukuze ufihle wonke umugqa, chofoza kwesokudla inombolo yomugqa (inhlokweni) bese ukhetha Fihla (Fihla).
Qaphela: Ukuze ufihle imigqa eminingi, qala ngokukhetha leyo migqa. Ukuze wenze lokhu, chofoza unhlokweni womugqa futhi, ngaphandle kokukhipha inkinobho yegundane kwesokunxele, hudula isikhombisi kulo lonke uhla lwemigqa ofuna ukuyifihla, bese uchofoza kwesokudla endaweni ekhethiwe bese uchofoza. Fihla (Fihla). Ungakhetha amarowu angasondelene ngokuchofoza izihloko zawo ngenkathi ucindezela ukhiye Ctrl.
Izinombolo ezihlokweni zemigqa efihliwe zizokweqiwa, bese kuvela umugqa okabili ezikhaleni.
Inqubo yokufihla amakholomu ifana kakhulu nenqubo yokufihla imigqa. Chofoza kwesokudla kukholomu ofuna ukuyifihla, noma khetha amakholomu amaningi bese uchofoza iqembu eligqanyisiwe. Kumenyu evelayo, khetha Fihla (Fihla).
Izinhlamvu ezisezihlokweni zekholomu efihliwe zizokweqiwa futhi kuzovela umugqa okabili endaweni yazo.
Ukuze ubonise kabusha umugqa ofihliwe noma imigqa eminingi, khetha imigqa nhlangothi zombili zemigqa efihliwe, bese uchofoza kwesokudla endaweni ekhethiwe bese ukhetha kumenyu yokuqukethwe. Bonisa (Ungafihli).
Ukuze ubonise ikholomu efihliwe noma amakholomu amaningi, khetha amakholomu nhlangothi zombili zekholomu(ama)kholomu efihliwe, bese uchofoza kwesokudla endaweni egqanyisiwe bese ukhetha kumenyu evelayo. Bonisa (Ungafihli).
Uma usebenza ngetafula elikhulu kodwa ungafuni ukufihla imigqa namakholomu, ungawaphina ukuze kuthi lapho upheqa idatha esethebulani, izihloko ezikhethiwe zihlale zikhona.