Uyisusa njani imiqolo engenanto kwi-Excel

Izithuba ezingenanto ku Itafile ye-Excel (iiseli, imiqolo, iikholamu) zidla ngokunika imbonakalo engemnandanga kangako, enika ingcamango yokuba umsebenzi wenziwe ngesiqingatha okanye ngokulula uboniswe ngaphandle kokukhathalelwa kangako. Yiyo loo nto kubalulekile ukwazi uyisusa njani imiqolo engenanto kwi-excel.

Ngokwenene ngumsebenzi osisiseko kodwa oyimfuneko. Ayinamsebenzi nokuba yitafile encinci okanye uxwebhu olukhulu olubandakanya iitafile ezahlukeneyo, uluhlu, njl. Kukho a iqhinga elilula "ukucoca" iibhokisi ezinemiqolo engenanto kunye neentsika, ukuze zibe nomfanekiso obonakalayo wobuchwephesha. Siyicacisa ngezantsi:

Umfanekiso uyinto yonke. ngexesha lokubonisa iphepha lezemfundo okanye ingxelo yobungcali, Uluvo lokuba siza kunikela ngathi kunye nomsebenzi wethu uya kuhlala ungcono xa uxwebhu lunikezelwa ngendlela elungeleleneyo, ngaphandle kweempazamo zopelo, kunye nokufana kobuhle obuthile kwaye ngaphandle kweempazamo. Kunokuthiwa yintelekelelo yethu. Ukungasusi imiqolo engenanto kunye neekholamu kunokunika umfanekiso wokuthamba okanye ukungazinzi.

Kwaye ayisiyiyo loo nto kuphela: ukuba sivula ishidi le-Excel sisebenzisa ezinye ii-apps, ezo kholamu zingenanto kunye nemigca zinokugqwetha imilinganiselo yokwenyani yetafile. Oku kuthetha ukuba, kwizihlandlo ezininzi, umphumo ubonakala ubuthathaka.

Eneneni, sinako iindlela ezimbini ezahlukeneyo ukwenza lo msebenzi. Kule mihlathi ilandelayo siza kuhlalutya kuqala indlela esisiseko kwaye emva koko intsonkothe ​​ngakumbi yokukhetha kunye nokucima zonke iiseli ezingenanto, nokuba zezemiqolo okanye iikholamu ezahlukeneyo.

Cima imiqolo engenanto kunye neekholamu

Siza kubona ukuba zeziphi iindlela zokuphelisa imiqolo yebhanki kwi-Excel kwaye ngaloo ndlela senze amaphepha ethu abonise ngokucacileyo kunye nokucwangciswa kwembonakalo. Kukho iindlela ezimbini zokuyenza:

Indlela ye-1

Yindlela "yakudala". Ukuyenza isebenze, la manyathelo okufuneka uwalandele:

1. Okokuqala, sikhetha nayiphi na iseli ekuluhlu olungenanto okanye ikholamu esifuna ukuyicima.
2. Emva koko siya kwithebhu yokuqalisa kwaye sikhetha ukhetho "Iiseli".
3. Kwi-drop-down menu evelayo, cofa kukhetho "Susa". Apho sisafumana izinto ezimbini ezintsha ezinokwenzeka. Sikhetha eyona ifanele le nto sifuna ukuyenza:  
   • Cima imiqolo yamaphepha.
   • Cima iikholamu zamaphepha. 

Indlela ye-2

Yenye indlela, ebonakalayo ngakumbi. Sichaza apha indlela yokwenza inyathelo ngenyathelo:

1. Ukuqala, senza ekunene nqakraza kwinani okanye unobumba womqolo okanye ikholamu esifuna ukuyicima. Lowo umhlophe, ngokucacileyo.
2. Nje ukuba umqolo okanye ikholamu ikhethiwe, a iwindow pop-up.
3. Kuyo, sicinezela ngokulula ukhetho "Susa".

Susa iiseli ezingenanto kuxwebhu

Amaxesha amaninzi, endaweni yokucima imiqolo engenanto kwi-Excel, iphuma ngakumbi kwiakhawunti. susa zonke iiseli ezingenanto etafileni. Zombini ezo zenza imiqolo kunye neekholamu kunye nezo zisasazwa ngokungaqhelekanga kulo lonke uxwebhu.

Kwakhona sifumana iindlela ezimbini zokwenza esi senzo. Eyokuqala isebenza ngakumbi, ekubeni inokusetyenziswa kuxwebhu lonke okanye inxalenye yalo ebesiyikhethile ngaphambili; okwesibini kugxininise ngakumbi "ekucoceni" iiseli ezingenanto kwiikholamu zomntu ngamnye; Okokugqibela, eyesithathu ifuna ukusetyenziswa kweemacros:

Indlela ye-1

Isekwe kuphendlo kunye nokhetho lokhetho lwe-Excel spreadsheets:

1. Okokuqala siya eKhaya thebhu.
2. Apho, sikhetha iqhosha "Ushicilelo".
3. Kolu khetho lulandelayo luvulayo, cofa kwi «Khangela kwaye ukhethe».
4. Okulandelayo, imenyu entsha ivula, apho sikhetha ukhetho lwe «Yiya kwi-Special».
5. Ekugqibeleni, kwibhokisi entsha yeenketho eboniswayo, sikhetha "Iiseli ezingenanto" kwaye uqinisekise isenzo ngokucofa "Ukwamkela".

Kubalulekile: ukuze le ndlela isebenze, kufuneka siqale sibeke umda weebhokisi apho sifuna isenzo sisetyenziswe. Oku kunokwenziwa nokuba ngekhesa ye mouse okanye nge Ctrl + isitshixo indibaniselwano. ukutshintsha + Isiphelo.

Indlela ye-2

Ukwenza le ndlela, isebenza kuphela kwimiqolo, kufuneka sibhenele kukhetho lwe-"Filters" lwe-Excel. Yenziwa ngolu hlobo:

1. Ngaphambi kokuba siqale, kuyimfuneko ukukhetha uluhlu apho sifuna ukususa imiqolo engenanto.
2. Emva koko siye kwithebhu "Idatha".
3. Apho sikhetha umsebenzi Icebo lokucoca ulwelo, eliza kwenza icebo lokucoca kuluhlu ngalunye olukhethiweyo (umqolo weheader ubonisa ukuhla kumqolo ngamnye).
4. Emva koko sikhetha imixholo yokubonisa. Masiye kwimenyu engaphantsi "Hluza" kwaye kuyo sivala ukhetho "Akukho." Xa usenza oku, i-Excel ifihla yonke imiqolo engenanto.

Indlela ye-3

Enye indlela yokugqibela, ilula kakhulu, eyenziwa kwibar yesixhobo sokufikelela ngokukhawuleza kwimenyu:

1. Kuqala siya kukhetho "Lungisa iThulbha yoFikelelo oluKhawulezayo."
2. Sinqakraza "Eminye imiyalelo."
3. Sikhetha "Makhro".
4. Emva koko sikhetha i-macro "DeleteEmptyRows" kwaye ucofe ku "Yongeza".
5. Ekugqibeleni, ukusebenzisa isenzo, cofa ku "Ukwamkela".