Indlela Yokukhetha Imigqa, Amakholomu, noma Ama-Worksheet ku-Excel

Ngokukhetha amabanga athile wamangqamuzana - njengamarowu onke, amakholomu, amatafula wedatha, noma ngisho namashidi okusebenzela, enza kube lula futhi kulula ukufeza imisebenzi eminingi ku-Excel njenge:

• Ukushintsha ububanzi bekholomu nobubanzi bomugqa .
• Ukufihla amakholomu nemigqa yedatha .
• Ukufaka amakholomu amasha nemigqa kushidi lokusebenzela .
• Isebenzisa ukufometha kwenombolo .

Indlela Yokukhetha Imikhawulo Yonke Emkhakheni Wokusebenza Ngezinqamuleli Zezinqamuleli

Isinqamuleli sekhibhodi sokugqamisa umugqa ophelele kushidi lokusebenza yi:

Shift + Spacebar

Ukusebenzisa Izinqamuleli Zezinqamuleli Ukukhetha Row Worksheet Row

1. Chofoza kuseli lokusebenzela lomugqa ukuze ukhethwe ukuze wenze iseli esebenzayo .
2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
3. Cindezela bese ukhulula ukhiye we- Spacebar ekhibhodi ngaphandle kokukhipha ukhiye we- Shift .
4. Khipha ukhiye we- Shift .
5. Wonke amaseli emgqeni okhethiwe kufanele agcizelelwe - kufaka phakathi isihloko segqa .

Ukukhetha izinkambo ezingeziwe

Ukukhetha imigqa eyengeziwe ngenhla noma ngaphansi kwegqa elikhethiwe

1. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
2. Sebenzisa okhiye we- Up noma we-Down onkhibhodi ukuze ukhethe imigqa eyengeziwe ngenhla noma ngaphansi komugqa okhethiwe.

Khetha Izintambo Nge-Mouse

Umugqa wonke ungabuye ukhethwe ngu:

1. Beka isikhombisi segundane kwinombolo yomugqa kusihlokweni segqa - isininisi segundane sishintsha kumcibisholo omnyama okhomba ngakwesokudla njengoba kuboniswa esithombeni ngenhla.
2. Chofoza kanye inkinobho yegundane lesokunxele .

Imigqa eminingi ingakhethwa ngu:

1. Beka isikhombisi segundane kwinombolo yomugqa kusihlokweni segqa.
2. Chofoza bese ubamba inkinobho yesinxele segundane .
3. Hudula isikhombisi segundane phezulu noma phansi ukuze ukhethe inombolo oyifunayo yemigqa.

Indlela Yokukhetha Amakholomu Ephelele Kwiphepha Elisebenzayo Ngezinqamuleli Zezinqamuleli

Inhlanganisela eyinhloko esetshenziselwa ukukhetha ikholomu yonke yile:

Ibha ye-Ctrl +

Ukusebenzisa Izinqamuleli Zezinqamuleli Khetha Ikholomu Yomsebenzi

1. Chofoza kuseli lokusebenzela lomsebenzi kukholomu okumelwe ukhethe ukuze lenze iseli elisebenzayo.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Cindezela bese ukhulula ukhiye we- Spacebar ekhibhodi ngaphandle kokukhipha ukhiye we- Shift .
4. Khipha ukhiye we- Ctrl .
5. Wonke amaseli ekholomu akhethiwe kufanele agcizelelwe - kufaka phakathi isihloko sekholomu.

Ukukhetha Amakholomu engeziwe

Ukukhetha amakholomu angeziwe ohlangothini olulodwa lwekholomu ekhethiwe

1. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
2. Sebenzisa okhiye bomcibisholo ongakwesobunxele noma ongakwesokudla ekhibhodi ukuze ukhethe amakholomu angeziwe ohlangothini olulodwa lwekholomu eligqamile.

Khetha Amakholomu Nge-Mouse

Ikholomu lonke lingabuye likhethwe ngu:

1. Beka isikhombisi segundane encwadini yekholomu esihlokweni sekholomu - i-pointer yesiguquko ishintsha kumcibisholo omnyama okhomba phansi njengoba kuboniswe esithombeni ngenhla.
2. Chofoza kanye inkinobho yegundane lesokunxele .

Imigqa eminingi ingakhethwa ngu:

1. Beka isikhombisi segundane encwadini yekholomu esihlokweni sekholomu.
2. Chofoza bese ubamba inkinobho yesinxele segundane .
3. Hudula inkomba yegundane kwesokunxele noma kwesokudla ukukhetha inombolo oyifunayo yemigqa.

Indlela Yokukhetha Wonke Amaseli Ku-Work Excel nge-Keys Keys

Kunezinhlanganisela ezimbili eziyinhloko zokukhetha wonke amaseli kushidi lokusebenzela yi:

Ctrl + A

noma

I-Ctrl + Shift + Yesikhala sendawo

Ukusebenzisa Izinqamuleli Zezinqamuleli Ukukhetha Wonke Amaseli Ekhasini Lokusebenzela

1. Chofoza endaweni engenalutho yephepha lokusebenzela - indawo engekho idatha kumaseli azungezile.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Cindezela bese ukhulula incwadi Isihluthulelo kukhibhodi.
4. Khipha ukhiye we- Ctrl .

Wonke amaseli okushicilela kufanele akhethwe.

Khetha Wonke Amaseli Ekhasini Lokusebenza usebenzisa inkinobho ethi "Khetha Konke"

Kulabo abakhetha ukungasebenzisi ikhibhodi, inkinobho ye- Select All enye inketho ngokushesha ukhethe wonke amaseli kwiphepha lokusebenzela.

Njengoba kuboniswe esithombeni esingenhla, Khetha konke kukhoneni elingaphezulu kwesobunxele kwiphepha lokusebenzela lapho ihloko yomugqa nekhanda lekholomu lihlangana khona.

Ukuze ukhethe wonke amaseli kuphepha lokusebenzela lamanje, chofoza kanye inkinobho ethi Khetha Konke .

Indlela Yokukhetha Wonke Amaseli KuThebula Ledatha ku-Excel ne-Shortcut Keys

Wonke amaseli ohlangothini oluqoqiwe lwedatha noma ithebula lwedatha angashethwa ngokushesha usebenzisa izinkinobho zokunqamulela.Izinhlanganisela ezimbili eziyinhloko zokukhetha kusuka:

Ctrl + A

noma

I-Ctrl + Shift + Yesikhala sendawo

Le nhlanganisela yekhibhodi yesinqamuleli izinkinobho zokunqamulela ezifanayo ezisetshenziselwa ukukhetha wonke amaseli kushidi lokusebenzela.

Ukukhetha Izingxenye Ezihlukene Zedata Ledatha kanye Nephepha Lomsebenzi

Kuye ngokuthi indlela idatha ephepheni lokusebenzela ihlelwe ngayo, ukusebenzisa izinkinobho zokunqamula ngenhla kuzokhetha amanani ahlukene wedatha.

Uma isikhangiso esisebenzayo seseli sitholakala ngaphakathi kwemininingwane eqondile yedatha yilezi:

• Cindezela i- Ctrl + A once - I-Excel ikhetha wonke amaseli aqukethe idatha ebangeni.

Uma Uhlu lwedatha lufomathiwe njengetafula futhi lunomugqa ohambisana nawo oqukethe ukwehla kwamamenyu njengokuboniswa esithombeni ngenhla.

• Cindezela i- Ctrl + A okwesibili - i-Excel ikhetha irowu elibheke phambili.

Indawo ekhethiwe ingabe isetshenziselwa ukufaka wonke amaseli kushidi lokusebenzela.

• Cindezela Ctrl + A okwesithathu - I-Excel ikhetha lonke ishidi lokusebenzela.

Indlela Yokukhetha Ama-Worksheets Amaningana ku-Excel Ngezinqamuleli Zesikhashana

Akukona kuphela ukuhamba phakathi kwamashidi encwadini yokusebenzela usebenzisa isinqamuleli sekhibhodi, kodwa ungakhetha futhi amashidi amaningi eduze nesinqamuleli sekhibhodi.

Ukuze wenze kanjalo, engeza ukhiye we- Shift emincintiswaneni emibili ekhonjisiwe ngenhla. Lokho oyisebenzisayo kuncike ekutheni ukhetha amashidi ngakwesobunxele noma kwesokudla sebhidi lamanje.

Ukukhetha amakhasi ngakwesokunxele:

Ctrl + Shift + PgUp

Ukukhetha amakhasi ngakwesokudla:

Ctrl + Shift + PgDn

Ukukhetha amaSpredishithi amaningi usebenzisa iMouse nekhibhodi

Ukusebenzisa igundane kanye nezinkinobho zekhibhodi kunenzuzo eyodwa ngaphezu kokusebenzisa ikhibhodi kuphela - ikuvumela ukuba ukhethe amashidi angasondelene nawo njengoba kuboniswa esithombeni ngenhla kanye nakwezansi.

Izizathu zokukhetha ama-worksheets amaningi zihlanganisa:

• Ukushintsha umbala wethebhu lomsebenzi .
• Ukufaka amafomu omsebenzi amaningi .
• Ukufihla amashidi okusebenza .

Ukukhetha amaSpredishithi amaningi aphezulu

1. Chofoza kwelinye ithebhu ithebhu ukuze ukhethe.
2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
3. Chofoza kuzithebhu ezengeziwe eziseduze ukuze uzinqume.

Ukukhetha amaSpredishithi angewona amachashazi

1. Chofoza eyodwa ithebhu ithebhu ukuze uyikhethe.
2. Cindezela bese ubamba ukhiye we- Ctrl ekhibhodi.
3. Chofoza kumathebhu angeziwe ukuze ubakhanyise.