Khetha Amaseli Angewona Akhona E-Excel Ngekhibhodi Ne-Mouse

Ngokukhetha amangqamuzana amaningi ku-Excel ungasusa idatha, sebenzisa ukufometha njengemingcele noma ukufaka shading, noma ukusebenzisa ezinye izinketho ezindaweni ezinkulu zeshidi lokusebenza konke ngesikhathi esisodwa.

Ngenkathi uhudula negundane ukuze ugcizelele ngokushesha i-block yamaseli asondelene cishe indlela ejwayelekile kunazo zonke yokukhetha amangqamuzana angaphezu kweyodwa, kunezikhathi lapho amaseli ofuna ukuwaqokomisa azikho eduze komunye nomunye.

Uma lokhu kwenzeka, kungenzeka ukhethe amaseli angasondelene. Nakuba ukhetha amangqamuzana angahambisani nawo angenziwa kuphela ngekhibhodi njengoba kuboniswe ngezansi, kulula ukukwenza usebenzisa ikhibhodi negundane ndawonye.

Ukukhetha Amaseli Angewona Akhona ku-Excel Ngekhibhodi Ne-Mouse

1. Chofoza kuseli lokuqala ofuna ukulikhetha nge-pointer yegundane ukuze wenze iseli elisebenzayo .
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Chofoza kuwo wonke amaseli ofuna ukuwakhetha ngaphandle kokukhipha ukhiye we-Ctrl.
4. Uma wonke amaseli afunayo ekhethiwe, khipha ikhi Ctrl.
5. Ungacindezi noma yikuphi nge-pointer yegundane uma ukhulula ukhiye we-Ctrl noma uzosusa okugqamile kumaseli akhethiwe.
6. Uma ukhulula ikhi ye-Ctrl ngokushesha futhi ufisa ukugqamisa amaseli amaningi, mane ucindezele futhi ubambe ukhiye we-Ctrl bese uchofoza kumaseli angeziwe

Khetha Amaseli Angewona Akhona E-Excel Ukusebenzisa Nje Ikhibhodi

Izinyathelo ezingezansi kwekhava ukukhetha amaseli usebenzisa ikhibhodi kuphela.

Ukusebenzisa ikhibhodi ngemodi eyandisiwe

Ukukhetha amangqamuzana angasondelene nekhibhodi kuphela kudinga ukuthi usebenzise ikhibhodi kumodi eyandisiwe.

Imodi enwetshiwe icushiwe ngokucindezela ukhiye we- F8 ekhibhodi. Ungavala imodi enwetshiwe ngokucindezela okhiye be- Shift no- F8 ekhibhodi ndawonye.

Khetha Amaseli Angewona Awamakheli E-Excel Ukusebenzisa Ikhibhodi

1. Hambisa isikhombisi seseli kwiseli yokuqala ofuna ukuyikhetha.
2. Cindezela bese ukhulula ukhiye we- F8 ekhibhodi ukuze uqale i-Mode Extended futhi ugcizelele iseli lokuqala.
3. Ngaphandle kokuhambisa isikhombisi se-cell, cindezela bese ukhulula okhiye be- Shift + F8 ekhibhodi ndawonye ukuvala imodi enwetshiwe.
4. Sebenzisa izinkinobho zemicibisholo ekhibhodi ukuhambisa isilayidi yeseli esiteleni esilandelayo ufisa ukugqamisa.
5. Iseli yokuqala kufanele ihlale iqokonyiswe.
6. Ngesikhombisi seseli kuseli elilandelayo ukuze sigcizelelwe, phinda izinyathelo 2 no-3 ngenhla.
7. Qhubeka ukwengeza amaseli ebangeni eligqamile ngokusebenzisa okhiye be-F8 ne-Shift + F8 ukuze uqale futhi umise imodi enwetshiwe.

Ukukhetha ama-Adjacent and Non-Adjentent Cells ku-Excel Ukusebenzisa ikhibhodi

Landela izinyathelo ezingezansi uma ububanzi obuthandayo ukukhetha luqukethe inhlanganisela yamaseli aseduze namanye njengoba kuboniswa esithombeni ngenhla.

1. Hambisa isikhombisi seseli kwiseli lokuqala eqenjini lamaseli ofuna ukuligqamisa.
2. Cindezela bese ukhulula Isihluthulelo se- F8 ekhibhodi ukuqala Imodi Elandisiwe.
3. Sebenzisa okhiye bomcibisholo ekhibhodi ukwandisa ibanga eligqamile ukuze ufake wonke amaseli eqenjini.
4. Ngayo wonke amaseli eqenjini akhethiwe cindezela bese ukhulula i- Shift + F8 ukhiye kwikhibhodi ndawonye ukuvala imodi enwetshiwe.
5. Sebenzisa izinkinobho zemicibisholo ekhibhodi ukuze uhambise isikhombisi seseli kude neqembu elikhethiwe lamaseli.
6. Iqembu lokuqala lamaseli kufanele lihlale ligqanyisiwe.
7. Uma kukhona amangqamuzana amaningi aqoqowe ufisa ukugqamisa, hamba esitokisini sokuqala eqenjini bese uphinda izinyathelo ezimbili kuya ku-4 ngenhla.
8. Uma kunamaseli ngabanye ofisa ukungeza ebangeni eligqamile, sebenzisa isethi yokuqala yemiyalelo ngenhla ukugqamisa amangqamuzana angabodwa.