I-Virtual office suite evela ku-Google, ehlangene nesitoreji sabo samafu, iyathandwa kakhulu phakathi kwabasebenzisi ngenxa yokusetshenziswa kwayo mahhala futhi kulula. Ihlanganisa izinhlelo ezinjalo zewebhu njengoNethulo, Amafomu, Amadokhumenti, Amathebula. Umsebenzi kanye nalokhu okulandelayo, kokubili kusiphequluli ku-PC nakumadivayisi eselula, kuzoxoxwa kulokhu kulesi sihloko.
Faka imigqa etafuleni le-google
Amathebula we-Google asezindlela eziningi ezingaphansi kwesisombululo esifanayo esivela ku-Microsoft - iprosesa ye-Excel yespredishithi. Ngakho-ke, ukuze ulungise imigqa emkhiqizo we-giant search, okungase kudingeke ukuba udale ikhanda letafula noma ikhanda, indlela eyodwa kuphela iyatholakala. Kulesi simo, kunezinketho ezimbili zokuqaliswa kwayo.
Inguqulo yeWebhu
Indlela elula kunazo zonke ukusebenzisa i-Google Spreadsheets kusiphequluli, ikakhulu uma usebenza nge-web service ngomkhiqizo wokuthengisa wenkampani, i-Google Chrome, etholakala kuma-computer, i-MacOS ne-Linux.
Okukhethwa kukho 1: Ukulungisa Ulayini Olunye
Abathuthukisi be-Google babeke umsebenzi esiwudinga cishe endaweni engabonakali, yingakho abasebenzisi abaningi babhekana nobunzima. Noma kunjalo, ukulungisa umugqa etafuleni, konke okudingekayo kungokuchofoza okumbalwa nje.
- Ukusebenzisa igundane, khetha umugqa etafuleni ofuna ukulungisa. Esikhundleni sokhetho lomuntu siqu, ungamane uchofoze inombolo yayo e-ordinal ku-panel yokuxhumanisa.
- Ngaphezulu kwebha yokuzula phezulu, thola ithebhu "Buka". Ukuchofoza kuyo kwimenyu yokudonsa, khetha "Ukuphepha".
- Ku-imenyu emenyu ebonakalayo, khetha "Umugqa ongu-1".
Umzila okhethiwe uzobe unqunyelwe - uma upheqa itafula, uzohlale uhlala endaweni yawo.
Qaphela: Muva nje, ithebhu ethi "Buka" ibizwa ngokuthi "Buka", ngakho-ke udinga ukuyivula ukuze ufinyelele kwimenyu yesithakazelo.
Njengoba ubona, akukho lutho olulukhuni ekulungiseni umugqa owodwa. Uma udinga ukwenza lokhu ngemigqa eminingana enezingqimba ngesikhathi esisodwa, funda.
Okukhethwa kukho 2: Ukuphina ibanga
Ngeke njalo ikhanda lesipredishithi lihlanganisa umugqa owodwa kuphela, kungenzeka kube khona ezimbili, ezintathu noma ngaphezulu. Ukusebenzisa uhlelo lwewebhu kusuka ku-Google, ungalungisa inombolo engenamkhawulo wemigqa equkethe noma iyiphi idatha.
- Esikhathini sephaneli yokudidiyela yedijithali, sebenzisa igundane ukuze ukhethe ibanga elidingekayo lemigqa ohlela ukuyiguqula ibe yinqinjana etafuleni elihleliwe.
- Phinda izinyathelo ezichazwe kunguqulo yangaphambilini: chofoza kuthebhu "Buka" - "Ukuphepha".
- Khetha into "Amakhodi amaningi (N)"lapho kunalokho "N" inani lemigqa ekhethwe nguwe lizoboniswa kubakaki.
- Ibanga lethebula elinqunyiwe olikhethile lizokhishwa.
Ithiphu: Esikhundleni sokukhetha ngegundane, ungakwazi nje uchofoze kwinamba yombhalo wokuqala ebangeni, bese ubamba "QHUBA" kwikhibhodi, chofoza inombolo yokugcina. Ububanzi obudinga buzobanjwa.
Naka ingqamuzana "Kulayini wamanje (N)" - ikuvumela ukuba ulungise yonke imigqa yetafula, equkethe idatha, kuze kube yilapho kulayini olungenalutho olungenalutho (hhayi okubandakanya).
Ngakho nje ungalungisa imigqa embalwa noma uhla oluphelele oluphelele kumathebula we-Google.
Hlehlisa imigqa etafuleni
Uma isidingo sokulungisa imigqa sinyamalalala, chofoza nje kuthebhu. "Buka"khetha into "Ukuphepha"bese ukhetha uhlu lokuqala - "Ungalungisi umugqa". Ukulungisa ibanga elikhethiwe ngaphambilini kuzokhanselwa.
Bheka futhi:
Indlela yokulungisa i-cap kuthebula le-Excel
Indlela yokulungisa isihloko ku-Excel
Uhlelo lokusebenza lweselula
I-Google Spreadsheets ayitholakali kuphela kuwebhu, kodwa futhi kumadivayisi eselula asebenzisa i-Android ne-iOS. Isicelo silula futhi kulula ukuyisebenzisa, futhi-ke, sinikwe umsebenzi wokuvumelanisa kwefu, okujwayelekile kuwo wonke amasevisi we-Google. Cabanga indlela yokulungisa imigqa kumatafula weselula.
Inketho 1: Umugqa owodwa
I-Google Spreadsheet yama-Smartphones namaphilisi, ngokusebenza kwawo, afana ncamashi ne-web version. Noma kunjalo ukukwenziwa kwezenzo ezithile, indawo yamathuluzi athile kanye nokulawulwa kwesicelo kusetshenziswe ngendlela ehlukile. Ngakho-ke, sinesithakazelo ukuthi kungenzeka ukulungisa imigqa ukudala isihloko setafula kufihlwe lapho kungabikho wonke umuntu ocabanga ukuthi uyayifuna.
- Njengoba usuqalisile uhlelo lokusebenza, vula idokhumenti edingekayo noma udale entsha (kusukela ekuqaleni noma kuthempelthi).
- Thepha kunombolo yokulandelana komugqa ofuna ukubopha. Lokhu kuyoba yinye, ngoba kuphela imigqa yokuqala (engenhla) ingagcinwa ngamunye ngamunye.
- Bamba umunwe wakho kwinamba yomugqa kuze kuvele imenyu ephumayo. Ungadideki iqiniso lokuthi liqukethe imiyalo yokusebenza nedatha, chofoza nje ku-ellipsis bese ukhetha kusukela kwento yemenyu ehlayo "Ukuphepha".
- Umzila okhethiwe uzobe uhleliwe, ungakhohlwa ukuchofoza uphawu lokuhlola elisekhoneni eliphezulu elingakwesokunxele ukuqinisekisa isenzo. Ukuqinisekisa ukudala okuphumelelayo kwekhanda, weqa itafula kusuka phezulu kuya phansi futhi emuva.
Option 2: Row Range
Ukulungiswa kwemigqa emibili noma ngaphezulu kumathebula we-Google kwenziwa ngokusebenzisa i-algorithm efanayo njengokwodwa kuphela. Kodwa, futhi, lapha futhi, akekho nhlobo intuitive intuitive, futhi inenkinga yokukhomba imigqa emibili kanye / noma ukukhombisa ibanga - akucaci ukuthi lokhu kwenziwa kanjani.
- Uma umugqa owodwa usuvele unamathele kuwe, chofoza inombolo yayo ye-ordinal. Empeleni, udinga ukuchofoza futhi uma kungekho header etafuleni.
- Ngokushesha lapho indawo yokukhethwa iba isebenzayo, okungukuthi, uhlaka oluhlaza okwesibhakabhaka ngamachashazi luvela, lihudule phansi emgqeni wokugcina, oluzofakwa ohlwini oluhleliwe (kusibonelo sethu kungesibili).
Qaphela: Ukudonsa kudingekile iphuzu elihlaza okwesibhakabhaka elisezindaweni zamaseli, hhayi ngombuthano ngezibonisi eduze nenombolo yomugqa).
- Bamba umunwe endaweni ekhethiwe, futhi ngemuva kwemenyu nemilayezo ivela, thinta ku-one-dotted one.
- Khetha okukhethwa kukho "Ukuphepha" kusuka ohlwini lwezinketho ezitholakalayo, futhi uqinisekise izenzo zakho ngokuchofoza uphawu lokuhlola. Pheqa ngetafula bese uqinisekisa ukuthi izintambo zihlanganisiwe ngempumelelo, okusho ukuthi ikhanda lidalwa.
- Le ndlela inhle uma udinga ukulungisa imigqa embalwa eseduzane. Kodwa kuthiwani uma ububanzi bubanzi kakhulu? Ungadonseli umunwe ofanayo ngaphesheya kwetafula, uzama ukufika emgqeni oyifunayo. Eqinisweni, konke kulula kakhulu.
- Akunandaba ukuthi imigqa ishintshiwe noma cha, ukhethe lowo oyoba ngowokugcina wefakiwe ebangeni elihleliwe.
- Bamba umunwe endaweni yokukhetha, futhi ngemuva kokuvela imenyu encane, cindezela amaphuzu amathathu aqondile. Kusuka ohlwini lokudonsa, khetha "Ukuphepha".
- Emva kokuqinisekisa ukusebenza ngokuchofoza uphawu lokuhlola, imigqa kusukela kokuqala kuya kokugcina emakwe nguwe izoboshwa ekhoneni letafula, elingabonakala ngokupheqa kusuka phezulu kuya phansi bese ubuyela emuva.
Qaphela: Uma ububanzi bomugqa ohleliwe bubanzi kakhulu, buzobonakala kancane esikrinini. Lokhu kuyadingeka ukuze kube lula ukuhamba futhi usebenze nayo yonke ithebula. Kulesi simo, i-cap ngokwayo ingabhalwa kunoma isiphi isiqondiso esikahle.
Manje uyazi ukuthi ungakha kanjani ikhanda kuma-Google Spreadsheets, uvikele umzila owodwa noma amaningana ngisho nobubanzi bawo obubanzi. Kwanele ukwenza lokhu kuphela izikhathi ezimbalwa ukuze ungakhumbuli ngokuqinisekile ukulungiswa okucacile nokuzwakalayo kwezinto ezidingekayo zemenyu.
Ukulungisa imigqa
Ungakwazi ukuguqula imigqa ku-Google Ithebula yeselula ngendlela efanayo njengoba siyiqondisile.
- Khetha umugqa wokuqala wetafula (ngisho noma ububanzi bubekiwe) ngokushaya inombolo yayo.
- Bamba umunwe wakho endaweni eveziwe kuze kuvele imenyu e-pop-up. Chofoza kuwo ngamaphuzu amathathu aqondile.
- Kuhlu lwezenzo ezizovuleka, khetha "Susa ukuphina"ngemuva kwalokho ukubopha imigqa (kanye) etafuleni kuzokhanselwa.
Isiphetho
Kusuka kulesi sihloko esincane osifunde ngokuxazulula umsebenzi onjalo olula njengokudala ikhanda ngokuhlanganisa imigqa kumaSpredishithi e-Google. Naphezu kokuthi i-algorithm yokwenza le nqubo kuwebhu kanye nesicelo seselula ihluke kakhulu, awukwazi ukuyibiza ngokuthi iyinkimbinkimbi. Into esemqoka ukukhumbula indawo yezinketho ezidingekayo nemenyu yemenyu. Ngendlela, ngendlela efanayo ungalungisa amakholomu - khetha nje into ehambelanayo kwimenyu yamathebhu "Buka" (ngaphambilini - "Buka") kwideskithophu noma uvule imenyu yemiyalo kwi-smartphone noma ithebhulethi.
