Indlela Yokuvula / Ukuvala Isici se-AutoComplete sika-Excel

Indlela yokulawula i-AutoComplete ku-Excel

Inketho ye-AutoComplete ku-Microsoft Excel izogcwalisa ngokuzenzakalelayo idatha njengoba uthayipha, kodwa akusiyo njalo ewusizo kuzo zonke izimo.

Ngenhlanhla, ungakhubaza noma unike amandla i-AutoComplete noma nini lapho uthanda khona.

Uma Kufanele futhi Kufanele & # 39; t Sebenzisa I-AutoComplete

Lesi sici sikhulu uma ufaka idatha kumshicileli oqukethe okuphindwe kabili. Ngokuzenzakalela ngokuzenzakalelayo, uma uqala ukuthayipha, kuzozigcwalisa ngokuzenzakalelayo lonke ulwazi kusuka kumongo oseduze kwalo, ukusheshisa ukungena kwedatha kancane kancane. Ulwazi lungasikelwa ngokuzenzekelayo kuwe ngokusekelwe kulokho okufakwe kuqala ngaphambi kwalo.

Lolu hlobo lokucushwa lukhulu uma ufaka igama elifanayo, ikheli, noma olunye ulwazi kumaseli amaningi. Ngaphandle kokuqedela i-AutoComplete, kuzodingeka ukuthi uphinde ufake idatha ofuna ukuyifaka, noma uyikopishe futhi uyihlanganise njalo, okungathatha isikhathi eside kakhulu kwezinye izimo.

Isibonelo, uma uthayiphe "uMary Washington" esitokisini sokuqala nezinye izinto eziningi kulaba abalandelayo, njenge "George" no "Harry," ungathetha "Mary Washington" futhi ngokushesha ngokuthayipha "M" bese ucindezela u-Enter ukuze i-Excel izofaka ngokuzenzakalelayo igama eligcwele.

Lokhu kungenziwa kunoma iyiphi inombolo yokufakwa kombhalo kunoma yisiphi iseli kunoma yiluphi uchungechunge, okusho ukuthi ungabe uthayipha "H" ngezansi ukuba ube ne-Excel isikisela "uHarry," bese uthayipha "M" futhi uma udinga ukuba nalokhu igama eliqediwe ngokuzenzakalela. Ngekho lapho udinga ukukopisha noma ukunamathisela noma iyiphi idatha.

Noma kunjalo, i-AutoComplete ayiyona umngane wakho njalo. Uma kungadingeki ukuthi uphinde uphinde uphinde uphinde ubhale, uzobe ukusikisela ngokuzenzakalelayo ngaso sonke isikhathi uma uqala ukuthayipha okuthile okwabelana ngenye incwadi yokuqala njengedatha yangaphambilini, okungase kube nokukhathazeka okungaphezu kosizo.

Vumela / Khubaza i-AutoComplete ku-Excel

Izinyathelo zokuvumela noma ukukhubaza i-AutoComplete ku-Microsoft Excel zihlukile kancane kuye ngokuthi inguqulo oyisebenzisayo:

I-Excel 2016, 2013, no-2010

1. Zulalela kufayela > Imenu yezinketho.
2. Ewindini lezinketho ze- Excel , vula Okuthuthukile ngakwesokunxele.
3. Ngaphansi kwesigaba sezinketho zokuhlela, vumela ukuthi u-AutoComplete avule noma avaliwe amanani weseli kuye ngokuthi ufuna ukuvula lesi sici noma ukukhubaza.
4. Chofoza noma thepha OK ukuze ulondoloze izinguquko futhi uqhubeke usebenzisa i-Excel.

Excel 2007

1. Chofoza i- Office Button .
2. Khetha Izinketho ze-Excel ukuletha ibhokisi lebhokisi le- Excel Izinketho .
3. Khetha Okuthuthukisiwe kwiphakheji ngakwesokunxele.
4. Chofoza ibhokisi eceleni kwe- Vumela i-AutoComplete ngokuzenzakalela ibhokisi lokukhethwa kwamanani eseli ukuvula noma ukuvala lesi sici.
5. Khetha OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Excel 2003

1. Zulazula kumathuluzi > Izinketho ezisuka kwibha yemenyu ukuvula ibhokisi lengxoxo yezinketho .
2. Khetha ithebhu Hlela .
3. Guqula i-AutoComplete ngokuvula / ukuvala ngebhokisi lokuhlola eliseduze ne- Vumela i-AutoComplete ngokukhethwa kukho kwamanani eseli .
4. Chofoza OK ukuze ulondoloze izinguquko bese ubuyela ekhasini lokusebenzela.