Rarraba a cikin Excel

A cikin Excel, zaku iya daidaita bayanai ta ginshiƙai ɗaya ko fiye. Ana iya yin rarrabuwa a cikin tsari mai hawa ko gangarawa.

Shafi daya

Don warware bayanai ta shafi ɗaya, yi kamar haka:

  1. Zaɓi kowane tantanin halitta a cikin ginshiƙi da kuke son warwarewa ta.
  2. Don warwarewa cikin tsari mai hawa, buɗe shafin data (Data) kuma danna kan gumakan DA NI (DA).Rarraba a cikin ExcelSakamakon karshe:Rarraba a cikin Excel

lura: Don warwarewa cikin tsari mai saukowa, danna gunkin ЯА (DOMIN).

ginshiƙai da yawa

Don warware bayanai ta ginshiƙai da yawa, bi waɗannan matakan:

  1. A kan Babba shafin data (Data) danna Raba (Kayyade).Rarraba a cikin ExcelAkwatin maganganu zai buɗe Raba (Kayyade).
  2. A cikin jerin zaɓuka Kasa (A ware ta) zaɓi ginshiƙi don daidaitawa ta (a cikin misalinmu shine Sunan mahaifa).Rarraba a cikin Excel
  3. latsa Ƙara matakin (Ƙara Level).
  4. A cikin jerin zaɓuka Sannan ta (Sa'an nan kuma ta) zaɓi shafi na gaba don tsarawa (mun zaɓa Tallace-tallace).Rarraba a cikin Excel
  5. latsa OKSakamako: Ana fara jerawa bayanai ta hanyar shafi Sunan mahaifa, sannan ta shafi Tallace-tallace.Rarraba a cikin Excel

Leave a Reply