Uma usebenzisa i-Microsoft Excel njalo kungenzeka ukuthi ubonile ukuthi ukushintsha amashidi okusebenzela ahlukene ku-excel kunzima kakhulu. Ngezinye izikhathi ukushintsha phakathi kwamakhasi okusebenzela ambalwa kubonakala kulula. Indlela ejwayeleke kakhulu yokushintsha amathebhu ukuchofoza kuthebhu ngayinye. Kodwa-ke, uma kuziwa ekuphatheni inala yamakhasi okusebenzela ku-Excel eyodwa, kuwumsebenzi okhathazayo kakhulu. Ngakho-ke, ukuba nolwazi mayelana nezinqamuleli nokhiye abafushane kuzoba usizo kakhulu. Futhi lezi zinqamuleli zingaba usizo ekwandiseni ukukhiqiza kwakho. Ake sixoxe ngezindlela ongakwazi ngazo shintsha kalula phakathi kwamakhasi okusebenzela ahlukene ku-excel eyodwa.
Ukusebenzisa okhiye bezinqamuleli akukwenzi uvilaphe kodwa kwandisa ukukhiqiza kwakho futhi kukugcinele isikhathi esiningi ongasichitha kweminye imisebenzi. Kwesinye isikhathi, i-touchpad yakho noma igundane liyekile ukusebenza futhi kuleso simo, izinqamuleli zekhibhodi ziyasiza kakhulu. Ngakho-ke, Izinqamuleli ze-Excel izindlela eziwusizo kakhulu zokusheshisa inqubo yakho yomsebenzi.
Okuqukethwe[ fihla ]
- Shintsha Ngokushesha Phakathi Kwamakhasi Okusebenzela ku-Excel
- Indlela 1: Okhiye Besinqamuleli sokushintsha phakathi kwaMashidi Okusebenzela ku-Excel
- Indlela yesi-2: Iya ku-Command ukuze uhambe phakathi kwamakhasi okusebenzela e-excel
- Indlela yesi-3: Hambisa ekhasini lokusebenza elihlukile usebenzisa u-Ctrl + Ukhiye Wesokunxele
Shintsha Ngokushesha Phakathi Kwamakhasi Okusebenzela ku-Excel
Indlela 1: Okhiye Besinqamuleli sokushintsha phakathi kwaMashidi Okusebenzela ku-Excel
Ctrl + PgUp (ikhasi phezulu) — Hambisa ishidi elilodwa kwesokunxele.
Uma ufuna ukuya kwesokunxele:
1. Cindezela bese ubamba inkinobho ethi Ctrl kukhibhodi.
2. Cindezela bese ukhulula inkinobho ye-PgUp kukhibhodi.
3. Ukuhambisa elinye ishidi cindezela kwesokunxele bese ukhulula inkinobho ye-PgUp okwesibili.
Ctrl + PgDn (ikhasi phansi) — Hambisa ishidi elilodwa kwesokudla.
Uma ufuna kwesokudla:
1. Cindezela bese ubamba inkinobho ethi Ctrl kukhibhodi.
2. Cindezela bese ukhulula inkinobho ye-PgDn kukhibhodi.
3. Ukuthuthela kwelinye ishidi cindezela kwesokudla bese ukhulula ukhiye we-PgDn okwesibili.
Funda futhi: Liyini ifayela le-XLSX & Indlela yokuvula Ifayela le-XLSX?
Indlela yesi-2: Iya ku-Command ukuze uhambe phakathi kwamakhasi okusebenzela e-excel
Uma uneshidi le-Excel elinenqwaba yedatha, i-Go To command ingakusiza ukuthi uzulazule kumaseli ahlukene. Ayilusizo kumakhasi okusebenzela aqukethe umthamo ophansi kakhulu wedatha. Ngakho-ke, kunconywa ukusebenzisa lo myalo kuphela uma unefayela le-excel elinenani elikhulu ledatha.
Isinyathelo 1: Zulazulela ku- Hlela inketho yemenyu.
Isinyathelo sesi-2: Chofoza ku- Thola & Khetha inketho bese ukhetha i Iya ku Inketho.
Isinyathelo sesi-3: Lapha thayipha ireferensi lapho ufuna ukuya khona: Ishidi_igama + isibabazo + ireferensi yeseli.
Qaphela: Ngokwesibonelo, uma kukhona Ishidi 1, Ishidi2, kanye Neshidi3 khona-ke kusithenjwa udinga ukuthayipha igama leshidi ofuna ukuya kulo bese kuba ireferensi yeseli. Ngakho uma kwenzeka udinga ukuya eshidini 3 bese uthayipha Ishidi3!A1 lapho i-A1 iyireferensi yeseli kokuthi Ishidi 3.
Isinyathelo sesi-4: Manje cindezela Kulungile noma cindezela Faka ukhiye kukhibhodi.
Indlela yesi-3: Hambisa ekhasini lokusebenza elihlukile usebenzisa u-Ctrl + Ukhiye Wesokunxele
Ngale ndlela, uzothola ibhokisi lengxoxo elinawo wonke amaphepha okusebenza atholakalayo ku-excel yakho ukuze uwaguqule phakathi. Lapha ungakwazi ukukhetha kalula ishidi ofuna ukusebenza kulo. Lena enye indlela ongayikhetha ukuze uguqule phakathi kwamakhasi okusebenza atholakalayo kufayela lakho le-excel lamanje.
Kunezinye izinqamuleli ezimbalwa ze-Excel ezingakusiza ukuthi wenze izinto zakho zenzeke ku-excel ngendlela elula nesheshayo.
I-CTRL +; Ngalokhu, ungakwazi Faka idethi yamanje kuseli esebenzayo
I-CTRL + A Izokhetha ishidi lokusebenza lonke
I-ALT + F1 Izodala ishadi ledatha ebangeni lamanje
SHIFT + F3 Ngokucindezela lesi sinqamuleli, sizovela ibhokisi lengxoxo elithi Faka Umsebenzi
SHIFT + F11 Izofaka ishidi lokusebenza elisha
CTRL + EKHAYA Ungathuthela ekuqaleni kweshidi lokusebenzela
CTRL + SPACEBAR Izokhetha ikholomu yonke ekhasini lokusebenzela
SHIFT + SPACEBAR Ngalokhu, ungakhetha umugqa wonke ekhasini lokusebenza
Ingabe kufanelekile ukukhetha okhiye bezinqamuleli zokusebenza ku-Excel?
Funda Futhi : Ukulungisa i-Excel ilinde olunye uhlelo lokusebenza ukuqedela isenzo se-OLE
Ingabe ufuna ukuqhubeka nokuskrola futhi uchofoze amakhasi okusebenza usuku lonke noma ufuna ukwenza umsebenzi wakho wenziwe ngokushesha futhi uchithe isikhathi esithile esiseqophelweni eliphezulu nontanga yakho nozakwenu? Uma ufuna ukwenza izinto zakho zenzeke ngokushesha, izinqamuleli ze-excel ziyindlela engcono kakhulu yokwenza lokhu. Ziningi ezinye izinqamuleli ezitholakalayo zemisebenzi eyahlukene ku-Excel, uma ungazikhumbula zonke, zizokwenza ube iqhawe ku-Excel. Kodwa-ke, ungakhumbula kuphela izinqamuleli ovame ukuzisebenzisa emsebenzini wakho njengoba zizokusiza ukuthi wenze imisebenzi yakho yansuku zonke wenziwe ngokushesha.
Elon Decker U-Elon ungumbhali wezobuchwepheshe e-Cyber S. Ubelokhu ebhala imihlahlandlela yokuthi kwenziwa kanjani iminyaka eyi-6 manje futhi uhlanganise izihloko eziningi. Uthanda ukumboza izihloko ezihlobene ne-Windows, i-Android, namaqhinga namathiphu akamuva.