Ukuba usebenzisa iMicrosoft Excel rhoqo usenokuba uye waqaphela ukuba ukutshintsha phakathi kwamaphepha okusebenzela awahlukeneyo kwi-excel kunzima kakhulu. Ngamanye amaxesha ukutshintsha phakathi kwamaphepha okusebenzela ambalwa kubonakala kulula. Eyona ndlela iqhelekileyo yokutshintsha iithebhu kukucofa kwisithuba ngasinye. Nangona kunjalo, xa kufikwa ekulawuleni uninzi lwamaphepha okusebenzela kwi-excel enye, ngumsebenzi odinayo kakhulu. Ke ngoko, ukuba nolwazi malunga neendlela ezimfutshane kunye nezitshixo ezimfutshane kuya kuba luncedo kakhulu. Kwaye ezi ndlela zimfutshane zinokuba luncedo ekwandiseni imveliso yakho. Makhe sixoxe ngeendlela onokuthi ngazo tshintsha ngokulula phakathi kwamaphepha okusebenzela awohlukeneyo kwi-excel enye.
Ukusebenzisa izitshixo ezinqumlayo akukwenzi wonqene kodwa kwandisa imveliso yakho kwaye kukugcinele ixesha elininzi onokulichitha komnye umsebenzi. Ngamanye amaxesha, i-touchpad yakho okanye impuku yayeka ukusebenza kwaye kuloo meko, iindlela ezimfutshane zebhodibhodi ziza kakhulu. Ngoko ke, Iindlela ezimfutshane ze-Excel zezona ndlela ziluncedo zokukhawulezisa inkqubo yakho yomsebenzi.
Imixholo[ fihla ]
- Tshintshela ngokukhawuleza phakathi kwaMaphepha okusebenzela kwi-Excel
- Indlela yoku-1: Izitshixo ezimfutshane zokutshintsha phakathi kwe-Worksheets kwi-Excel
- Indlela yesi-2: Yiya kuMyalelo ukuze uhambe ujikeleze i-excel worksheets
- Indlela yesi-3: Hambisa kwiphepha lomsebenzi elahlukileyo usebenzisa i-Ctrl + Isitshixo saseKhohlo
Tshintshela ngokukhawuleza phakathi kwaMaphepha okusebenzela kwi-Excel
Indlela yoku-1: Izitshixo ezimfutshane zokutshintsha phakathi kwe-Worksheets kwi-Excel
Ctrl + PgUp (iphepha phezulu) — Hambisa iphepha libe linye ekhohlo.
Xa ufuna ukuya ekhohlo:
1. Cofa kwaye ubambe iqhosha le-Ctrl kwikhibhodi.
2. Cofa kwaye ukhulule iqhosha lePgUp kwikhibhodi.
3. Ukuhambisa elinye ishiti ukuya ekhohlo cofa kwaye uyeke iqhosha lePgUp okwesibini.
Ctrl + PgDn (iphepha ezantsi) — Hambisa iphepha elinye ekunene.
Xa ufuna ekunene:
1. Cofa kwaye ubambe iqhosha le-Ctrl kwikhibhodi.
2. Cofa kwaye ukhulule iqhosha lePgDn kwikhibhodi.
3. Ukuya kwelinye iphepha ukuya ekunene cofa kwaye uyeke iqhosha lePgDn okwesibini.
Kwakhona Funda: Yintoni ifayile yeXLSX & Uyivula njani iFayile yeXLSX?
Indlela yesi-2: Yiya kuMyalelo ukuze uhambe ujikeleze i-excel worksheets
Ukuba unephepha le-Excel elinomthwalo wedatha, yiya kumyalelo inokukunceda ukuba uhambe uye kwiiseli ezahlukeneyo. Ayiloncedo kumaphepha okusebenzela aqulethe umthamo ophantsi kakhulu wedatha. Ke ngoko, kucetyiswa ukuba usebenzise lo myalelo kuphela xa unefayile egqwesileyo enomthamo omkhulu wedatha.
Inyathelo 1: Yiya kwi Hlela ukhetho lwemenyu.
Inyathelo 2: Cofa kwi Fumana & Khetha ukhetho emva koko khetha i Yiya e Ukhetho.
Inyathelo lesi-3: Apha chwetheza ireferensi apho ufuna ukuya khona: Iphepha_igama + uphawu lwesikhuzo + ireferensi yeseli.
Qaphela: Umzekelo, ukuba kukho iPhepha 1, iPhepha2, kunye nePhepha3 ngoko kwireferensi kufuneka uchwetheze igama lephepha ofuna ukuya kulo emva koko ireferensi yeseli. Ngoko ke xa kufuneka uye kwiphepha lesi-3 emva koko uchwetheze Iphepha3!A1 apho i-A1 iyireferensi yeseli kwiPhepha lesi-3.
Inyathelo 4: Cofa ngoku Kulungile okanye cofa Faka iqhosha kwi keyboard.
Indlela yesi-3: Hambisa kwiphepha lomsebenzi elahlukileyo usebenzisa i-Ctrl + Isitshixo saseKhohlo
Ngale ndlela, uya kufumana ibhokisi yencoko yababini enawo onke amaphepha okusebenzela akhoyo kwi-excel yakho ukuze uguqule phakathi. Apha ungakhetha ngokulula iphepha lomsebenzi ofuna ukusebenza kulo. Le yenye indlela onokuthi ukhethe ukuyitshintsha phakathi kwamaphepha okusebenzela akhoyo kwifayile yakho yangoku yokugqwesa.
Kukho ezinye iindlela ezimfutshane ezininzi ze-Excel ezinokukunceda ukuba wenze izinto zakho ngokugqwesileyo ngeyona ndlela ilula nekhawulezayo.
CTRL + ; Ngoku, ungangenisa umhla wangoku kwiseli esebenzayo
CTRL + A Iya kukhetha lonke iphepha lomsebenzi
I-ALT + F1 Iyakwenza itshathi yedatha kuluhlu lwangoku
SHIFT + F3 Ngokucinezela le ndlela imfutshane, iya kuvela i Faka ibhokisi yencoko yababini yoMsebenzi
SHIFT + F11 Iza kufaka iphepha lomsebenzi elitsha
CTRL + IKHAYA Ungaya ekuqaleni kwephepha lomsebenzi
CTRL + SPACEBAR Iya kukhetha yonke ikholamu kwiphepha lomsebenzi
SHIFT + SPACEBAR Ngale nto, unokukhetha umqolo opheleleyo kwiphepha lomsebenzi
Ngaba kufanelekile ukukhetha izitshixo ezimfutshane zokusebenza kwi-Excel?
Kwakhona Funda : Lungisa i-Excel ilinde esinye isicelo ukuba sigqibezele isenzo se-OLE
Ngaba uyafuna ukuqhubeka nokuskrola kwaye ucofa kumaphepha okusebenzela imini yonke okanye ufuna ukwenza umsebenzi wakho wenziwe ngokukhawuleza kwaye uchithe ixesha elisemgangathweni noontanga bakho kunye noogxa bakho? Ukuba ufuna ukwenza izinto zakho ngokukhawuleza, iindlela ezimfutshane zokugqwesa yeyona ndlela ilungileyo yokwenza oku. Zininzi ezinye iindlela ezimfutshane ezikhoyo kwimisebenzi eyahlukeneyo kwi-Excel, ukuba ungazikhumbula zonke, iya kukwenza ube yi-superhero kwi-Excel. Nangona kunjalo, unokukhumbula kuphela iindlela ezimfutshane ozisebenzisa rhoqo emsebenzini wakho njengoko ziya kukunceda ukuba wenze imisebenzi yakho yemihla ngemihla ngokukhawuleza.
Elon Decker U-Elon ungumbhali wezobugcisa kwi-Cyber S. Ubhale indlela-izikhokelo malunga neminyaka eyi-6 ngoku kwaye uye wagubungela izihloko ezininzi. Uyakuthanda ukugubungela izihloko ezinxulumene neWindows, Android, kunye namaqhinga amva nje kunye neengcebiso.