Rarraba aiki ne na Excel wanda ya saba da raɗaɗi kuma sananne ga kusan kowa. Koyaya, akwai lokuta da yawa waɗanda ba daidai ba kuma masu ban sha'awa na amfani da su.
Case 1. Rarraba ta ma'ana, ba haruffa ba
Ka yi tunanin yanayi na gama-gari: akwai tebur wanda a cikinsa akwai ginshiƙi mai sunan watan (Janairu, Fabrairu, Maris…) ko ranar mako (Jumma'a, Talata, Laraba…). Tare da nau'i mai sauƙi akan wannan shafi, Excel yana tsara abubuwan da haruffa (watau daga A zuwa Z):
Kuma ina so, ba shakka, in sami jerin abubuwan da aka saba daga Janairu zuwa Disamba ko daga Litinin zuwa Talata. Ana iya yin wannan cikin sauƙi tare da na musamman jerawa ta jeri na al'ada (jerin jeri na al'ada).
Zaɓi teburin kuma danna babban maɓallin Raba tab data (Data - Nau'i). Akwatin maganganu zai buɗe wanda a ciki kake buƙatar saka nau'in filin (ginshiƙi) kuma zaɓi nau'in nau'in a cikin jerin zaɓuka na ƙarshe. Jerin Custom (Jerin Custom):
Bayan haka, taga mai zuwa zai buɗe, inda zaku iya zaɓar jerin watanni ko kwanakin mako da muke buƙata:
Idan lissafin da ake buƙata (misali, watanni, amma a cikin Ingilishi) ba a samuwa ba, to ana iya shigar da shi cikin filin da ya dace ta zaɓi zaɓi. Sabon jerin (Sabon Jerin):
Za ka iya amfani da matsayin SEPARATOR yaya ko key Shigar. Da zarar ka ƙirƙiri irin wannan jeri na al'ada, zaku iya amfani da shi a cikin wasu littattafan aikin Excel.
Wani nuance mai ban sha'awa shi ne cewa ta wannan hanyar za ku iya rarraba ba a cikin haruffa ba, amma ta hanyar mahimmanci da mahimmanci duk wani abu mai mahimmanci, kuma ba kawai watanni ko kwanakin mako ba. Misali:
- mukamai (darakta, mataimakin darakta, shugaban sashe, shugaban sashe…)
- matsayin soja (Janar, Kanal, Laftanar Kanal, Manjo…)
- takaddun shaida (TOEFL, ITIL, MCP, MVP…)
- abokan ciniki ko kayayyaki gwargwadon mahimmancinku (whiskey, tequila, cognac, giya, giya, lemo…)
- da dai sauransu.
Case 2: Tsara rubutu da lambobi a lokaci guda
A ce tebur ɗinmu yana da ginshiƙi tare da lambobi don sassa daban-daban da majalisai don motoci (lambar ɓangaren). Haka kuma, manyan ɓangarorin da aka haɗa (misali akwatin gear, inji, tuƙi) ana nuna su ta hanyar lambar dijital zalla, kuma ƙananan sassan da suka haɗa ana nuna su ta hanyar lamba tare da ƙari mai lamba ta hanyar, a ce, digo. Ƙoƙarin tsara irin wannan jeri ta hanyar da aka saba zai haifar da sakamakon da ba a so, saboda Excel ya bambanta lambobi daban-daban (lambobin manyan tarawa a cikin taron) da kuma rubutun daban (lambobin ƙananan sassa tare da dige):
 |  |
Kuma, ba shakka, Ina so in sami lissafin inda bayan kowace babban raka'a bayanansa zasu tafi:
Don aiwatar da wannan, muna buƙatar ƙara wani ginshiƙi na ɗan lokaci zuwa teburin mu, wanda a ciki muke juya duk lambobin zuwa rubutu ta amfani da aikin TEXT:
Idan kun tsara ta wannan ginshiƙi, Excel zai tambaye ku yadda ake warware lambobi da rubutu:
Idan ka zaɓi zaɓi na biyu a cikin wannan akwatin maganganu, to, Excel ba zai canza lambobin manyan tarawa zuwa lambobi ba kuma zai tsara jerin duka a matsayin rubutu, wanda zai ba mu sakamakon da ake so. Za a iya share ginshiƙin taimako, ba shakka,.
- Tsara ta launi
- Tsara ta launi tare da ƙari na PLEX
- Tsara ta dabara