A darasin da ya gabata, mun saba da tushen rarrabuwa a cikin Excel, mun bincika ainihin umarni da nau'ikan nau'ikan. Wannan labarin zai mayar da hankali kan rarrabuwa na al'ada, watau wanda mai amfani zai iya daidaita shi. Bugu da ƙari, za mu bincika irin wannan zaɓi mai amfani kamar rarraba ta tsarin tantanin halitta, musamman ta launi.
Wani lokaci kuna iya haɗu da gaskiyar cewa daidaitattun kayan aikin rarrabuwa a cikin Excel ba su iya rarraba bayanai cikin tsarin da ake buƙata ba. Abin farin ciki, Excel yana ba ku damar ƙirƙirar jeri na al'ada don nau'in tsari na ku.
Ƙirƙiri nau'in al'ada a cikin Excel
A cikin misalin da ke ƙasa, muna son rarraba bayanai akan takardar aikin ta girman T-shirt (shafi D). Rarraba al'ada zai tsara masu girma dabam a cikin tsari na haruffa, wanda ba zai zama daidai ba. Bari mu ƙirƙiri jeri na al'ada don rarrabe masu girma dabam daga ƙarami zuwa babba.
- Zaɓi kowane tantanin halitta a cikin tebur na Excel wanda kuke son tsarawa. A cikin wannan misali, za mu zaɓi cell D2.
- danna data, sannan danna umarni Raba.
- Akwatin maganganu zai buɗe Raba. Zaɓi ginshiƙin da kake son tsara tebur da shi. A wannan yanayin, za mu zaɓi rarraba ta girman T-shirt. Sai a filin Domin click Jerin Custom.
- Akwatin maganganu zai bayyana lists… Da fatan za a zaɓa SABON LISSAFI a sashe lists.
- Shigar da girman T-shirt a cikin filin Jerin abubuwa a cikin tsari da ake bukata. A cikin misalinmu, muna so mu tsara masu girma dabam daga ƙarami zuwa babba, don haka za mu shiga bi da bi: Ƙananan, Matsakaici, Large da X-Large ta danna maɓallin. Shigar bayan kowane kashi.
- danna Adddon adana sabon tsari. Za a ƙara lissafin zuwa sashin lists. Tabbatar an zaba kuma danna OK.
- Tagan maganganu lists zai rufe. Danna OK a cikin akwatin maganganu Raba domin yin rarrabuwar kawuna.
- Za a jera ma'auni na Excel a cikin tsarin da ake buƙata, a cikin yanayinmu, ta girman T-shirt daga ƙarami zuwa babba.
Rarraba a cikin Excel ta tsarin salula
Bugu da ƙari, za ku iya warware maƙunsar maƙunsar Excel ta tsarin tantanin halitta maimakon abun ciki. Wannan rarrabuwa yana da amfani musamman idan kun yi amfani da lambar launi a wasu sel. A cikin misalinmu, za mu jera bayanai ta launi ta tantanin halitta don ganin waɗanne oda suke da kuɗin da ba a tara ba.
- Zaɓi kowane tantanin halitta a cikin tebur na Excel wanda kuke son tsarawa. A cikin wannan misali, za mu zaɓi cell E2.
- danna data, sannan danna umarni Raba.
- Akwatin maganganu zai buɗe Raba. Zaɓi ginshiƙin da kake son tsara tebur da shi. Sai a filin Raba Ƙayyade nau'in nau'in: Launi na salula, Launi na Font, ko Alamar salula. A cikin misalinmu, za mu jera tebur ta shafi Hanyar biyan (column E) kuma ta launin tantanin halitta.
- a cikin Domin zaɓi launi don rarrabewa. A cikin yanayinmu, za mu zabi launin ja mai haske.
- latsa OK. Yanzu an jera teburin da launi, tare da jajayen sel masu haske a saman. Wannan odar yana ba mu damar ganin fitattun umarni.
