Ho notlela a Google Sheet ke mohato oa bohlokoa ho netefatsa polokeho le bots'epehi ba data ea hau. Ka ho kenya ts'ebetsong mehato e nepahetseng ea ts'ireletso, o ka thibela phihlello e sa lumelloeng ea tlhahisoleseling ea hau mme oa fokotsa likotsi tse amanang le ho tlola data. Sehloohong sena, re tla hlahloba mabaka a hore na ke hobane'ng ha u lokela ho notlela Google Sheet le likotsi tse ka bang teng tsa ho se etse joalo. Hape re tla fana ka tataiso ea mohato ka mohato mabapi le mokhoa oa ho notlela Google Sheet, ho kenyeletsoa le ho khetha sebaka sa ho notlela le ho beha litumello bakeng sa sebaka se sirelelitsoeng. Re tla arolelana malebela a mang a ho sireletsa hau Li-Sheets tsa Google, joalo ka ho sebelisa diphasewete tse matla, E nolofalletsang netefatso ea lintho tse peli, ho hlahloba likarolo khafetsa, le ho boloka likopi tsa maqephe a hau. Ka ho kenya tšebetsong mehato ena, u ka etsa bonnete ba tšireletseho le boinotši ba boitsebiso ba Google Sheets.
Ke Hobane'ng ha U Lokela ho Notlela Google Sheet?
Ho notlela Google Sheet ho fana ka melemo e mengata 'me ho na le merero e fapaneng:
- Ts'ireletso ea Datha: Ho notlela Google Sheet ho thusa ho sireletsa lintlha tse ka har'a eona hore li se ke tsa fetoloa ka tsietsi, li hlakoloe kapa li fihlelle batho ba sa lumelloe. Sena se bohlokoa haholo ha o sebetsana le litaba tsa lekunutu kapa tsa lekunutu.
- Botšepehi ba Datha: Ka ho notlela Google Sheet, u etsa bonnete ba hore litaba, liforomo le lifomete li lula li sa fetohe. Sena se thibela liphetoho tse sa lebelloang tse ka amang ho nepahala kapa ho sebetsa ha leqephe.
- Taolo ea Tšebelisano: Ho notlela Google Sheet ho u lumella ho laola boemo ba phihlello le tšebelisano bakeng sa basebelisi ba fapaneng. U ka thibela litokelo tsa ho hlophisa ho batho ba itseng kapa ua beha leqephe e le la ho shebella feela, ho netefatsa hore ke basebelisi ba lumelletsoeng feela ba ka etsang liphetoho.
- Tlhophiso ea mofuta: Ho notlela Google Sheet ho thusa ho boloka taolo ea mofuta ka ho thibela basebelisi ba bangata ho etsa liphetoho ka nako e le 'ngoe. Sena se tiisa hore liphetoho li etsoa ka mokhoa o laoloang, ho fokotsa kotsi ea liphetoho tse hanyetsanang.
- Tšireletso ea Setšoantšo: Haeba u na le template ea Google Sheet eo u batlang ho e arolelana le ba bang, ho e notlela ho tiisa hore sebopeho sa template sa mantlha se lula se sa fetohe. Basebelisi ba ka etsa likopi tsa template e notletsoeng ntle le ho fetola mofuta oa mantlha.
- Ho boloka liforomo le lifomete: Ho notlela Google Sheet ho boloka liforomo tse rarahaneng le ho fomata ka maemo. Sena se thibela liphetoho tse sa lebelloang tse ka senyang ts'ebetso kapa ponahalo ea leqephe.
- Ho Thibela ho Hlakola ka Kotsi: Ka ho notlela Google Sheet, o fokotsa monyetla oa hore data ea bohlokoa kapa liforomo tsa bohlokoa li hlakoloe ka phoso. Sena se eketsa tšireletso e eketsehileng khahlanong le tahlehelo ea data ka boomo.
- Ntlafatso ea Tlhahiso ea Lintlha: Ho notlela lisele kapa mekha e itseng ho Google Sheet ho u lumella ho etsa tokomane e hlophisitsoeng le e shebahalang e le setsebi. U ka thibela basebelisi ho fetola libaka tse itseng, ho netefatsa hore ho fomete le ho fana ka lipuo ho lumellana.
- Litlhoko tsa Tumellano le Taolo: Liindastering kapa mekhatlong e meng, ho ka ba le litlhokahalo tsa boikamahanyo kapa tsa taolo tse hlokang ho notleloa ha data ea bohlokoa. Ho notlela Google Sheet ho thusa ho fihlela litlhokahalo tsena le ho boloka ts'ireletso ea data.
- Khotso ea Kelello: Ho notlela Google Sheet ho fana ka khotso ea kelello, ho tseba hore data ea hau e bolokehile, e sirelelitsoe, 'me e fumaneha feela ho ba nang le tumello e hlokahalang.
Ha re nahana ka melemo ena, ho notlela Google Sheet ke mokhoa oa bohlokoa oa ho sireletsa data ea hau, ho boloka botšepehi ba data, le ho laola phihlello le tšebelisano.
Ke Likotsi life tsa ho se notlele Google Sheet?
- Ponahalo ea lintlha tsa bohlokoa: Ho se notlele Google Sheet ho beha lintlha tsa bohlokoa kotsing ea ho hlakoloa kapa ho fetoloa ka phoso ke basebelisi ba bang.
- Litaba tsa botšepehi ba data: Ntle le ho notlela, ho na le monyetla o moholo oa liphetoho tse sa reroang ho lisele tsa bohlokoa, tse ka lebisang litabeng tsa botšepehi ba data.
- Ho hloka taolo: Ho se notlele Google Sheet ho bolela hore mang kapa mang ea nang le phihlello a ka etsa liphetoho leqepheng lohle, a ka beha data kapa lipalo tsa bohlokoa kotsing.
- Ho lahleheloa ke lekunutu: Ho hloleha ho notlela Google Sheet ho lumella basebedisi ba bang ho bona kapa ho fetosa boleng ba ho kenya, e leng ho ka fellang ka ho fihlella boitsebiso ba bohlokwa ba sa dumellwang.
- Kotsi ea liphoso kapa ho senya: Ntle le ho notlela, data e ka fetoloa habonolo, ea eketsa monyetla oa liphoso kapa ho qhekella ka boomo ho ke keng ha hlokomeloa.
Ho se notlele Google Sheet ho hlahisa lintlha tsa bohlokoa, ho eketsa kotsi ea mathata a botšepehi ba data, ho haelloa ke taolo ea liphetoho, ho beha lekunutu, 'me ho lumella liphoso kapa ho senya. Ho bohlokoa ho kenya tšebetsong lisele tse notletsoeng ho thibela likotsi tsena le ho netefatsa ts'ireletso le ho nepahala ha data ea hau.
Ke Likotsi life tsa ho se notlele Google Sheet?
- Ho pepesa lintho tse kentsoeng tsa bohlokoa: Ho se notlele Google Sheet ho beha lintlha tsa bohlokoa kotsing ea ho hlakoloa ka phoso kapa ho fetoloa ke basebelisi ba bang.
- Litaba tsa botšepehi ba data: Ntle le ho notlela, ho na le monyetla o moholo oa ho fetoha ka boomo ho lisele tsa bohlokoa, tse ka lebisang litabeng tsa botšepehi ba data.
- Ho hloka taolo: Ho se notlele Google Sheet ho bolela hore mang kapa mang ea nang le phihlello a ka etsa liphetoho leqepheng lohle, a ka beha data kapa lipalo tsa bohlokoa kotsing.
- Ho lahleheloa ke makunutu: Ho hloleha ho notlela Google Sheet ho lumella basebelisi ba bang ho bona kapa ho fetola lintlha tsa bohlokoa, e leng se ka fellang ka ho fihlella litaba tsa lekunutu ntle le tumello.
- Kotsi ea liphoso kapa ho senya: Ntle le ho notlela, data e ka fetoloa habonolo, ea eketsa monyetla oa liphoso kapa ho qhekella ka boomo ho ke keng ha hlokomeloa.
Ho se notlele Google Sheet ho hlahisa lintlha tsa bohlokoa, ho eketsa kotsi ea mathata a botšepehi ba data, ho haelloa ke taolo ea liphetoho, ho beha lekunutu, 'me ho lumella liphoso kapa ho senya. Ho bohlokoa ho kenya tšebetsong lisele tse notletsoeng ho thibela likotsi tsena le ho netefatsa ts'ireletso le ho nepahala ha data ea hau.
Mokhoa oa ho notlela Google Sheet?
Ho notlolla bokhoni ba Google Sheets ho qala ka ho ithuta ho notlela lintlha tsa hau tsa bohlokoa ka mokhoa o sireletsehileng. Karolong ena, re tla qala mohato ka mohato oa ho utloisisa tsebo ea ho notlela Google Sheet. Ho tloha ho bula leqephe le lakatsehang ho fihlela likhethong tsa ts'ireletso, ho khetha sebaka se tla notleloa, ho beha litumello, 'me, qetellong, ho netefatsa le ho sebelisa ts'ireletso, re tla u hlomella ka tsebo le bokhoni ba ho sireletsa data ea hau ka nepo.
Mohato oa 1: Bula Google Sheet eo U Batlang ho e Notlela
Ho notlela Google Sheet, latela mehato ena:
- Hata 1: Bula Google Sheet eo u batlang ho e notlela.
- Fumana Likhetho tsa Tšireletso.
- Khetha mofuta oa lisele tseo u batlang ho li notlela.
- Beha litumello bakeng sa sebaka se sirelelitsoeng.
- Netefatsa mme o sebedise tshireletso.
Ka ho latela mehato ena, u ka thibela ba bang ho hlophisa lisele tsa bohlokoa kapa ho etsa liphetoho leqepheng lohle. Qala ka ho khetha leqephe leo u batlang ho le notlela, ebe u fihlella Likhetho tsa Tšireletso. Ka mor'a moo, khetha mofuta o khethehileng oa lisele tseo u batlang ho li sireletsa. Sena se ka kenyelletsa lintlha tsa bohlokoa, kholomo e itseng, kapa liphetho tse baliloeng. Hang ha u se u khethile marang-rang, beha tumello bakeng sa lisele tse sirelelitsoeng, tse tla laola hore na ke litho life tsa sehlopha tse lumelloang ho etsa liphetoho. Netefatsa khetho ea hau 'me u sebelise tšireletso ho notlela lisele tse khethiloeng. Ke habohlokoa ho hlokomela hore ts'ebetso ena e ka fapana hanyenyane haeba u sebelisa Google Sheets ka Microsoft Office editing e nolofalitsoe. Ho notlela lisele ho Google Sheet ke mokhoa o molemo ka mabaka a fapaneng, joalo ka ho boloka botšepehi ba data le ho thibela liphetoho tse sa lebelloang.
Mohato oa 2: Fumana Likhetho tsa Tšireletso
Ho fihlella likhetho tsa ts'ireletso ho Google Sheets, latela mehato ena:
- Bula Google Sheet eo u batlang ho e notlela.
- Fumana "sireletsa” tab e kaholimo ho leqephe.
- Ho tswa ho menu e theoha, khetha "Beha Litumello bakeng sa Sebaka se Sirelelitsoeng."
- Ka lebokoseng la puisano le hlahang, khetha mefuta e mengata ea lisele kapa maqephe ao u batlang ho a notlela.
- Hlalosa boemo ba tumello ea ho hlophisa eo u batlang ho e abela litho tsa sehlopha.
- Tlanya "etsahalale” ho netefatsa le ho sebedisa disetting tsa tshireletso.
Ka ho fihlella likhetho tsa ts'ireletso, o ka thibela ba bang ho etsa liphetoho liseleng tsa bohlokoa kapa maqepheng a felletseng. E u lumella ho laola hore na ke litho life tsa sehlopha tse ka hlophisang litekanyetso tsa ho kenya, ho eketsa leqephe kapa marang-rang, ho etsa liphetoho leqepheng lohle, kapa ho tlosa tšireletso. U ka boela ua kenya tlhaloso bakeng sa sebaka se sirelelitsoeng, se ka thusang ho boloka tlaleho ea mesebetsi e fanoeng kapa ho hlakisa sepheo sa lisele tse itseng. Ho fihlella likhetho tsa ts'ireletso ho bohlokoa bakeng sa ho boloka botsitso ba data, ho netefatsa hore ke batho ba lumelletsoeng feela ba ka fetolang lintlha tsa bohlokoa kapa liphetho tse baliloeng. Ke mohato oa bohlokoa, haholo-holo Mohato oa 2: Fihla ho Dikgetho tsa Tshireletso, ha u boloka Google Sheets ka mabaka a fapaneng, joalo ka ho boloka ho nepahala le ho thibela liphetoho tse sa tsitsang kapa tse sa lumelloeng. Ho notlela lisele ho boetse ho fana ka molemo oa lithibelo tsa kamehla tsa phihlello, ho u fa khotso ea kelello mabapi le lekunutu le ts'epahalo ea data ea hau.
Mohato oa 3: Khetha Range ho Lock
Ha u notlela Google Sheet, "Mohato oa 3: Khetha Range ho Lock” ke karolo ea bohlokoa ea tšebetso.
- Bula Google Sheet eo u batlang ho e notlela.
- Fumana likhetho tsa ts'ireletso ka ho tobetsa "Lintlha”tabong bareng ea menyu, ebe o khetha “Sireletsa maqephe le libaka."
- Khetha sebaka se ikhethileng seo u batlang ho se notlela. Ena e ka ba sele e le 'ngoe, letoto la lisele, kapa kholomo kapa mola kaofela.
- Beha litumello bakeng sa sebaka se sirelelitsoeng. U ka khetha ho lumella basebelisi ho hlophisa lintho tse kenang, ho lumella feela litho tse itseng tsa sehlopha ho etsa liphetoho, kapa ho thibela tumello ea ho hlophisa ka botlalo.
- Netefatsa 'me u sebelise tšireletso ka ho tobetsa "Ipehele Litumello"Konopo.
Ka ho latela mehato ena, u ka notlela lisele tsa bohlokoa habonolo, ua thibela ba bang ho etsa liphetoho leqepheng la hau, 'me u laole hore na ke litho life tsa sehlopha tse nang le phihlello ea ho hlophisa litekanyetso tsa ho kenya kapa lintho tse ling tsa bohlokoa. Ho notlela lethathamo ho Google Sheets ke mokhoa o bonolo le o sebetsang oa ho sireletsa data ea hau ea bohlokoa le ho netefatsa hore e lula e bolokehile.
Mohato oa 4: Beha Litumello bakeng sa Range e Sirelelitsoeng
Mohato oa 4: Beha Litumello bakeng sa Range e Sirelelitsoeng
- Khetha leqephe kapa sebaka seo u batlang ho se sireletsa.
- Tobetsa ho "Data" ho menu ea Google Sheets.
- Ho tswa ho menu e theoha, khetha 'Sireletsa maqephe le libaka'.
- Ka lehlakoreng le hlahang ka ho le letona, tobetsa konopo ea 'Set Permissions'.
- Ka har'a lebokose la puisano la 'Beha Litumello', kenya liaterese tsa lengolo-tsoibila tsa litho tsa sehlopha tseo u batlang ho li lumella ho fihlella sebaka se sirelelitsoeng.
- Khetha hore na litho tsa sehlopha li ka fetola boleng ba ho kenya, ho etsa liphetoho leqepheng lohle, kapa ho laola hore na ke litho life tsa sehlopha tse nang le tumello ea ho hlophisa.
- Khetha boemo ba lithibelo tseo u batlang ho li sebelisa, joalo ka 'A ka sheba', 'A ka fana ka maikutlo', kapa 'A ka fetola'.
- Kenya tlhaloso bakeng sa sebaka se sirelelitsoeng haeba u lakatsa.
- Tobetsa konopo ea 'Boloka' ho sebelisa litumello sebakeng se sirelelitsoeng.
Ka ho latela mehato ena e bonolo, o ka beha litumello habonolo bakeng sa sebaka se sirelelitsoeng ho Google Sheet ea hau. Sena se tiisa hore ke litho tsa sehlopha tse lumelletsoeng feela tse ka etsang liphetoho liseleng tsa bohlokoa, ho kenya letsoho ho teng, kapa kholomo ea bohlokoa. E boetse e thusa ho thibela ba bang ho fetola ka phoso kapa ka boomo liphetho tse baloang. Ho beha litumello bakeng sa sebaka se sirelelitsoeng ho u fa taolo e felletseng ea hore na ke mang ea ka fihlellang le ho hlophisa datha ho Google Sheet ea hau, ho eketsa tšireletso bakeng sa tlhahisoleseling ea hau.
Mohato oa 5: Netefatsa le ho Sebelisa Tšireletso
Ho netefatsa ts'ireletso ea Google Sheet ea hau, latela mehato ena:
Mohato oa 1: Bula Google Sheet eo u lakatsang ho e notlela.
Hata 2: Fumana Likhetho tsa Tšireletso ka har'a leqephe.
Hata 3: Khetha Range e khethehileng eo u batlang ho e notlela.
Hata 4: Beha litumello bakeng sa sebaka se sirelelitsoeng ho latela likhetho tsa hau.
Hata 5: Netefatsa le ho sebelisa tšireletso ka ho latela litaelo tse fanoeng.
Ka ho latela mehato ena, u ka khona ho sireletsa lisele tsa bohlokoa le lintho tse kenang, ho thibela batho ba sa lumelloeng ho etsa liphetoho tse sa batleheng. Karolo ena e molemo haholo ha litho tse ngata tsa sehlopha li sebelisana leqepheng le le leng, kaha li u lumella ho laola le ho laola tumello ea ho hlophisa bakeng sa setho ka seng sa sehlopha.
Ho netefatsa le ho sebelisa ts'ireletso ho tiisa hore leqephe lohle kapa mefuta e itseng e notletsoe ka mokhoa o sireletsehileng. Sena se tiisa hore basebelisi ba sa lumelloeng ha ba khone ho fetola litekanyetso kapa ho etsa liphetoho leha e le life. Lera lena le ekelitsoeng la ts'ireletso le netefatsa hore litšiea tsa bohlokoa kapa liphetho tse baliloeng li lula li sa fetohe 'me li thibela liphetoho tse sa lebelloang.
Ha o ntse o netefatsa ts'ireletso, o na le boikhethelo ba ho kenyelletsa tlhaloso bakeng sa ts'ebeliso ea nako e tlang kapa ho fana ka moelelo o eketsehileng. Sena se bonahala se thusa ha ho lateloa liphetoho kapa ho abela litho tsa sehlopha mesebetsi.
Ka Google Sheets, u na le monyetla oa ho notlela lisele kapa ho sireletsa maqephe, e fanang ka melemo e mengata. Melemo ena e kenyelletsa ho boloka bots'epehi ba data ea hau, ho thibela liphetoho tse sa lebelloang, le ho netefatsa hore litokomane tsa hau li lumellana. Ke mohato oa bohlokoa ho sireletsa data ea hau ea bohlokoa, ho sireletsa lekunutu la hau, le ho netefatsa bonnete ba litokomane tsa hau tsa bohlokoa.
Malebela a Tlatsetso a ho Sireletsa Google Sheets
U batla ho eketsa tšireletso ho Google Sheets ea hau? Karolong ena, re tla utulla malebela a mang a tla u thusa ho sireletsa data ea hau ea bohlokoa. Ho tloha ho bopa diphasewete tse matla ho nolofalletsa netefatso ea lintho tse peli, re tla hlahloba mekhoa e fapaneng e ka ntlafatsang tšireletso ea Google Sheets ea hau. Re tla tšohla bohlokoa ba ho ntlafatsa litumello khafetsa le ho hlahloba liabo, hammoho le melemo ea ho boloka bekapo ea Google Sheets. Kahoo, ha re ikakhele ka setotsoana 'me re fumane mehato ena ea bohlokoahali ho netefatsa polokeho ea tlhahisoleseling ea hau.
Sebelisa marang-rang a matla
Ha e fihla ho ho sebelisa li-password tse matla ho sireletsa Google Sheets, latela mehato ena ea bohlokoa ho netefatsa polokeho ea lintlha tsa hau tsa bohlokoa:
- Etsa phasewete e leng e ikhethang ebile e sa nahanele habonolo. Qoba ho sebelisa mantsoe a tloaelehileng kapa litaba tsa hau.
- Etsa bonnete ba hore kenyeletsa motsoako oa litlhaku tse kholo le tse nyenyane, linomoro, le litlhaku tse khethehileng ka password ea hau.
- Ho eketsa matla a eona, etsa phasewete ea hau bonyane Litlhaku tse 8 bolelele.
- Thibela litlolo tse ka bang teng tsa ts'ireletso ka ho qoba ho sebelisa li-password hape bakeng sa li-account tse ling.
- Nchafatsa khafetsa password ea hau ho fokotsa kotsi ea ho fihlella ntle le tumello.
- Nahana ho sebelisa mookameli oa password ho boloka le ho laola li-password tsohle tsa hau ka mokhoa o sireletsehileng.
Ka ho sebelisa li-password tse matla, u ka sireletsa Google Sheets ea hau hore e se ke ea kena-kenana le batho ba sa lumelloeng 'me ua netefatsa tšireletso ea data ea hau ea bohlokoa.
Netefatsa Bopaki ba Bopaki ba Bobeli
E nolofalletsa netefatso ea lintlha tse peli bakeng sa Google Sheets ea hau e fana ka tšireletso e eketsehileng ho sireletsa lintlha tsa hau tsa bohlokoa. Latela mehato ena ho kenya tshebetsong netefatso ya dintho tse pedi:
- Eea ho litlhophiso tsa ak'haonte ea hau ea Google ebe u khetha "Security" tab.
- Lula khetho ea ho nolofalletsa netefatso ea lintlha tse peli ebe o tobetsa ho eona.
- U tla khothalletsoa ho khetha mokhoa oa bobeli oa ho netefatsa, joalo ka ho amohela khoutu ea ts'ireletso fonong ea hau kapa ho sebelisa sesebelisoa sa netefatso.
- Latela litaelo tse fanoeng ho theha mokhoa o khethiloeng oa ho netefatsa.
- Hang ha netefatso ea lintlha tse peli e nolofalitsoe, nako le nako ha u kena akhaonteng ea hau ea Google Sheets, u tla hloka ho fana ka mokhoa o mong oa netefatso ho kenyelletsa phasewete ea hau.
Ho etsa bonnete ba lintlha tse peli ho bohlokoa bakeng sa ho sireletsa lisele tsa hau tsa bohlokoa le lintlha tse teng ho Google Sheets. E eketsa tšireletso e eketsehileng e thibelang phihlello e sa lumelloeng le liphetoho tse sa lumelloeng ho maqephe a hau kaofela. Ka ho fana ka phihlello ho basebelisi ba lumelletsoeng feela, o ka netefatsa ts'ireletseho ea lintho tse kentsoeng tsa bohlokoa le liphetho tse baliloeng.
Ho etsa bonnete ba lintlha tse peli ke e 'ngoe ea mehato e molemohali eo u ka e nkang ho matlafatsa ts'ireletso ea Google Sheets ea hau le ho laola phihlello ho eona ke litho tsa sehlopha. E khothaletsoa haholo ka mabaka a fapaneng, ho kenyelletsa ho fokotsa kotsi ea phihlello e sa lumelloeng le ho fokotsa monyetla oa ho senya data.
Kamehla Nchafatsa Litumello 'me U hlahlobe Liabo
- Mohato oa 1: Kamehla bula Google Sheet eo u batlang ho nchafatsa litumello tsa eona.
- Mohato oa 2: Fumana "
Share
” khetho e hukung e kaholimo ho le letona la skrini khafetsa.
- Mohato oa 3: Ka linako tsohle hlahloba lenane la batho ba khonang ho fumana leqephe le tumello eo ba e abetsoeng.
- Mohato oa 4: Tobetsa khafetsa mosebelisi e mong le e mong kapa setho sa sehlopha ho bona boemo ba bona ba phihlello le ho etsa liphetoho tse hlokahalang.
- Mohato oa 5: Kamehla tlosa phihlello bakeng sa batho kapa lihlopha tse seng li sa e hloke, joalo ka basebetsi ba pele kapa basebetsi-'moho.
- Mohato oa 6: Kamehla fana ka tumello e nepahetseng ho litho tse ncha tsa sehlopha kapa basebetsi-'moho ba hlokang ho fumana leqephe.
- Mohato oa 7: Kamehla hlahloba litumello tse arolelanoang ho netefatsa hore ke batho ba nang le tumello feela ba nang le monyetla oa ho sebelisa leqephe lena.
- Mohato oa 8: Nahana ka ho kenya ts'ebetsong mehato e meng ea ts'ireletso joalo ka ho nolofalletsa netefatso ea lintlha tse peli bakeng sa ts'ireletso e ekelitsoeng khafetsa.
- Mohato oa 9: Kamehla boloka bekapo ea Lishiti tsa hau tsa Google haeba ho ka hlakoloa ka phoso kapa ho lahleheloa ke data.
- Mohato oa 10: Nchafatsa litumello khafetsa 'me u hlahlobe likarolo nako le nako, haholo ha ho na le liphetoho ka har'a sehlopha kapa mokhatlo.
- Mohato oa 11: Ka ho lula u nchafatsa litumello le ho hlahloba likarolo, u ka thibela phihlello e sa lumelloeng ea lintlha tsa bohlokoa, likholomo kapa liphetho tse baloang leqepheng.
- Mohato oa 12: Ho boloka taolo ea hore na ke mang ea ka fetolang leqephe ho thusa ho netefatsa bonnete ba data le ho thibela ba bang ho hlophisa lisele tsa bohlokoa ka phoso kapa ka boomo.
- Mohato oa 13: Ho hlahloba khafetsa le ho ntlafatsa litumello ho boetse ho u lumella ho laola boemo ba phihlello bakeng sa litho tse fapaneng tsa sehlopha, ho u nolofalletsa ho hlophisa lithibelo tsa phihlello ho latela mesebetsi kapa karolo eo ba e abetsoeng.
- Mohato oa 14: Lintlafatso tsa khafetsa mabapi le litumello le likabelo li bohlokoa bakeng sa ho boloka ts'ireletso ea data le ho sireletsa lekunutu la Google Sheets.
Boloka Backup ea Google Sheets ea Hao
Boloka Backup ea Google Sheets ea Hao ho bohlokoa ho etsa bonnete ba hore ha o lahleheloe ke data leha e le efe ea bohlokoa. Ho etsa sena, latela mehato ena:
- Ntlha ea pele, khetha leqephe leo u lakatsang ho le boloka. U ka etsa sena ka ho tobetsa tab ea lakane e ka tlase ho fensetere ea Google Sheets.
- E 'ngoe, tobetsa "File" e kaholimo ho le letšehali la fensetere.
- Ho menu e theoha, khetha "Etsa kopo".
- Ho tla hlaha fensetere e ncha, moo o lokelang ho fana ka lebitso le ikhethileng leqepheng la hau la bekapo ho le khetholla ho la mantlha.
- Khetha sebaka se lakatsehang ho boloka bekapo. U na le khetho ea ho e boloka ho Google Drive kapa ho e jarolla khomphuteng ea hau.
- Ho theha bekapo, tobetsa feela "Ho lokile".
Ka ho latela mehato ena, u ka khona boloka bekapo ea Google Sheets ea hau 'me u be le kopi ea data ea hau ea bohlokoa haeba ho ka etsahala letho ho ea pele. Ho khothalletsoa ho etsa li-backups khafetsa, haholo kamora ho etsa liphetoho tse kholo ho maqephe a hau. Ka tsela ena, o ka thibela tahlehelo ea tlhahisoleseling ea bohlokoa mme o na le khotso ea kelello, o tseba hore data ea hau e bolokehile ebile e bolokehile.
Lipotso Asked hangata
Nka thibela joang hore na ke mang ea ka fetolang mefuta e mengata ho Google Sheets?
Ho beha meeli ea hore na ke mang ea ka fetolang mefuta ho Google Sheets, latela mehato ena:
- Tobetsa ka ho le letona seleng eo u batlang ho e notlela.
- Tsamaea holim'a "Sheba liketso tse ling tsa lisele" ebe u khetha "Sireletsa sebaka."
- Ka lehlakoreng le ka lehlakoreng, tobetsa "Eketsa lakane kapa sebaka."
- Khetha lisele tseo u batlang ho li notlela ka ho tobetsa ho tsona kapa ho kenya lethathamo.
- Khetha "Seta tumello" ho khetha hore na ke mang ea ka fetolang lisele tse khethiloeng.
- Tobetsa "Ho lokile" ho boloka likhetho tsa hau.
A na nka fetola litumello tsa ho hlophisa mefuta e meng ho Google Sheets?
Ee, o ka fetola litumello tsa ho hlophisa mefuta ho Google Sheets ka ho latela mehato ena:
- Tobetsa ka ho le letona seleng eo u batlang ho e notlela.
- Tsamaea holim'a "Sheba liketso tse ling tsa lisele" ebe u khetha "Sireletsa sebaka."
- Ka lehlakoreng le ka lehlakoreng, tobetsa "Eketsa lakane kapa sebaka."
- Khetha lisele tseo u batlang ho li notlela ka ho tobetsa ho tsona kapa ho kenya lethathamo.
- Khetha "Seta tumello" ho khetha hore na ke mang ea ka fetolang lisele tse khethiloeng.
- Tobetsa "Ho lokile" ho boloka likhetho tsa hau.
Nka fokotsa ho hlophisa joang ho Google Sheets?
Ho fokotsa ho hlophisa ho Google Sheets, o ka latela mehato ena:
- Tobetsa ho "Lisebelisoa" karolong e ka holimo ea Google Sheets.
- Khetha "Sireletsa lakane."
- Khetha lakane eo u batlang ho e sireletsa.
- Tobetsa ho "Set permits" 'me u tšoaee lebokose le reng "Thibela hore na ke mang ea ka fetolang mofuta ona."
- Ho li-dropdown, khetha "Uena feela" ho fokotsa ho itlhophisa.
- Tobetsa "Ho lokile" ho sebelisa liphetoho.
Nka amoha litumello tsa ho hlophisa mefuta e fapaneng joang ho Google Sheets?
Ho tlosa litumello tsa ho hlophisa mefuta e itseng ho Google Sheets, latela mehato ena:
- Tobetsa ho "Lisebelisoa" karolong e ka holimo ea Google Sheets.
- Khetha "Sireletsa lakane."
- Khetha lakane eo u batlang ho e sireletsa.
- Tobetsa ho "Set permits" 'me u khethe "Thibela hore na ke mang ea ka fetolang mofuta ona."
- Khetha "Custom" ho tsoa ho menu e hlahang.
- Khetha liaterese tsa imeile tseo u batlang ho tlosa tumello ea ho ngola ho tsona.
- Tobetsa "Etsa" ho boloka liphetoho.
Melemo ea ho notlela lisele ho Google Sheets ke efe?
Ho notlela lisele ho Google Sheets ho fana ka melemo e mengata, ho kenyelletsa:
- Ho sireletsa lintlha tsa bohlokoa le lipalo
- Ho laola hore na ke litho life tsa sehlopha tse ka hlophisang tokomane
- Ho netefatsa bonnete le botshepehi ba data
- Ho lumella litho tse ngata tsa sehlopha ho sebetsa leqepheng le le leng ntle le ho kena-kenana le mesebetsi ea e mong
Nka notlela le ho notlolla lisele joang ho Google Sheets?
Ho notlela le ho notlolla lisele ho Google Sheets, o ka latela mehato ena:
- Tobetsa ka ho le letona seleng eo u batlang ho e notlela kapa ho e notlolla.
- Tsamaea holim'a "Sheba liketso tse ling tsa lisele" ebe u khetha "Sireletsa sebaka."
- Ka lehlakoreng le ka lehlakoreng, tobetsa "Eketsa lakane kapa sebaka."
- Khetha lisele tseo u batlang ho li notlela kapa ho li notlolla ka ho tobetsa ho tsona kapa ho kenya sebaka.
- Khetha "Seta tumello" ho khetha hore na ke mang ea ka fetolang lisele tse khethiloeng.
- Tobetsa "Ho lokile" ho boloka likhetho tsa hau.
