Iindlela ezimfutshane ezili-11 zikaGoogle

I-Google Sheets inokuba nengqondo ngakumbi kwaye isengqiqweni ukuyisebenzisa kubantu abangenayo inkqubo Microsoft Kwaye bathanda ukusebenzisa i-spreadsheets ukuqhuba ishishini labo elincinci. Ngokucacileyo sebenzisa AmaSpredishithi eGoogle Ukutshintsha phakathi kwekhibhodi kunye nemouse kunzulu, yiyo loo nto abasebenzisi bezama ukubandakanya iindlela ezimfutshane zebhodi yezitshixo kumsebenzi wabo. Iindlela ezimfutshane zekhibhodi ezisuka kuGoogle Docs okanye ezimfutshane zekhibhodi ezisuka kwiMacOS zinokusetyenziselwa ukuphucula ukuhamba kwazo. Ke, siza kugubungela ezona ndlela zimfutshane zibalulekileyo zikaGoogle kubasebenzisi bekhibhodi. Masiqale!

1. Khetha imiqolo kunye neekholamu

Xa usebenza kwi-spreadsheets kuxwebhu lwaMashidi, kunokudinisa ukukhetha amaqela amakhulu emigca kunye neekholamu ngemouse, enokuthi idle ixesha kwaye ingasebenzi. Ukusombulula le ngxaki, iindlela ezimfutshane zebhodi yezitshixo zingasetyenziswa ngokukhawuleza ukukhetha umqolo opheleleyo okanye ikholamu kwiphepha, apho iCtrl + Isithuba sinokucinezelwa ukukhetha umhlathi, kunye noShift + Isithuba ukukhetha umqolo, kwaye oku konga ixesha elininzi. kunye nomgudu. Igridi epheleleyo yeeseli nazo zinokukhethwa kusetyenziswa indlela emfutshane Ctrl+A okanye ⌘+A (macOS), esebenza kakuhle kwaye igcina ixesha ekukhetheni.

2. Cola ngaphandle kokufomatha

Xa kukotshwa idatha esuka kwamanye amaphepha, ulwazi olukhutshelweyo lusenokuqulatha ukufomatha okukhethekileyo okufana nobukhulu befonti, imibala, kunye nokufomatha kweeseli, ezisenokunganqweneleki xa zincanyathiselwe kwi-spreadsheet. Ukusebenzela malunga nale ngxaki, indlela emfutshane yebhodi yezitshixo ingasetyenziswa ukuncamathisela idatha ngaphandle kokufomatha, ke endaweni yokucinezela ⌘+V, ungacinezela ⌘+Shift+V (macOS) okanye Ctrl+Shift+V (Windows) ukuncamathisela. idata ngaphandle kokufomatha. Le ndlela imfutshane inceda ukususa nakuphi na ukufomatha okungafunwayo kwaye ikuvumela ukuba ukope kuphela idatha ekrwada, yenza idatha ibonakale ngakumbi kwaye kulula ukuyisebenzisa.

3. Faka imida

Xa usebenza kwiphepha elikhulu ledatha, kunokuba nzima ukwahlula phakathi kwedatha ngamanye amaxesha, yiyo loo nto i-Spreadsheets ikuvumela ukuba ungeze imida ukugqamisa iiseli. Unokongeza imida kuzo zonke, icala elinye, okanye ngaphezulu kwiseli nganye. Ukongeza imida kuwo onke amacala eseli, cofa indlela emfutshane yebhodi yezitshixo ⌘+Shift+7 (macOS) okanye Ctrl+Shift+7 (Windows).

Xa ugqibile kwaye ufuna ukususa imida, ungasebenzisa indlela emfutshane yebhodi yezitshixo uKhetho+Shift+6 (macOS) okanye Alt+Shift+6 (Windows) ukususa imida eyongezwe ngaphambili ngokucofa ngokulula kwiseli okanye uluhlu ofuna ukulwenza. susa imida. Eli gama lifutshane linceda ukunyusa ukucaca kwedatha kwaye iyenze ifundeke ngakumbi kwaye isebenziseke.

4. Ulungelelwaniso lwedatha

Ukwenza idatha yakho ibonakale ihambelana kwaye icwangciswe kwiphepha, unokufezekisa oku ngokulungelelanisa iiseli. Kukho iindlela ezintathu zokulungelelanisa iiseli: ekhohlo, ekunene, nasembindini. Ukufezekisa oku, ungacofa indlela emfutshane yebhodi yezitshixo ⌘+Shift+L (macOS) okanye Ctrl+Shift+L (Windows) ukuze uchwetheze ngasekhohlo, ⌘+Shift+R okanye Ctrl+Shift+R ukuchwetheza ekunene, indlela emfutshane ⌘+Shift +E okanye Ctrl+Shift+E ukulungelelanisa embindini.

Ngokusebenzisa la manyathelo, ukucwangciswa kwedatha kunokucwangciswa ngakumbi kwaye kuhle, kwaye kube nenkangeleko ekulula ukuyifunda nokuyiqonda.

5. Faka umhla kunye nexesha

Ukongeza umhla kunye nexesha sesinye sezona zenzo zisetyenziswa kakhulu kwi-Google Sheets, kwaye ukufezekisa oku, umsebenzisi kufuneka azi iindlela ezimfutshane ezichanekileyo zebhodibhodi. Umhla kunye nexesha zingangeniswa kube kanye, okanye zingongezwa ngokwahlukeneyo.

Ukufaka umhla kunye nexesha kunye, indlela emfutshane ye-keyboard inokucofa ⌘+Ukhetho+Shift+; (KwiMacOS) okanye Ctrl+Alt+Shift+; (iiWindows). Ukongeza umhla wangoku, cofa ⌘+; okanye Ctrl+;, kwaye ukongeza ixesha langoku, ungacinezela indlela emfutshane ⌘+Shift+; okanye Ctrl+Shift+;.

Ngokusebenzisa ezi ndlela zimfutshane, unokonga ixesha, ukongeza umhla kunye nexesha ngokukhawuleza kwaye kulula, kwaye ufezekise ixesha elichanekileyo kunye nokurekhoda komhla.

6. Fomatha idatha kwimali

Masithi wongeze idatha kwiphepha lomsebenzi kodwa amaxabiso afakiweyo ngamanani nje, ungaziguqula ezi seli kwaye ufomethe idatha ukuba ibe kwifomati yemali oyifunayo.

Ukuguqula idatha yeseli kwifomathi yemali, ungakhetha zonke iiseli eziqulethe amanani, emva koko ucinezele i-keyboard enqumlayo I-Ctrl + Shift + 4.

Ngale ndlela imfutshane, idatha yeseli ifomathwa ngokukhawuleza kwaye iguqulelwe kwifomathi yemali, ukonga ixesha kunye nomgudu kwidatha yokufomatha ngesandla.

7. Yongeza amakhonkco

Nokuba ugcina uluhlu lwabakhuphisana nabo okanye wenze iiwebhusayithi zemithombo, unokongeza i-hyperlink kwi-spreadsheets Uphando Ukwenza iindawo zokuvula zibe lula kakhulu.

Ukongeza i-hyperlink, indlela emfutshane ye-keyboard inokucinezelwa ⌘+K (kwi-macOS) okanye Ctrl + K (Windows) kwaye uncamathisele ikhonkco ofuna ukulongeza. Ukongeza, amakhonkco anokuvulwa ngokuthe ngqo ngokucofa kuyo kwaye ucinezele uKhetho + Faka (macOS) okanye Alt + Ngena (kwinkqubo Windows).

Ngokusebenzisa la manyathelo, kunokwenzeka ukuququzelela ukufikelela kwiindawo ezibalulekileyo kunye nokufezekisa ukusetyenziswa ngokufanelekileyo kwee-spreadsheets.

8. Yongeza imiqolo kunye neentsika

Enye yezinto eziphazamisayo ekusebenziseni i-Google Sheets yayikukuba ukusebenzisa ibar yesixhobo ukongeza imiqolo kunye neekholamu yinto yokwenyani. Nangona kunjalo, nje ukuba ufumene iindlela ezimfutshane zekhibhodi, awusoze ubuyele kwindlela yakudala.

• Faka umqolo ongentla: cofa Ctrl + Ukhetho + Mna emva koko R okanye Ctrl + Alt + Mna emva koko R .
• Ukufaka umqolo ongezantsi: Cofa Ctrl + Ukhetho + Mna emva koko B okanye Ctrl + Alt + I emva koko B .
• Faka ikholamu ekhohlo: cofa Ctrl + Ukhetho + Mna emva koko C okanye Ctrl + Alt + Mna emva koko C .
• Faka ikholamu ekunene: cofa Ctrl + Ukhetho + Mna emva koko O okanye Ctrl + Alt + Mna emva koko O .

9. Cima imiqolo kunye neekholamu

Njengokufaka imiqolo kunye neekholamu, ukuzicima kunokuba ngumngeni, kodwa kwi-spreadsheets Uphando Isifinyezo sinokusetyenziswa ukwenza inkqubo ibe lula.

Umqolo wangoku ungacinywa ngokucinezela indlela emfutshane yebhodibhodi Ctrl+Ukhetho+E Emva koko D. Ukucima ikholamu, ungacinezela indlela emfutshane Ctrl+Ukhetho+E Emva koko E kwakhona.

Ngokusebenzisa la manyathelo, imiqolo kunye namakholomu angacinywa ngokukhawuleza kwaye kulula, ukugcina ixesha kunye nomgudu kwinkqubo yokulungelelanisa idatha kunye nokutshintsha isakhiwo ukuze sihambelane neemfuno ezahlukeneyo.

10. Yongeza uluvo

Amagqabantshintshi angongezwa nakweyiphi na iseli okanye iqela leeseli kwiishiti zikaGoogle ngokulula usebenzisa iindlela ezimfutshane ezifanelekileyo.

Kwaye ngokucofa indlela emfutshane yebhodibhodi ⌘+Ukhetho+M (macOS) okanye Ctrl+Alt+M (macOS). Windows)-Unokongeza uluvo kwiseli ekhethiweyo okanye iqela elikhethiweyo.

Ngokongeza izimvo, amanqaku abalulekileyo, ukucaciswa, kunye nemiyalelo ehambelana nedatha ingabhalwa, enceda ukuphucula unxibelelwano kunye nokulungelelaniswa phakathi kwabasebenzisi kunye nokufezekisa ukusetyenziswa ngokufanelekileyo kweespredishithi.

11. Bonisa iwindow enqumlayo ye-keyboard

Olu luhlu lungentla alubandakanyi zonke iindlela ezimfutshane zebhodi yezitshixo ezifumanekayo kuMashidi kaGoogle, kodwa lugubungela ezona ziluncedo kakhulu. Nasiphi na isinqumli sebhodi yezitshixo zikaGoogle sinokufunyanwa ngokuzisa ifestile yolwazi ngokucinezela indlela emfutshane yebhodi yezitshixo ⌘+/ (macOS) okanye Ctrl+/ (Windows).

Ngokuzisa ifestile yolwazi, unokukhangela nasiphi na isinqumli sebhodibhodi kwaye ujonge inkcazo eneenkcukacha zokuyisebenzisa kuMashidi kaGoogle. Oku kunceda ukwandisa ukusebenza kunye nokusebenza kakuhle ekusebenziseni i-spreadsheets kunye nokufezekisa imveliso ephezulu.

12. Ezinye iindlela ezimfutshane:

1. Ctrl + Shift + H: Fihla imiqolo ekhethiweyo.
2. Ctrl + Shift + 9: Fihla iikholamu ezikhethiweyo.
3. Ctrl + Shift + 0: Ungafihli imiqolo ekhethiweyo.
4. Ctrl + Shift + F4: Bala kwakhona iifomyula kwitheyibhile.
5. Ctrl + Shift + \ : Susa imida kwiiseli ezikhethiweyo.
6. Ctrl + Shift + 7: Guqula iiseli ezikhethiweyo zibe yifomati yokubhaliweyo engenanto.
7. Ctrl + Shift + 1: Guqula iiseli ezikhethiweyo kwifomathi yenani.
8. Ctrl + Shift + 5: Guqula iiseli ezikhethiweyo kwifomati yepesenti.
9. Ctrl + Shift + 6: Guqula iiseli ezikhethiweyo kwifomati yemali.
10. Ctrl + Shift + 2: Guqula iiseli ezikhethiweyo kwifomati yexesha.
11. Ctrl + Shift + 3: Guqula iiseli ezikhethiweyo zibe yifomati yomhla.
12. Ctrl + Shift + 4: Guqula iiseli ezikhethiweyo zibe ngumhla kunye nefomati yexesha.
13. Ctrl + Shift + P: Shicilela i-spreadsheet.
14. Ctrl + P: Shicilela uxwebhu lwangoku.
15. Ctrl + Shift + S: Gcina i-spreadsheet.
16. Ctrl + Shift + L: Ukucoca idatha.
17. Ctrl + Shift + A: Khetha zonke iiseli ezikwitafile.
18. Ctrl + Shift + E: Khetha zonke iiseli kumqolo wangoku.
19. Ctrl + Shift + R: Khetha zonke iiseli ezikuluhlu lwangoku.
20. Ctrl + Shift + O: Khetha zonke iiseli kwindawo ejikeleze iseli yangoku.

Iseti yeendlela ezimfutshane ezongezelelweyo zeGoogle Sheets:

1. Ctrl + Shift + F3: Ukususa konke ukufomatha kwiiseli ezikhethiweyo.
2. Ctrl + D: Khuphela ixabiso ukusuka kwiseli ephezulu ukuya kwiseli esezantsi.
3. Ctrl + Shift + D: Khuphela ifomula ukusuka kwiseli ephezulu ukuya kwiseli esezantsi.
4. Ctrl + Shift + U: Nciphisa ubungakanani befonti kwiiseli ezikhethiweyo.
5. Ctrl + Shift + +: Yandisa ubungakanani befonti yeeseli ezikhethiweyo.
6. Ctrl + Shift + K: Yongeza ikhonkco elitsha kwiseli ekhethiweyo.
7. Ctrl + Alt + M: Vula inqaku elithi "Guqulela" kwaye uguqulele umxholo kolunye ulwimi.
8. Ctrl + Alt + R: Faka iiequation ezifihliweyo kwitafile.
9. Ctrl + Alt + C: Ibala izibalo zeeseli ezikhethiweyo.
10. Ctrl + Alt + V: Bonisa elona xabiso lefomula kwiseli ekhethiweyo.
11. Ctrl + Alt + D: Ivula ibhokisi yencoko yababini yeMiqathango.
12. Ctrl + Alt + Shift + F: Ivula ibhokisi yencoko yababini yeeSeli zokuFomatha.
13. Ctrl + Alt + Shift + P: Ivula iiNdlela zokuShicilela iingxoxo.
14. Ctrl + Alt + Shift + E: Ivula incoko yababini yokuThumela ngaphandle.
15. Ctrl + Alt + Shift + L: Ivula i Lawula imirhumo yencoko yababini.
16. Ctrl + Alt + Shift + N: Yenza itemplate entsha.
17. Ctrl + Alt + Shift + H: Fihla izihloko kunye namanani kwimiqolo kunye neekholamu.
18. Ctrl + Alt + Shift + Z: Khetha zonke iiseli eziqulethe ixabiso eliphindwe kabini.
19. Ctrl + Alt + Shift + X: Khetha zonke iiseli eziqulethe amaxabiso awodwa.
20. Ctrl + Alt + Shift + S: Khetha zonke iiseli eziqulethe iifomula ezifanayo.

Ezi ndlela zimfutshane zihambele phambili:

Amava angakumbi ngamaPhepha kaGoogle ayafuneka. Ezinye iindlela ezimfutshane kunye nezakhono eziphambili zinokufundwa ngokujonga:

1. Ctrl + Shift + Faka: Faka ifomyula yoluhlu kwiseli ekhethiweyo.
2. Ctrl + Shift + L: Faka uluhlu lokuhla lweseli ekhethiweyo.
3. Ctrl + Shift + M: Faka uluvo kwiseli ekhethiweyo.
4. Ctrl + Shift + T: Guqula uluhlu lwedatha kwitafile.
5. Ctrl + Shift + Y: Faka ibhakhowudi kwiseli ekhethiweyo.
6. Ctrl + Shift + F10: Ibonisa uluhlu lweenketho ezikhoyo kwiseli ekhethiweyo.
7. Ctrl + Shift + G: Fumana iiseli eziqulethe amaxabiso athile.
8. Ctrl + Shift + Q: Yongeza iQhosha loLawulo kwiseli ekhethiweyo.
9. Ctrl + Shift + E: Yongeza itshathi kwitafile.
10. Ctrl + Shift + I: Yenza ukuFomatha okuneMiqathango yeeseli ezikhethiweyo.
11. Ctrl + Shift + J: Faka ukufomatha kwangaphambili kwiiseli ezikhethiweyo.
12. Ctrl + Shift + O: Khetha yonke indawo yetafile.
13. Ctrl + Shift + R: Guqula umbhalo ube ngoonobumba abakhulu okanye abancinane.
14. Ctrl + Shift + S: Guqula itafile ibe ngumfanekiso.
15. Ctrl + Shift + U: Faka imigca ethe tye kwiiseli ezikhethiweyo.
16. Ctrl + Shift + W: Faka imigca ethe nkqo kwiiseli ezikhethiweyo.
17. Ctrl + Shift + Z: Hlehlisa intshukumo yokugqibela.
18. Ctrl + Alt + Shift + F: Yenza iifomati zeseli eziqhelekileyo.
19. Ctrl + Alt + Shift + U: Faka isimboli ye-Unicode kwiseli ekhethiweyo.
20. Ctrl + Alt + Shift + V: Faka uMthombo weDatha kwiseli ekhethiweyo.

Umahluko phakathi kwe-Google kunye ne-Ofisi spreadsheets

IiSpredishithi zikaGoogle kunye neMicrosoft Excel zispredishithi ezimbini ezidume kakhulu emsebenzini nakubomi bemihla ngemihla. Nangona zombini iinkqubo zenza imisebenzi esisiseko efanayo, ziyahluka ngeendlela ezithile. Nazi ezinye zeeyantlukwano phakathi kwaMashidi kaGoogle kunye neOfisi:

1. Ukufikelela kwinkqubo:
   Ngelixa iMicrosoft Excel ifakwe kwiPC, iGoogle Sheets ifumaneka ngesikhangeli nakwi-Intanethi.
2. Intsebenziswano kunye nokwabelana:
   I-Google Sheets kulula ngakumbi ukwabelana kunye nokusebenzisana nabanye, njengoko abasebenzisi abaninzi banokusebenza kwi-spreadsheet ngaxeshanye, baphawule kwiiseli kwaye babelane ngexesha lokwenyani.
3. Ubume kunye noyilo:
   I-Microsoft Excel ithande ukuba bhetyebhetye ngakumbi ekufomathani nasekuyilweni, njengoko i-Excel ibonelela ngeemilo eziphambili kunye noluhlu olubanzi lweefonti, imibala, kunye neziphumo.
4. Izixhobo kunye neempawu:
   IMicrosoft Excel inoluhlu olubanzi lwezixhobo eziphambili kunye neempawu, ezinje ngetafile zeperiodic, iitshathi eziphilayo, kunye nohlalutyo oluphambili lwamanani. Ngoxa i-Google Sheets ilula, ilula kwaye iguquguqukayo, eyenza ukuba ifaneleke ngakumbi kubasebenzisi abafuna izisombululo ezilula nezithe ngqo.
5. Ukudityaniswa nezinye iinkonzo:
   I-Google Sheets iquka udibaniso olungenamthungo kunye nezinye iinkonzo zikaGoogle, ezifana ne-Google Drive, Google Docs, Google Slides, kunye nokunye, ngelixa iMicrosoft Excel inesidibaniselwano esingenamthungo kunye nezinye iimveliso zeMicrosoft, ezifana neLizwi, iPowerPoint, i-Outlook, kunye nokunye.
6. ixabiso:
   I-Google Sheets isimahla kuye wonke umntu, kodwa kufuneka uhlawule umrhumo wokubhalisa ukuze uthathe ithuba leMicrosoft Excel.
7. Ukhuseleko:
   I-Google Sheets ikhuseleke ngakumbi ukugcina idatha njengoko idatha iguqulelwa ngokuntsonkothileyo kwaye igcinwe kwilifu kwiiseva zikaGoogle ezikhuselwe ngamagama ayimfihlo awomeleleyo kunye nobuchwepheshe bokhuseleko obuphambili. Ngelixa iifayile zeMicrosoft Excel zigcinwe kwisixhobo sakho, ifuna ukugcina ii-backups kunye nokukhusela isixhobo sakho ngamaphasiwedi awomeleleyo.
8. inkxaso:
   UGoogle ubonelela ngezifundo kunye noluntu olukhulu lwenkxaso, ngelixa inkxaso yeMicrosoft ifumaneka ngefowuni, i-imeyile, kunye newebhu.
9. Iimfuno zobugcisa:
   I-Google Sheets ikwi-intanethi, nto leyo ethetha ukuba ifuna uqhagamshelo lwe-intanethi ukufikelela nokuhlela idatha. Ngelixa iMicrosoft Excel inokusetyenziswa ngaphandle kwesidingo soqhagamshelo lwe-intanethi, nto leyo eyenza ukuba ifaneleke ngakumbi kubasebenzisi abafuna ukufikelela kwidatha ngaphandle kweintanethi.
10. Sebenzisa kwizixhobo eziphathwayo:
    I-Google Sheets yenza kube lula kwaye kube lula ukufikelela kunye nokuhlela idatha kwii-smartphones kunye neetafile, ngelixa i-Microsoft Excel idinga i-app ye-Excel yeselula ukuba ifakwe ukufikelela kunye nokuhlela idatha.

Ngokubanzi, abasebenzisi kufuneka bakhethe isoftware ehlangabezana neemfuno zabo, nokuba yiGoogle Sheets okanye iMicrosoft Excel. Zombini ezi nkqubo zinokukhutshelwa kwaye zisetyenziswe simahla ukumisela ukuba yeyiphi eyona ilungele ukusetyenziswa komntu okanye ishishini.

Sesiphi isinqumli osithandayo kuMashidi kaGoogle

Iindlela ezimfutshane ezikhankanywe ngasentla zezinye zezona zisetyenziswa kakhulu kwi-Google Sheets, kodwa zininzi ezinye iindlela ezimfutshane eziluncedo ezinokuthi zisetyenziswe ukuphucula ukusebenza kakuhle kunye nemveliso. Phakathi kwezi ndlela zimfutshane:

•  Shift+Space isinqumli sekhibhodi ukukhetha umqolo wangoku.
•  Isinqumli se-keyboard Ctrl+Space ukukhetha umhlathi wangoku.
•  Ctrl+Shift+V Cola umbhalo ngaphandle kokufomatha.
•  Alt+Ngena (Windows) okanye Khetha+Ngena (macOS) indlela enqumlayo yekhibhodi ukufaka umgca omtsha kwiseli.
•  Izinqumli ze-keyboard Ctrl+Alt+Shift+K ukuvula uluhlu lweendlela ezimfutshane ezikhoyo.

Xa usebenzisa ezi ndlela zimfutshane kunye nezinye izenzo ezilungileyo, unokuphucula ukusebenza kakuhle kunye nemveliso kwi-Google Sheets, kwaye wonge ixesha kunye nomzamo wokulawula kunye nokulungelelanisa idatha yakho.