Njira Zachidule Zapamwamba 11 za Google

Mapepala a Google atha kukhala anzeru komanso omveka kugwiritsa ntchito kwa anthu opanda dongosolo Microsoft Ndipo amakonda kugwiritsa ntchito maspredishiti kuchita bizinesi yawo yaying'ono. Mwachiwonekere ntchito Masamba a Google Kusintha pakati pa kiyibodi ndi mbewa ndikovuta, ndichifukwa chake ogwiritsa ntchito amayesa kuphatikiza njira zazifupi za kiyibodi mumayendedwe awo. Njira zazifupi za kiyibodi kuchokera ku Google Docs kapena njira zazifupi za kiyibodi kuchokera ku macOS zitha kugwiritsidwa ntchito kukonza kayendedwe kawo. Chifukwa chake, tifotokoza njira zazifupi za Google Sheets kwa ogwiritsa ntchito kiyibodi. Tiyeni tiyambe!

1. Sankhani mizere ndi mizati

Pogwira ntchito pamasamba mu chikalata cha Mapepala, zingakhale zotopetsa kusankha magulu akuluakulu a mizere ndi mizati ndi mbewa, zomwe zingakhale zowononga nthawi komanso zosagwira ntchito. Kuti athetse vutoli, njira zazifupi kiyibodi angagwiritsidwe ntchito kusankha mwamsanga mzere wonse kapena ndime pa pepala, kumene Ctrl + Space akhoza mbamuikha kusankha ndime, ndi Shift + Space kusankha mzere, ndipo izi zimapulumutsa nthawi yambiri. ndi khama. Gulu lonse la ma cell litha kusankhidwanso pogwiritsa ntchito njira yachidule ya Ctrl+A kapena ⌘+A (macOS), yomwe imakhala yothandiza kwambiri komanso imasunga nthawi posankha.

2. Matani osasintha

Mukakopera data kuchokera kumasamba ena, zomwe mwakoperazo zitha kukhala ndi masanjidwe apadera monga kukula kwa mafonti, mitundu, ndi masanjidwe a ma cell, zomwe sizingakhale zofunika mukaziika mu spreadsheet. Kuti muthane ndi vutoli, njira yachidule ya kiyibodi ingagwiritsidwe ntchito kumata zomwe zili popanda kusanjidwa, kotero m'malo mongosindikiza ⌘+V, mutha kukanikiza ⌘+Shift+V (macOS) kapena Ctrl+Shift+V (Windows) kuti muime. deta popanda masanjidwe aliwonse. Njira yachiduleyi imathandizira kuchotsa masanjidwe aliwonse osafunikira ndipo imakulolani kukopera deta yaiwisi yokha, kupangitsa kuti datayo iwonekere komanso yosavuta kugwiritsa ntchito.

3. Ikani Malire

Pogwira ntchito pa pepala lalikulu la deta, zingakhale zovuta kusiyanitsa pakati pa deta nthawi zina, chifukwa chake Spreadsheets amakulolani kuti muwonjezere malire kuti muwonetsere maselo. Mutha kuwonjezera malire kwa onse, mbali imodzi, kapena zingapo za selo iliyonse. Kuti muwonjezere malire kumbali zonse zinayi za selo, dinani njira yachidule ya kiyibodi ⌘+Shift+7 (macOS) kapena Ctrl+Shift+7 (Windows).

Mukamaliza ndipo mukufuna kuchotsa malire, mutha kugwiritsa ntchito njira yachidule ya kiyibodi Option+Shift+6 (macOS) kapena Alt+Shift+6 (Windows) kuti muchotse malire omwe adawonjezedwa kale ndikungodina pa cell kapena mtundu womwe mukufuna. chotsani malire. Chidule ichi chimathandiza kumveketsa bwino deta ndikupangitsa kuti ikhale yowerengeka komanso yogwiritsidwa ntchito.

4. Kusinthana kwa data

Kuti deta yanu iwoneke yofanana komanso yokonzedwa papepala, mutha kukwaniritsa izi mwa kugwirizanitsa ma cell. Pali njira zitatu zoyanitsira ma cell: kumanzere, kumanja, ndi pakati. Kuti muchite izi, mutha kukanikiza njira yachidule ya kiyibodi ⌘+Shift+L (macOS) kapena Ctrl+Shift+L (Windows) kuti mujambule kumanzere, ⌘+Shift+R kapena Ctrl+Shift+R kuti mujambule kumanja, njira yachidule ⌘+Shift. +E kapena Ctrl+Shift+E kuti agwirizane pakati.

Pogwiritsa ntchito njirazi, dongosolo la deta likhoza kukhala lokonzekera bwino komanso lokongola, ndipo limakhala ndi maonekedwe osavuta kuwerenga ndi kumvetsa.

5. Lowetsani tsiku ndi nthawi

Kuonjezera tsiku ndi nthawi ndi chimodzi mwazinthu zomwe zimagwiritsidwa ntchito kwambiri mu Google Sheets, ndipo kuti akwaniritse izi, wogwiritsa ntchito ayenera kudziwa njira zazifupi za kiyibodi. Tsiku ndi nthawi zitha kulowetsedwa kamodzi, kapena zitha kuwonjezeredwa padera.

Kuti mulowetse tsiku ndi nthawi pamodzi, njira yachidule ya kiyibodi ingathe kukanidwa ⌘+Option+Shift+; (mu macOS) kapena Ctrl+Alt+Shift+; (Windows). Kuti muwonjezere tsiku lapano, dinani ⌘+; kapena Ctrl+;, ndi kuwonjezera nthawi yomwe ilipo, mutha kukanikiza njira yachidule ⌘+Shift+; أو Ctrl + Shift +;.

Pogwiritsa ntchito njira zazifupizi, mutha kusunga nthawi, kuwonjezera tsiku ndi nthawi mwachangu komanso mophweka, ndikupeza nthawi yolondola komanso kujambula tsiku.

6. Sinthani deta ku ndalama

Tiyerekeze kuti mwawonjezera zambiri patsamba lantchito koma zomwe mwalowa ndi manambala chabe, mutha kusintha ma cellwa ndikuyika deta kuti ikhale mumtundu womwe mukufuna.

Kuti musinthe ma cell data kukhala mtundu wa ndalama, mutha kusankha ma cell onse omwe ali ndi manambala, kenako dinani njira yachidule ya kiyibodi Ctrl + Shift + 4.

Ndi njira yachidule iyi, data ya foni imasinthidwa mwachangu ndikusinthidwa kukhala mtundu wandalama, kupulumutsa nthawi ndi mphamvu pakusanjikiza pamanja deta.

7. Onjezani maulalo

Kaya mumasunga mndandanda wa omwe akupikisana nawo kapena kupanga mawebusayiti, mutha kuwonjezera ma hyperlink kumaspredishithi. Google Kupangitsa mawebusayiti kukhala osavuta kwambiri.

Kuti muwonjezere hyperlink, njira yachidule ya kiyibodi ingathe kupanikizidwa ⌘+K (pa macOS) kapena Ctrl + K (Windows) ndikuyika ulalo womwe mukufuna kuwonjezera. Kuphatikiza apo, maulalo amatha kutsegulidwa mwachindunji ndikudina ndikudina Option + Enter (macOS) kapena Alt + Lowani (mu system Windows).

Pogwiritsa ntchito njirazi, ndizotheka kuwongolera mwayi wopezeka pamasamba ofunikira ndikukwaniritsa kugwiritsa ntchito bwino ma spreadsheets.

8. Onjezani mizere ndi mizati

Chimodzi mwazinthu zokhumudwitsa zogwiritsa ntchito Mapepala a Google chinali chakuti kugwiritsa ntchito chida chowonjezera mizere ndi mizati ndizovuta kwambiri. Komabe, mukapeza njira zazifupi za kiyibodi, simudzabwereranso kumayendedwe akale.

• Lowetsani mzere pamwamba: dinani Ctrl + Option + I kenako R أو Ctrl + Alt + I kenako R .
• Kuyika mzere pansipa: Dinani Ctrl + Option + I kenako B أو Ctrl + Alt + I kenako B .
• Lowetsani ndime kumanzere: dinani Ctrl + Option + I kenako C أو Ctrl + Alt + I kenako C .
• Lowetsani ndime kumanja: dinani Ctrl + Option + I kenako O أو Ctrl + Alt + I kenako O .

9. Chotsani mizere ndi mizati

Monga ngati kuwonjezera mizere ndi zipilala, kuzichotsa kungakhalenso kovuta, koma mumapepala Google Chidule chingagwiritsidwe ntchito kuti ndondomekoyi ikhale yosavuta.

Mzere wapano ukhoza kufufutidwa mwa kukanikiza njira yachidule ya kiyibodi Ctrl+Njira+E Ndiye D. Kuchotsa ndime, mukhoza akanikizire njira yachidule Ctrl+Njira+E Ndiye E kachiwiri.

Pogwiritsa ntchito masitepewa, mizere ndi mizati zitha kuchotsedwa mwachangu komanso mosavuta, kupulumutsa nthawi ndi khama pokonzekera deta ndikusintha mawonekedwe kuti agwirizane ndi zosowa zosiyanasiyana.

10. Onjezani ndemanga

Ndemanga zitha kuwonjezedwa ku selo iliyonse kapena gulu la ma cell a Google Sheets mosavuta pogwiritsa ntchito njira zazifupi zoyenera.

Ndipo mwa kukanikiza njira yachidule ya kiyibodi ⌘+Option+M (macOS) kapena Ctrl+Alt+M (macOS). Windows)-Itha kuwonjezera ndemanga ku selo yosankhidwa kapena gulu losankhidwa.

Powonjezera ndemanga, zolemba zofunika, mafotokozedwe, ndi malangizo okhudzana ndi deta akhoza kulembedwa, zomwe zimathandiza kupititsa patsogolo kulankhulana ndi kugwirizana pakati pa ogwiritsa ntchito ndikukwaniritsa kugwiritsa ntchito bwino ma spreadsheets.

11. Onetsani zenera lachidule la kiyibodi

Mndandanda womwe uli pamwambawu sunaphatikizepo njira zazifupi zonse za kiyibodi zomwe zikupezeka mu Google Sheets, koma zimagwira ntchito zothandiza kwambiri. Njira yachidule ya kiyibodi ya Google Sheets ingapezeke poyambitsa zenera lazidziwitso mwa kukanikiza njira yachidule ya kiyibodi ⌘+/ (macOS) kapena Ctrl+/ (Windows).

Poyambitsa zenera lazidziwitso, mutha kusaka njira yachidule ya kiyibodi ndikuwona tsatanetsatane wa momwe mungagwiritsire ntchito mu Google Mapepala. Izi zimathandiza kuonjezera kuchita bwino komanso kugwiritsa ntchito bwino ma spreadsheets ndikukwaniritsa zokolola zambiri.

12. Njira zazifupi:

1. Ctrl + Shift + H: Bisani mizere yosankhidwa.
2. Ctrl + Shift + 9: Bisani mizati yosankhidwa.
3. Ctrl + Shift + 0: Onetsani mizati yosankhidwa.
4. Ctrl + Shift + F4: werengeraninso ma formula omwe ali patebulo.
5. Ctrl + Shift + \ : Chotsani malire kumaselo osankhidwa.
6. Ctrl + Shift + 7: Imasintha maselo osankhidwa kukhala mawonekedwe osavuta.
7. Ctrl + Shift + 1: Sinthani maselo osankhidwa kukhala mtundu wa manambala.
8. Ctrl + Shift + 5: Sinthani maselo osankhidwa kukhala mawonekedwe aperesenti.
9. Ctrl + Shift + 6: Sinthani maselo osankhidwa kukhala mtundu wa ndalama.
10. Ctrl + Shift + 2: Sinthani maselo osankhidwa kukhala mawonekedwe a nthawi.
11. Ctrl + Shift + 3: Sinthani maselo osankhidwa kukhala mawonekedwe amasiku.
12. Ctrl + Shift + 4: Sinthani maselo osankhidwa kukhala tsiku ndi nthawi.
13. Ctrl + Shift + P: Sindikizani spreadsheet.
14. Ctrl + P: Sindikizani chikalata chomwe chilipo.
15. Ctrl + Shift + S: Sungani spreadsheet.
16. Ctrl + Shift + L: Kusefa deta.
17. Ctrl + Shift + A: Sankhani maselo onse patebulo.
18. Ctrl + Shift + E: Sankhani ma cell onse pamzere wapano.
19. Ctrl + Shift + R: Sankhani maselo onse omwe ali mugawo lapano.
20. Ctrl + Shift + O: Sankhani ma cell onse omwe ali pafupi ndi selo lomwe lilipo.

Njira zowonjezera zachidule za Google Sheets:

1. Ctrl + Shift + F3: Kuchotsa masanjidwe onse pamaselo osankhidwa.
2. Ctrl + D: Koperani mtengo kuchokera pa selo yapamwamba kupita ku selo yapansi.
3. Ctrl + Shift + D: Lembani fomula kuchokera pa selo yapamwamba kupita ku selo yapansi.
4. Ctrl + Shift + U: Chepetsani kukula kwa font mumaselo osankhidwa.
5. Ctrl + Shift + +: Wonjezerani kukula kwa mafonti m'maselo osankhidwa.
6. Ctrl + Shift + K: Onjezani ulalo watsopano kuselo yosankhidwa.
7. Ctrl + Alt + M: Yambitsani gawo la "Masulirani" ndikumasulira zomwe zili m'chilankhulo china.
8. Ctrl + Alt + R: Ikani ma equation obisika patebulo.
9. Ctrl + Alt + C: Kuwerengera ziwerengero zamaselo osankhidwa.
10. Ctrl + Alt + V: Onetsani mtengo weniweni wa fomula mu selo yosankhidwa.
11. Ctrl + Alt + D: Itsegula bokosi lazokambirana la Conditionals.
12. Ctrl + Alt + Shift + F: Tsegulani bokosi la dialog Cell Format.
13. Ctrl + Alt + Shift + P: Tsegulani Zosankha Zosindikiza.
14. Ctrl + Alt + Shift + E: Imatsegula zokambirana za Export.
15. Ctrl + Alt + Shift + L: Imatsegula bokosi la Manage Subscriptions.
16. Ctrl + Alt + Shift + N: Pangani template yatsopano.
17. Ctrl + Alt + Shift + H: Bisani mitu ndi manambala m’mizere ndi mizati.
18. Ctrl + Alt + Shift + Z: Sankhani maselo onse omwe ali ndi mfundo zofanana.
19. Ctrl + Alt + Shift + X: Sankhani maselo onse omwe ali ndi makhalidwe apadera.
20. Ctrl + Alt + Shift + S: Sankhani maselo onse omwe ali ndi mawonekedwe ofanana.

Njira zazifupizi ndizotsogola:

Muyenera kudziwa zambiri ndi Google Mapepala. Njira zazifupi komanso maluso apamwamba zitha kuphunziridwa poyang'ana izi:

1. Ctrl + Shift + Lowani: Lowetsani mndandanda wamitundu yosiyanasiyana mu cell yomwe mwasankha.
2. Ctrl + Shift + L: Lowetsani mndandanda wotsitsa wa selo yosankhidwa.
3. Ctrl + Shift + M: Ikani ndemanga mu selo yosankhidwa.
4. Ctrl + Shift + T: Imasintha kuchuluka kwa data kukhala tebulo.
5. Ctrl + Shift + Y: Ikani barcode mu selo yosankhidwa.
6. Ctrl + Shift + F10: Imawonetsa mndandanda wazosankha zomwe zilipo pa cell yomwe yasankhidwa.
7. Ctrl + Shift + G: Pezani ma cell omwe ali ndi zinthu zinazake.
8. Ctrl + Shift + Q: Onjezani batani Lowongolera ku cell yosankhidwa.
9. Ctrl + Shift + E: Onjezani tchati patebulo.
10. Ctrl + Shift + I: Amapanga Mapangidwe Okhazikika a maselo osankhidwa.
11. Ctrl + Shift + J: Ikani masanjidwe oyambira m'maselo osankhidwa.
12. Ctrl + Shift + O: Sankhani malo onse a tebulo.
13. Ctrl + Shift + R: Imasintha mawu kukhala zilembo zazikulu kapena zazing'ono.
14. Ctrl + Shift + S: Sinthani tebulo kukhala chithunzi.
15. Ctrl + Shift + U: Ikani mizere yopingasa m'maselo osankhidwa.
16. Ctrl + Shift + W: Ikani mizere yowongoka m'maselo osankhidwa.
17. Ctrl + Shift + Z: Bwezerani zomwe zachitika pomaliza.
18. Ctrl + Alt + Shift + F: Pangani mawonekedwe amtundu wa cell.
19. Ctrl + Alt + Shift + U: Ikani chizindikiro cha Unicode mu cell yomwe mwasankha.
20. Ctrl + Alt + Shift + V: Ikani Gwero la Data mu selo losankhidwa.

Kusiyana pakati pa Google ndi Office spreadsheets

Google Mapepala ndi Microsoft Excel ndi masamba awiri otchuka kwambiri pantchito ndi moyo watsiku ndi tsiku. Ngakhale mapulogalamu onsewa amagwira ntchito zofanana, amasiyana mwanjira zina. Nazi zina mwazosiyana pakati pa Google Sheets ndi Office:

1. Kufikira pulogalamu:
   Pomwe Microsoft Excel imayikidwa pa PC, Mapepala a Google amapezeka kudzera pa msakatuli komanso pa intaneti.
2. Kugwirizana ndi kugawana:
   Mapepala a Google ndiwosavuta kugawana ndi kugwirizana ndi ena, chifukwa ogwiritsa ntchito angapo amatha kugwira ntchito pa spreadsheet nthawi imodzi, kupereka ndemanga pamaselo ndikugawana nthawi yeniyeni.
3. Mtundu ndi kapangidwe:
   Microsoft Excel imakonda kukhala yosinthika pamapangidwe ndi kapangidwe kake, popeza Excel imapereka mawonekedwe apamwamba komanso mafonti osiyanasiyana, mitundu, ndi zotsatira.
4. Zida ndi mawonekedwe:
   Microsoft Excel ili ndi zida zambiri zapamwamba ndi mawonekedwe, monga matebulo a periodic, ma chart amoyo, ndi kusanthula kwapamwamba kwamawerengero. Ngakhale Mapepala a Google ndi osavuta, osavuta komanso osinthika, zomwe zimapangitsa kuti zikhale zoyenera kwa ogwiritsa ntchito omwe akufunafuna njira zosavuta komanso zosavuta.
5. Kuphatikiza ndi mautumiki ena:
   Mapepala a Google amakhala ndi kuphatikiza kosagwirizana ndi ntchito zina za Google, monga Google Drive, Google Docs, Google Slides, ndi zina zambiri, pomwe Microsoft Excel imakhala ndi kuphatikiza kosagwirizana ndi zinthu zina za Microsoft, monga Mawu, PowerPoint, Outlook, ndi zina zambiri.
6. mtengo:
   Mapepala a Google ndi aulere kwa aliyense, koma muyenera kulipira chindapusa kuti mutengere mwayi pa Microsoft Excel.
7. Chitetezo:
   Google Sheets ndiyotetezeka kusunga data chifukwa data imabisidwa yokha ndikusungidwa mumtambo pa maseva a Google omwe ali otetezedwa ndi mawu achinsinsi amphamvu komanso umisiri wapamwamba wachitetezo. Ngakhale mafayilo a Microsoft Excel amasungidwa pa chipangizo chanu, pamafunika kusunga zosunga zobwezeretsera ndikuteteza chipangizo chanu ndi mawu achinsinsi amphamvu.
8. chithandizo:
   Google imapereka maphunziro ndi gulu lalikulu lothandizira, pomwe thandizo la Microsoft likupezeka kudzera pa foni, imelo, ndi intaneti.
9. Zofunikira zaukadaulo:
   Google Sheets ili pa intaneti, zomwe zikutanthauza kuti imafunika intaneti kuti ipeze ndikusintha deta. Ngakhale Microsoft Excel ingagwiritsidwe ntchito popanda kufunikira kwa intaneti, zomwe zimapangitsa kuti zikhale zoyenera kwa ogwiritsa ntchito omwe amafunika kupeza deta popanda intaneti.
10. Gwiritsani ntchito pazida zam'manja:
    Mapepala a Google amapangitsa kuti zikhale zosavuta komanso zosavuta kupeza ndikusintha deta pa mafoni ndi mapiritsi, pamene Microsoft Excel imafuna kuti pulogalamu ya Excel yam'manja iyikidwe kuti ipeze ndikusintha deta.

Kawirikawiri, ogwiritsa ntchito ayenera kusankha mapulogalamu omwe amakwaniritsa zosowa zawo, kaya Google Sheets kapena Microsoft Excel. Mapulogalamu onsewa amatha kutsitsidwa ndikugwiritsidwa ntchito kwaulere kuti adziwe yomwe ili yabwino kwa munthu payekha kapena bizinesi.

Kodi njira yachidule ya Google Sheets yomwe mumakonda ndi iti

Njira zazifupi zomwe tazitchula pamwambapa ndi zina mwazomwe zimagwiritsidwa ntchito kwambiri mu Google Sheets, koma palinso njira zazifupi zina zambiri zomwe zingagwiritsidwe ntchito kuti zitheke komanso zokolola. Mwa njira zazifupi izi:

•  Njira yachidule ya kiyibodi ya Shift+Space kuti musankhe mzere womwe ulipo.
•  Njira yachidule ya kiyibodi Ctrl+Space kuti musankhe ndime yomwe ilipo.
•  Ctrl+Shift+V Matani mawu osasintha.
•  Alt+Enter (Windows) kapena Option+Enter (macOS) njira yachidule ya kiyibodi kuti muyike mzere watsopano muselo.
•  Njira yachidule ya kiyibodi Ctrl+Alt+Shift+K kuti mutsegule mndandanda wamafupi omwe alipo.

Mukamagwiritsa ntchito njira zazifupizi ndi zina zabwino, mutha kuwongolera magwiridwe antchito ndi zokolola mu Google Sheets, ndikusunga nthawi ndi mphamvu pakuwongolera ndi kukonza data yanu.