Likhaoletso tse 11 tsa mantlha tsa Google Sheets

Google Sheets e ka ba e hlakileng haholoanyane le e utloahalang ho sebelisoa ho batho ba se nang sistimi Microsoft 'Me ba rata ho sebelisa li-spreadsheet ho tsamaisa khoebo ea bona e nyenyane. Ho hlakile hore sebelisa Li-Sheets tsa Google Ho fetola pakeng tsa keyboard le mouse ho matla, ke ka lebaka leo basebelisi ba lekang ho kenyelletsa likhutšoane tsa keyboard mosebetsing oa bona. Likharollo tsa keyboard tse tsoang ho Google Docs kapa likhutšoane tsa keyboard tse tsoang ho macOS li ka sebelisoa ho ntlafatsa ts'ebetso ea tsona. Kahoo, re tlo akaretsa tse ling tsa likhutšoane tsa bohlokoahali tsa Google Sheets bakeng sa basebelisi ba keyboard. A re qaleng!

1. Kgetha mela le dikholomo

Ha u sebetsa ho li-spreadsheet tokomaneng ea Lipampiri, e ka ba mokhathala ho khetha lihlopha tse kholo tsa mela le litšiea ka mouse, e ka nkang nako le ho se sebetse hantle. Ho rarolla bothata bona, likhutšoane tsa keyboard li ka sebelisoa ho khetha ka potlako mola kapa kholomo letlapeng, moo Ctrl + Space e ka hatelloang ho khetha kholomo, le Shift + Space ho khetha mola, 'me sena se boloka nako e ngata. le boiteko. Karolo e felletseng ea lisele le eona e ka khethoa ho sebelisoa Ctrl+A kapa ⌘+A (macOS), e sebetsang hantle le ho boloka nako khethong.

2. Peista ntle le ho fometa

Ha ho kopitsoa data ho tsoa maqepheng a mang, tlhahisoleseling e kopilitsoeng e kanna ea ba le fomete e khethehileng joalo ka boholo ba fonte, mebala, le fomete ea lisele, tse ka 'nang tsa se ke tsa lakatseha ha li manehiloe ho spreadsheet. Ho rarolla bothata bona, ho ka sebelisoa sekhechana sa keyboard ho beha data ntle le ho fometa, kahoo sebakeng sa ho tobetsa ⌘+V, u ka tobetsa ⌘+Shift+V (macOS) kapa Ctrl+Shift+V (Windows) ho peista. data ntle le ho fometa. Tsela e khutšoanyane ena e thusa ho tlosa fomete efe kapa efe e sa batleheng 'me e u lumella ho kopitsa feela data e tala, ho etsa hore data e bonahale haholoanyane le ho e sebelisa habonolo.

3. Sebelisa Meeli

Ha u sebetsa letlapeng le leholo la data, ho ka ba thata ho khetholla pakeng tsa data ka linako tse ling, ke ka lebaka leo Li-Spreadsheets li u lumellang ho eketsa meeli ho totobatsa lisele. O ka eketsa meeli ho tsohle, lehlakore le le leng, kapa ho feta tsa sele ka 'ngoe. Ho kenya meeli mahlakoreng 'ohle a mane a sele, tobetsa konopo ea keyboard ⌘+Shift+7 (macOS) kapa Ctrl+Shift+7 (Windows).

Ha u qetile 'me u batla ho tlosa meeli, u ka sebelisa sekhechana sa keyboard Option+Shift+6 (macOS) kapa Alt+Shift+6 (Windows) ho tlosa meeli e kentsoeng pele ka ho tobetsa feela sele kapa sebaka seo u batlang ho se etsa. tlosa meedi. Acronym ena e thusa ho ntlafatsa ho hlaka ha data le ho etsa hore e balehe le ho sebelisoa.

4. Khokahano ea data

Ho etsa hore data ea hau e bonahale e ts'oana ebile e hlophisehile letlapeng, u ka fihlela sena ka ho hokahanya lisele. Ho na le mekhoa e meraro ea ho hokahanya lisele: ho le letšehali, ho le letona le bohareng. Ho fihlela sena, o ka tobetsa sekhechana sa keyboard ⌘+Shift+L (macOS) kapa Ctrl+Shift+L (Windows) ho tlanya ka ho le letšehali, ⌘+Shift+R kapa Ctrl+Shift+R ho tlanya ka ho le letona, tsela e khuts'oane ⌘+Shift. +E kapa Ctrl+Shift+E ho hokahanya bohareng.

Ka ho sebelisa mehato ena, tlhophiso ea data e ka hlophisoa le ho ba ntle haholoanyane, 'me e na le ponahalo eo ho leng bonolo ho e bala le ho e utloisisa.

5. Kenya letsatsi le nako

Ho kenyelletsa letsatsi le nako ke e 'ngoe ea liketso tse sebelisoang haholo ho Google Sheets,' me ho fihlela sena, mosebelisi o hloka ho tseba likhutšoane tse nepahetseng tsa keyboard. Letsatsi le nako li ka kenngoa hang, kapa li ka kenyelletsoa ka thoko.

Ho kenya letsatsi le nako mmoho, kgaoletso ya keyboard e ka tobetswa ⌘+Kgetho+Shift+; (ho macOSkapa Ctrl+Alt+Shift+; (Windows). Ho kenya letsatsi la hajoale, tobetsa ⌘+; kapa Ctrl+;, le ho eketsa nako ya jwale, o ka tobetsa kgaoletso ⌘+Shift+; أو Ctrl+Shift+;.

Ka ho sebelisa likhutšoane tsena, u ka boloka nako, ua etsa ho eketsa letsatsi le nako kapele le ha bonolo, 'me u fumane nako e nepahetseng le ho rekota letsatsi.

6. Foma data ho chelete

Ha re re u kentse lintlha tse ling leqepheng la mosebetsi empa boleng bo kentsoeng ke linomoro feela, u ka fetola lisele tsena 'me ua fomata data hore e be ka mokhoa o lakatsehang oa chelete.

Ho fetolela data ea sele ho fomete ea chelete, u ka khetha lisele tsohle tse nang le linomoro, ebe u tobetsa khetho ea keyboard Ctrl + Shift + 4.

Ka tsela e khaoletsang ena, data ea sele e hlophisoa ka potlako ebe e fetoloa ho sebopeho sa chelete, ho boloka nako le matsapa a ho fometa data ka letsoho.

7. Eketsa lihokelo

Hore na o boloka lethathamo la bahlolisani kapa o theha liwebsaete tsa lisebelisoa, o ka eketsa li-hyperlink ho li-spreadsheets. Google Ho etsa hore libaka tsa ho bula li be bonolo haholo.

Ho kenya hyperlink, ho ka tobetsoa khaoletso ea keyboard ⌘+K (ho macOS) kapa Ctrl + K (Windows) ebe u beha sehokelo seo u batlang ho se eketsa. Ntle le moo, lihokelo li ka buloa ka kotloloho ka ho tobetsa ho eona le ho tobetsa Option + Enter (macOS) kapa Alt + Kena (ka sistimi Windows).

Ka ho sebelisa mehato ena, hoa khoneha ho nolofatsa phihlello ea libaka tsa bohlokoa le ho fihlela ts'ebeliso e ntle ea li-spreadsheet.

8. Kenya mela le litšiea

E 'ngoe ea likarolo tse nyahamisang tsa ho sebelisa Google Sheets e ne e le hore ho sebelisa sesebelisoa ho eketsa mela le litšiea ke toro ea 'nete. Leha ho le joalo, hang ha u fumana likhutšoane tsa keyboard, u ke ke ua hlola u khutlela tseleng ea setso.

• Kenya mola ka holimo: tobetsa Ctrl + Option + I ebe R أو Ctrl + Alt + I ebe R .
• Ho kenya mola ka tlase: Tobetsa Ctrl + Option + I ebe joale B أو Ctrl + Alt + I ebe joale B .
• Kenya kholomo ka ho le letšehali: tobetsa Ctrl + Option + I ebe C أو Ctrl + Alt + I ebe C .
• Kenya kholomo ka ho le letona: tobetsa Ctrl + Option + I ebe O أو Ctrl + Alt + I ebe O .

9. Hlakola mela le likholomo

Joalo ka ho kenya mela le likholomo, ho li hlakola le hona ho ka ba phephetso, empa ho li-spreadsheet Google Kgutsufatso e ka sebediswa ho nolofatsa tshebetso.

Mothalo wa hona jwale o ka hlakolwa ka ho tobetsa kgaoletso ya keyboard Ctrl+Kgetho+E Ebe D. Ho phumula kholomo, o ka tobetsa kgaoletso Ctrl+Kgetho+E Ebe E hape.

Ka ho sebelisa mehato ena, mela le litšiea li ka hlakoloa kapele le ha bonolo, ho boloka nako le boiteko nakong ea ho hlophisa data le ho fetola sebopeho hore se lumellane le litlhoko tse fapaneng.

10. Kenya maikutlo

Maikutlo a ka eketsoa seleng efe kapa efe kapa sehlopheng sa lisele ho Google Sheets ho sebelisa likhutšoane tse nepahetseng.

'Me ka ho tobetsa konopo ea keyboard ⌘+Option+M (macOS) kapa Ctrl+Alt+M (macOS). Windows)-O ka eketsa maikutlo ho sele e khethiloeng kapa sehlopheng se khethiloeng.

Ka ho eketsa litlhaloso, lintlha tsa bohlokoa, litlhaloso, le litaelo tse amanang le data li ka rekota, tse thusang ho ntlafatsa puisano le tšebelisano pakeng tsa basebelisi le ho finyella tšebeliso e nepahetseng ea li-spreadsheet.

11. Hlahisa fensetere ea ho khaoletsa keyboard

Lethathamo le ka holimo ha le kenye likhutšoane tsohle tsa keyboard tse fumanehang ho Google Sheets, empa le akaretsa tse molemo ka ho fetisisa. Tsela efe kapa efe e khaoletsang ea keyboard ea Google Sheets e ka fumanoa ka ho bula fensetere ea lintlha ka ho tobetsa konopo ea keyboard ⌘+/ (macOS) kapa Ctrl+/ (Windows).

Ka ho bula fensetere ea lintlha, u ka batla sekhechana leha e le sefe sa keyboard 'me u shebe tlhaloso e qaqileng ea ho e sebelisa ho Google Sheets. Sena se thusa ho eketsa katleho le ts'ebetso ea ts'ebeliso ea li-spreadsheets le ho fihlela tlhahiso e phahameng.

12. Likhaoletso tse ling:

1. Ctrl + Shift + H: Pata mela e khethiloeng.
2. Ctrl + Shift + 9: Pata litšiea tse khethiloeng.
3. Ctrl + Shift + 0: Hlakola litšiea tse khethiloeng.
4. Ctrl + Shift + F4: Bala hape liforomo tse tafoleng.
5. Ctrl + Shift + \ : Tlosa meeli ho lisele tse khethiloeng.
6. Ctrl + Shift + 7: E fetolela lisele tse khethiloeng hore e be sebopeho se hlakileng sa mongolo.
7. Ctrl + Shift + 1: Fetolela lisele tse khethiloeng hore e be sebopeho sa linomoro.
8. Ctrl + Shift + 5: Fetolela lisele tse khethiloeng hore e be sebopeho sa liperesente.
9. Ctrl + Shift + 6: Fetolela lisele tse khethiloeng ho sebopeho sa chelete.
10. Ctrl + Shift + 2: Fetolela lisele tse khethiloeng hore e be sebopeho sa nako.
11. Ctrl + Shift + 3: Fetolela lisele tse khethiloeng hore e be sebopeho sa letsatsi.
12. Ctrl + Shift + 4: Fetolela lisele tse khethiloeng hore e be letsatsi le sebopeho sa nako.
13. Ctrl + Shift + P: Hatisa spreadsheet.
14. Ctrl + P: Hatisa tokomane ea hona joale.
15. Ctrl + Shift + S: Boloka spreadsheet.
16. Ctrl + Shift + L: Ho sefa data.
17. Ctrl + Shift + A: Khetha lisele tsohle tse tafoleng.
18. Ctrl + Shift + E: Khetha lisele tsohle tse moleng oa hona joale.
19. Ctrl + Shift + R: Khetha lisele tsohle tse kholomong ea hajoale.
20. Ctrl + Shift + O: Khetha lisele tsohle tse sebakeng se potolohileng sele ea hona joale.

Sehlopha sa likhutšoane tse ling tsa Google Sheets:

1. Ctrl + Shift + F3: Ho tlosa lifomete tsohle liseleng tse khethiloeng.
2. Ctrl + D: Kopitsa boleng ho tloha seleng e ka holimo ho ea seleng e ka tlaase.
3. Ctrl + Shift + D: Kopitsa foromo ho tloha seleng e ka holimo ho ea seleng e ka tlaase.
4. Ctrl + Shift + U: Fokotsa boholo ba fonte liseleng tse khethiloeng.
5. Ctrl + Shift + +: Eketsa boholo ba fonte liseleng tse khethiloeng.
6. Ctrl + Shift + K: Kenya sehokelo se secha seleng e khethiloeng.
7. Ctrl + Alt + M: Kenya tshebetsong karolo ya "Fetolela" mme o fetolele dikahare puong e nngwe.
8. Ctrl + Alt + R: Kenya lipalo tse patiloeng tafoleng.
9. Ctrl + Alt + C: E bala lipalo-palo bakeng sa lisele tse khethiloeng.
10. Ctrl + Alt + V: Bontša boleng ba 'nete ba foromo ka seleng e khethiloeng.
11. Ctrl + Alt + D: E bula lebokose la puisano la Conditionals.
12. Ctrl + Alt + Shift + F: E bula lebokose la puisano la Lisele tsa Format.
13. Ctrl + Alt + Shift + P: E bula puisano ea Likhetho tsa Printa.
14. Ctrl + Alt + Shift + E: E bula puisano ea Export.
15. Ctrl + Alt + Shift + L: E bula puisano ea Laola Lipeeletso.
16. Ctrl + Alt + Shift + N: Etsa setšoantšo se secha.
17. Ctrl + Alt + Shift + H: Pata lihlooho le linomoro ka mela le litšiea.
18. Ctrl + Alt + Shift + Z: Khetha lisele tsohle tse nang le boleng bo habeli.
19. Ctrl + Alt + Shift + X: Khetha lisele tsohle tse nang le boleng bo ikhethang.
20. Ctrl + Alt + Shift + S: Khetha lisele tsohle tse nang le liforomo tse tšoanang.

Likhaoletso tsena li tsoetse pele:

Ho hlokahala boiphihlelo bo eketsehileng ka Google Sheets. Likhutšoane tse ling le litsebo tse tsoetseng pele li ka ithutoa ka ho sheba:

1. Ctrl + Shift + Enter: Kenya foromo ea sehlopha seleng e khethiloeng.
2. Ctrl + Shift + L: Kenya lenane le theoha bakeng sa sele e khethiloeng.
3. Ctrl + Shift + M: Kenya maikutlo seleng e khethiloeng.
4. Ctrl + Shift + T: E fetolela lethathamo la data hore e be tafole.
5. Ctrl + Shift + Y: Kenya barcode ka har'a sele e khethiloeng.
6. Ctrl + Shift + F10: E bontša lenane la likhetho tse fumanehang bakeng sa sele e khethiloeng.
7. Ctrl + Shift + G: Fumana lisele tse nang le boleng bo itseng.
8. Ctrl + Shift + Q: Kenya Konopo ea Taolo ho sele e khethiloeng.
9. Ctrl + Shift + E: Kenya chate tafoleng.
10. Ctrl + Shift + I: E theha Sebopeho sa Maemo bakeng sa lisele tse khethiloeng.
11. Ctrl + Shift + J: Kenya sebopeho sa preconditional ka har'a lisele tse khethiloeng.
12. Ctrl + Shift + O: Khetha sebaka sohle sa tafole.
13. Ctrl + Shift + R: E fetolela mongolo ho litlhaku tse kholo kapa tse nyane.
14. Ctrl + Shift + S: Fetolela tafole ho setšoantšo.
15. Ctrl + Shift + U: Kenya mela e otlolohileng ka har'a lisele tse khethiloeng.
16. Ctrl + Shift + W: Kenya mela e emeng ka har'a lisele tse khethiloeng.
17. Ctrl + Shift + Z: Hlakola ketso ea ho qetela.
18. Ctrl + Alt + Shift + F: Etsa liforomo tsa sele tsa tloaelo.
19. Ctrl + Alt + Shift + U: Kenya letšoao la Unicode seleng e khethiloeng.
20. Ctrl + Alt + Shift + V: Kenya Mohloli oa Boitsebiso ka seleng e khethiloeng.

Phapang lipakeng tsa Google le Office spreadsheets

Google Sheets le Microsoft Excel ke li-spreadsheet tse peli tse tsebahalang haholo mosebetsing le bophelong ba letsatsi le letsatsi. Le hoja mananeo ana ka bobeli a etsa mesebetsi e tšoanang ea motheo, a fapane ka litsela tse ling. Mona ke tse ling tsa liphapang lipakeng tsa Google Sheets le Office:

1. Ho kena lenaneong:
   Le ha Microsoft Excel e kentsoe komporong, Google Sheets e fumaneha ka sebatli le Marang-rang.
2. Tšebelisano le ho arolelana:
   Google Sheets e bonolo le ho feta ho arolelana le ho sebelisana le ba bang, kaha basebelisi ba bangata ba ka sebetsa ho spreadsheet ka nako e le 'ngoe, ba fana ka maikutlo ka lisele le ho arolelana ka nako ea sebele.
3. Sebopeho le moralo:
   Microsoft Excel e na le ho feto-fetoha habonolo ho fomete le moralo, kaha Excel e fana ka libopeho tse tsoetseng pele le mefuta e mengata e fapaneng ea lifonte, mebala le litlamorao.
4. Lisebelisoa le likarolo:
   Microsoft Excel e na le lisebelisoa le likarolo tse ngata tse tsoetseng pele, tse kang litafole tsa nako le nako, lichate tse phelang, le tlhahlobo e tsoetseng pele ea lipalo. Le hoja Google Sheets e le bonolo, e bonolo ebile e tenyetseha, e leng se etsang hore e tšoanelehe haholoanyane ho basebelisi ba batlang tharollo e bonolo le e tobileng.
5. Ho kopanya le litšebeletso tse ling:
   Google Sheets e fana ka khokahanyo e se nang moeli le lits'ebeletso tse ling tsa Google, joalo ka Google Drive, Google Docs, Google Slides, le tse ling, ha Microsoft Excel e fana ka khokahanyo e se nang moeli le lihlahisoa tse ling tsa Microsoft, joalo ka Lentsoe, PowerPoint, Outlook, le tse ling.
6. litšenyehelo:
   Google Sheets ke mahala bakeng sa motho e mong le e mong, empa o tlameha ho lefa tefo ea ho ngolisa ho nka monyetla ka Microsoft Excel.
7. Tšireletseho:
   Google Sheets e bolokehile ho boloka lintlha kaha data e ngolloa ka mokhoa o ikhethileng 'me e bolokoa marung ho li-server tsa Google tse sirelelitsoeng ka li-password tse matla le mahlale a tsoetseng pele a ts'ireletso. Le ha lifaele tsa Microsoft Excel li bolokiloe sesebelisoa sa hau, e hloka ho boloka likopi tsa "backup" le ho sireletsa sesebelisoa sa hau ka li-password tse matla.
8. tšehetso:
   Google e fana ka lithupelo le sechaba se seholo sa tšehetso, ha tšehetso ea Microsoft e fumaneha ka mohala, lengolo-tsoibila le marang-rang.
9. Litlhoko tsa tekheniki:
   Google Sheets e inthaneteng, ho bolelang hore e hloka khokahano ea inthanete ho fihlella le ho hlophisa data. Le ha Microsoft Excel e ka sebelisoa ntle le tlhoko ea khokahano ea inthanete, e etsang hore e loketse basebelisi ba hlokang ho fihlella data ntle le marang-rang.
10. Sebelisa lisebelisoa tsa mohala:
    Google Sheets e etsa hore ho be bonolo le ho otloloha ho fihlella le ho hlophisa data ho li-smartphones le matlapa, ha Microsoft Excel e hloka hore sesebelisoa sa mobile sa Excel se kenngoe ho fihlella le ho hlophisa data.

Ka kakaretso, basebelisi ba lokela ho khetha software e fihlelang litlhoko tsa bona hantle, e ka ba Google Sheets kapa Microsoft Excel. Mananeo ao ka bobeli a ka kopitsoa le ho sebelisoa mahala ho fumana hore na ke efe e molemohali bakeng sa tšebeliso ea motho ka mong kapa ea khoebo.

Tsela e khaoletsang ea Google Sheets eo u e ratang ke efe

Likhutšoane tse boletsoeng ka holimo ke tse ling tsa tse sebelisoang haholo ho Google Sheets, empa ho na le likhutšoane tse ling tse ngata tse sebetsang tse ka sebelisoang ho ntlafatsa ts'ebetso le tlhahiso. Har'a li-shortcuts tsena:

•  Shift+Space keyboard shortcut ho khetha mola oa hajoale.
•  Tsela ea khaoletso ea keyboard Ctrl+Space ho khetha kholomo ea hajoale.
•  Ctrl+Shift+V Beha mongolo ntle le ho fometa.
•  Shortcut ea keyboard Alt+Enter (Windows) kapa Option+Enter (macOS) E kenya mohala o mocha ka har'a sele.
•  Tsela e khaoletsang ea keyboard Ctrl+Alt+Shift+K ho bula lenane la likhaoletso tse fumanehang.

Ha u sebelisa likhutšoane tsena le mekhoa e meng e metle, u ka ntlafatsa ts'ebetso le tlhahiso ho Google Sheets, 'me u boloke nako le boiteko ho laola le ho hlophisa lintlha tsa hau.