Nzira Yekutenderera / Kurega Excel AutoComplete Feature

Nzira yekugadzirisa AutoComplete mu Excel

Nzira yeAccomplete in Microsoft Excel ichazadza data iwe pachayo, asi haisi iyo inoshanda nguva dzose mumamiriro ese ezvinhu.

Nenzira yakanaka, unokwanisa kubvisa kana kuita AutoComplete chero paunenge uchida.

Paunofanirwa uye Usingafaniri & # 39; t Shandisa AutoComplete

Ichi chinhu chakanaka paunopinda dhamusi mune pepa rekushandisa iro rine zvakawanda zvezvidimbu. Ne AutoComplete pane, paunotanga kuverenga, ichagadzirisa zvinyorwa zvose zvemashoko kubva mumuganhu wakaipoteredza, kuti ikurumidze kuiswa kwedhidiki zvishoma. Ruzivo runogona kuve ruchinyatsokurudzirwa kwauri kubva pane izvo zvanga zvichinyorwa pamberi payo.

Iko rudzi rwekugadzirisa hukuru kana iwe uchipinda muzita rimwe chete, kero, kana rumwe ruzivo mumasero akawanda. Pasina AutoComplete, iwe unofanirwa kudzorerazve data yaunoda kudzokororwa, kana kukopa nekuisungirira kakawanda, iyo inogona kutora nguva yakareba mune dzimwe mamiriro ezvinhu.

Somuenzaniso, kana iwe wakanyora "Mary Washington" mumutsara wokutanga uyezve zvimwe zvinhu zvakawanda pane zvinotevera, se "George" uye "Harry," unogona kutora "Mary Washington" zvakare zvakanyanya nokukurumidza nekunyora "M" uye zvino kuvhara Enter kuitira kuti Excel ichinyatsozvinyora zita rose.

Izvi zvinogona kuitwa chero nhamba ipi zvayo yezvinyorwa zvinyorwa mune chero sero pane chero mutsara, zvichireva kuti iwe unogona kuisa "H" pasi kuti uve neExcel inorati "Harry," ndokuzoisa "M" zvakare kana uchida kuva nazvo zita-auto-rakapedzwa. Hapana kana iwe unofanirwa kunyora kana kusungiridza chero data.

Zvisinei, AutoComplete haisi nguva dzose shamwari yako. Kana iwe usingadi kudzokorora chinhu chipi nechipi, chichiri chichiratidza kuzviita nguva dzose paunotanga kuisa chimwe chinhu chinogovera tsamba imwechete yekutanga se data yekare, iyo inowanzova yakanyanya kunetseka kupfuura rubatsiro.

Itai kuti / Dzivisai AutoComplete mu Excel

Nhanho dzekugonesa kana kudzivisa AutoComplete mu Microsoft Excel dzakasiyana zvakasiyana zvichienderana neshanduro yaunoshandisa:

Excel 2016, 2013, uye 2010

1. Enda kune File > Options menu.
2. MuchiExcel Options window, svinura Shanduro kuruboshwe.
3. Pasi Pechikamu Chekugadzirisa Chikamu, chengetedza Ipa AutoComplete kuti maitiro ezvitendi avhare kana kuti aende zvichienderana nekuti iwe unoda kuchinja chinhu ichi kana kuchidzivirira.
4. Dzvanya kana tora OK kuti uchengetedze kuchinja uye ramba uchishandisa Excel.

Excel 2007

1. Dzvanya muBhoton Button .
2. Sarudza Excel Options kuti uuye neExcel Options dialog box.
3. Sarudza Zvakapfurikidza pane pane pane kuruboshwe.
4. Dzvanya bhokisi riri pedo neAkagadzirira AutoComplete ye cell cell option box kuti udzivise kana kuvhara.
5. Sarudza OK kuti uvhare bhokisi rebhokisi uye dzokera kubasa rekushanda.

Excel 2003

1. Tsvaga kune Zvishandise > Zvimwe zvinenge zviri pa menu bar kuti uzarure Options dialog box.
2. Sarudza Hora tab.
3. Chengetedza AutoComplete on / off with the checkmark box pedyo neAkagadzirisa AutoComplete ye cell cell option.
4. Dzvanya OK kuti uchengetedze shanduko uye dzokera kushizha.