Momwe mungatsegule / kutulutsa Feature AutoComplete Feature

Momwe mungadzitetezere Zomwe Zachitika mu Excel

Chotsatira cha AutoComplete ku Microsoft Excel chidzadzazitsa deta pamene mukuyimira, koma sizothandiza nthawi zonse.

Mwamwayi, mungathe kulepheretsa kapena kutsegula AutoComplete nthawi iliyonse yomwe mumakonda.

Pamene Muyenera Kuyenera Ndipo Muyenera Kuchita & # 39; t Gwiritsani Ntchito Zomangamanga

Chigawo ichi ndi chokongola poika deta mu tsamba lomwe liri ndi zolemba zambiri. Pogwiritsa ntchito AutoComplete, pamene muyambe kuyimba, idzadzigudubuza zotsalira zonsezo kuchokera pazomwe zikuchitika kuzungulira izo, kuti ikufulumizitse kulowa ma data pang'ono. Zambiri zitha kukufotokozerani mwachidziwitso malinga ndi zomwe zinalembedwa kale.

Kukonzekera uku kuli bwino pamene mukulowa dzina lomwelo, adilesi, kapena mauthenga ena mumaselo angapo. Popanda Kutsegula Magetsi, muyenera kubwezeretsa deta yomwe mukufuna kuti ikhale yowerengeka, kapena kuyikopera ndikuyiyika mobwerezabwereza, zomwe zingatenge nthawi yayitali pa zochitika zina.

Mwachitsanzo, ngati mwajambula "Mary Washington" mu selo yoyamba ndiyeno zinthu zina zambiri mwa zotsatirazi, monga "George" ndi "Harry," mukhoza kulemba "Mary Washington" kachiwiri mofulumira polemba "M" ndikukakamiza kulowa kuti Excel idziwetse dzina lonse.

Izi zikhoza kuchitidwa pa chiwerengero chilichonse cha malemba mu selo iliyonse mndandanda uliwonse, kutanthauza kuti mukhoza kulemba "H" pansi kuti Excel iwonetsere "Harry," kenako ikani "M" kachiwiri ngati mukufuna kukhala dzina la auto-lomaliza. Pa nthawi iliyonse muyenera kutengera kapena kusunga deta iliyonse.

Komabe, Kutsegula kwambiri sikungokhala bwenzi lanu nthawi zonse. Ngati simusowa kubwereza chilichonse, chidzapitirizabe kuzipanga nthawi iliyonse mutayamba kulemba chinachake chomwe chimalemba kalata yoyamba monga deta yapitayi, yomwe nthawi zambiri imakhala yovuta kuposa chithandizo.

Thandizani / Khutsani Zomwe Zidasinthidwe mu Excel

Mayendedwe othandizira kapena kulepheretsa AutoComplete ku Microsoft Excel ndi osiyana kwambiri malingana ndi momwe mukugwiritsira ntchito:

Excel 2016, 2013, ndi 2010

  1. Yendetsani ku Faili > Menyu zosankha.
  2. Mu Excel Zowonekera mawindo, Tsegulani Patsogolo kumanzere.
  3. Pansi pa Gawo la Kusintha kwa Zosintha , pezani Pulogalamu Yomaliza Yomaliza Yotsatsa Magetsi kuti iwononge kapena kuchotsa malingana ndi momwe mukufuna kutsegula mbali iyi kapena kuiikira.
  4. Dinani kapena pangani OK kuti musunge kusintha ndikupitiriza kugwiritsa ntchito Excel.

Excel 2007

  1. Dinani ku Boma la Office .
  2. Sankhani Zolemba Zowonjezerapo kuti mubweretsere Excel Options dialog box.
  3. Sankhani Zapamwamba pazithunzi kumanzere.
  4. Dinani bokosi pafupi ndi Lolani Zomwe Zidzakhala Zomwe Zidasinthidwa kuti muwonetsetse mbaliyi.
  5. Sankhani bwino kuti mutseke bokosilo ndi kubwerera kuntchito.

Excel 2003

  1. Yendetsani ku Zida > Zosankha kuchokera pa bar menyu kuti mutsegule Options dialog box.
  2. Sankhani Tsamba la Kusintha .
  3. Sinthani Kutsatsa Kwadongosolo / kutseka ndi bokosi lofufuzira pafupi ndi Yambitsani Zomwe Zidzakuthandizira pazomwe mungasankhe.
  4. Dinani OK kuti musunge kusintha ndikubwerera ku tsamba lokumbukira.