Fihla futhi uhlanganise ama Columns, Imigqa, namaseli ku-Excel

Ufuna ukufunda ukuxhumanisa noma ukufihla amakholomu ku-Microsoft Excel? Lesi sifundo esifushane sichaza zonke izinyathelo ozidingayo ukuze ulandele lowo msebenzi, ikakhulukazi:

1. Fihla amakholomu
2. Bonisa noma uhlanganise ama-Columns
3. Indlela Yokufihla Imigqa
4. Bonisa noma Hlanganisa imigqa

01 ngo-04

Fihla amakholomu ku-Excel

Amaseli ngabanye akakwazi ukufihlwa ku-Excel. Ukufihla idatha esesitokisini esisodwa, noma ikholomu yonke noma umugqa wendawo ehlala kuyo kufanele ifihlwe.

Ukwaziswa kwamakholomu nokufihla okungafihli kungatholakala kumakhasi alandelayo:

1. Fihla Amakholomu - bheka ngezansi;
2. Amakholomu ahlangene - kuhlanganise nekholomu A;
3. Fihla imigqa;
4. Hlanganisa imigqa - kuhlanganise Umzila 1.

Izindlela Ezihlanganisiwe

Njengasezinhlelo zonke ze-Microsoft, kunendlela engaphezu kweyodwa yokufeza umsebenzi. Imiyalo yalesi sifundo ikhava izindlela ezintathu zokufihla nokuhlanganisa amakholomu nemigqa kuphepha lokusebenzela le-Excel :

• usebenzisa isinqamuleli sekhibhodi,
• usebenzisa imenyu yokuchofoza okukwesokudla
• usebenzisa izinketho zefomethi kuthebhu yaseKhaya yebhebhoni

Ukusetshenziswa kwedatha kumakholomu afihlekile kanye nemigqa

Uma amakholomu nemigqa equkethe idatha efihliwe, idatha ayisusiwe futhi Ingahle ibhekiswe emafomulini namashadi.

Amafomu efihliwe aqukethe izinkomba zeseli izovuselela uma idatha kumaseli ahlongozwayo ishintsha.

1. Fihla amakholomu usebenzisa ama-keycut Keys

Inhlanganisela yekhibhodi yekhibhodi yokufihla amakholomu yi:

Ctrl + 0 (zero)

Ukufihla ikholomu eyodwa Usebenzisa isinqamuleli sekhibhodi

1. Chofoza kuseli kukholomu ukuze ufihlwe ukuze wenze iseli esebenzayo.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Cindezela bese ukhulula i- "0" ngaphandle kokukhipha ukhiye we- Ctrl .
4. Ikholomu equkethe isisetshenziswa esisebenzayo kanye nanoma iyiphi idatha equkethe kufanele ifihlwe kusuka ekubukweni.

• Ukufihla amakholomu amaningi usebenzisa isinqamuleli sekhibhodi, qokomisa okungenani iseli elilodwa kukholomu ngayinye ukuthi lifihliwe, bese uphinda izinyathelo 2 no-3 ngenhla.

2. Fihla Amakholomu Usebenzisa Imenyu Yokuqukethwe

Izinketho ezitholakalayo kwimenyu yokuqukethwe - noma imenyu yokuchofoza ngakwesokudla - shintsha kuye ngokuthi into ekhethiwe uma imenyu ivuliwe.

Uma inketho yokufihla , njengoba kuboniswe esithombeni ngenhla, ayitholakali kumenyu yenkomfa kungenzeka ukuthi yonke ikholomu ayikhethwanga lapho imenyu ivulwa.

Ukufihla ikholomu eyodwa

1. Chofoza kusihlokweni sekholomu yekholomu ukuze ufihlwe ukuze ukhethe lonke ikholomu.
2. Chofoza ngakwesokudla kukholomu ekhethiwe ukuvula imenyu yesimo.
3. Khetha Fihla kwimenyu.
4. Ikholomu ekhethiwe, incwadi yekholomu, nanoma iyiphi idatha ekholomu izofihlwa kusuka ekubukeni.

Ukufihla amakholomu afanele

Isibonelo, ufuna ukufihla amakholomu C, D, no-E.

1. Esihlokweni sekholomu, chofoza bese uhudula nge-pointer yegundane ukugqamisa wonke amakholomu amathathu.
2. Chofoza ngakwesokudla kumakholomu akhethiwe.
3. Khetha Fihla kwimenyu.
4. Amakholomu akhethiwe namakholomu azofihlwa kusuka ekubukeni.

Ukufihla Amakholomu Ahlukanisiwe

Isibonelo, ufuna ukufihla amakholomu B, D, no-F

1. Esihlokweni sekholomu chofoza kukholomu yokuqala ukuthi ufihliwe.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Qhubeka ubamba ukhiye we- Ctrl bese uchofoza kanye kukholomu ngayinye eyengeziwe ukuze ufihlwe ukuze ukhethe.
4. Khipha ukhiye we- Ctrl .
5. Esihlokweni sekholomu, chofoza ngakwesokudla kwenye yekholomu ekhethiwe.
6. Khetha Fihla kwimenyu.
7. Amakholomu akhethiwe namakholomu azofihlwa kusuka ekubukeni.

Qaphela : Uma ufihla amakholomu ahlukene, uma isininisi segundane singekho ngaphezu kwekhanda lekholomu uma inkinobho yegundane kwesokudla ichofoziwe, inketho yokufihla ayitholakali.

02 ka 04

Bonisa noma uhlanganise ama-columns ku-Excel

1. Hlanganisa ikholomu A Ukusebenzisa Ibhokisi Legama

Le ndlela ingasetshenziswa ukuxhumanisa noma iyiphi ikholomu eyodwa - hhayi nje ikholomu A.

1. Thayipha ireferensi yeseli ye-A1 ebhokisini legama .
2. Cindezela ukhiye wokungena kwikhibhodi ukhethe ikholomu efihliwe.
3. Chofoza kuthebhu yaseKhaya ye- ribbon .
4. Chofoza kwisithonjana sokufometha ebhonsini ukuze uvule imenyu yehla yezinketho.
5. Esigabeni sokubonakala semenyu, khetha Hlela & Hlanganisa> Ikholomu Yobumbano.
6. Ikholomu A izobonakala.

2. Hlanganisa ikholomu A usebenzisa Amathanga Ashothikhathi

Le ndlela ingasetshenziswa futhi ukuxhumanisa noma iyiphi ikholomu eyodwa - hhayi nje ikholomu A.

Inhlanganisela eyinhloko yamakholomu angafihliwe:

I-Ctrl + Shift + 0 (zero)

Ukuhlanganisa Amakholomu A Ukusebenzisa Izinqamuleli Zezinqamuleli Nebhokisi Legama

1. Thayipha ireferensi yeseli ye-A1 ebhokisini legama.
2. Cindezela ukhiye wokungena kwikhibhodi ukhethe ikholomu efihliwe.
3. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
4. Cindezela bese ukhulula ukhiye we- "0" ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
5. Ikholomu A izobonakala.

Ukuhlanganisa Amakholomu owodwa noma amaningi usebenzisa ama-keycut Keys

Ukuxhumanisa eyodwa noma ngaphezulu amakholomu, qokomisa okungenani iseli elilodwa kukholomu ohlangothini lwekholomu (e) efihliwe ne-pointer yegundane.

Isibonelo, ufuna ukuhlanganisa amakholomu B, D, no-F:

1. Ukuze uhlanganise wonke amakholomu, chofoza bese uhudula negundane ukugqamisa amakholomu A kuya ku-G.
2. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
3. Cindezela bese ukhulula ukhiye we- "0" ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
4. Ikholamu (ama) efihliwe izobonakala.

3. Amakholomu ahlangene usebenzisa Imenyu Yokuqukethwe

Njengendlela yokhiye oyisinqamuleli ngenhla, kufanele ukhethe okungenani ikholomu eyodwa ngakwesinye kwekholomu efihliwe noma amakholomu ukuze uwahlanganise.

Ukuxhumanisa Ikholomu eyodwa noma ngaphezulu

Isibonelo, ukuhlanganisa amakholomu D, E, no-G:

1. Hambisa isikhombi segundane ngaphezu kwekholomu C kusihlokweni sekholomu.
2. Chofoza bese uhudula negundane ukuze ugcizelele amakholomu C kuya kuH ukuhlanganisa zonke izinsika ngesikhathi esisodwa.
3. Chofoza ngakwesokudla kumakholomu akhethiwe.
4. Khetha u- Unhide kusuka kwimenyu.
5. Ikholamu (ama) efihliwe izobonakala.

4. Hlanganisa ikholomu A ku-Excel Izinguquko 97 kuya ku-2003

1. Thayipha ireferensi yeseli ye-A1 ebhokisini legama bese ucindezela ukhiye wokungena kwikhibhodi.
2. Chofoza kwimenyu yefomethi .
3. Khetha ikholomu> Hlanganisa imenyu.
4. Ikholomu A izobonakala.

03 ka 04

Indlela Yokufihla Imigqa ku-Excel

1. Fihla imigqa usebenzisa izinqamuleli zesikhashana

Inhlanganisela yekhibhodi yekhibhodi yokufihla imigqa yile:

I-Ctrl + 9 (inombolo engu-9)

Ukufihla umugqa owodwa usebenzisa isinqamuleli sekhibhodi

1. Chofoza kuseli emgqeni ukuze ufihlwe ukuze wenze iseli elisebenzayo .
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Cindezela bese ukhulula i- "9" ngaphandle kokukhipha ukhiye we- Ctrl .
4. Umugqa onesitokisi esisebenzayo kanye nanoma iyiphi idatha equkethe kufanele kufihlwe kusuka ekubukweni.

• Ukufihla imigqa eminingi usebenzisa isinqamuleli sekhibhodi, gqamisa okungenani iseli elilodwa emgqeni ngamunye ukuba lifihliwe, bese uphinda izinyathelo 2 no-3 ngenhla.

2. Fihla imigqa usebenzisa iMenyu Yokuqukethwe

Izinketho ezitholakalayo kwimenyu yokuqukethwe - noma imenyu yokuchofoza ngakwesokudla - shintsha kuye ngokuthi into ekhethiwe uma imenyu ivuliwe.

Uma inketho yokufihla , njengoba kuboniswe esithombeni ngenhla, ayitholakali kwimenyu yenkomfa kungenzeka ukuthi wonke umugqa awukhethiwe uma imenyu ivulwa. Inketho ye- Hide itholakala kuphela uma wonke umugqa ukhethiwe.

Ukufihla umugqa owodwa

1. Chofoza kusihloko segqa lomugqa ukuze ufihlwe ukuze ukhethe wonke umugqa.
2. Chofoza ngakwesokudla irowu ekhethiwe ukuvula imenyu yesimo
3. Khetha Fihla kwimenyu.
4. Uhlu olukhethiwe, incwadi yomugqa, nanoma iyiphi idatha emgqeni izofihlwa kusuka ekubukweni.

Ukufihla imigqa ephakeme

Isibonelo, ufuna ukufihla imigqa 3, 4, no-6.

1. Esihlokweni somugqa, chofoza bese uhudula ne-mouse yokukhomba ukugqamisa yonke imigqa emithathu.
2. Chofoza ngakwesokudla emigqeni ekhethiwe.
3. Khetha Fihla kwimenyu.
4. Imigqa ekhethiwe izofihlwa kusuka ekubukeni.

Ukufihla imigqa ehlukanisiwe

Isibonelo, ufuna ukufihla imigqa 2, 4, no-6

1. Esihlokweni somugqa, chofoza kumugqa wokuqala ukufihla.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Qhubeka ubamba ukhiye we- Ctrl bese uchofoza kanye emgqeni ngamunye owengeziwe ukuze ufihlwe ukuze ukhethe.
4. Chofoza ngakwesokudla kwenye imigqa ekhethiwe.
5. Khetha Fihla kwimenyu.
6. Imigqa ekhethiwe izofihlwa kusuka ekubukeni.

04 ka 04

Bonisa noma Hlanganisa imigqa ku-Excel

1. Hlanganisa umzila 1 Ukusebenzisa Ibhokisi Legama

Le ndlela ingasetshenziselwa ukuhlukanisa noma yiliphi umugqa owodwa - hhayi nje umugqa owodwa.

1. Thayipha ireferensi yeseli ye-A1 ebhokisini legama.
2. Cindezela ukhiye wokungena kwikhibhodi ukhethe umugqa ofihliwe.
3. Chofoza kuthebhu yaseKhaya ye-ribbon.
4. Chofoza kwisithonjana sokufometha ebhonsini ukuze uvule imenyu yehla yezinketho.
5. Esigabeni sokubonakala semenyu, khetha Hlela & Hlanganisa> Hlanganisa Umzila.
6. Umzila 1 uzobonakala.

2. Hlanganisa umzila 1 Ukusebenzisa izinqamuleli zezinqamuleli

Le ndlela ingasetshenziswa futhi ukuxhumanisa noma yiliphi umugqa owodwa - hhayi nje umugqa owodwa.

Inhlanganisela eyinhloko yemigqa engavundile yile:

I-Ctrl + Shift + 9 (inombolo engu-9)

Ukuhlanganisa Umzila 1 usebenzisa Izinqamuleli Zezinqamuleli Nebhokisi Legama

1. Thayipha ireferensi yeseli ye-A1 ebhokisini legama.
2. Cindezela ukhiye wokungena kwikhibhodi ukhethe umugqa ofihliwe.
3. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
4. Cindezela bese ukhulula ukhiye ongu-9 ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
5. Umzila 1 uzobonakala.

Ukuxhumanisa Omunye noma iMigqa Engaphezulu Ukusebenzisa Izinqamuleli Zezinqamuleli

Ukuze unganise imigqa eyodwa noma ngaphezulu, qokomisa okungenani iseli elilodwa emigqeni nganoma yiluphi uhlangothi lwemigqa efihliwe ene-mouse pointer.

Isibonelo, ufuna ukuhlukanisa imigqa 2, 4, no-6:

1. Ukuze uhlanganise wonke imigqa, chofoza bese uhudula ngegundane ukugqamisa imigqa 1 kuya ku-7.
2. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
3. Cindezela bese ukhulula ukhiye ongu-9 ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
4. Imigqa efihliwe izobonakala.

3. Hlanganisa imigqa usebenzisa iMenyu Yokuqukethwe

Njengendlela yokhiye oyisinqamuleli ngenhla, kufanele ukhethe okungenani umugqa owodwa ngakwesinye uhlangothi lomugqa ofihliwe noma imigqa ukuze uzihlanganise.

Ukuxhumanisa I-One noma iMigqa Engaphezulu usebenzisa Imenyu Yokuqukethwe

Isibonelo, ukuhlukanisa imigqa 3, 4, no-6:

1. Hambisa isikhombisi segundane phezu komugqa wesi-2 kusihlokweni segqa.
2. Chofoza bese uhudula ngegundane ukugqamisa imigqa 2 kuya ku-7 ukuhlanganisa yonke imigqa ngesikhathi esisodwa.
3. Chofoza ngakwesokudla emigqeni ekhethiwe.
4. Khetha u- Unhide kusuka kwimenyu.
5. Imigqa efihliwe izobonakala.

4. Hlanganisa umzila 1 ku-Excel izinguqulo 97 kuya ku-2003

1. Thayipha ireferensi yeseli ye-A1 ebhokisini legama bese ucindezela ukhiye wokungena kwikhibhodi.
2. Chofoza kwimenyu yefomethi .
3. Khetha Umjaho> Hlanganisa imenyu.
4. Umzila 1 uzobonakala.

Kufanele futhi uhlole isifundo esilandelayo sendlela yokufihla nokususa ama-worksheets ku-Excel .