Okuqukethwe
Lapho usebenza ku-Excel, ngokuvamile kuyadingeka ukuhlukanisa imininingwane. Ungakwenza lokhu njengaseshidini elifanayo, noma wengeze elisha. Yiqiniso, kukhona inketho efana nokudala idokhumenti entsha, kodwa isebenza kuphela uma singadingi ukuxhumanisa idatha ndawonye.
Kunezindlela ezimbalwa zokwengeza ishidi elisha encwadini yokusebenzela ye-Excel. Ngezansi sizocubungula ngokwehlukana ngamunye wabo.
Okuqukethwe
Inkinobho Yeshidi Entsha
Kuze kube manje, lena indlela elula futhi ethengekayo, okungenzeka ukuthi isetshenziswe abasebenzisi abaningi bohlelo. Konke kumayelana nobulula obukhulu benqubo yokwengeza - udinga nje ukuchofoza inkinobho ekhethekile ethi "Ishidi Elisha" (ngendlela yokuhlanganisa), etholakala kwesokudla samashidi akhona ngezansi kwewindi lohlelo. .
Ishidi elisha lizoqanjwa ngokuzenzakalelayo. Ukuze uyishintshe, udinga ukuyichofoza kabili ngenkinobho yegundane engakwesokunxele, ubhale igama olifunayo, bese ucindezela u-Enter.
Ungangeza ishidi elisha encwadini usebenzisa imenyu yokuqukethwe. Ukuze wenze lokhu, chofoza kwesokudla kunoma imaphi amashidi asevele ekhona kudokhumenti. Imenyu izovuleka, lapho kufanele ukhethe khona into ethi "Faka Ishidi".
Njengoba ubona, indlela ilula njengale echazwe ngenhla.
Ulengeza kanjani ishidi ngeribhoni yohlelo
Vele, umsebenzi wokwengeza ishidi elisha ungatholakala phakathi kwamathuluzi atholakala kuribhoni ye-Excel.
- Iya kuthebhu “Ekhaya”, chofoza ithuluzi elithi “Amaseli”, bese kumcibisholo omncane oya phansi eduze kwenkinobho ethi “Faka”.
- Kulula ukuqagela ukuthi yini okudingeka ukhethe ohlwini oluvelayo - lena into ethi "Faka ishidi".
- Yilokho kuphela, ishidi elisha lengeziwe kudokhumenti
Qaphela: kwezinye izimo, uma usayizi wewindi lohlelo weluliwe ngokwanele, awudingi ukubheka ithuluzi elithi "Amaseli", ngoba inkinobho ethi "Faka" iboniswa ngokushesha kuthebhu "Ekhaya".
Ukusebenzisa ama-hotkeys
Njengezinye izinhlelo eziningi, i-Excel ine, ukusetshenziswa okunganciphisa isikhathi sokubheka imisebenzi evamile kumenyu.
Ukwengeza ishidi elisha encwadini yokusebenzela, mane ucindezele isinqamuleli sekhibhodi Shift + F11.
Isiphetho
Ukwengeza ishidi elisha ku-Excel kuwumsebenzi olula, okungenzeka ukuthi ungomunye odume kakhulu futhi osetshenziswa kakhulu. Kwezinye izimo, ngaphandle kwekhono lokwenza lokhu, kuyoba nzima kakhulu noma kungenzeki nhlobo ukwenza umsebenzi kahle. Ngakho-ke, leli elinye lamakhono ayisisekelo okufanele wonke umuntu ohlela ukusebenza ngempumelelo ohlelweni awazi kahle.