Pamusoro 11 Google Sheets Shortcuts

Google Sheets inogona kuve yakawedzera intuitive uye zvine musoro kushandisa kune vanhu vasina system Microsoft Uye vanoda kushandisa maspredishiti kumhanyisa bhizinesi ravo diki. Zviri pachena kushandisa Google Sheetsiti Kuchinja pakati pekhibhodi nembeva kwakasimba, ndosaka vashandisi vachiedza kubatanidza mapfupi ekhibhodi mukufamba kwavo kwebasa. Mapfupi eKibhodhi kubva kuGoogle Docs kana mapfupi ekhibhodi kubva kuMacOS anogona kushandiswa kuvandudza mafambiro avo. Saka, isu tichavhara mamwe anonyanya kukosha maGoogle Sheets mapfupi evashandisi vekhibhodi. Ngatitangei!

1. Sarudza mitsara nemakoramu

Paunenge uchishanda pamaspredishiti mugwaro reMashizha, zvinogona kunetesa kusarudza mapoka makuru emitsara nemakoramu negonzo, izvo zvinogona kutora nguva uye kusashanda. Kugadzirisa dambudziko iri, mapfupi ekhibhodi anogona kushandiswa kukurumidza kusarudza mutsara wese kana koramu pabepa, apo Ctrl + Space inogona kudzvanywa kusarudza koramu, uye Shift + Space kusarudza mutsara, uye izvi zvinochengetedza nguva yakawanda. uye kushanda nesimba. Giridhi yese yemasero inogonawo kusarudzwa uchishandisa nzira yekudimbudzira Ctrl+A kana ⌘+A (macOS), iyo inoshanda zvakanyanya uye inochengetedza nguva pakusarudza.

2. Nama pasina kufomatidza

Paunenge uchikopa data kubva kune mamwe mapepa, ruzivo rwakakopwa runogona kunge ruine mafomati akakosha senge saizi yefonti, mavara, uye fomati yesero, izvo zvingasadiwa kana zvakanamirwa muspredishiti. Kugadzirisa dambudziko iri, nzira yekudimbudzira yekhibhodi inogona kushandiswa kunamira iyo data pasina chero fomati, saka pane kudzvanya ⌘+V, unogona kudzvanya ⌘+Shift+V (macOS) kana Ctrl+Shift+V (Windows) kuti unamate. iyo data pasina chero fomati. Iyi nzira yekudimbudzira inobatsira kubvisa chero isingadiwe fomati uye inoita kuti iwe ukope chete data rakasvibirira, zvichiita kuti data rive pachena uye nyore kushandisa.

3. Shandisa Border

Paunenge uchishanda pane hombe data sheet, zvinogona kuve zvakaoma kusiyanisa pakati pe data pane dzimwe nguva, ndosaka Spreadsheets inobvumidza iwe kuwedzera miganhu kuratidza maseru. Iwe unogona kuwedzera mabhodha kune ese, rimwe, kana akawanda mativi esero rega rega. Kuti uwedzere mabhodha kumativi mana esero, tinya nzira yekudimbudzira keyboard ⌘+Shift+7 (macOS) kana Ctrl+Shift+7 (Windows).

Kana wapedza uye woda kubvisa muganho, unogona kushandisa iyo keyboard nzira yekudimbudzira Option+Shift+6 (macOS) kana Alt+Shift+6 (Windows) kuti ubvise muganhu wakambowedzerwa nekungodzvanya pasero kana kurongedza iwe. kuda kubvisa muganhu kubva. Iyi acronym inobatsira kuwedzera kujeka kwedata uye kuita kuti iverengeke uye ishandiswe.

4. Kurongeka kwedata

Kuita kuti data rako riite serakafanana uye rakarongeka pane pepa, unogona kuita izvi nekubatanidza maseru. Pane nzira nhatu dzekubatanidza maseru: kuruboshwe, kurudyi, uye pakati. Kuti uite izvi, unogona kudzvanya nzira yekudimbudzira keyboard ⌘+Shift+L (macOS) kana Ctrl+Shift+L (Windows) kuti ubate kuruboshwe, ⌘+Shift+R kana Ctrl+Shift+R kuti ubate kurudyi, nzira pfupi ⌘+Shift. +E kana Ctrl+Shift+E kurongedza pakati.

Nekushandisa matanho aya, kurongeka kweiyo data kunogona kuve kwakarongeka uye kwakanaka, nechitarisiko chiri nyore kuverenga nekunzwisisa.

5. Isa zuva uye nguva

Kuwedzera zuva nenguva ndechimwe chezviito zvinonyanya kushandiswa muGoogle Sheets, uye kuti uite izvi, mushandisi anofanirwa kuziva mapfupi ekhibhodi. Zuva uye nguva zvinogona kuiswa kamwe chete, kana zvinogona kuwedzerwa zvakasiyana.

Kuisa zuva nenguva pamwe chete, nzira yekudimbudzira yekhibhodi inogona kudzvanywa ⌘+Option+Shift+; (mu macOS) kana Ctrl+Alt+Shift+; (Windows). Kuti uwedzere zuva razvino, tinya ⌘+; kana Ctrl+;, uye kuwedzera nguva iripo, unogona kudzvanya nzira yekudimbudzira ⌘+Shift+; أو Ctrl+Shift+;.

Nekushandisa mapfupi aya, unogona kuchengetedza nguva, kuita kuwedzera zuva uye nguva nekukurumidza uye nyore, uye kuwana nguva chaiyo uye kurekodha zuva.

6. Fomati data kune mari

Ngatiti iwe wawedzera imwe data kupepa rekushanda asi iyo yakapinda kukosha ingori manhamba, unogona kushandura maseru aya nekufometa iyo data kuti ive mune yaunoda mari fomati.

Kushandura cell data kuita currency format, unogona kusarudza maseru ese ane manhamba, wobva wadzvanya keyboard shortcut Ctrl + Shift + 4.

Neiyi nzira yekudimbudzira, nharembozha inokurumidza kufomatidzwa uye kuchinjirwa kuita mari fomati, kuchengetedza nguva uye kushanda nesimba mukuita manyorerwo data.

7. Wedzera zvinongedzo

Kunyangwe iwe uchichengeta runyorwa rwevanokwikwidza kana kugadzira zviwanikwa mawebhusaiti, unogona kuwedzera hyperlink kumaspredishiti. Google Kuita kuti nzvimbo dzekuvhura dzive nyore.

Kuti uwedzere hyperlink, nzira yekudimbudzira yekhibhodi inogona kudzvanywa ⌘+K (pa macOS) kana Ctrl + K (Windows) uye isa chinongedzo chaunoda kuwedzera. Mukuwedzera, zvinongedzo zvinogona kuvhurwa zvakananga nekudzvanya pairi uye nekudzvanya Option + Enter (macOS) kana Alt + Pinda (mu system Windows).

Nekushandisa nhanho idzi, zvinokwanisika kufambisa kuwanikwa kune akakosha masayiti uye kuwana kushandiswa kwakanaka kwemaspredishiti.

8. Wedzera mitsara nemakoramu

Chimwe chezvinhu zvinoshungurudza zvekushandisa Google Sheets ndechekuti kushandisa bhara rekushandisa kuwedzera mitsara nemakoramu inhamo chaiyo. Nekudaro, kana iwe uchinge wawana mapfupi ekhibhodi, haufe wakadzokera kunzira yechinyakare.

• Isa mutsara pamusoro: dzvanya Ctrl + Option + Ini ipapo R أو Ctrl + Alt + I ipapo R .
• Kuisa mutsara pazasi: Dzvanya Ctrl + Option + I ipapo B أو Ctrl + Alt + I ipapo B .
• Isa mbiru kuruboshwe: dzvanya Ctrl + Option + I ipapo C أو Ctrl + Alt + I ipapo C .
• Isa mbiru kurudyi: dzvanya Ctrl + Option + I ipapo O أو Ctrl + Alt + I ipapo O .

9. Bvisa mitsara nemakoramu

Kungofanana nekuwedzera mitsara nemakoramu, kudzidzima kunogonawo kuve dambudziko, asi mumaspredishiti Google Chidimburidzo chinogona kushandiswa kuita kuti hurongwa huve nyore.

Mutsara uripo unogona kudzimwa nekudzvanya nzira yekudimbudzira keyboard Ctrl+Sarudzo+E Zvadaro D. Kudzima mbiru, unogona kudzvanya nzira yekudimbudzira Ctrl+Sarudzo+E Zvadaro E zvakare.

Nekushandisa matanho aya, mitsara nemakoramu anogona kubviswa nekukurumidza uye nyore, kuchengetedza nguva uye kushanda nesimba mukugadzirisa data uye kushandura chimiro kuti chienderane nezvinodiwa zvakasiyana.

10. Wedzera mhinduro

Mhinduro dzinogona kuwedzerwa kune chero sero kana boka remasero muGoogle Sheets uchishandisa mapfupi akakodzera.

Uye nekudzvanya nzira yekudimbudzira keyboard ⌘+Sarudzo+M (macOS) kana Ctrl+Alt+M (macOS). Windows)-Inogona kuwedzera mhinduro kune yakasarudzwa sero kana boka rakasarudzwa.

Nekuwedzera zvirevo, zvinyorwa zvakakosha, kujekeswa, uye mirairo ine chekuita nedata inogona kurekodhwa, iyo inobatsira kuvandudza kutaurirana nekubatana pakati pevashandisi uye kuwana kushandiswa kwakanaka kwemaspredishiti.

11. Ratidza hwindo rekudimbudzira kiibhodhi

Rondedzero iri pamusoro haisanganisire mapfupi ekhibhodi anowanikwa muGoogle Sheets, asi inovhara zvakanyanya anobatsira. Chero nzira yekudimbudzira yeGoogle Sheets keyboard inogona kuwanikwa nekuvhura iyo info hwindo nekudzvanya iyo keyboard nzira ⌘+/ (macOS) kana Ctrl+/ (Windows).

Nekutanga iyo info hwindo, unogona kutsvaga chero nzira yekudimbudzira yekhibhodi uye woona tsananguro yakadzama yemashandisiro ayo muGoogle Sheets. Izvi zvinobatsira kuwedzera kushanda uye kubudirira mukushandiswa kwemaspredishiti uye kuwana chibereko chepamusoro.

12. Mamwe mapfupi:

1. Ctrl + Shift + H: Viga mitsara yakasarudzwa.
2. Ctrl + Shift + 9: Viga makoramu akasarudzwa.
3. Ctrl + Shift + 0: Svinura makoramu akasarudzwa.
4. Ctrl + Shift + F4: Dzokorora mafomula ari patafura.
5. Ctrl + Shift + \ : Bvisa miganhu kubva kumaseru akasarudzwa.
6. Ctrl + Shift + 7: Inoshandura masero akasarudzwa kuti ave akajeka mavara fomati.
7. Ctrl + Shift + 1: Shandura masero akasarudzwa kuti ave nhamba fomati.
8. Ctrl + Shift + 5: Shandura masero akasarudzwa kuti ave muzana fomati.
9. Ctrl + Shift + 6: Shandura maseru akasarudzwa kuti ave mari fomati.
10. Ctrl + Shift + 2: Shandura masero akasarudzwa kuti ave nguva.
11. Ctrl + Shift + 3: Shandura masero akasarudzwa kuti ave mazuva.
12. Ctrl + Shift + 4: Shandura masero akasarudzwa kuti ave zuva uye nguva fomati.
13. Ctrl + Shift + P: Dhinda spreadsheet.
14. Ctrl + P: Dhinda gwaro razvino.
15. Ctrl + Shift + S: Chengetedza spreadsheet.
16. Ctrl + Shift + L: Kusefa iyo data.
17. Ctrl + Shift + A: Sarudza maseru ese ari patafura.
18. Ctrl + Shift + E: Sarudza maseru ese ari mumutsara wazvino.
19. Ctrl + Shift + R: Sarudza maseru ese ari mukoramu yazvino.
20. Ctrl + Shift + O: Sarudza masero ese munzvimbo yakatenderedza sero razvino.

Seti yemamwe mapfupi eGoogle Sheets:

1. Ctrl + Shift + F3: Kubvisa mafomati ese kubva kumaseru akasarudzwa.
2. Ctrl + D: Kopa kukosha kubva kumusoro sero kusvika pazasi sero.
3. Ctrl + Shift + D: Kopa fomula kubva kumusoro sero kusvika pazasi sero.
4. Ctrl + Shift + U: Deredza saizi yefonti mumaseru akasarudzwa.
5. Ctrl + Shift + +: Wedzera saizi yefonti mumaseru akasarudzwa.
6. Ctrl + Shift + K: Wedzera chinongedzo chitsva kune yakasarudzwa sero.
7. Ctrl + Alt + M: Shandisa "Shandura" chimiro uye shandura zviri mukati mune mumwe mutauro.
8. Ctrl + Alt + R: Isa yakavanzika equation mutafura.
9. Ctrl + Alt + C: Inoverenga nhamba dzemasero akasarudzwa.
10. Ctrl + Alt + V: Ratidza kukosha chaiko kweformula musero rakasarudzwa.
11. Ctrl + Alt + D: Inovhura iyo Conditionals dialog box.
12. Ctrl + Alt + Shift + F: Inovhura iyo Format Cells dialog box.
13. Ctrl + Alt + Shift + P: Inovhura iyo Dhinda Sarudzo dialog.
14. Ctrl + Alt + Shift + E: Inovhura iyo Export dialog.
15. Ctrl + Alt + Shift + L: Inovhura iyo Manage Subscriptions dialog.
16. Ctrl + Alt + Shift + N: Gadzira template nyowani.
17. Ctrl + Alt + Shift + H: Viga misoro uye nhamba mumitsara nemakoramu.
18. Ctrl + Alt + Shift + Z: Sarudza maseru ese ane duplicate values.
19. Ctrl + Alt + Shift + X: Sarudza ese maseru ane akasiyana maitiro.
20. Ctrl + Alt + Shift + S: Sarudza ese maseru ane mafomula akafanana.

Aya mapfupi ane emberi:

Kuwedzera ruzivo neGoogle Sheets kunodiwa. Mamwe mapfupi uye hunyanzvi hwepamberi hunogona kudzidzwa nekutarisa:

1. Ctrl + Shift + Pinda: Isa iyo yakarongwa fomula muchitokisi chakasarudzwa.
2. Ctrl + Shift + L: Isa rondedzero yekudonha yesero rakasarudzwa.
3. Ctrl + Shift + M: Isa chirevo muchitokisi chakasarudzwa.
4. Ctrl + Shift + T: Inoshandura huwandu hwe data kuita tafura.
5. Ctrl + Shift + Y: Isa bhakodhi musero rakasarudzwa.
6. Ctrl + Shift + F10: Inoratidza rondedzero yesarudzo dziripo kune yakasarudzwa sero.
7. Ctrl + Shift + G: Tsvaga maseru ane chaiwo maitiro.
8. Ctrl + Shift + Q: Wedzera Bhatani Rokudzora kune yakasarudzwa sero.
9. Ctrl + Shift + E: Wedzera chati kutafura.
10. Ctrl + Shift + I: Inogadzira Mamiriro Ekugadzirisa emasero akasarudzwa.
11. Ctrl + Shift + J: Isa preconditional fomati mumaseru akasarudzwa.
12. Ctrl + Shift + O: Sarudza nzvimbo yese yetafura.
13. Ctrl + Shift + R: Inoshandura mavara kuva makuru kana maduku.
14. Ctrl + Shift + S: Shandura tafura kuita mufananidzo.
15. Ctrl + Shift + U: Isa mitsetse yakachinjika mumasero akasarudzwa.
16. Ctrl + Shift + W: Isa mitsetse yakatwasuka mumaseru akasarudzwa.
17. Ctrl + Shift + Z: Bvisa chiito chekupedzisira.
18. Ctrl + Alt + Shift + F: Gadzira mafomati emusero.
19. Ctrl + Alt + Shift + U: Isa chiratidzo che Unicode muchitokisi chakasarudzwa.
20. Ctrl + Alt + Shift + V: Inoisa iyo Data Source musero rakasarudzwa.

Musiyano uripo pakati peGoogle neHofisi maspredishiti

Google Sheets neMicrosoft Excel maviri ane mukurumbira maspredishiti pabasa uye nehupenyu hwezuva nezuva. Kunyangwe mapurogiramu ese ari maviri achiita mabasa akafanana, anosiyana mune zvimwe zvinhu. Heano mimwe yemisiyano pakati peGoogle Sheets neHofisi:

1. Kuwana chirongwa:
   Nepo Microsoft Excel yakaiswa paPC, Google Sheets inowanikwa kuburikidza nebrowser uye paInternet.
2. Kudyidzana uye kugovana:
   Google Sheets yakatonyanya nyore kugovera uye kubatana nevamwe, sezvo vashandisi vazhinji vanogona kushanda paspredishiti panguva imwe chete, kutaura pamaseru uye kugovera munguva chaiyo.
3. Format uye dhizaini:
   Microsoft Excel inoita kunge inoshanduka-shanduka mukugadzirisa uye kugadzira, sezvo Excel inopa maumbirwo epamberi uye akasiyana mafonti, mavara, uye mhedzisiro.
4. Zvishandiso uye maitiro:
   Microsoft Excel ine huwandu hwakasiyana hwezvishandiso zvepamberi uye maficha, akadai seperiodic matafura, machati mhenyu, uye kuongororwa kwenhamba. Nepo Google Sheets iri nyore, iri nyore uye inochinjika, izvo zvinoita kuti ive yakakodzera kune vashandisi vari kutsvaga mhinduro dzakapusa uye dzakananga.
5. Kubatanidzwa nemamwe masevhisi:
   Google Sheets inoratidzira kusanganisa isina musono nemamwe masevhisi eGoogle, akadai seGoogle Drive, Google Docs, Google Slides, uye nezvimwe, nepo Microsoft Excel inoratidzira kusanganisa kwakabatana nezvimwe zvigadzirwa zveMicrosoft, seIzwi, PowerPoint, Outlook, nezvimwe.
6. mutengo:
   Google Sheets ndeyemahara kune wese munhu, asi iwe unofanirwa kubhadhara mubhadharo wekunyorera kutora mukana weMicrosoft Excel.
7. Safety:
   Google Sheets yakachengeteka kuchengetedza data sezvo data ichingovharidzirwa uye ichichengetwa mugore pamasevha eGoogle akachengetedzwa nemapassword akasimba uye matekinoroji epamusoro ekuchengetedza. Nepo mafaera eMicrosoft Excel akachengetwa pachishandiso chako, zvinoda kuchengetedza mabhapu uye kuchengetedza mudziyo wako nemapassword akasimba.
8. rutsigiro:
   Google inopa zvidzidzo uye nharaunda yakakura yerutsigiro, nepo Microsoft rutsigiro rwunowanikwa kuburikidza nerunhare, email, uye webhu.
9. Zvido zvehunyanzvi:
   Google Sheets iri online, zvinoreva kuti inoda chinongedzo cheinternet kuti uwane uye kugadzirisa data. Nepo Microsoft Excel inogona kushandiswa pasina kudiwa kweinternet, izvo zvinoita kuti ive yakakodzera kune vashandisi vanoda kuwana data kunze kwenyika.
10. Shandisa pane nharembozha:
    Google Sheets inoita kuti zvive nyore uye zviri nyore kuwana uye kugadzirisa data pama smartphones uye mahwendefa, nepo Microsoft Excel inoda kuti mobile Excel app iiswe kuti iwane uye kugadzirisa data.

Kazhinji, vashandisi vanofanira kusarudza software inonyatsoita zvavanoda, ingave Google Sheets kana Microsoft Excel. Mapurogiramu ese ari maviri anogona kutorwa uye kushandiswa mahara kuona kuti ndeipi yakanakira munhu kana bhizinesi kushandiswa.

Ndeipi nzira yekudimbudzira yaunofarira paGoogle Sheets

Mapfupi ataurwa pamusoro apa angori mamwe eanonyanya kushandiswa muGoogle Sheets, asi kune mamwe akawanda anobatsira mapfupi anogona kushandiswa kuvandudza mashandiro nekubudirira. Pakati pezvipfupi izvi:

•  Shift+Space keyboard shortcut kuti usarudze mutsara uripo.
•  Kiyibhodhi nzira yekudimbudzira Ctrl+Space kuti usarudze koramu iripo.
•  Ctrl+Shift+V Namira mavara pasina kufomatidza.
•  Keyboard shortcut Alt+Enter (Windows) kana Sarudzo+Enter (macOS) Inopinza mutsara mutsva muchitokisi.
•  Kudimbudzira kiyibhodhi Ctrl+Alt+Shift+K kuvhura rondedzero yemapfupi anowanikwa.

Paunoshandisa mapfupi aya uye mamwe maitiro akanaka, unogona kuvandudza kugona uye kugadzirwa muGoogle Sheets, uye chengetedza nguva nekuedza kubata uye kuronga data rako.