Ungabalwa kanjani amakholomu ku-Excel

Lapho usebenza ngamatafula, kudingekile kaningi ukwenza inani lamakholomu. Vele, lokhu kungenziwa ngesandla, inombolo eqhutshwa ngokwehlukile kwikholomu ngayinye kwikhibhodi. Uma kukhona amakholomu amaningi etafuleni, kuzothatha isikhathi esiningi. Kunamathuluzi akhethekile ku-Efpelle, avumela ukuqhuba amanani ngokushesha. Ake sithole ukuthi basebenza kanjani.

Izindlela Zokuthola Izinombolo

Ku-Excel, kunezinketho ezinombolo zezinombolo zekholamu ezilandelanayo. Ezinye zazo zilula futhi ziyaqondakala, ezinye ziyinkimbinkimbi ngokweqiniso. Ake siyeke imininingwane ngamunye wabo ukuthi aphethe ngokuthi iyiphi inketho yokusebenzisa ngokukhiqiza ngecala elithile.

Indlela 1: Ukugcwalisa umaki

Indlela ethandwa kakhulu yamakholomu ezenzakalelayo azenzakalelayo ngokuqinisekile ukusetshenziswa kophawu lokugcwalisa.

1. Vula itafula. Faka intambo kuyo lapho inani lamakholomu lizobekwa khona. Ukuze senze lokhu, sabela noma isiphi isitokisi sentambo esizoba ngaphansi kwezibalo ngokushesha, ngokuchofoza inkinobho yegundane elifanele, ngaleyo ndlela kubangele imenyu yokuqukethwe. Kulolu hlu, khetha into ethi "Namathisela ...".



2. Kuvulwa iwindi elincane. Sihumusha ushintshele esimweni esithi "Faka String" isikhundla. Chofoza inkinobho ethi "KULUNGILE".



3. Esitokisini sokuqala somugqa ongeziwe, sibeka inombolo "1". Ngemuva kwalokho siletha isikhombisi ekhoneni elingezansi kwesokudla sale seli. Isikhombisi siphenduka isiphambano. Ubizwa ngokuthi umaki wokugcwalisa. Ngasikhathi sinye, bopha inkinobho yegundane kwesobunxele kanye nokhiye we-CTRL kwikhibhodi. Ngidonsa umaki wokugcwalisa ngakwesokunene sokuphela kwetafula.
4. Njengoba sikwazi ukubona, umugqa owudingayo ugcwele izinombolo ngokulandelana. Lokho kungukuthi, inani lamanani amanani entengo.

Ungafaka futhi indlela ehlukile. Gcwalisa amaseli amabili okuqala emugqa ongeziwe ngezinombolo "1" no "2". Sabela womabili amaseli. Sisungula isikhombisi ekhoneni elingezansi kwesokudla selungelo. Ngenkinobho yegundane ehlanganayo, Hudula umaki wokugcwalisa kuze kube sekupheleni kwetafula, kepha kulokhu awudingi ukucindezela ukhiye we-CTRL. Umphumela uzobe unjalo.

Yize inguqulo yokuqala yale ndlela ibonakala ilula, kepha, noma kunjalo, abasebenzisi abaningi bakhetha ukusebenzisa owesibili.

Kukhona enye inketho yokusebenzisa umaki wokugcwalisa.

1. Esitokisini sokuqala Sibhala inombolo "1". Usebenzisa umaki, kopisha okuqukethwe ngakwesokudla. Kulokhu, futhi, inkinobho ye-CTRL ayidingekile.
2. Ngemuva kokukopisha kwenziwa, siyabona ukuthi lonke umugqa ugcwele inombolo "1". Kepha sidinga ukubalwa kwezinombolo. Chofoza ku-pictograph okuvele eduze kweseli eligcwele kakhulu eligcwele. Uhlu lwezenzo luyavela. Senza ukufakwa kokushintshwa kwesikhundla esithi "Gcwalisa".

Ngemuva kwalokho, wonke amaseli ebanga elizinikezele azogcwaliswa ngamanani ngokulandelana.

Isifundo: Ungayenza kanjani i-autocomplete ku-Excel

Indlela 2: Inombolo esebenzisa inkinobho ethi "Gcwalisa" ethepheni

Enye indlela yokubala amakholomu ku-Microsoft Excel kusho ukusetshenziswa kwenkinobho ye- "Gcwalisa" ethepheni.

1. Ngemuva kokuthi umugqa wengezelwe ukubalwa kwamanani amakholomu, angena kwinombolo yokuqala yeseli "1". Sigqamisa lonke umugqa wetafula. Ukuba sethebhu "Yasekhaya", ku-Ribbon Sichofoza inkinobho ethi "Gcwalisa", etholakala kwibha yamathuluzi "yokuhlela". Imenyu eyehlayo iyavela. Kuyo, khetha into "ukuqhubeka ...".



2. Kuvulwa iwindi lezilungiselelo. Onke amapharamitha lapho kufanele avele alungiselelwe ngokuzenzakalelayo njengoba sidinga. Kodwa-ke, ngeke kube okungcono kakhulu ukuhlola isimo sabo. Ebhlokini "yendawo", ukushintshwa kufanele kusethwe esimweni "ngezintambo". Ipharamitha "yohlobo" kufanele ikhethwe ngenani elithi "izibalo". Isinyathelo esizenzakalelayo kufanele sikhutshazwe. Okungukuthi, akudingi ukuba uphawu lokuhlola eduze kwegama elihambisanayo lepharamitha. In the "Isinyathelo" field, hlola inombolo yenombolo 1. Insimu "inani lomkhawulo" kufanele lingabi nalutho. Uma enye ipharamitha ingahambisani nezikhundla ezivezwe ngenhla, bese ulungiselela ngokwezincomo. Ngemuva kokuthi uqinisekise ukuthi wonke amapharamitha agcwaliswa kahle, chofoza inkinobho ethi "KULUNGILE".

Ukulandela lokhu, amakholomu etafula azobalwa ngokulandelana.

Awukwazi ngisho ukwaba yonke intambo, kepha umane ubeke inombolo "1" esitokisini sokuqala. Bese ushayele iwindi lokuhlela le-Progression ngendlela efanayo echazwe ngenhla. Onke amapharamitha kufanele ahambisane nalabo esasikhuluma ngaphambili, ngaphandle kwensimu "yenani lomkhawulo". Kufanele ibekwe ngenani lamakholomu etafuleni. Bese uchofoza inkinobho ethi "KULUNGILE".

Ukugcwaliswa kuzobulawa. Inketho yokugcina ilungele amatafula anenombolo enkulu kakhulu yamakholomu, ngoba akudingi ukuhudula isikhombisi noma kuphi lapho usisebenzisa.

Indlela 3: Umsebenzi wekholomu

Ungabalwa namakholomu asebenzisa umsebenzi okhethekile, obizwa nangokuthi ikholamu.

1. Khetha iseli lapho inombolo "1" kufanele ibe khona kumanani okhuluma. Chofoza inkinobho ethi "Namathisela umsebenzi", ubekwe ngakwesobunxele ngentambo yefomula.



2. I-Wizard iyavula. Inohlu lwemisebenzi ehlukahlukene ye-Excel. Sifuna igama elithi "ikholomu", sikwabela bese sichofoza inkinobho ethi "KULUNGILE".



3. Ukuphikisana nomsebenzi kuyavuleka. Ensimini yesixhumanisi, udinga ukucacisa isixhumanisi kunoma yisiphi iseli sekholomu yokuqala yeshidi. Okwamanje kubaluleke kakhulu ukunaka, ikakhulukazi uma ikholomu lokuqala letafula akuyona ikholomu yokuqala yeshidi. Ikheli le-Link lingabekwa ngesandla. Kepha kulula kakhulu ukwenza lokhu ngokufaka isikhombisi kwinkambu ye-Link, bese uqhafaza kwiseli oyifunayo. Njengoba ubona, emva kwalokho, izixhumanisi zalo ziboniswa endle. Chofoza inkinobho ethi "KULUNGILE".



4. Ngemuva kwalezi zenzo, isibalo esithi "1" sivela esitokisini esikhethiwe. Ukuze ubale wonke amakholomu, abe ekhoneni lawo eliphansi eliphansi bese ushayela umaki wokugcwalisa. Njengoba nje ngezikhathi ezedlule, silidonsela ngakwesokunene sokuphela kwetafula. Awudingi ukubopha ukhiye we-CTRL, cindezela kuphela inkinobho yegundane efanele.

Ngemuva kokuqeda zonke izenzo ezingenhla, wonke amakholomu etafula azobalwa ngokulandelana.

Isifundo: Imisebenzi yeWizard ku-Excel

Njengoba ubona, inani lamanani amakholomu ngokunwebeka lingaba ngezindlela eziningana. Okudumile kakhulu kubo ukusetshenziswa komaki wokugcwalisa. Kumatafula abanzi kakhulu, kunengqondo ukusebenzisa inkinobho ethi "Gcwalisa" ngokushintshwa kumasethingi wethuthuka. Le ndlela ayisho ukuthi ukukhohlisa isikhombisi kuyo yonke indiza yeshidi. Ngaphezu kwalokho, kukhona umsebenzi okhethekile wekholomu. Kepha ngenxa yobunzima bokusebenzisa nokungahambisani, le ndlela ayithandwa ngabasebenzisi abathuthukile. Yebo, futhi isikhathi le nqubo ithatha ngaphezu kokusetshenziswa okujwayelekile kophawu lokugcwaliswa.