Idan kana son Excel ya nuna kawai bayanan da suka dace da wasu sharudda, to, yi amfani da tacewa. Don wannan:
- Danna kowane tantanin halitta a cikin bayanan.
- A kan Babba shafin data (Data) danna Tace (Tace). Kibiyoyi suna bayyana a cikin taken shafi.
- Danna kibiya kusa da take Kasa.
- Danna kan layi Zaɓi duk (Zaɓi Duk) don share duk akwatunan rajista, sannan duba akwatin Amurka.
- latsa OKSakamakon: Excel kawai yana nuna bayanan tallace-tallace na Amurka.
- Danna kibiya kusa da take Quarter.
- Danna kan layi Zaɓi duk (Zaɓi Duk) don share duk akwatunan rajista, sannan duba akwatin Qtr 4.
- latsa OKSakamakon: Excel kawai yana nuna bayanan tallace-tallace na Amurka na huɗu kawai.
- Don soke tacewa, akan shafin data (Data) danna Clean (bayyana). Don cire tacewa gaba ɗaya, watau cire kiban, sake danna maɓallin Tace (Tace).