Izindlela ezishisayo Ungahlanganisa kanjani amaseli ku-Efvelave

Indlela 1: Inkinobho Yeseli Eningi

Ake siqale ngendlela yakudala yokuhlanganisa amaseli ku-Excel usebenzisa umsebenzi ngegama elihambisanayo. Kodwa-ke, kulokhu kushintsha indlela yokubiza, etshela ngezikhiye ezijwayelekile ezishisayo ezenzelwe ukuhamba ngamathuluzi wohlelo. Uzodinga ukwenza amangcindezi eminingana, kepha uma ubakhumbula, kusebenze inkinobho kuzokwenziwa ngokushesha kunokukhetha kwayo negundane.

1. Khetha amaseli ofuna ukuwahlanganisa.



2. Cindezela ukhiye we-ALT ukuze uvele imenyu enokukhethwa kwezenzo kanye nokhiye we-backlit. Khetha ithebhu "yasekhaya" ye-J. Key



3. Lokhu okulandelayo kuzobonisa iphaneli ngezenzo, lapho udinga ukufaka izinketho zokuqondanisa ezitholakalayo ngokhiye we-shch.



4. Kumenyu entsha eyehlayo, izinketho eziningi ezitholakalayo zokuhlanganisa amaseli azovela. Sebenzisa noma yimuphi wabo ngokwazisa izidingo zakho.



5. Ngemuva kokusebenzisa inkinobho, ukuhlanganiswa kuzokwenzeka ngokuzenzakalelayo ukuthi uzobona ukubuyela etafuleni.



6. Uyacelwa ukuthi uqaphele ukuthi ukuhlanganisa amaseli amabili noma amaningi, kulowo nalowo onenani elithile, kwenzeka ngokugcwalisa inani leseli ephezulu kwesobunxele lobubanzi, okungukuthi, kuzovezwa kuphela, futhi idatha esele iyasuswa kuphela, futhi idatha esele iyasuswa. Ngaphezu kwalokho, lokhu kuzokwazisa isaziso sohlelo esivelayo.



7. Umphumela wenyunyana enjalo ubona isithombe esilandelayo.

Indlela 2: Inkinobho kwiphaneli yokufinyelela esheshayo

Kusetshenziswa izinkinobho ezishisayo futhi kuthatha isikhathi, ngakho-ke uma uhlanganisa amaseli ku-Excel, kuvame ukudingekile, kungani ungabeki esikhundleni senkinobho eyodwa kwiphaneli enqamule. Ukuze wenze lokhu, uzodinga ukwenza isimo esincane.

1. Nwebisa imenyu yokufinyelela esheshayo yokungena ngokushesha ngokuchofoza inkinobho ethi Down Arrow lapho ukhetha khona eminye imiyalo.



2. Uhlu lwemiyalo etholakalayo, thola "ukuhlangana bese ubeka enkabeni", ngemuva kwalokho lapho uchofoza kabili i-LKM kulomugqa noma usebenzise inkinobho ethi "Faka".



3. Inkinobho ehambisanayo izovela ohlwini ngakwesokudla, okusho ukuthi ingezwe ngempumelelo kwiphaneli yokufinyelela esheshayo futhi ungavala le menyu ngokuphephile.



4. Njengoba kungabonakala, inkinobho itholakala kwesobunxele ngenhla, ihlala isefomini elisobala futhi okuphezulu kusetshenziswa ekusebenzeni kwayo.



5. Khetha amaseli bese ucindezela inkinobho ukuze uthole ngokushesha izinguquko ezidingekayo.

Indlela 3: Isenzo "Gcwalisa" - "Hlela"

Ngosizo lokuzulazula ngezinkinobho ezishisayo, njengoba kukhonjisiwe ngendlela 1, ungabiza isenzo "-" Hlela "-" Qondanisa ", okuzohlanganisa lezo zindawo lapho kubhalwe khona amaseli. Lesi sici asilungele noma sisebenza ngamatafula, kepha lapho kunemibhalo kuphela, ingaba wusizo. Umgomo wezenzo zawo uzobona emyalweni olandelayo.

1. Khetha ikholomu ngombhalo ofuna ukugcwalisa futhi uvumelanise isibonisi esilungile.



2. Shayela ukuzulazula nge-alt bese ucindezela ukuthi ngishintshele kuthebhu enkulu.



3. Okokuqala, cindezela u-Yu, bese uya kumenyu ethi "Ukuhlela".



4. Ngokuhlukile, chofoza futhi uvule uhlu olwehliswayo "Gcwalisa".



5. Khetha lapho isenzo "qondanisa" usebenzisa ukhiye.



6. Buyela ebangeni elizinikezele bese ubheka umphumela ophumela wokugcwaliswa kanye nokuqondanisa.