Cima imigca efihliweyo kwi-Excel. Enye kwaye yonke kwangoko

Kwi-Windows ye-Microsoftgn, unokususa ngokukhawuleza imigca efihlakeleyo, engenanto ephambene inkangeleko yoluhlu lwetafile. Ukwenza njani oku kuya kuxelelwa kweli nqaku.

Ungayikhupha njani imigca efihliweyo kwi-Excel

Zininzi iindlela zokwenza umsebenzi ophunyeziweyo usebenzisa izixhobo zenkqubo esemgangathweni. Emva koko, eyona ixhaphakileyo kubo iya kuqwalaselwa.

Indlela 1. Indlela yokususa imigca kwitafile enye ngemenyu yomxholo

Ukujamelana nalo msebenzi, kuyacetyiswa ukuba usebenzise le algorithm elandelayo:

1. Khetha umgca owufunayo woluhlu lwetafile ye-LKM.
2. Cofa kuyo nayiphi na indawo eyabiweyo indawo ekunene.
3. Kwimenyu yenguqu, cofa kwigama "Cima ...".

Indlela yokucima iifestile zeeseli kwi-Microsoft Excel

1. Kwifestile evula, beka ukutshintshela kwi-TOGG Guqula ecaleni kweparameter "yomtya" kwaye ucofe u-Kulungile.

Khetha ukhetho oluchanekileyo lokususa umgca etafileni

1. Jonga iziphumo. Umtya okhethiweyo mayingaphazanyiswa.
2. Yenza le nkqubo kunye nezinye izinto zeplate.

Indlela yokuthintela i-2. ukuthoba iintambo ezingatshatanga ngokukhetha kwi-tepe yenkqubo

I-Excel inezixhobo ezisemgangathweni zokususa iiseli zetafile. Ukuzisebenzisa ukususa imigca, kufuneka wenze ngolu hlobo:

1. Khetha nasiphi na iseli kumtya ofuna ukuyicima.
2. Yiya kwithebhu "yekhaya" kwiphaneli ephezulu ye-Excel.
3. Fumana iqhosha lokucima kwaye ubhengeze olu khetho ngokunqakraza kumdala ngasekunene.
4. Khetha ukhetho "Cima umgca kwiphepha".

I-algorithm yokucima umgca okhethiweyo ukusuka kwiphepha lokusebenza ngesixhobo senkqubo esemgangathweni

1. Qiniseka ukuba ukukhetha isitayile ngaphambili kwakungachazwanga.

Indlela 3. Uyisusa njani yonke imigca efihliweyo ngokukhawuleza

Ukuthinjelwa kukwanokufakelela amathuba okuba neqela lokukhupha izinto ezikhethiweyo zoluhlu lwetafile. Olu khetho luvumela ukuba ususe imigca engenanto esasazeke kwiindawo ezahlukeneyo zeplate. Ngokubanzi, inkqubo yokukhupha i-UNISART yahlulahlulwe la manyathelo alandelayo:

1. Ngesikimu esifanayo, tshintshela kwithebhu yasekhaya.
2. Kwindawo evula, kwicandelo "lokuhlela", cofa kwi "Fumana kwaye wabela" iqhosha ".
3. Emva kokwenza isenzo sangaphambili, imenyu yemeko iya kuvela, apho umsebenzisi aya kudinga ukucofa emgceni "ukukhetha iqela leeseli ...".

Ukwabiwa kwayo yonke imigca engenanto kuluhlu kwangoko ngokusebenzisa "Fumana kwaye wabele i-Excel

1. Kwifestile ebonisiweyo, kufuneka ukhethe izinto ukuze ubalule. Kule meko, kuya kufuneka ubeke i-TOGG GET Switch ecaleni kweparamitha "yeseli" kwaye ucofe u "Kulungile". Ngoku kwitafile yomthombo kufuneka ngaxeshanye zimanye yonke imigca engenanto ngaphandle kwendawo yazo.

Ukukhetha imigca engenanto kwifestile yokhetho yamaqela eseli

1. I-menapilator iphambili i-winapilator icofa kuyo nayiphi na imigca ekhethiweyo.
2. Kwifestile yewomxholo yefestile, cofa kwigama elithi "Cima ..." kwaye ukhethe "umtya" ukhetho. Emva kokucofa kwi "Kulungile", zonke izinto ezifihliweyo azikhutshwa.

Iqela likhuphe izinto ezifihliweyo

Iplate enesakhiwo esaphukileyo ngendlela ye-Excel 4. Ukusetyenziswa kokucwangciswa

Eyona ndlela ifakwe ngokwe-algorithm elandelayo:

1. Khetha itafile yetafile. Le ndawo iya kulungiswa idatha.
2. Kwithebhu yasekhaya, hambisa uhlobo kunye necandelwana lokucoca.
3. Kwifestile evelayo, khetha ukhetho "Ukuhlelwa ngokufihlakeleyo" ngokunqakraza kuyo nge-LKM.

Indlela yokuya kwifestile yesiko

1. Kwimenyu yohlengahlengiso oluhlengahlengisiweyo, faka uphawu lokutshekisha phambi kwe "data" yam "iqulethe iintloko.
2. Kwikholamu, chaza naluphi na ukhetho lokuhlela: Nokuba "ukusuka kwi-z" okanye "kum kwi".
3. Ekupheleni kokucwangciswa, cofa kwi "Kulungile" emazantsi efestile. Emva koko, idatha kuluhlu lwetafile iya kulungiswa yi-cogrigion echaziweyo.

Izenzo ezifunekayo kwimenyu yohlengahlengiso

1. Ngokwakwisikimu ekuxoxwe kwicandelo elidlulileyo lenqaku, labela yonke imigca efihliweyo kwaye uzicime.

Ukuhlela amaxabiso ngokuzenzekelayo kuveza yonke imigca engenanto kude kube sekupheleni kweplate.

Ukukhupha imigca engenanto, eyayibeka ngokuzenzekelayo ukuya esiphelweni setafile emva kwendlela yayo yokulungisa 5. Sebenzisa ukucoca

Kwiitafile ze-Excel, kunokwenzeka ukuba ucime uluhlu oluchaziweyo, lishiya kuphela ulwazi oluyimfuneko kuyo. Ngale ndlela ungawususa nayiphi na umtya etafileni. Kubalulekile ukuba wenze ngokwe-algorithm:

1. Isitshixo sasekhohlo se-manipulator siphakamisa iseti yentloko.
2. Yiya kwicandelo "ledatha", elikwe ngaphezulu kwemenyu ephambili yenkqubo.
3. Cinezela iqhosha le "Filter". Emva koko, iintolo ziya kuvela kwintloko yekholamu nganye yoluhlu.

Ukubeka icebo lokucoca kwitafile yomthombo kwi-Excel

1. Cinezela i-LKM kulo naluphi na utolo lokukhupha uluhlu lweefiltha ezikhoyo.
2. Susa uphawu lweempawu kwimigca oyifunayo. Ukukhupha umtya ongenanto, kuya kufuneka uchaze inombolo yayo ngokulandelelana kwetafile.

Ukususa imigca engafunekiyo ngendlela yokuzimela

1. Jonga iziphumo. Emva kokucofa kwi "Kulungile", utshintsho kufuneka luthathwe, kwaye izinto ezikhethiweyo ziya kususwa.

Ukuqukumbela

Ke, kwi-Windows e-Ecel Excel ikhuphe imigca efihliweyo kwitafile ilula ngokwaneleyo. Oku akunyanzelekanga ukuba ube ngumsebenzisi onamava kwi-Excel. Kuyanele ukusebenzisa enye yezi ndlela zingasentla ezisebenza ngokuzimeleyo kwisoftware.

Umyalezo ususa intambo efihliweyo kwi-Excel. Inye kwaye bonke babonakala kwangoko kwitekhnoloji yolwazi.