01 ngo 05
Ngee-Worksheets ezifihliweyo ze-Excel
Iphepha lokusebenzela le-Excel lilodwa ispredishithi esineeseli. Isitya ngasinye sinokubamba umbhalo, inombolo, okanye ifom, kwaye nganye iseli inokubonisa iseli ehlukileyo kwiphepha elifanayo lomsebenzi, incwadi efanayo, okanye incwadi eyahlukeneyo.
Incwadi ye-Excel iqukethe enye okanye ngaphezulu kwamaphepha. Ngokungagqibekanga, zonke iincwadi zokusebenzela ze-Excel zibonise iithebhu zesebenzi kwiibar yomsebenzi phantsi kwekrini, kodwa ungazifihla okanye uzibonise njengoko zifunekayo. Ubuncinane iphepha lokusebenzela kufuneka libonwe ngamaxesha onke.
Kukho indlela engakumbi yokufihla nokudibanisa ama-worksheets e-Excel. Unga:
- Sebenzisa imenyu yokunqakraza imenu.
- Sebenzisa iifomati zefomathi kwiTable yasekhaya yerbhoni .
Ukusetyenziswa kwedatha kwiShishini lokuSebenza elifihliweyo
Idata efumaneka kwiifayile zokufihla ezifihliweyo ayinakususwa, kwaye isenokuthi ibhekiswe kwiifomula kunye neetshathi ezikwezinye iifishthi okanye ezinye iincwadi zokusebenzela .
Iifomula ezifihliweyo eziqukethe iinkcukacha zeseli zihlaziya ukuba idatha kwiiiseli ezichaziweyo ziguquka.
02 we 05
Fihla i-Excel Worksheet usebenzisa iMenu eqondileyo
Izinketho ezitholakalayo kwimenyu yenkcazelo-okanye iqhosha lokucofa lokunene-tshintsha kuxhomekeke kwinto ekhethiweyo xa imenyu ivuliwe.
Ukuba i-Hide inketho ayisebenzi okanye ixutywe ngaphandle, inokwenzeka ukuba incwadana yencwadi ekhoyo inephepha elilodwa lokusebenzela. I-Excel icima inketho yokufihla kwiincwadi zokusebenzela ezikwi-one ngoba kubakho ukuba kubekho ubuncinane ibhokisi lokusebenzela elibonakalayo kwincwadi yokusebenzela.
Ukufihla isicatshulwa esisodwa
- Cofa kwithebhu yokusebenzela yeshidi ukufihla ukuyikhetha.
- Ukuchofoza ngakwesokudla kwithebhu yokusebenzela ukuze uvule imenyu yomxholo.
- Ku menu, nqakraza kwiCandelo lokufihla ukufihla iphepha lokusebenzela elikhethiweyo.
Ukufihla amanqaku amaninzi okusebenzela
- Cofa kwithebhu yephepha lokuqala lokusebenzela ukuba lifihliwe ukulikhetha.
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cofa kwiithebhu zesebenzi ezongezelelweyo zokuzikhetha.
- Ukucofa kwesokudla kwelinye ithebhu yomsebenzi ukuze uvule imenyu yomxholo.
- Kwimenyu, nqakraza kwiCandelo lokufihla ukufihla zonke iifayile zokusebenzela.
03 we 05
Fihla ii-Worksheets usebenzisa iRibhoni
I-Excel ayinaso isinqamulelo sekhibhodi sokufihla ama-worksheets, kodwa ungasebenzisa i-ribbon ukwenza umsebenzi.
- Khetha ithebhu yomsebenzi phantsi kwefayile ye-Excel.
- Cofa kwiThebhu yaseKhaya kwibhoni uze ukhethe iiCells icon.
- Khetha Ifomathi kwimenyu ehlayo ebonakalayo.
- Cofa kwiMfihla & Hlanganisa .
- Khetha Hlela Ishicilelo .
04 we 05
Hlanganisa i-Excel Worksheet usebenzisa iMenu eqondileyo
Izinketho ezitholakalayo kwimenyu yenkcazelo-okanye iqhosha lokucofa lokunene-tshintsha kuxhomekeke kwinto ekhethiweyo xa imenyu ivuliwe.
Ukudibanisa iWindows Worksheet
- Ukucofa ngakwesokudla kwithebhu yokusebenzela ukuze uvule ibhokisi yencoko ye- Unhide , ebonisa zonke iifayile ezifihliweyo.
- Cofa kwiphepha ukuba lidibaniswe.
- Cofa Kulungile ukudibanisa iphepha elikhethiweyo uze uvale ibhokisi yencoko.
05 we 05
Hlanganisa i-Worksheet usebenzisa iRibhoni
Njengoko ngokufihla ama-worksheet, i-Excel ayinaso isinqamulelo sebhodibhodi yokukhupha iphepha lokusebenzela, kodwa ungasebenzisa i-ribbon ukufumana nokudibanisa ama-worksheet afihliweyo.
- Khetha ithebhu yomsebenzi phantsi kwefayile ye-Excel.
- Cofa kwiThebhu yaseKhaya kwibhoni uze ukhethe iiCells icon.
- Khetha Ifomathi kwimenyu ehlayo ebonakalayo.
- Cofa kwiMfihla & Hlanganisa .
- Khetha i- Unhide Sheet .
- Jonga uluhlu lweefayile ezifihliweyo ezibonakalayo. Cofa kwifayile ofuna ukuyidibanisa.
- Chofoza OK .