Mukati
Autocomplete masero muExcel inokubvumira kuti ukurumidze kupinda data mupepa rekushanda. Zvimwe zviito muMicrosoft Excel zvinofanirwa kudzokororwa kakawanda, izvo zvinotora nguva yakawanda. Iko kuita otomatiki mabasa akadaro iyo autocomplete basa rakagadzirwa. Muchidzidzo ichi, tichatarisa nzira dzinowanzozivikanwa dzekuzadza otomatiki: kushandisa chicherechedzo uye flash fill, iyo yakatanga kuoneka muExcel 2013.
Kushandisa iyo autofill marker muExcel
Dzimwe nguva unofanirwa kukopa zvemukati kune akawanda maseru ari padyo papepa rebasa. Iwe unogona kukopa nekuisa data musero rega rega, asi pane nzira iri nyore. Kuti uite izvi, iwe unofanirwa kushandisa iyo autocomplete mubato, iyo inobvumidza iwe kukurumidza kukopa uye kunama data.
- Sarudza sero rine data raunoda kutevedzera. Chikamu chiduku chichaonekwa mukona yezasi yekona yesero rakasarudzwa - iyi ndiyo autofill marker.
- Dzvanya uye bata bhatani rekuruboshwe uye dhonza mubato wekuzadza wega kusvika maseru ese anodiwa aiswa pachena. Kamwe chete, iwe unogona kuzadza maseru angave mutsara kana mutsara.
- Sunungura bhatani rembeva kuti uzadze maseru akasarudzwa.
Kuzadza otomatiki Sequential Data Series muExcel
Chiratidzo che autocomplete chinogona kushandiswa pese paunoda kuzadza data rine sequential order. Semuenzaniso, kutevedzana kwenhamba (1, 2, 3) kana mazuva (Muvhuro, Chipiri, Chitatu). Kazhinji, iwe unozoda kusarudza akawanda maseru usati washandisa chicherechedzo kubatsira Excel kuona nhanho yekutevedzana.
Muenzaniso uri pazasi unoshandisa autocomplete tokeni kuenderera mberi nenhevedzano yemazuva mukoramu.
Instant Zadza muExcel
Excel 2013 ine itsva Flash Kuzadza sarudzo iyo inogona kuisa otomatiki data mupepa rekushanda, ichikuchengetedza nguva nesimba. Sezvakangoita AutoComplete, iyi sarudzo inodzora rudzi rweruzivo rwaunoisa papepa rebasa.
Mumuenzaniso uri pazasi, tinoshandisa Flash Kuzadza kugadzira runyoro rwemazita kubva pane iripo runyorwa rweemail kero.
- Tanga kuisa data papepa rekushanda. Kana Flash Kuzadza yaona pateni, tarisiro yesarudzo inoonekwa pazasi pesero rakasimbiswa.
- Dzvanya Enter. Iyo data ichawedzerwa kune pepa.
Kugadzirisa kana kushandura mhedzisiro yeFlash Kuzadza chiitiko, tinya pane smart tag inoonekwa padivi pezvichangobva kuwedzerwa kukosha.
