Yadda za a kunna / kashe fasalin AutoComplete na Excel

Yadda za a sarrafa AutoComplete a Excel

Zaɓin AutoComplete a cikin Microsoft Excel zai cika bayanai yayin da kake bugawa, amma ba koyaushe a kowane yanayi ba.

Abin farin ciki, zaka iya musaki ko taimaka AutoComplete duk lokacin da kake so.

Lokacin da Ya kamata kuma Ya kamata & Yi amfani da AutoComplete

Wannan fasalin yana da kyau a yayin shigar da bayanai a cikin takardun aiki wanda ya ƙunshi ƙididdigar yawa. Tare da AutoComplete, lokacin da ka fara bugawa, zai kunshi sauran bayanan daga cikin mahallin da ke kewaye da shi, don hanzarta shigar da bayanai sosai a bit. Za a iya ba da shawara ta atomatik zuwa gare ka dangane da abin da aka taɓa shi kafin shi.

Irin wannan tsari yana da kyau a yayin da kake shigar da wannan sunan, adireshin, ko wasu bayanai a cikin sel masu yawa. Idan ba tare da AutoComplete ba, kana so ka sake tantance bayanan da kake so a kirkiro, ko kwafa da kuma manna shi gaba daya, wanda zai iya ɗaukar lokaci mai tsawo a wasu al'amuran.

Alal misali, idan ka danna "Mary Washington" a cikin sallar farko da kuma sauran abubuwa masu zuwa, kamar "George" da "Harry," zaka iya rubuta "Mary Washington" da sauri ta hanyar rubuta "M" sa'an nan kuma danna Shigar don Excel za ta atomatik rubuta cikakken suna.

Ana iya yin wannan don kowane adadin shigarwar rubutu a cikin kowane tantanin halitta a kowane jerin, ma'anar cewa za ku iya rubuta "H" a ƙasa don Excel ya ba da shawara "Harry," sannan kuma rubuta "M" kuma idan kana buƙatar samun wannan sunan auto-kammala. Babu wani lokaci ka buƙaci ka kwafa ko manna duk bayanai.

Duk da haka, AutoComplete ba koyaushe aboki ba ne. Idan ba ku buƙatar yin wani abu ba, zai kasance har yanzu-yana ba da shawarar da shi a duk lokacin da ka fara buga wani abu da ya ba da wannan wasika ta farko kamar bayanan da aka gabata, wanda zai iya zama damuwa fiye da taimakon.

Yarda / Kashe AutoComplete a Excel

Matakan da za a iya taimaka ko dakatar da AutoComplete a cikin Microsoft Excel su ne kaɗan daban dangane da fasalin da kake amfani dasu:

Excel 2016, 2013, da 2010

1. Nuna zuwa fayil > Zaɓuɓɓukan menu.
2. A cikin Zabuka na Excel , bude Babba a hagu.
3. A karkashin Ƙaƙwalwar Zabuka sashe, kunna Canza AutoComplete don ƙimar salula a kunne ko a kashe dangane da ko kuna son juya wannan alama a kan ko soke shi.
4. Danna ko matsa OK don ajiye canje-canje kuma ci gaba da amfani da Excel.

Excel 2007

1. Danna maɓallin Ofishin .
2. Zabi Zaɓuɓɓukan Zabuka don kawo akwatin zane na Excel Zabuka .
3. Zaɓi Na ci gaba a cikin aiki zuwa hagu.
4. Danna akwatin kusa da Enable AutoComplete don zaɓin zaɓi na ƙirar salula don kunna wannan fasali ko kashe.
5. Zaba Ok don rufe akwatin maganganu kuma komawa cikin aikin aiki.

Excel 2003

1. Gudura zuwa Kayan aiki > Zaɓuɓɓuka daga barikin menu don buɗe akwatin maganganun Zɓk .
2. Zaɓa da Edit shafin.
3. Kunna / kunna AutoComplete tareda akwatin alamar kusa kusa da Enable AutoComplete don zaɓin dabi'un salula .
4. Danna Ya yi don adana canje-canje kuma komawa zuwa aikin aiki.