Maɓallin Shaukaka "Share kirtani" a cikin tebur mai kyau

Anonim

Haɗin makullin hot siɓo zabi ne wanda zai yiwu a buga wani haɗin, wanda zaku iya samun saurin samun dama ga wasu fasali na Editor Editan Eksel Editor Editan Eksel Edita. A cikin labarin, la'akari da hanyoyin share layuka a cikin edita shafi na amfani da makullin.

Share string tare da keyboard tare da makullin zafi

Hanyar cire mafi sauri shine ko dai da yawa shine amfani da haɗakar makullin zafi. Domin cire layin layi ta amfani da maɓallin maɓallin, kawai kuna buƙatar danna maballin biyu, ɗayan shine "Ctrl", da na biyu "-".

Maɓallin Shaukaka
ɗaya

Hakanan ya kamata a lura cewa layin (ko abubuwa da yawa) suna buƙatar kasuwar da aka ware a gaba. Umurnin zai cire kewayon da aka ƙayyade tare da kashe. Aikace-aikacen zai samar da zarafin rage lokacin da aka kashe da kuma watsi da ayyukan da ba dole ba wanda aka kira akwatin tattaunawar da aka kira. Zai yuwu a hanzarta tsarin cire igiyoyi ta hanyar hotan files, amma don wannan dalilin zaku buƙaci yin ayyuka 2. Da farko, adana Macro, sannan kuma ya inganta kisan ta a wani takamaiman haɗuwar maɓallan.

Adana macro

Ta hanyar amfani da lambar software na Macro don cire sashin layin, yana yiwuwa a cire shi ba tare da keke ba tare da mai bayyana linzamin kwamfuta. Aikin zai taimaka ƙayyade adadin layin da keɓewa inda alamar ware take ta kuma cire layin tare da ɗumbin. Don aiwatar da aikin, ba lallai ne ba za ku buƙaci raba abubuwan da kanta ba. Don canja wurin irin wannan lambar zuwa PC, ya kamata ka kwafa shi da liƙa kai tsaye cikin tsarin aikin.

2 Sanya haɗi na Macro

Zai yuwu a saka hot hot sakinsu, don haka za a iya hanzarta aiwatar da hanya, amma don wannan dalili ana buƙatar ayyuka 2. Da farko, kuna buƙatar ajiye Macro a cikin littafin, sannan kuma ya haɗa kowane maɓallin kewayen maɓallin kisan ta. Hanyar cire kirtani ya fi dacewa da ƙarin masu amfani da Eksel Editan Eksel.

Bugu da kari, editan ya bambanta da haruffa harafin, saboda kada ka jaddada a lokacin ƙaddamar da sunan da kuma zaɓi haɗi don amfani da shi .

Maɓallin Shaukaka
3.

Macro don cire kirtani ta yanayin

Hakanan akwai kayan aiki na ci gaba don aiwatar da tsarin da aka la'akari, ta amfani da wanda ba zai buƙatar mai da hankali kan gano layin da za a cire ba. Misali, zaku iya ɗaukar Macro wanda yake nema kuma yana share ƙananan abubuwan da ke ɗauke da rubutun da mai amfani, da ƙara don Excel. Yana cire layi tare da abubuwa da yawa daban-daban yanayi da kuma ikon saita su a akwatin maganganu.

Ƙarshe

Don cire ƙananan abubuwa a cikin edita Exdita akwai yawancin kayan aikin da suka dace. Kuna iya amfani da makullin zafi don aiwatar da irin wannan aikin, da kuma ƙirƙirar macro don cire abubuwan da ƙananan abubuwa a cikin tebur, babban abin shine don cika algorithm na ayyuka.

Saƙon gidan yanar gizo "Share layi" a cikin tebur mai kyau ya bayyana da farko don ƙarin fasaha.

Kara karantawa