Indlela yokulawula i-AutoComplete kwi-Excel
Inketho ye-AutoComplete kwi-Microsoft Excel izakuzalisa ngokuzenzekelayo idatha njengoko uthayipha, kodwa akusoloko iluncedo kuzo zonke iimeko.
Ngethamsanqa, unokukhubaza okanye unike amandla ngokuzenzekelayo ngokuqhotyoshelweyo xa uthanda.
Xa kufuneka kwaye kufanelekile & # 39; t Sebenzisa i-AutoComplete
Lo mbandela ukhulu xa ufaka idatha kwiphepha lokusebenzela eliqukethe ezininzi ezininzi. Ngokuqhotyosheliswa ngokuzenzekelayo, xa uqala ukuthayipha, uza kuzalisa ngokuzenzekelayo lonke ulwazi oluvela kumxholo ojikelezile, ukukhawulezisa ukungena kwedatha ngokukhawuleza. Ulwazi lungaxhaswa ngokuzenzekelayo kuwe ngokusekelwe kwinto ebeyifakelwe nje phambi kwayo.
Olu hlobo loqwalaselo lukhulu xa ungena igama elifanayo, idilesi, okanye olunye ulwazi kwiiseli ezininzi. Ngaphandle kokuba i-AutoComplete, kufuneka uphinde uphinde ufake idatha ofuna ukuyiphinda, okanye uyikopishe kwaye uyihlanganise ngokugqithiseleyo, leyo ingathabatha ixesha elide kwiimeko ezithile.
Umzekelo, ukuba uthayiphe "uMary Washington" kwiseli yokuqala kunye nezinye izinto ezininzi kulezi zilandelayo, njenge "George" kunye no "Harry," ungabhala "uMary Washington" kwakhona ngokukhawuleza ngokukhawuleza "M" kwaye ucinezela u-Enter ukuze i-Excel izenze ngokuzenzekelayo igama elipheleleyo.
Oku kunokwenzelwa nayiphi na inani lokufakwa kwetekethi kunaliphi na iseli kunoma yiluphi uchungechunge, oku kuthetha ukuba unokuthi uthayiphe "H" ngasezantsi ukwenzela ukuba i-Excel ibonise "uHarry," uze uthayiphe "M" kwakhona xa ufuna ukuba igama elizaliswe ngokuzenzekelayo. Akukho ndawo ofuna ukuyikopisha okanye ukuyibamba nayiphina idatha.
Nangona kunjalo, i-AutoComplete ayisoloko isingumhlobo wakho. Ukuba awudingi ukuphinda niphinde niphinde niphinde niphinde niphinde niphakamise okokuba uqala ukuthayipha into ekwabelana ngayo enye incwadi yokuqala njengedatha yangaphambili, enokubakho ukukhathazeka kunokuba uncedo.
Nika amandla / Khubaza i-AutoComplete kwi-Excel
Amanyathelo okunika amandla okanye ukukhubaza ukuCwangciswa kwe-AutoComplete kwi-Microsoft Excel ahluke ngokuxhomekeke kwenguqu oyisebenzisayo:
Excel 2016, 2013, no-2010
- Jonga kwiFayile > Imenyu yokukhetha.
- Kwifayile yeefayile ze - Excel , vula phambili kwi-left.
- Ngaphantsi kweCandelo leenketho zokuHlela, shintsha i-AutoComplete kwi-value yeeselingi okanye icime ngokuxhomekeke ekubeni ufuna ukuvula le nto okanye uyikhubaza.
- Cofa okanye uthepha Kulungile ukugcina utshintsho kwaye uqhubeke usebenzisa i-Excel.
Excel 2007
- Cofa kwiComputer Button .
- Khetha i- Excel Options ukukhupha ibhokisi yencoko ye- Excel .
- Khetha Okuphambili kwiphaneli ngakwesobunxele.
- Cofa kwibhokisi ecaleni kwi- AutoComplete ikhefu lokukhetha ixabiso leseli ukuvula le nto okanye icime.
- Khetha OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.
Excel 2003
- Jonga kwiiThuluzi > Khetha kwi-bar menu ukuze uvule ibhokisi yencoko yebhokisi.
- Khetha i- Hlela ithebhu.
- Shintsha i-AutoComplete ngoku / cima ngebhokisi lokutshekisha elikufutshane kwi- AutoComplete yokukhetha ixabiso leseli .
- Cofa Kulungile ukugcina utshintsho kwaye ubuyele kwiphepha lokusebenzela.