Indlela Excel ukwenza uluhlu drop-phantsi: le ndlela elula

abasebenzisi abaninzi yohambelwano ofisi eqhelekileyo ukususela Microsoft Excel spreadsheet ngokucacileyo lula umhleli. I-drop-phantsi uluhlu kwi bhokisi, ukonga ixesha elithathwayo ukungena okanye ukukhangela iinkcukacha, oko kudala isibini lemizuzwana, njengoko kuthelekiswa Access, apho le nkqubo inzima kakhulu. Ngezantsi kukho iindlela ezintathu ezisisiseko ukudala izintlu ezinjalo, yaye ezinye i parameters ezibalulekileyo zolawulo.

Yintoni zizintlu drop-phantsi?

Ngaba izintlu olu hlobo zibandakanya uluhlu olubanzi izicelo. Xa iseli enye, ungangenisa intsingiselo ngaphezu kwesinye, njengokuba kusenziwa eyenziwe ngokungagqibekange, kodwa eziliqela.

iinketho izilungiso kuba ezimbini:

• Kuphela amanani ukusuka oqalwe.
• Iinqobo ukusuka kuluhlu, kunye nazo naziphi na ezinye iinkcukacha.

Ngaloo ndlela, siqala ukusebenza Excel. Yenza imenyu yoluhlu apha ilula. Kodwa kuqala, kufuneka enze ezinye izenzo lokuqala ukuya ekugqibeleni le nkqubo iyonke kuyehla kuphela ukhetho wokungenela data eziyimfuneko.

Indlela Excel ukwenza uluhlu drop-phantsi: inkqubo jikelele

Yokuqala sigaba sibandakanya ufikelelo umsebenzi, nto leyo evumela ukwenza le nkqubo. Indlela Yokwenza i-Excel uluhlu imenyu-phantsi ngokwesiseko iimpawu ibhanile nkqubo? elula kakhulu. Okokuqala, khetha elinye okanye iseli ngaphezulu, ekuthi kujongwe ukuba ukwazisa ezinye umqolo wamaxabiso, kwaye i Ukunqakaza ekunene-umxholo menu. Kuyo, kuqala ukusebenzisa kwicandelo "Data", uze - nqakraza "Data Ukuqinisekiswa". Kwaye yiya kwi Izicwangciso tab.

Kuye imeko (test) uvavanyo kunye uhlobo data umtya, yaye apho sikhetha ukuba 'List ". Enyanisweni, amasimi eseleyo ude ube uyakwazi kuhlala injalo. Kubhaliwe ibekwe ngezantsi nje ilayini apho iinqobo umthombo ziya kubhalwa. Nantsi ke into abanomdla.

I-drop-phantsi uluhlu kwi Excel 2007: I-entry data manual

Makhe siqale yokungena manual lwamaxabiso. Ukuba sithetha ukuba yenziwa njani i-Excel uluhlu drop-phantsi ngale ndlela, isicombululo ukumisela amaxabiso kumhlaba ngasentla kuphela. Kufuneka kuqatshelwe ukuba kufuneka ufake amaxabiso ezahlulwe sisithuba lokuma phakathi kwezivakalisi lisetyenziswe eyendawo Russian. Kuba isabelo IsiNgesi usebenza comma kuphela. Engxakini le ndlela izicacele: kuthatha ixesha elininzi.

Umthombo kobubanzi

Kwimeko yesibini, ungasebenzisa isicombululo ngokukhawuleza. Ngokomzekelo, kufuneka ukuba ufake wonke amaxabiso iiseli: ukusuka A2 kunye nesiphelo kunye A4. Umthombo okuphindiweyo umtya, ukuba ubeka isalathisi. Emva koko khetha nje band oyifunayo. Le program iya kubeka i uphawu lokulingana, kodwa liya kubhalisa ixabiso ayikho kwifom «(A2: A4)», njengokuba kusenziwa kumqolo kokufanayo iifomyula, kwaye lwalo «= $ A $ 2: $ A $ 4".

Le ndlela yeyona nto elungileyo imilinganiselo yayo ukufaka isantya. Kodwa njengokuba uninzi neengxaki eziphambili zezi ekungakwazini ukusebenzisa kuyehla iseli, leyo kwelinye sheet ngaphandle esebenzayo okwangoku.

Ukubeka amabanga igama (uluhlu)

Okokugqibela, enye indlela yokusombulula ingxaki, ukuba bahlabele indlela yokwenza drop-phantsi uluhlu. Okokuqala, oko kudala ngokwalo uluhlu waza igama ahambelanayo. Kwaye ngoko umthombo line kuya kufuneka nje ufake igama, inophawu uphawu ngokulinganayo. Le ndlela ivumela ukuba ukudala izintlu usebenzisa iinkcukacha kunye neenqobo ukuba ibekwe kwiphepha ezahlukeneyo ncwadi. Kwaye olu khetho busetyenziswa kakhulu iinguqulelo Excel 2007, umhleli kunye ngezantsi, njengoko ezi iinguqulelo abazi ukusebenza njani uluhlu apho data ukusuka sheets ezahlukeneyo.

Phantsi Izilungiselelo, Phatha

Ngokumalunga izintlu zolawulo umhleli Excel yiseti imisebenzi eyimfuneko. Kodwa ke eyona nto, mhlawumbi, zinomdla - ukunwenwa inani elinkeza iziphumo igalelo nemiqathango efanayo. Oku kusebenza kwiimeko apho kwi igqabi kukho iitshekhi ezininzi kakhulu kunye neemeko zazo kufuneka itshintshwe. Ukulungiselela le njongo, icandelo Uqinisekiso-ngcombolo, nto leyo iye yasetyenziswa kuzo zonke iindlela zangaphambili, vula kwi tab "Imiyalezo ukuba angene." Apha uyakwazi ukungena icebiso evezwayo xa eyokuqalisa iseli. Lo myalezo ungaba nangaphandle ngokususa nje uphawu ukusuka kwindawo show yakhe. Kwi Imposiso tab, ungafaka isilumkiso malunga data ayilunganga igalelo. Oku kuluncedo xa kungekho iimeko zolawulo amaxabiso nzima okanye xa kuthe kwakho utshintsho buso.

isiphelo

Njengoko kubonakala ngentla apha, ingxaki, ukuba bahlabele indlela yokwenza drop-phantsi uluhlu zivumelekile ayikho nzima kangaka. Umbuzo: yeyiphi indlela yokusebenzisa? Ukuba ezi nkcukacha aziphelelanga kakhulu, inguqulelo elula fanela. Indlela yesibini ixhaphakile. Umyinge umsebenzisi uya ilingane kakhulu. Kodwa ukuba ukwazi inkqubo esuka umsebenzisi ayiphelelanga ukusebenzisa kuphela elula kwemisebenzi apha kuya kuba ukuyila uluhlu kangangoko Igama kwaye elandela amabanga igalelo data ngenxa yabo. Ekubeni utshintsho kuluhlu ogama uyakhawuleza kwaye kulula. Ngokubanzi, khetha eyona ndlela lula kunokwenzeka ngaphandle naziphi na iingxaki.