Tse ka Hare
U ka sebelisa sesebelisoa Fumana mme o nkela sebaka (Find and Replace) ho Excel ho fumana kapele mongolo oo o o batlang ebe o beha mongolo o mong sebakeng sa ona. Hape u ka sebelisa taelo E-ea ho Special (Khetha Sehlopha sa Lisele) ho khetha kapele lisele tsohle tse nang le liforomo, maikutlo, ho fomata ka maemo, li-constants, le tse ling.
Ho fumana
Ho fumana mongolo o itseng kapele, latela litaelo tsa rona:
- Ho Advanced tab Home (Lapeng) tobetsa Fumana & Khetha (Fumana mme o totobatse) ebe o kgetha fumana (Fumana).
Lebokose la puisano le tla hlaha Fumana mme o nkela sebaka (Fumana 'me u nke sebaka).
- Kenya mongolo oo u batlang ho o batla, mohlala "Ferrari".
- ebe o tobetsa konopo Fumana E latelang (Fumana ka tlase).
Excel e tla totobatsa ketsahalo ea pele.
- ebe o tobetsa konopo Fumana E latelang (Fumana se latelang) hape ho totobatsa ketsahalo ea bobeli.
- Ho fumana lethathamo la liketsahalo tsohle, tobetsa ho Fumana Tsohle (Fumana tsohle).
Sebaka
Ho fumana mongolo o itseng kapele le ho beha mongolo o mong sebakeng sa ona, latela mehato ena:
- Ho Advanced tab Home (Lapeng) tobetsa Fumana & Khetha (Fumana mme o totobatse) ebe o kgetha Kenya sebaka (Etsa sebaka).
Lebokose la puisano la lebitso le tšoanang le tla hlaha le tab e sebetsang Kenya sebaka (Etsa sebaka).
- Kenya mongolo oo u batlang ho o batla (mohlala, "Veneno") le mongolo oo u batlang ho o fetola (mohlala, "Diablo").
- Tobetsa ho Fumana E latelang (Fumana ka tlase).
Excel e tla totobatsa ketsahalo ea pele. Ha ho na tse ling tse entsoeng.
- ebe o tobetsa konopo Kenya sebaka (Fetola) ho etsa sebaka se le seng.
Hlokomela: tshebediso Kenya sebaka kaofela (Fetola Tsohle) ho khutlisa liketsahalo tsohle.
Ho khetha sehlopha sa lisele
U ka sebelisa sesebelisoa E-ea ho Special (Cell Group Selection) ho khetha kapele lisele tsohle tse nang le liforomo, maikutlo, ho fomata ka maemo, li-constants, le tse ling. Mohlala, ho khetha lisele tsohle tse nang le liforomo, etsa se latelang:
- Khetha sele e le 'ngoe.
- Ho Advanced tab Home (Lapeng) tobetsa Fumana & Khetha (Fumana mme o totobatse) ebe o kgetha E-ea ho Special (Ho khetha sehlopha sa lisele).
Hlokomela: Liforomo, maikutlo, ho fomata ka maemo, li-constants, le netefatso ea data kaofela li ka fumanoa ka taelo E-ea ho Special (Ho khetha sehlopha sa lisele).
- Sheba lebokose le haufi le Litlhahlobo (Liforomo) ebe o tobetsa OK.
Hlokomela: U ka batla lisele tse nang le liforomo tse khutlisang linomoro, mongolo, li-opereishene tse utloahalang (TRUE le FALSE), le liphoso. Hape, likhetho tsena li tla fumaneha haeba u sheba lebokose Kamehla (Ka mehla).
Excel e tla totobatsa lisele tsohle ka liforomo:
Hlokomela: Haeba o khetha sele e le 'ngoe pele o tobetsa fumana (Fumana), Kenya sebaka (Fetola) kapa E-ea ho Special (Khetha sehlopha sa lisele), Excel e tla sheba leqephe lohle. Ho batla ka har'a mefuta e mengata ea lisele, khetha pele sebaka seo u se batlang.