Yadda ake cire rarrabawa a cikin Excel bayan adanawa

A cikin Microsoft Office Excel, zaku iya tsara abubuwan da ke cikin tebur ta wata sifa ta amfani da kayan aikin da aka gina a cikin shirin. Wannan labarin zai bayyana fasalulluka na soke rarrabuwa kafin da bayan adana daftarin aiki.

Yadda ake tsara tebur a Excel

Don kawo jeri na tebur zuwa sigar da ake so don mai amfani, kuma kada ku sake tsara bayanan da ke cikin ginshiƙan da hannu, dole ne ku yi manipulations masu zuwa:

1. Zaɓi gabaɗayan tebur ko ɓangarensa: ginshiƙi, jere, takamaiman kewayon sel. Don zaɓar abubuwa na farantin, riƙe ƙasa maɓallin hagu na mai sarrafa kuma ja shi zuwa keɓaɓɓen shugabanci.

2. Danna kalmar "Gida" a cikin saman kayan aiki na Microsoft Office Excel kuma a hankali nazarin yanayin ɓangaren zaɓin da ke buɗewa.
3. A ƙarshen jerin, nemo shafin "Tsarin da Tace" kuma danna kan shi tare da LMB. Shafin zai buɗe azaman ƙaramin menu.

4. Zaɓi ɗayan zaɓuɓɓukan da aka gabatar don rarraba bayanai a cikin tebur. Anan zaka iya rarrabuwa a cikin tsari na haruffa ko kuma bi da bi.

5. Duba sakamakon. Bayan tantance ɗaya daga cikin zaɓuɓɓukan, tebur ko ɓangaren da aka zaɓa zai canza, za a jera bayanan bisa ga takamaiman sifa da mai amfani ya ƙayyade.

Kula! Hakanan zaka iya zaɓar nau'in Custom. A wannan yanayin, mai amfani zai iya tsara ma'auni na tsararrun tebur a cikin tsari mai hawa, ta kwanan wata, ta font, ta ginshiƙai da yawa, layi, ko yin rarrabuwa mai ƙarfi.

Yadda ake soke rarrabuwa yayin aiki da takarda

Idan mai amfani, yayin aiki a cikin takaddun Excel, da gangan ya jera bayanan tebur ɗin da gangan, sannan don gyara aikinsa, zai buƙaci ɗaukar matakai masu zuwa:

1. Rufe nau'in taga.
2. A cire duk sel na tebur. Don wannan dalili, kuna buƙatar danna maɓallin linzamin kwamfuta na hagu akan sarari kyauta na takaddar aiki a waje da farantin.
3. Danna alamar "Cancel", wanda yayi kama da kibiya a hagu kuma yana kusa da maɓallin "File" a kusurwar hagu na sama na allon.

4. Tabbatar cewa ayyukan da ke cikin takaddar sun koma mataki ɗaya. Wadancan. ya kamata a ware kewayon sel. Aikin gyarawa yana ba ku damar share aikin da aka yi a ƙarshe.
5. Hakanan zaka iya soke aiki na ƙarshe a cikin Microsoft Office Excel ta amfani da haɗin maɓalli akan madannai na kwamfuta. Don wannan dalili, mai amfani yana buƙatar canzawa zuwa shimfidar Ingilishi kuma a lokaci guda riƙe maɓallan "Ctrl + Z".

Ƙarin Bayani! Aikin warwarewa ta amfani da haɗin "Ctrl + Z" yana aiki a cikin duk editocin Microsoft Office, ba tare da la'akari da sigar su ba.

Yadda ake soke rarrabuwa bayan adana takaddun Excel

Lokacin da aka ajiye aikin Excel kuma mai amfani ya rufe daftarin aiki, ana share duk bayanan allo ta atomatik. Wannan yana nufin cewa maɓallin "Cancel" ba zai yi aiki ba a gaba lokacin da kake gudanar da fayil ɗin, kuma ba za ka iya cire nau'in tebur ta wannan hanyar ba. A wannan yanayin, ƙwararrun ƙwararrun ƙwararrun ƙwararrun sun ba da shawarar ɗaukar matakai masu sauƙi bisa ga algorithm:

1. Gudun fayil ɗin Excel, tabbatar cewa an adana aikin da ya gabata kuma an nuna shi akan takaddar aiki.
2. Danna maɓallin linzamin kwamfuta na dama akan sunan ginshiƙi na farko a cikin farantin.
3. A cikin mahallin mahallin, danna kan layi "Saka". Bayan irin wannan aikin, za a ƙirƙiri ginshiƙi na taimako a cikin tebur.
4. A cikin kowane jere na ginshiƙin taimako, kuna buƙatar saka lamba ta siriyal don ginshiƙai masu zuwa. Misali, daga 1 zuwa 5, dangane da adadin sel.

5. Yanzu muna buƙatar daidaita bayanan a cikin tsararrun tebur ta kowace hanya mai dacewa. Yadda za a yi wannan an bayyana a sama.
6. Ajiye daftarin aiki kuma rufe shi.

7. Shigar da fayil ɗin Microsoft Office Excel kuma sake tsara ginshiƙi na taimako a cikin tsari mai hawa ta zaɓar shi gabaɗaya kuma zaɓi zaɓin da ya dace daga jeri akan Tace da Tace tab.
8. A sakamakon haka, ya kamata a jera dukan tebur azaman ginshiƙi na taimako, watau ɗaukar sigar asali.
9. Yanzu zaku iya share ginshiƙi na farko don guje wa ruɗani da adana takaddar.

Muhimmin! Kuna iya ƙididdige ginshiƙi na taimako ta atomatik ta rubuta ƙimar kawai a cikin tantanin halitta ta farko kuma ƙara shi zuwa ƙarshen tsararrun tebur.

Hakanan zaka iya tsara bayanai a cikin tebur na Excel da hannu ta yin wasu ƙididdiga, canza dabi'u a cikin ginshiƙai da layuka tsakanin su. Koyaya, wannan tsari yana ɗaukar lokaci mai yawa ga mai amfani. Yana da sauƙi don amfani da kayan aiki da aka gina a cikin software da aka tsara don kammala aikin. Bugu da ƙari, ana iya daidaita sigogin da ake so ta launi da girman tantanin halitta.

Kammalawa

Don haka, ana yin rarrabuwa a cikin Microsoft Office Excel a cikin ɗan gajeren lokaci tare da hanyoyi masu sauƙi. Don soke wannan aikin bayan adana daftarin aiki, kuna buƙatar ƙirƙirar ƙarin ginshiƙi na taimako a cikin tsararrun tebur, ƙidaya shi, sannan jera shi cikin tsari mai hawa. An gabatar da cikakken algorithm a sama.