ha u ntse u sebetsa ho Li-Sheet tsa Google U ka kopana le li-spreadsheet tse kholo moo u lokelang ho sebetsana le litlatsetso tse ngata tse tšoanang.
Re utloisisa bothata ba ho sebetsana le likopi le kamoo ho ka bang thata kateng haeba u totobatsa le ho tlosa likeno ka bonngoe.
Leha ho le joalo, ka thuso Ho fomata ho latela maemo Ho tšoaea le ho tlosa likopi ho ba bonolo haholo.
Athe ho fomata ho latela maemo ho etsa hore ho be bonolo haholo ho khetholla likopi tsa Li-Sheet tsa Google.
Latela tataiso ena ha re ntse re u joetsa hore na u ka fumana le ho tlosa lingoliloeng tse kopilitsoeng joang ho Google Sheets.
Ho hlokahala feela hore u tobetse tse seng kae ho tlosa likopi ho Google Sheets 'me re li tsebe.
Google Sheets
pele o tseba Mokhoa oa ho tlosa litlatsetso tse kopitsoang ho tloha lipampiri Google Ha re ithuteng ho khetholla likopi ka kholomo e le 'ngoe. Latela mehato ena.
- Bula spreadsheet ho Google Sheets ebe u khetha kholomo.
- Ho etsa mohlala, khetha Kholomo A > Khokahanya > Khokahanya Lepolesa .
- Tlas'a melao ea ho Fomata, bula menyetla e tlohelang ebe o khetha Morero o tloaelehileng ke .
- Kenya boleng ba foromo ea moetlo, = palo (A1: A, A1)> 1 .
- Tlas'a Melao ea Fomate, o ka fumana Lifomate tsa Sebopeho, tse u lumellang ho beha mmala o fapaneng ho mafahla a totobalitsoeng. Ho etsa sena, tlanya letšoao Tlatsa mmala 'Me u khethe moriti oo u o ratang haholo.
- Ha o qetile, tobetsa etsahalale أو E phethiloe Ho totobatsa likopi kholomong e le 'ngoe.
- Ka mokhoa o ts'oanang, haeba o tlameha ho etsa sena kholomong ea C, foromo e ba, = countif (C1: C, C1)> 1 mme e tla etsa Ho joalo le ka likholomo tse ling.
Ntle ho moo, ho na le mokhoa oa ho fumana likopi bohareng ba litšiea hape. Ho ithuta, latela mehato ena.
- Ha re re u batla ho hlakisa likopi pakeng tsa lisele tsa C5 ho isa ho C14.
- Tabeng ena, ea ho Khokahanya ebe o kgetha fomata ya maemo .
- Tlas'a Apply ho pharalla, kenya marang-rang, C5:C14 .
- E latelang, tlasa melao ea ho Fomata, bula lenane la li-drop-down ebe u khetha Morero o tloaelehileng ke .
- Kenya boleng ba foromo ea moetlo, = palo (C5: C, C5)> 1 .
- Haeba ho hlokahala, fana ka 'mala o fapaneng ho lingoliloeng tse totobalitsoeng ka ho latela mehato e fetileng. Ha o qetile, tobetsa E phethiloe .
- Haeba ho hlokahala, fana ka 'mala o fapaneng ho lingoliloeng tse totobalitsoeng ka ho latela mehato e fetileng. Ha o qetile, tobetsa E phethiloe .
Google Sheet
Feela haeba u batla ho tšoaea likopi ho li-column le mela e mengata, latela mehato ena.
- Bula spreadsheet ho Google Sheets ebe u khetha likholomo tse ngata.
- Mohlala, khetha likholomo B ho ea ho E> tlanya fomate > Tlanya fomata ya maemo .
- Tlas'a melao ea ho Fomata, bula menyetla e tlohelang ebe o khetha Morero o tloaelehileng ke .
- Kenya boleng ba foromo ea moetlo, = palo (B1: E, B1)> 1 .
- Haeba ho hlokahala, fana ka 'mala o fapaneng ho lingoliloeng tse totobalitsoeng ka ho latela mehato e fetileng. Ha o qetile, tobetsa E phethiloe .
- Ka mokhoa o ts'oanang, haeba o batla ho hlakisa se etsahalang ka kholomo M ho P, o kenya B1 ka M1 le E ka P. Morero o mocha o fetoha, = palo (M1: P, M1)> 1 .
- Ntle le moo, haeba u batla ho tšoaea liketsahalo tsa likholomo tsohle ho tloha ho A ho ea ho Z, pheta feela mehato e fetileng ebe u kenya boleng ba foromo ea moetlo, = palo (A1: Z, A1)> 1 .
Google Sheets
Ka mor'a hore u qete ho totobatsa litlhaloso tse kopitsoang ka spreadsheet, mohato o latelang ke ho li tlosa. Latela mehato ena.
- Khetha kholomo eo u batlang ho tlosa mafahla ho eona.
- Tlanya Seteishen > tlosa tse habeli .
- Joale o tla bona popup. beha letšoao Ka lebokoseng le haufi le data ho na le hlooho joale> tlanya etsisa > Tlanya E phethiloe .
- U ka pheta mehato ea likholomo tse ling.
Ena ke tsela eo ka eona u ka tšoaeang le ho tlosa mafahla ho Li-Sheet tsa Google.
