Mholo Tecnobits! Kuqhubekani? Ndiyathemba ukuba unosuku olumnandi njengokukhenkceza iseli kuMashidi kaGoogle (Ctrl + Shift+ F10)Molo!
1. Kuthetha ukuthini ukukhenkcisa iseli kwi-Google Sheets?
Xa umisa iseli kuGoogle Amaxwebhu, umqolo omnye okanye ngaphezulu kunye/okanye imiqolo itshixiwe ukuze ihlale ibonakala ngamaxesha onke ngelixa uskrola kwi-spreadsheet.. Oku kuluncedo xa usebenza iseti zedatha ezinkulu kwaye ufuna ukugcina ulwazi oluthile lubonakala ngelixa ujonga ishiti.
2. Ndingawukhenkcisa njani umqolo kuGoogle waMashidi?
- Vula i-spreadsheet sakho kwi-Google Sheets.
- Khetha umqolo ofuna ukuwumisa ngokucofa inombolo yomqolo ngasekhohlo kwephepha.
- Yiya kukhetho "Jonga" kwimenyu ephezulu kwaye ukhethe u-"Pin Row".
- Umqolo okhethiweyo uya kuqhotyoshelwa phezulu kwiphepha kwaye uya kuhlala ubonakala naxa uskrolela ezantsi.
3. Kuthekani ukuba ndifuna ukukhenkcisa ikholamu kuMashidi kaGoogle?
- Vula i-spreadsheet sakho kwi-Google Sheets.
- Khetha ikholamu ofuna ukuyimisa ngokucofa unobumba wekholamu phezulu ephepheni.
- Yiya kwinketho ethi "Jonga" kwimenyu ephezulu kwaye ukhethe "Lungisa iKholamu."
- Uluhlu olukhethiweyo luza kuprintwa ekhohlo kwiphepha kwaye liza kuhlala libonakala naxa uskrolela ekunene.
4. Ngaba kunokwenzeka ukukhenkceza yomibini imiqolo kunye neekholamu kwiiShedi zikaGoogle?
- Vula i-spreadsheet sakho kwi-Google Sheets.
- Khetha iseli ezantsi nje komqolo wokugqibela kwaye ekunene koluhlu lokugqibela ofuna ukulwenza.
- Yiya kukhetho »Jonga» kwimenyu ephezulu kwaye ukhethe u-“Lungisa imiqolo ePhezulu” kwaye »Lungisa Ikholamu eKhohlo”.
- Oku kuya kutshixa imiqolo ephezulu kunye neekholamu ekhohlo kwiseli ekhethiweyo endaweni, ikuvumela ukuba ubone laa nxalenye yespreadsheet ngamaxesha onke.
5. Ndingayikhulula njani imiqolo okanye iikholamu kuMashidi kaGoogle?
- Vula i-spreadsheet sakho kwi-Google Sheets.
- Yiya kwinketho ethi "Jonga" kwimenyu ephezulu kwaye ukhethe u-"Pin Row" okanye "iKholamu yePin," kuxhomekeke kwinto ofuna ukuyikhulula.
- Umqolo okhethiweyo okanye umhlathi awusayi kuphinda uprintwe kwaye uya kubuyela ekuskroleni ngokuqhelekileyo kunye nespreadsheet sonke.
6. Ndingakwazi ukukhenkceza imiqolo emininzi okanye iikholamu ngexesha elinye kuMashithi kaGoogle?
- Vula i-spreadsheet sakho kwi-Google Sheets.
- Khetha umqolo okanye ikholamu ofuna ukuyimisa ngokucinezela iqhosha elithi "Ctrl" (kwiWindows) okanye iCmd (kwiMac) ngelixa ucofa kwimiqolo eyahlukeneyo okanye iikholamu ofuna ukuzikhetha.
- Yiya ku "Jonga" ukhetho kwimenyu ephezulu kwaye ukhethe u-"Pin rows" okanye "Pin Columns."
- Iirowu ezikhethiweyo okanye iikholamu ziya kulungiswa endaweni, zihlale zibonakala ngawo onke amaxesha xa uskrola kwi-spreadsheet.
7. Ngaba kunokwenzeka ukukhenkceza iiseli ezithile kwi-Google Sheets?
- Vula i-spreadsheet sakho kwi-Google Sheets.
- Khetha iseli okanye iqela leeseli ofuna ukuzibambisa.
- Yiya kwinketho ethi "Jonga" kwimenyu ephezulu kwaye ukhethe u-"Pin Cells."
- Iiseli ezikhethiweyo ziya kutshixwa endaweni, zikuvumela ukuba usebenze namanye amacandelo espredishithi ngaphandle kokulahlekelwa ngumbono wolwazi olubalulekileyo oluphiniweyo.
8. Ndingakwazi ukukhenkcisa iiseli ezantsi kwephepha kuMashidi kaGoogle?
- Vula i-spreadsheet sakho kwi-Google Sheets.
- Khetha iseli engaphezulu nje komqolo wokuqala ofuna ukuwumisa emazantsi ephepha.
- Yiya kukhetho luka “Jonga” kwimenyu ephezulu kwaye ukhethe “Pin Emazantsi Imiqolo.”
- Ngale ndlela, imiqolo engezantsi kweseli ekhethiweyo iya kulungiswa endaweni, ihlale ibonakala xa uskrola phezulu.
9. Ndingazi njani ukuba umqolo okanye ikholamu ingumkhenkce kuGoogle Sheets?
- Vula ispredishithi yakho kwiGoogle Sheets.
- Qaphela ukuba kukho umgca owahlulayo phakathi kwemiqolo ephiniweyo okanye iikholamu kunye ne-spreadsheet sonke.
- Irowu ezipiniweyo kunye neekholamu ziya kubonisa umgca onamachokoza obonisa ukuba umkhenkce kwindawo yawo.
10. Ngaba kukho indlela ekhawulezayo yokukhenkcela imiqolo okanye iikholamu kwiiShedi zikaGoogle?
- Vula ispredishithi yakho kwiGoogle Sheets.
- Yiya kumqolo okanye kwikholamu ofuna ukuyimisa kwaye ucofe inombolo ehambelanayo yomqolo okanye unobumba wekholamu.
- Cofa ekunene kwaye ukhethe "Lungisa umqolo" okanye "Lungisa iKholamu" ukhetho.
- Olu khetho luzakuvumela ukuba ulungise ngokukhawuleza umqolo okhethiweyo okanye umhlathi ngaphandle kokujonga iimenu zokukhetha.
Mandikubobe kwixesha elizayo! Kwaye ungalibali ukudibana Tecnobits ukufunda amaqhinga afana Ufakwa njani umkhenkce kwiseli kuGoogle Amaxwebhu. Mandikubone emva kwexesha!
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.