Molo Tecnobits!Unjani? Ndiyathemba ukuba ukrelekrele njengeekholamu ezikhonkxiweyo kuMashidi kaGoogle. Ukuba ufuna ukwazi ukuseta iikholamu kwiiSpredishithi zikaGoogle, ndiza kuyichaza ngokungqindilili: khetha ngokulula ikholamu ofuna ukuseta kwaye ucofe u-"Jonga" kwaye emva koko "Seta umqolo / ikholamu." Ilula ngolo hlobo!
1. Ndingazicwangcisa njani iikholamu kuMashidi kaGoogle?
- Into yokuqala omawuyenze kukuvula i-spreadsheet sakho kwi-Google Sheets kwaye ukhethe ikholamu ofuna ukuseta.
- Nje ukuba ikholamu ikhethiwe, cofa kwimenyu ethi “Jonga” phezulu kwesikrini.
- Ngaphakathi kwemenyu ethi "Jonga", khetha "Iphini" kwaye emva koko "Phina ikholamu ekhohlo" okanye "Phina ikholamu ekunene", ngokuxhomekeke kukhetho lwakho.
- Ulungile! Ikholamu ekhethiweyo ngoku iza kuqhotyoshelwa kwi-spreadsheet sakho, ikuvumela ukuba uskrole kuyo yonke imihlathi kwaye usayibona le uyifakileyo.
2. Ndingaseta ngaphezulu kwekholamu enye kuMashidi kaGoogle?
- Ewe, kwi-Google Sheets kunokwenzeka ukuseta ngaphezulu kwekholamu enye ngexesha. Ukwenza oku, khetha ngokulula iikholamu ofuna ukuzifaka ngokucinezela iqhosha elithi “Ctrl” kwikhibhodi yakho.
- Emva koko, landela la manyathelo afanayo nokuqhobosha ikholamu enye: cofa imenyu ethi “Jonga”, khetha u-“Pin” ukhetho, emva koko ukhethe ukuba uyafuna na ukuqhobosha iikholamu ekhohlo okanye ekunene.
- Ngale ndlela, unokuba neekholamu ezininzi ezilungisiweyo kwi-spreadsheet yakho, eya kwenza kube lula ukusebenza ngedatha ebanzi.
3. Ngaba kunokwenzeka ukuseta imiqolo kwi-Google Sheets ngendlela efanayo neekholamu?
- Ewe, inkqubo yokuqhola imiqolo kwi-Google Sheets iyafana nekholamu yokuqhobosha.
- Okokuqala, vula i-spreadsheet sakho kwaye ukhethe umqolo ofuna ukuwuphinifa.
- Emva koko, yiya kwimenyu ethi "Jonga", khetha u-"Pin" kwaye ukhethe u-"Pin Row Up" okanye "Pin Row Down" ngokweemfuno zakho.
- Ngoku umqolo okhethiweyo uya kuqhotyoshelwa kwi-spreadsheet sakho, okukuvumela ukuba uskrole kuyo yonke eminye imiqolo ngelixa ugcina le oyiphiniweyo ibonakala!
4. Ngaba kukho indlela yokuseta yomibini imiqolo kunye neekholamu kwi-Google Sheets?
- Ewe, kuMashidi kaGoogle unenketho yokuseta yomibini imiqolo kunye neekholamu ukuze ube nokubonwa okungcono kwedatha yakho.
- Ukwenza oku, khetha iseli ekwikona ephezulu ngasekhohlo yecandelo ofuna ukuliqhobosha.
- Emva koko, yiya kwimenyu ethi "Jonga", khetha u-"Pin" kwaye ukhethe u-"Pin Row kunye neKholamu."
- Ngale ndlela, yomibini imiqolo ekhethiweyo kunye neekholamu ziya kulungiswa kwi-spreadsheet sakho, ikwenza kube lula kuwe ukujonga idatha yakho.
5. Ndingaluvala njani ukhetho lokuqhobosha imiqolo okanye iikholamu kuMashidi kaGoogle?
- Ukuba nangaliphi na ixesha ufuna ukukhubaza ukhetho lokuqhobosha kwimiqolo okanye iikholamu kuMashidi kaGoogle, inkqubo ilula kakhulu.
- Yiya nje kwimenyu ethi "Jonga" kwaye ujonge inketho ethi "Pin". Apho, khetha ukhetho "olungaphiniweyo" ukukhubaza umqolo kunye nokupinwa kwekholamu.
- Nje ukuba kwenziwe oku, imiqolo kunye neekholamu azisayi kulungiswa kwaye unokuskrola kwi-spreadsheet njengesiqhelo.
6. Ziziphi iingenelo zokuseta iikholamu kuMashidi kaGoogle?
- Inzuzo ephambili yeekholamu zokukhonkotha kwi-Google Sheets kukuba ikuvumela ukuba ugcine iikholamu ezithile zibonakala ngelixa uskrola kuyo yonke idatha yakho kwi-spreadsheet.
- Oku kuluncedo ngakumbi xa usebenza ngeeseti ezinkulu zedatha kwaye kufuneka uhlale unolwazi oluthile oluphambili kwimboniselo.
- Ukongeza, ukuphina iikholamu kwenza kube lula ukuthelekisa idatha kunye nokulandelela iipateni kuyo yonke idatha yakho, okunokubaluleka kuhlalutyo kunye nokwenza izigqibo.
7. Loluphi uhlobo lwemisebenzi endinokuthi isebenzise ikholamu yokukhonkotha kuMashidi kaGoogle?
- Iikholamu zokukhonkotha kwiiShedi zeGoogle ziluncedo kuluhlu olubanzi lwemisebenzi, ngakumbi leyo ibandakanya ukuphatha amanani amakhulu edatha.
- Inokuba luncedo olukhulu ekudaleni iingxelo zemali, ukuhlalutya idatha yokuthengisa, ukulandelela uluhlu, kunye nawuphi na omnye umsebenzi ofuna ukusebenza kunye neetafile zolwazi olubanzi.
- Ngamafutshane, ukukhonkxwa kwekholamu kwiiSpredishithi zikaGoogle sisixhobo esiguquguqukayo esinokwenza ukusebenza ngedatha yazo zonke iintlobo kube lula.
8. Ngaba i-pinning columns kwi-Google Sheets ixhasa ukujonga kwizixhobo eziphathwayo?
- Ewe, ikholamu yokukhonkotha kuMashidi kaGoogle ixhasa ukujonga ngeselfowuni, ikuvumela ukuba ube namava angaguqukiyo kuzo zonke izixhobo ezahlukeneyo.
- Xa uvula ispredishithi sakho kwisixhobo esiphathwayo, iikholamu ezimiselweyo ziya kuhlala zibonakala kwisikrini, nto leyo eyenza kube lula ukuzulazula nokujonga idatha yakho.
- Oku kuluncedo ngakumbi kubasebenzisi abafuna ukufikelela kwi-spreadsheets zabo kwizixhobo zabo eziphathwayo ngelixa besendleleni.
9. Ndingakwazi ukuseta iikholamu kuMashidi kaGoogle ngokuzenzekelayo xa ndiskrola kwi-spreadsheet?
- KuMashidi kaGoogle, ukuqhotyoshwa kwekholamu kuhlala kungaguquguquki njengoko udlula kwi-spreadsheet, kukuvumela ukuba usoloko ugcina iikholamu eziphiniweyo kwimboniselo.
- Oku kuthetha ukuba awudingi ukuthatha naliphi na inyathelo elongezelelweyo ukugcina iikholamu zilungisiwe njengoko uskrola kwidatha yakho.
- I-Pinning yenziwa isebenze ngokuzenzekelayo xa sele ukhethe iikholamu ofuna ukuzifaka, kwaye zihlala zisebenza kwiseshoni yakho yonke kuMashidi kaGoogle, nokuba kukuguqulelo lwewebhu okanye kwi-app yeselula.
10. Ingaba kukho umda kwinani leekholamu endinokulibeka kuGoogle Amashiti?
- Akukho mda ukhethekileyo kwinani leekholamu onokuthi ulibeke kuMashidi kaGoogle. Unokuseta iikholamu ezininzi njengoko ufuna umsebenzi wakho wedatha.
- Oku kwenza iikholamu zokuseta kwiishiti zikaGoogle zibe sisixhobo esiguqukayo esiziqhelanisa neemfuno zomsebenzisi ngamnye kunye nokuntsonkotha kwespreadsheets zabo.
- Ke, ukuba uneseti enkulu yedatha kwaye ufuna ukugcina iikholamu ezininzi zibonakala ngamaxesha onke, ungakwenza oko ngaphandle kokukhathazeka malunga nemida yokukhonkotha.
Kude ibe lilixa elizayo, Tecnobits! Kwaye khumbula, ukuseta iikholamu kuMashidi kaGoogle kufuneka ukhethe ikholamu, uye ku "Jonga" kwaye "Seta amaKholamu" Ngoku idatha yakho iya kubalaseliswa, njengoko kuya kuba njalo ngesibindi!
NdinguSebastián Vidal, injineli yekhompyuter ethanda itekhnoloji kunye ne-DIY. Ngaphaya koko, ndingumdali we tecnobits.com, apho ndabelana ngee-tutorials ukwenza itekhnoloji ifikeleleke kwaye iqondeke kumntu wonke.