Ngokukhetha iiseli ezininzi kwi-Excel ungasusa idatha, ufake ifomathi njengemida okanye u-shading, okanye usebenzise ezinye iinketho kwiindawo ezinkulu zephepha lokusebenzela zonke ngexesha elinye.
Ngethuba uhudula ngemouse ukuba ukhankanye ngokukhawuleza ibhloko yeeseli eziseduze mhlawumbi yindlela eqhelekileyo yokukhetha ngaphezulu kwesinye iseli, kukho amaxesha apho iifayile ofuna ukuyibeka zingekho ngaphaya komnye.
Xa oku kwenzeka, kunokwenzeka ukhethe ii-cell ezingahambisani. Nangona ukhetha iiseli ezingaqhelekanga zenziwe kuphela ngebhodibhodi njengoko kuboniswe ngezantsi, kulula ukwenza usebenzisa ikhibhodi kunye ne mouse ndawonye.
Ukukhetha iiselingi ezingekho kwii-Excel kunye neKhobhodi kunye neMouse
- Cofa kwifowuni yokuqala ofuna ukuyikhetha kunye ne-pointer ye mouse ukuze wenze iseli esebenzayo .
- Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
- Cofa kuzo zonke iiseli ofuna ukuzikhetha ngaphandle kokukhulula ikhiye ye Ctrl.
- Emva kokuba zonke iiseli ezifunwayo zikhethiweyo, khupha ikhiye ye Ctrl.
- Musa ukucofa nakwezinye i-pointer ye mouse xa ukhulula ikhi Ctrl okanye uya kucima ukugqwesa kwiiseli ezikhethiweyo.
- Ukuba ukhulula ikhi ye Ctrl ngokukhawuleza kwaye unqwenela ukugqamisa iiseli ezininzi, cindezela kwaye ubambe iqhosha le Ctrl kwakhona uze uklikha kwiiseli ezongezelelweyo.
Khetha ii-Non-Adjacent Cells kwi-Excel usebenzisa i-Keyboard kuphela
Amanyathelo angezantsi kwinqaku yokukhetha iiseli esebenzisa nje ikhibhodi.
Ukusebenzisa i-Keyboard kwiModelo eyongeziweyo
Ukukhetha ii-cell ezingasondelene kunye nebhodibhodi kufuna ukuba usebenzise ikhibhodi kwiModeli eyongeziweyo.
Imodi eyongeziweyo isebenze ngokucinezela iqhosha le- F8 kwikhibhodi. Ungavimbela imodeli eyongeziweyo ngokucinezela iifayile zeShift kunye neF8 kwikhibhodi ndawonye.
Khetha iiSeleli ezingaqhelekanga ezingaqhelekanga kwi-Excel usebenzisa i-Keyboard
- Hambisa isikhombisi seseli kwifowuni yokuqala ofuna ukuyikhetha.
- Cinezela ukhulule iqhosha le- F8 kwikhibhodi ukuqala Imodi eyongeziweyo kunye nokugqamisa iseli yokuqala.
- Ngaphandle kokuhambisa isalathisi seeseli, cinezela kwaye ukhulule izitshixo zeShift + F8 kwikhibhodi ndawonye ukuvala imodeli enwetshiwe.
- Sebenzisa izitshixo zitshixo kwibhobhobho ukuhambisa isalathisi seseli kwisisele elandelayo ofuna ukuyibeka.
- Isisele sokuqala kufuneka sihlale sigxininiswe.
- Ngesikhokhelo sesisele kwisisele esilandelayo ukuba sikhankanywe, phinda amanyathelo 2 no-3 ngasentla.
- Qhubeka ukongeza iiseli kwibala eliqakathekileyo ngokusebenzisa iifayile zeF8 neShift + F8 ukuqala nokuyeka imodeli enwetshiwe.
Ukukhetha iiselithi ezingekhoyo kunye neeNkalo ezingekho kwi-Excel usebenzisa i-Keyboard
Landela amanyathelo angezantsi ukuba uluhlu olufunayo ukhetha luqulethe umxube weeseli ezizimeleyo njengoko kuboniswe kumfanekiso ongentla.
- Hambisa isikhombisi seseli kwisisele yokuqala kwiqela leeseli ofuna ukuligqamisa.
- Cinezela kwaye ukhulule Isihlomelo se-F8 kwibhodibhodi ukuqala Imodi eyongeziweyo.
- Sebenzisa izitshixo zitshixo kwibhodibhodi ukwandisa uluhlu oluqakathekileyo ukubandakanya zonke iiseli kwiqela.
- Kuzo zonke iiseli kwiqela elikhethiweyo cinezela kwaye ukhulule iShift + F8 izitshixo kwibhodibhodi ndawonye ukuvala imodi eyongeziweyo.
- Sebenzisa izitshixo zitshixo kwikhibhodi ukuhambisa isikhombisi seseli kude neqela elikhethiweyo leeseli.
- Iqela lokuqala leeseli kufuneka lihlale libalaselisiwe.
- Ukuba kukho iiseli ezininzi ezinqwenela ukugqamisa, hlela kwiseli yokuqala kwiqela uze uphinde uphendule amanqanaba 2 ukuya ku-4 ngaphezulu.
- Ukuba kukho iiseli ngamnye ozifunayo ukongeza kwibala eligqityiweyo, sebenzisa isethi yokuqala yemiyalezo ngasentla ukugqamisa iiseli ezilodwa.