Lumela, Tecnobits! Ke tšepa hore li khanya joaloka lisele tse totobalitsoeng ho Google Sheets. Ho totobatsa sele e ngotsoeng ka mongolo o motenya, khetha feela sele ebe o tobetsa letšoao le ngotsoeng ka mongolo o motenya ka har'a toolbar. Natefeloa ke ho tseba likarolo tsa Google Sheets!
Nka totobatsa lisele joang ho Google Sheets?
- Bula spreadsheet ho Google Sheets.
- Khetha lisele tseo u batlang ho li totobatsa. U ka etsa sena ka nako e le 'ngoe kapa ua khetha lisele tse ngata ka ho tobetsa konopo ea leqele le ho hula sesupa holim'a lisele tseo u li batlang. U ka boela ua khetha lisele tse ngata ka ho tšoara Ctrl (Cmd on Mac) ha u ntse u tobetsa.
- Ha u se u khethile lisele, tlanya ho tsona ka ho le letona ho bula menyu ea litaba.
- Ho menu ea moelelo, khetha khetho ea "Tlatsa mmala".
- Phalete ea mebala e tla buloa ka likhetho tse fapaneng ho totobatsa lisele. U ka khetha 'mala oo u o ratang ka ho tobetsa ho oona.
- E lokile! Lisele tsa hau li tla totobatsoa ka 'mala o khethiloeng.
A na nka totobatsa lisele ho Google Sheets ke sebelisa likhutšoane tsa keyboard?
- Bula spreadsheet ho Google Sheets.
- Khetha lisele tseo u batlang ho li totobatsa u sebelisa mekhoa e boletsoeng potsong e fetileng.
- Ha u se u khethile lisele, sebelisa sekhechana sa keyboard Ctrl (Cmd on Mac) + Shift + s.
- Phalete ea mebala e tla buleha e le hore u ka khetha eo ue batlang u sebelisa linotlolo tsa metsu ebe u tobetsa Enter ho netefatsa.
- Ka tsela ena, o ka totobatsa lisele tsa hau kapele o sebelisa likhutšoane tsa keyboard.
Na hoa khoneha ho totobatsa lisele ho Google Sheets ka mebala e tloaelehileng?
- Bula spreadsheet ea hau ho Google Sheets.
- Khetha lisele tseo u batlang ho li totobatsa u sebelisa mekhoa e boletsoeng potsong ea pele.
- Tobetsa ka ho le letona liseleng tse khethiloeng ho bula menyu ea litaba.
- Khetha khetho ea "Fill Color".
- Botlaaseng ba mebala ea mebala, u tla fumana khetho ea "More" e u lumellang hore u thehe mebala e tloaelehileng.
- Tobetsa "More" 'me ho tla buleha menu e u lumellang hore u khethe 'mala o tloaelehileng u sebelisa likhoutu tsa RGB kapa ka ho khetha' mala ho tsoa lebiling la mebala.
- Hang ha u se u iketselitse 'mala oa hau, tobetsa "OK" ho totobatsa lisele tsa hau ka 'mala oo.
A na nka totobatsa lisele ho Google Sheets ke sebelisa liforomo kapa melao e nang le maemo?
- Bula spreadsheet ho Google Sheets.
- Khetha lisele moo u batlang ho sebelisa molao oa maemo. U ka etsa sena u sebelisa mekhoa e boletsoeng potsong ea pele.
- Eya ho menu ya "Format" 'me u khethe khetho ea "Conditional formatting".
- Phanele e ka lehlakoreng e tla bula moo o ka behang melao e nang le maemo ho totobatsa lisele tsa hau.
- Khetha maemo ao u batlang ho a sebelisa, joalo ka ho totobatsa lisele haeba boleng ba tsona bo feta palo e itseng kapa haeba li kopana le maemo a itseng a utloahalang.
- Hang ha melao e se e thehiloe, khetha mokhoa oa ho totobatsa oo u batlang ho o sebelisa ho lisele tse finyellang maemo ana.
- Ha u se u thehile melao eohle e lakatsehang, tobetsa "Ho lokile" ho sebelisa fomete e nang le maemo liseleng tsa hau.
Nka tlosa ho hlakisoa ha lisele joang ho Google Sheets?
- Bula leqephe la hau ho Google Sheets.
- Khetha lisele tse nang le ntlha eo u batlang ho e tlosa.
- Tobetsa ka ho le letona liseleng tse khethiloeng ho bula menyu ea litaba.
- Khetha khetho ea "Fill Color".
A na nka totobatsa lisele ho Google Sheets ke sebelisa lipaterone kapa masela?
- Bula spreadsheet ho Google Sheets.
- Khetha lisele tseo u batlang ho li totobatsa u sebelisa mekhoa e boletsoeng potsong ea pele.
- Tobetsa ka ho le letona liseleng tse khethiloeng ho bula menyu ea litaba.
- Khetha khetho ea "Fill Color".
A na nka totobatsa lisele ho Google Sheets ka mebala e fapaneng?
- Bula spreadsheet ea hau ho Google Sheets.
- Khetha lisele tseo u batlang ho li totobatsa u sebelisa mekhoa e boletsoeng potsong ea pele.
- Tobetsa ka ho le letona liseleng tse khethiloeng ho bula menyu ea litaba.
- Khetha khetho ea "Fill Color".
A na nka totobatsa lisele ho Google Sheets ho latela litaba tsa tsona?
- Bula spreadsheet ho Google Sheets.
- Khetha lisele tseo u batlang ho li totobatsa ho latela litaba tsa tsona.
- Eya ho menu ea "Format" 'me u khethe khetho ea "Conditional formatting".
A na nka totobatsa lisele ho Google Sheets ka sebopeho sa tafole?
- Bula spreadsheet ea hau ho Google Sheets.
- Khetha lisele tse tla ba karolo ea tafole ea hau kapa, haeba u se u ntse u e-na le tafole e entsoeng, khetha tafole eohle.
- Eya ho "Format" menu 'me u khethe khetho ea "Tafole".
- Ka lehlakoreng la phanele, khetha mokhoa oa tafole o kenyelletsang ho totobatsa lisele.
Na ho na le katoloso kapa plugin ho totobatsa lisele ho Google Sheets?
- Bula spreadsheet ea hau ho Google Sheets.
- Eya ho "Add-ons" menu 'me u khethe khetho ea "Fumana Li-add-ons".
- Lebenkeleng la tlatsetso, sebelisa lebokose la ho batla ho fumana likeketso tse u lumellang ho totobatsa lisele ho Google Sheets.
- Hang ha u se u fumane katoloso eo u e batlang, tobetsa "Kenya" 'me u latele litaelo ho e kenya ho spreadsheet ea hau.
Ho fihlela nakong e tlang, metsoalle! Hopola ho lula u khanya joalo ka lisele tse totobalitsoeng ka sebete ho Google Sheets. Haeba u batla likeletso tse ling tse kang tsena, u se ke oa lebala ho etela Tecnobits. Ke tla u bona hamorao!
Ke 'na Sebastián Vidal, moenjiniere oa k'homphieutha ea chesehelang theknoloji le DIY. Ho feta moo, ke 'na moetsi oa tecnobits.com, moo ke arolelanang lithupelo ho etsa hore theknoloji e fumanehe le ho utloisisoa ke motho e mong le e mong.