UGoogle kunye neemveliso zakhe zilawula ishishini lesoftware kwihlabathi liphela, kunye nezigidi zabasebenzisi abavela kumazwe ahlukeneyo nakumazwekazi. Enye yee-apps ezidume kakubi ezisetyenziswa zizigidi ngaMashidi kaGoogle. I-Google Sheets lusetyenziso olunceda ngokufanelekileyo ukulungelelanisa idatha ngohlobo lweetafile kwaye ikuvumela ukuba wenze imisebenzi eyahlukeneyo kwidatha. Phantse onke amashishini asebenzisa uLawulo lwedathabheyisi kunye neenkqubo zespredishithi kwihlabathi. Nkqu nezikolo namaziko emfundo asebenzisa i-spreadsheets ukugcina iirekhodi zabo zedatha. Xa kuziwa kwi-spreadsheets, iMicrosoft Excel kunye neGoogle Sheets zikhokela ishishini. Abantu abaninzi bathanda ukusebenzisa njengoko kusimahla ukuyisebenzisa, kwaye inokugcina i-spreadsheets zakho kwi-intanethi kwi-Google Drive yakho. Oku kuyenza ifikeleleke kuyo nayiphi na ikhompyuter okanye ilaptop eqhagamshelwe kwiWebhu eBanzi yeHlabathi nge. I-intanethi. Enye into entle malunga namaPhepha kaGoogle kukuba ungayisebenzisa kwifestile yebrawuza yakho kwiKhompyutha yakho okanye iLaptop.
Xa ucwangcisa idatha yakho ngendlela yeetafile, unokuhlangabezana neengxaki ezimbalwa. Omnye umba onjalo oqhelekileyo kukuba iseli incinci kakhulu kwidatha, okanye idatha ayinakungena ngokugqibeleleyo kwiseli, kwaye ihamba ngokuthe tye njengoko uchwetheza. Nokuba ifikelela kumda wobungakanani beseli, iya kuqhubeka, igqume iiseli ezikufutshane. Yiyo i, okubhaliweyo kwakho kuzakuqala kwicala lasekhohlo leseli yakho kwaye kuyakuphuphumala ukuya kwiiseli ezingenanto ezikufutshane . Ungayiqikelela loo nto kwi-snip engezantsi.
Abantu abasebenzisa i-Google Sheets ukunika inkcazo eneenkcukacha ngohlobo lokubhaliweyo ngenene badibene nalo mba. Ukuba ungomnye wabo, ndingatsho ukuba ufikile kwindawo efanelekileyo. Makhe ndikukhokele ngezinye iindlela zokunqanda oku.
Imixholo[ fihla ]
- Ungakunqanda njani ukuphuphuma kweteksti kumashidi kaGoogle?
- Ungasonga njani isicatshulwa kuGoogle waMashithi?
- Ukusonga okubhaliweyo kwiSixhobo seSixhobo sikaGoogle saMashithi
- Ukusonga iSibhalo ngeManu kuMashidi kaGoogle
- Gquba iSibhalo kwi-App ye-Google Sheets
Ukuphepha njani ukuphuphuma kweteksti kumashidi kaGoogle?
Ukunqanda lo mba, umxholo wakho kufuneka ungene kububanzi beseli ngokugqibeleleyo. Ukuba idlula ububanzi, kufuneka iqalise ngokuzenzekelayo ukuchwetheza ukusuka kumgca olandelayo, ngokungathi ucinezele iqhosha elithi Faka. Kodwa njani ukuphumeza oku? Ngaba ikho indlela? Ewe ilapho. Ungasonga isicatshulwa sakho ukunqanda imiba enjalo. Ngaba unayo nayiphi na ingcamango malunga nendlela yokusonga isicatshulwa kwi-Google Sheets? Yiyo kanye kanye le nto silapha. Yiza, makhe sijonge nzulu kwiindlela onokuthi usonge ngazo isicatshulwa sakho kuMashidi kaGoogle.
Ungasonga njani isicatshulwa kuGoogle waMashithi?
1. Unokuvula isikhangeli osithandayo kwaye uye kuMashidi kaGoogle ukusuka kwiPC yakho okanye kwilaptop. Kwakhona, ungakwenza oko ngokuchwetheza docs.google.com/spreadsheets .
2. Emva koko unokuvula i Ispreadsheet Esitsha kwaye uqale ukufaka umxholo wakho.
3. Emva kokuchwetheza eyakho okubhaliweyo kwiseli , khetha iseli ochwetheze kuyo.
4. Emva kokukhetha iseli, cofa kwi Ubume imenyu esuka kwindawo yolawulo phezulu kwifestile ye-Google Sheets yakho (ngezantsi kwegama le-spreadsheet sakho).
5. Beka isalathisi semouse yakho phezu kokhetho olunesihloko Ukusongwa kombhalo . Ungaqikelela ukuba Ukuphuphuma ukhetho lukhethwa ngokungagqibekanga. Cofa kwi Ukusonga ukhetho lokusonga umbhalo wakho kuMashidi kaGoogle.
6. Ngokukhawuleza nje ukuba ukhethe i Ukusonga ukhetho, uya kubona imveliso enje kumfanekiso wekhusi ongezantsi:
Ukusonga Isiqendu kwi I-Google Sheets Ibar yesixhobo
Unokufumana kwakhona indlela emfutshane yokusonga isicatshulwa sakho esidweliswe kwibar yesixhobo sefestile kaGoogle. Unganqakraza kwi Ukusonga umbhalo icon kwi menu kwaye nqakraza kwi Ukusonga iqhosha kwiinketho.
Ukusonga iSibhalo ngeManu kuMashidi kaGoogle
1. Ungaphinda ufake ikhefu lomgca ngaphakathi kweeseli ukusonga iiseli zakho ngesandla ngokweemfuno zakho. Ukwenza oko,
Mbini. Khetha iseli equlathe okubhaliweyo okuzakufomathwa (isongelwe) . Yenza ukucofa kabini kuloo seli okanye ucinezele i F2. Oku kuyakusa kwindlela yokuhlela, apho unokuhlela imixholo yeseli. Beka ikhesa yakho apho ufuna ukwaphula umgca. Cofa i Ngena isitshixo ngelixa ubambe i YONKE INTO isitshixo (oko kukuthi, Cinezela ikhombo yesitshixo - ALT + Ngena).
3. Ngale nto, unokongeza ikhefu naphi na apho ufuna khona. Oku kwenza ukuba usonge isicatshulwa sakho ngayo nayiphi na ifomathi oyifunayo.
Kwakhona Funda: UJikelezisa njani uMfanekiso okanye uMfanekiso kwiLizwi
Gquba iSibhalo kwi-App ye-Google Sheets
Ukuba usebenzisa usetyenziso lweeShedi zikaGoogle kwi-smartphone yakho ye-Android okanye ye-iOS, unokubhidaniswa nojongano, kwaye usenokungazi ukuba ungalufumana phi ukhetho lokusonga isicatshulwa. Sukuba nexhala, landela la manyathelo angezantsi ukusonga isicatshulwa kuGoogle Sheets kwifowuni yakho:
1. Vula i I-Google Sheets isicelo kwisixhobo sakho se-smartphone se-Android okanye i-iOS.
2. Vula i-spreadsheet esitsha okanye esele ikhona ofuna ukusonga ngayo okubhaliweyo.
3. Yenza impompo ethambileyo kwi iseli okubhaliweyo kwayo unqwenela ukusonga. Oku kuyakukhetha laa seli ithile.
4. Ngoku cofa kwi Ubume ukhetho kwiscreen sesicelo (esiboniswe kumfanekiso wekhusi).
5. Uya kufumana iindlela zokufomatha ezidweliswe phantsi kwamacandelo amabini - Isicatshulwa kwaye Iseli . Yiya kwi Iseli
6. Kuya kufuneka uskrole ezantsi kancinci ukuze ufumane indawo Ukusonga Guqula. Qiniseka ukuba uyayenza, kwaye wena okubhaliweyo kungasongelwa kwisicelo saMashithi kaGoogle.
PHAWULA: Ukuba ufuna ukusonga umxholo wonke we-spreadsheet sakho, oko kukuthi, zonke iiseli kwi-spreadsheet, ungasebenzisa Khetha Zonke uphawu. Ukwenza oku, cofa kwibhokisi engenanto phakathi kwezihloko A kwaye Nye (iphawulwe kumfanekiso wekhusi ongezantsi). Ukwenza unqakrazo kule bhokisi kuya kukhetha i-spreadsheet siphela. Okanye, ungasebenzisa isitshixo se-combo Ctrl + A. Emva koko landela la manyathelo angasentla, kwaye ibiya kujika wonke umbhalo kwi-spreadsheet sakho.
Yazi ngakumbi malunga nokhetho lokusonga umbhalo wakho kuMashidi kaGoogle
Ukuphuphuma: Umbhalo wakho uya kuphuphuma ukuya kwiseli elandelayo engenanto ukuba ingaphezulu kobubanzi beseli yakho yangoku.
Ukusonga: Okubhaliweyo kwakho kungasongelwa kwimigca eyongezelelweyo xa ingaphezulu kobubanzi beseli. Oku kuyakuguqula ngokuzenzekelayo ubude bomqolo ngokumalunga nesithuba esifunekayo kumbhalo.
Ikliphu: Kuphela okubhaliweyo ngaphakathi kweseli ubude kunye nemida yobubanzi eboniswayo. Okubhaliweyo kwakho kuseza kuqulathwa kwiseli, kodwa yinxalenye yayo kuphela ewela phantsi kwemida yeseli iyaboniswa.
eCetyisiweyo:
- Ulongeza njani iKhadi lakho laBantu kuPhendlo lukaGoogle
- Thumela uMfanekiso nge-imeyile okanye umyalezo obhaliweyo kwi-Android
Ndiyathemba ukuba unako ngoku khawuleza usonge isicatshulwa sakho kwi-Google Sheets. Ukuba unayo nayiphi na imibuzo, sebenzisa icandelo lamagqabaza. Ndingathanda ukufunda iingcebiso zakho. Ngoko ke zibeke kwizimvo zakho.
Elon DeckerU-Elon ungumbhali wezobugcisa kwi-Cyber S. Ubhale indlela-izikhokelo malunga neminyaka eyi-6 ngoku kwaye uye wagubungela izihloko ezininzi. Uyakuthanda ukugubungela izihloko ezinxulumene neWindows, Android, kunye namaqhinga amva nje kunye neengcebiso.