Ngokukhetha uluhlu oluthile lweeseli - njengemiqolo yonke, iikholumu, iithebula zedata, okanye nakwiifayile ezisebenzayo, yenza kube lula kwaye kulula ukufeza imisebenzi embalwa kwi-Excel njengale:
- Ukutshintsha ububanzi bekholomu kunye neendawo eziphakamileyo .
- Ukufihla iikholam kunye nemigca yedatha .
- Ukufaka iikholomu ezintsha kunye nemigca kwiphepha lokusebenzela .
- Ukusebenzisa ukufometha kweenombolo .
Indlela yokukhetha iindleko ezipheleleyo kwi-Worksheet nge-Shortcut Keys
Inqamulelo yebhobhodi yokugqamisa umgca opheleleyo kwiphepha lokusebenzela yile:
Shift + Spacebar
Ukusebenzisa iiNqamlezo zeNqamlethi zokukhetha iRow Worksheet Row
- Cofa kwiseli yeshidi lomgca ekukhethiweyo ukuba ukhethe ukwenza iseli esebenzayo .
- Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
- Cinezela kwaye ukhulule ukhiye we- Spacebar kwikhibhodi ngaphandle kokukhulula ikhift Shift .
- Ukukhupha ikhiye yeShift .
- Zonke iiseli kumqolo okhethiweyo kufuneka zigqitywe - kubandakanywa nomxholo wesigcawu .
Ukukhetha iireyibhile ezongezelelweyo
Ukukhetha imigangatho eyongeziweyo ngasentla okanye ngaphantsi komgca okhethiweyo
- Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
- Sebenzisa izitshixo eziphezulu okanye ezantsi kwebhodibhodi ukhethe imigqa eyongeziweyo ngasentla okanye ngaphantsi kwelohlu olukhethiweyo.
Khetha Iimilo NgeMouse
Umgca opheleleyo unokukhethwa ngoku:
- Beka isikhombisi semouse kumqolo woluhlu kumqolo ogciniweyo - i-pointer ye mouse iguqula kumtsalane omnyama ubhekisela ngakwesokudla njengoko kuboniswe kumfanekiso ongentla.
- Nqakraza kanye ngeqhosha le mouse .
Imigqa emininzi ingakhethwa ngu:
- Beka isalathisi semouse kumqolo woluhlu kumqolo woluhlu.
- Cofa uze ubambe iqhosha le mouse elikhohlo .
- Hudula umgca we mouse usebenzisa okanye uhla ukuze ukhethe inani elifunayo lemiqolo.
Indlela yokukhetha iikholethi ezipheleleyo kwiWebhu lokusebenzela kunye neNqakrazo Keys
Intlangano ebalulekileyo esetyenziselwa ukhetha iikholam yonke yile:
Ctrl + Ibha yendawo
Ukusebenzisa iiNqamlezo zeNqamlezo zokukhetha iWorksheet Column
- Cofa kwiseli yeshidi lomsebenzi kwikholam ukuba ukhethwe ukuba wenze iseli esebenzayo.
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cinezela kwaye ukhulule ukhiye we- Spacebar kwikhibhodi ngaphandle kokukhulula ikhift Shift .
- Ukukhulula ikhiye ye Ctrl .
- Zonke iiseli ekhompyutheni ekhethiweyo kufuneka zigqitywe - kubandakanywa intloko yekholomu.
Ukukhetha iikholomu ezongezelelweyo
Ukukhetha iikholomu ezongezelelweyo ngaphesheya kwikholamu ekhethiweyo
- Cinezela kwaye ubambe iqhosha leShift kwibhodibhodi.
- Sebenzisa izitshixo zokucoca ezisekhohlo okanye ezikunene kwibhodibhodi ukhethe iikholomu ezongezelelweyo ngaphesheya kwikholam ephakamileyo.
Khetha iikholomu nge mouse
Iyonke ikholomu inokukhethwa ngu:
- Faka umbonisi we mouse kwileta yekholomu kwintloko yentloko - i-pointer ye mouse iguqula kumtsalane omnyama ubhekise phantsi njengoko kuboniswe kumfanekiso ongentla.
- Nqakraza kanye ngeqhosha le mouse .
Imigqa emininzi ingakhethwa ngu:
- Beka umbonisi we mouse kumbhalo wekholomu kwintloko yekholomu.
- Cofa uze ubambe iqhosha le mouse elikhohlo .
- Udonsa isalathisi se mouse esishiye okanye ngakwesokudla ukukhetha inani elifunayo lemiqolo.
Indlela yokukhetha zonke iiseli kwi-Excel Worksheet kunye neNqakrazo Keys
Kukho iintlobo ezimbini ezibalulekileyo zokukhetha zonke iiseli kwiphepha lokusebenzela :
Ctrl + A
okanye
Ctrl + Shift + Ibha yendawo
Ukusebenzisa iiNqamlezo zeNqamlezo zokukhetha zonke iiseli kwiWebhu lokusebenzela
- Cofa kwindawo engenanto yephepha lokusebenzela - indawo engenayo idatha kwiiseli ezungezile.
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cinezela kwaye ukhulule incwadi ebalulekileyo kwikhibhodi.
- Ukukhulula ikhiye ye Ctrl .
Zonke iiseli ezisemsebenzini kufuneka zikhethwe.
Khetha Zonke iiseli kwiWindows Worksheet usebenzisa "Inketho Yonke"
Kulabo abakhetha ukungawusebenzisi umbhobho, khetha Khetha yonke inketho ngokukhawuleza ukhethe zonke iiseli kwiphepha lokusebenzela.
Njengoko kuboniswe kumfanekiso ongentla, Khetha konke kukhoneni elingaphezulu lasekhohlo kwiphepha lokusebenzela apho umxholo wesihloko kunye nekhompyutyana yekholomu ukudibana.
Ukukhetha zonke iiseli kwiphepha lokusebenzela langoku, nqakraza kanye kwiKhotho Yonke .
Indlela yokukhetha zonke iiseli kwiThebhile yeDatha kwi-Excel kunye neNqakrazo Keys
Zonke iiseli kwindawo edibeneyo yedata okanye itafile yedata kunokukhethwa ngokukhawuleza usebenzisa izitshixo ezifutshane.Izidibaniso ezimbini ezibalulekileyo ukhetha kuzo:
Ctrl + A
okanye
Ctrl + Shift + Ibha yendawo
Inqamaniso yefayile e mfutshane yeefayili ezifutshane ezisetyenziselwa ukukhetha zonke iiseli kwiphepha lokusebenzela.
Ukukhetha iindawo ezahlukeneyo zoLwazi lweThebula kunye neWebhu
Ngokuxhomekeke kwindlela indlela idatha ekwahlukileyo ifakwe ngayo ifomathi, ukusebenzisa izitshixo ezithe tye ngasentla kuya kukhetha inani elithile leenkcukacha.
Ukuba i-cell esebenzayo yecala ifumaneka kwinqanaba elithathayo lwedatha yile:
- Cinezela i- Ctrl + A once - Excel ikhetha zonke iiseli eziqulethwe ngoluhlu.
Ukuba Uluhlu lweenkcukacha lufomathiwe njengetafile kwaye lunomqolo ohamba phambili oqukethe umgca we-drop down njengoko uboniswa kumfanekiso ongentla.
- Cinezela i- Ctrl + A okwesihlandlo sesibini - I-Excel ikhetha umqolo ophezulu.
Ummandla okhethiweyo unako ukwandiswa ukufaka zonke iiseli kwiphepha lokusebenzela.
- Cinezela Ctrl + Ixesha lesithathu - I-Excel ikhetha lonke iphepha lokusebenzela.
Indlela yokukhetha amaFebhu aMaqela amaninzi kwi-Excel Namaqhosha okufutshane
Akunakwenzeka kuphela ukuhamba phakathi kweemakhishithi kwincwadi yokusebenzela usebenzisa inqamulelo yebhobhobhodi, kodwa unokukhetha kwakhona amanqaku amaninzi athile kunye nenqamulelo yebhobhodi.
Ukwenza njalo, faka i- Shift iqhosha kwiintlobo ezimbini ezibalulekileyo eziboniswe ngasentla. Leyiphi na oyisebenzisayo kuxhomekeke ekubeni ukhetha amakhishithi ngakwesobunxele okanye ngakwesokudla kwiphepha langoku.
Ukukhetha amaphepha ngakwesobunxele:
Ctrl + Shift + PgUp
Ukukhetha amaphepha ngakwesokudla:
Ctrl + Shift + PgDn
Ukukhetha Amaphepha amaninzi usebenzisa iMouse kunye nekhibhodi
Ukusebenzisa imouse kunye nezitshixo zekhibhodi kunelinye inzuzo ngaphezu kokusebenzisa ikhibhodi - kukuvumela ukuba ukhethe amashidi angabandakanyekanga njengoko kuboniswe kumfanekiso ongentla kunye nakwezinye.
Izizathu zokukhetha amaphepha omsebenzi amaninzi ziquka:
- Ukutshintsha umbala wethebhu lomsebenzi .
- Ukufaka ii-worksheets ezintsha ezintsha .
- Ukufihla amaxwebhu okusebenzela .
Ukukhetha amaSpredishithi aMaqela amaninzi
- Cofa kwiphepha elilodwa ukuze ukhethe.
- Cinezela kwaye ubambe iqhosha leShift kwikhibhodi.
- Cofa kwiibhokisi ezongezelelweyo ezisezantsi ukuze uzinqamle.
Ukukhetha amaSpredishithi angabonakaliyo
- Cofa iqhosha elinye lethebhu ukulikhetha.
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cofa kwiibhokisi ezongezelelweyo zeekhredithi ukuze zigqitywe.