Manyan Hanyoyi 11 na Google Sheets

Shafukan Google na iya zama mai hankali da ma'ana don amfani ga mutanen da ba su da tsari Microsoft Kuma suna son yin amfani da maƙunsar rubutu don gudanar da ƙananan kasuwancin su. Babu shakka amfani Google Sheets Canjawa tsakanin madannai da linzamin kwamfuta yana da ƙarfi, wanda shine dalilin da ya sa masu amfani ke ƙoƙarin haɗa gajerun hanyoyin madannai a cikin aikin su. Ana iya amfani da gajerun hanyoyin keyboard daga Google Docs ko gajerun hanyoyin keyboard daga macOS don inganta aikin su. Don haka, za mu rufe wasu mahimman gajerun hanyoyin Google Sheets don masu amfani da madannai. Bari mu fara!

1. Zaɓi layuka da ginshiƙai

Lokacin aiki akan maƙunsar bayanai a cikin takaddar Sheets, yana iya zama mai gajiyawa don zaɓar manyan rukunin layuka da ginshiƙai tare da linzamin kwamfuta, wanda zai iya ɗaukar lokaci da rashin inganci. Don magance wannan matsalar, za a iya amfani da gajerun hanyoyin madannai don zaɓar jeri ko ginshiƙi da sauri a kan takardar, inda za a iya danna Ctrl + Space don zaɓar shafi, da Shift + Space don zaɓar jere, kuma wannan yana adana lokaci mai yawa. da kokari. Hakanan ana iya zaɓar gabaɗayan grid na sel ta amfani da gajeriyar hanyar Ctrl+A ko ⌘+A (macOS), wanda ya fi dacewa kuma yana adana lokaci akan zaɓi.

2. Manna ba tare da tsarawa ba

Lokacin yin kwafin bayanai daga wasu zanen gado, bayanan da aka kwafi na iya ƙunsar tsarawa na musamman kamar girman rubutu, launuka, da tsara tantanin halitta, waɗanda ƙila ba za a so idan an liƙa a cikin maƙunsar rubutu ba. Don magance wannan matsalar, ana iya amfani da gajeriyar hanyar maɓalli don liƙa bayanan ba tare da wani tsari ba, don haka maimakon danna ⌘+V, zaku iya danna ⌘+Shift+V (macOS) ko Ctrl+Shift+V (Windows) don liƙa. bayanan ba tare da wani tsari ba. Wannan gajeriyar hanyar tana taimakawa cire duk wani tsarin da ba'a so kuma yana ba ku damar kwafi ɗanyen bayanai kawai, yana sa bayanan su zama bayyane da sauƙin amfani.

3. Aiwatar da Iyakoki

Lokacin aiki akan babban takardar bayanan, yana iya zama da wahala a iya bambanta tsakanin bayanai a wasu lokuta, wanda shine dalilin da ya sa Fayiloli ke ba ka damar ƙara iyakoki don haskaka sel. Kuna iya ƙara iyakoki zuwa duka, ɗaya, ko fiye da bangarorin kowane tantanin halitta. Don ƙara iyakoki a duk bangarorin huɗu na tantanin halitta, danna gajeriyar hanyar keyboard ⌘+Shift+7 (macOS) ko Ctrl+Shift+7 (Windows).

Lokacin da kuka gama kuma kuna son cire iyakar, zaku iya amfani da gajeriyar hanyar keyboard Option + Shift + 6 (macOS) ko Alt + Shift + 6 (Windows) don cire iyakar da aka ƙara a baya ta danna kan tantanin halitta ko kewayon ku. so a cire iyakar daga. Wannan gajarta na taimakawa wajen haɓaka tsayuwar bayanai da kuma sa su zama abin karantawa da amfani.

4. Daidaita bayanai

Don sanya bayananku su zama daidai kuma an tsara su akan takardar, zaku iya cimma hakan ta hanyar daidaita sel. Akwai hanyoyi guda uku don daidaita sel: hagu, dama, da tsakiya. Don cimma wannan, zaku iya danna gajeriyar hanyar keyboard ⌘+Shift+L (macOS) ko Ctrl+Shift+L (Windows) don ɗaukar hagu, ⌘+Shift+R ko Ctrl+Shift+R don ɗauka dama, gajeriyar hanya ⌘+Shift +E ko Ctrl+Shift+E zuwa daidaita layi.

Ta hanyar yin amfani da waɗannan matakan, tsarin bayanan zai iya zama mafi tsari da kyau, kuma yana da siffar da ke da sauƙin karantawa da fahimta.

5. Shigar da kwanan wata da lokaci

Ƙara kwanan wata da lokaci yana ɗaya daga cikin ayyukan da aka fi amfani da su a cikin Google Sheets, kuma don cimma wannan, mai amfani yana buƙatar sanin gajerun hanyoyin keyboard daidai. Ana iya shigar da kwanan wata da lokaci sau ɗaya, ko kuma ana iya ƙara su daban.

Don shigar da kwanan wata da lokaci tare, ana iya danna gajeriyar hanyar madannai ⌘+Option+Shift+; (a cikin macOS) ko kuma Ctrl+Alt+Shift+; (Windows). Don ƙara kwanan wata, danna ⌘+; ko Ctrl+;, kuma don ƙara lokacin yanzu, zaku iya danna gajeriyar hanya ⌘+Shift+; أو Ctrl+Shift+;.

Ta amfani da waɗannan gajerun hanyoyin, zaku iya adana lokaci, sanya ƙara kwanan wata da lokaci cikin sauri da sauƙi, da samun ingantaccen lokaci da rikodin kwanan wata.

6. Tsarin bayanai zuwa kudin waje

A ce kun ƙara wasu bayanai a cikin takardar aiki amma ƙimar da aka shigar ta lambobi ne kawai, zaku iya canza waɗannan ƙwayoyin kuma tsara bayanan su kasance cikin tsarin kuɗin da ake so.

Don canza bayanan tantanin halitta zuwa tsarin kuɗi, zaku iya zaɓar duk sel waɗanda ke ɗauke da lambobi, sannan danna gajeriyar hanyar madannai Ctrl + Shift + 4.

Tare da wannan gajeriyar hanyar, ana tsara bayanan tantanin halitta da sauri kuma a canza su zuwa tsarin kuɗi, adana lokaci da ƙoƙari wajen tsara bayanai da hannu.

7. Ƙara hanyoyin haɗi

Ko kuna kula da jerin masu fafatawa ko ƙirƙirar gidajen yanar gizo na albarkatu, zaku iya ƙara hanyoyin haɗin kai zuwa maƙunsar rubutu Google Don sanya wuraren buɗewa su dace sosai.

Don ƙara hyperlink, ana iya danna gajeriyar hanyar madannai ⌘+K (a kan macOS) ko Ctrl + K (Windows) kuma liƙa hanyar haɗin da kake son ƙarawa. Bugu da ƙari, ana iya buɗe hanyoyin haɗin kai tsaye ta danna kan shi kuma danna Option + Shigar (macOS) ko Alt Shigar (a cikin tsarin Windows).

Ta hanyar aiwatar da waɗannan matakan, yana yiwuwa a sauƙaƙe samun dama ga mahimman shafuka da cimma ingantaccen amfani da maƙunsar bayanai.

8. Ƙara layuka da ginshiƙai

Ɗaya daga cikin ɓangarori masu ban takaici na amfani da Google Sheets shine amfani da kayan aiki don ƙara layuka da ginshiƙai babban mafarki ne na gaske. Koyaya, da zarar kun gano gajerun hanyoyin keyboard, ba za ku taɓa komawa hanyar gargajiya ba.

• Saka jere a sama: latsa Ctrl + Option + I sannan R أو Ctrl + Alt + I sannan R .
• Don saka jere a ƙasa: Danna Ctrl + Option + I sannan B أو Ctrl + Alt + I sannan B .
• Saka ginshiƙi zuwa hagu: latsa Ctrl + Option + I sannan C أو Ctrl + Alt + I sannan C .
• Saka ginshiƙi zuwa dama: latsa Ctrl + Option + I sannan O أو Ctrl + Alt + I sannan O .

9. Share layuka da ginshiƙai

Kamar ƙara layuka da ginshiƙai, share su kuma na iya zama ƙalubale, amma a cikin maƙunsar rubutu Google Ana iya amfani da taƙaitaccen bayani don sauƙaƙe tsari.

Za'a iya share layin na yanzu ta latsa gajeriyar hanyar madannai Ctrl+Option+E Sannan D. Don share ginshiƙi, zaku iya danna gajeriyar hanya Ctrl+Option+E Sa'an nan kuma E.

Ta hanyar amfani da waɗannan matakan, layuka da ginshiƙai za a iya share su cikin sauri da sauƙi, adana lokaci da ƙoƙari a cikin tsarin tsara bayanai da canza tsarin don dacewa da buƙatu daban-daban.

10. Ƙara sharhi

Ana iya ƙara sharhi zuwa kowane tantanin halitta ko rukuni na sel a cikin Google Sheets cikin sauƙi ta amfani da gajerun hanyoyin da suka dace.

Kuma ta hanyar latsa gajeriyar hanyar keyboard ⌘+Option+M (macOS) ko Ctrl+Alt+M (macOS). Windows)-Za a iya ƙara sharhi zuwa ga tantanin halitta da aka zaɓa ko ƙungiyar da aka zaɓa.

Ta hanyar ƙara sharhi, mahimman bayanai, bayani, da umarni masu alaƙa da bayanan za a iya yin rikodin, wanda ke taimakawa haɓaka sadarwa da daidaitawa tsakanin masu amfani da cimma ingantaccen amfani da maƙunsar bayanai.

11. Nuna taga gajeriyar hanyar madannai

Lissafin da ke sama bai ƙunshi duk gajerun hanyoyin keyboard da ke cikin Google Sheets ba, amma ya ƙunshi mafi fa'ida. Ana iya samun kowane gajeriyar hanyar keyboard Sheets ta hanyar ƙaddamar da taga bayanin ta latsa gajeriyar hanyar keyboard ⌘+/ (macOS) ko Ctrl+/ (Windows).

Ta hanyar ƙaddamar da taga bayanin, zaku iya nemo kowane gajeriyar hanyar madannai kuma duba cikakken bayanin yadda ake amfani da shi a cikin Google Sheets. Wannan yana taimakawa wajen haɓaka tasiri da inganci a cikin yin amfani da maƙunsar bayanai da kuma cimma babban aiki.

12. Ƙarin Gajerun hanyoyi:

1. Ctrl + Shift + H: Ɓoye zaɓaɓɓun layuka.
2. Ctrl + Shift + 9: Boye ginshiƙan da aka zaɓa.
3. Ctrl + Shift + 0: Cire ginshiƙan da aka zaɓa.
4. Ctrl + Shift + F4: Sake ƙididdige ƙididdiga a cikin tebur.
5. Ctrl + Shift + \ : Cire iyakoki daga sel da aka zaɓa.
6. Ctrl + Shift + 7: Yana canza zaɓaɓɓun sel zuwa tsarin rubutu bayyananne.
7. Ctrl + Shift + 1: Mayar da zaɓaɓɓun sel zuwa tsarin lamba.
8. Ctrl + Shift + 5: Mayar da zaɓaɓɓun sel zuwa tsarin kashi.
9. Ctrl + Shift + 6: Mayar da zaɓaɓɓun sel zuwa tsarin kuɗi.
10. Ctrl + Shift + 2: Mayar da zaɓaɓɓun sel zuwa tsarin lokaci.
11. Ctrl + Shift + 3: Mayar da zaɓaɓɓun sel zuwa tsarin kwanan wata.
12. Ctrl + Shift + 4: Mayar da zaɓaɓɓun sel zuwa tsarin kwanan wata da lokaci.
13. Ctrl + Shift + P: Buga maƙunsar rubutu.
14. Ctrl + P: Buga daftarin aiki na yanzu.
15. Ctrl + Shift + S: Ajiye maƙunsar bayanai.
16. Ctrl + Shift + L: Don tace bayanai.
17. Ctrl + Shift + A: Zaɓi duk sel a cikin tebur.
18. Ctrl + Shift + E: Zaɓi duk sel a jere na yanzu.
19. Ctrl + Shift + R: Zaɓi duk sel a cikin shafi na yanzu.
20. Ctrl + Shift + O: Zaɓi duk sel a yankin da ke kewaye da tantanin halitta na yanzu.

Saitin ƙarin gajerun hanyoyi don Google Sheets:

1. Ctrl + Shift + F3: Don cire duk tsarawa daga sel da aka zaɓa.
2. Ctrl + D: Kwafi darajar daga tantanin halitta na sama zuwa tantanin ƙasa.
3. Ctrl + Shift + D: Kwafi dabarar daga tantanin halitta na sama zuwa tantanin ƙasa.
4. Ctrl + Shift + U: Rage girman font a cikin sel da aka zaɓa.
5. Ctrl + Shift ++: Ƙara girman font a cikin sel da aka zaɓa.
6. Ctrl + Shift + K: Ƙara sabon hanyar haɗi zuwa tantanin halitta da aka zaɓa.
7. Ctrl + Alt + M: Kunna fasalin “Fassara” kuma fassara abubuwan cikin wani harshe.
8. Ctrl + Alt + R: Saka ma'auni na ɓoye a cikin tebur.
9. Ctrl + Alt + C: Yana ƙididdige ƙididdiga don sel da aka zaɓa.
10. Ctrl + Alt + V: Nuna ainihin ƙimar dabarar a cikin tantanin halitta da aka zaɓa.
11. Ctrl + Alt + D: Yana buɗe akwatin maganganu na Sharuɗɗa.
12. Ctrl + Alt + Shift + F: Yana buɗe akwatin maganganu Format Cells.
13. Ctrl + Alt + Shift + P: Yana buɗe maganganun Zaɓuɓɓukan bugawa.
14. Ctrl + Alt + Shift + E: Yana buɗe maganganun fitarwa.
15. Ctrl + Alt + Shift + L: Yana buɗe maganganun Sarrafa Biyan kuɗi.
16. Ctrl + Alt + Shift + N: Ƙirƙiri sabon samfuri.
17. Ctrl + Alt + Shift + H: Boye kanun labarai da lambobi a cikin layuka da ginshiƙai.
18. Ctrl + Alt + Shift + Z: Zaɓi duk sel waɗanda ke ɗauke da kwafi kwafi.
19. Ctrl + Alt + Shift + X: Zaɓi duk sel waɗanda ke ɗauke da ƙima na musamman.
20. Ctrl + Alt + Shift + S: Zaɓi duk sel waɗanda ke ɗauke da dabaru iri ɗaya.

Waɗannan gajerun hanyoyin sun ci gaba:

Ana buƙatar ƙarin ƙwarewa tare da Google Sheets. Ana iya koyon ƙarin gajerun hanyoyi da ƙwarewa ta hanyar kallo:

1. Ctrl + Shift + Shigar: Shigar da tsarin tsararru a cikin tantanin halitta da aka zaɓa.
2. Ctrl + Shift + L: Saka jerin zaɓuka don tantanin da aka zaɓa.
3. Ctrl + Shift + M: Saka sharhi a cikin tantanin halitta da aka zaɓa.
4. Ctrl + Shift + T: Yana canza kewayon bayanai zuwa tebur.
5. Ctrl + Shift + Y: Saka lambar sirri a cikin tantanin halitta da aka zaɓa.
6. Ctrl + Shift + F10: Yana nuna jerin zaɓuɓɓukan da ke akwai don tantanin da aka zaɓa.
7. Ctrl + Shift + G: Nemo sel waɗanda ke ɗauke da takamaiman ƙima.
8. Ctrl + Shift + Q: Ƙara Maɓallin Sarrafa zuwa tantanin halitta da aka zaɓa.
9. Ctrl + Shift + E: Ƙara ginshiƙi zuwa tebur.
10. Ctrl + Shift + I: Yana Ƙirƙirar Tsarin Yanayi don sel da aka zaɓa.
11. Ctrl + Shift + J: Saka tsarin saiti a cikin sel da aka zaɓa.
12. Ctrl + Shift + O: Zaɓi duk yankin tebur.
13. Ctrl + Shift + R: Yana canza rubutu zuwa babban harafi ko ƙarami.
14. Ctrl + Shift + S: Maida tebur zuwa hoto.
15. Ctrl + Shift + U: Saka layin kwance cikin sel da aka zaɓa.
16. Ctrl + Shift + W: Saka layukan tsaye cikin sel da aka zaɓa.
17. Ctrl + Shift + Z: Gyara aikin ƙarshe.
18. Ctrl + Alt + Shift + F: Ƙirƙiri tsarin salula na al'ada.
19. Ctrl + Alt + Shift + U: Saka alamar Unicode a cikin tantanin da aka zaɓa.
20. Ctrl + Alt + Shift + V: Saka Tushen Bayanai a cikin tantanin halitta da aka zaɓa.

Bambanci tsakanin maƙunsar bayanai na Google da Office

Shahararrun Google Sheets da Microsoft Excel manyan maƙunsar bayanai biyu ne a cikin aiki da rayuwar yau da kullun. Kodayake duka shirye-shiryen biyu suna yin ayyuka na asali iri ɗaya, sun bambanta ta wasu fannoni. Ga wasu bambance-bambance tsakanin Google Sheets da Office:

1. Samun damar shirin:
   Yayin da aka shigar da Microsoft Excel akan PC, Google Sheets ana samun dama ta hanyar mai lilo da Intanet.
2. Haɗin kai da rabawa:
   Google Sheets ya fi sauƙi don rabawa da haɗin gwiwa tare da wasu, kamar yadda masu amfani da yawa za su iya aiki akan maƙunsar bayanai a lokaci guda, yin sharhi kan sel kuma raba a cikin ainihin lokaci.
3. Tsara da ƙira:
   Microsoft Excel yana son zama mafi sassauƙa wajen tsarawa da ƙira, kamar yadda Excel ke ba da sifofi masu ci gaba da nau'ikan rubutu, launuka, da tasiri.
4. Kayan aiki da fasali:
   Microsoft Excel yana ƙunshe da manyan kayan aiki da fasali, kamar tebur na lokaci-lokaci, sigogin rayuwa, da bincike na ƙididdiga na ci gaba. Duk da yake Google Sheets yana da sauƙi, mai sauƙi da sauƙi, wanda ya sa ya fi dacewa da masu amfani waɗanda ke neman mafita mai sauƙi da sauƙi.
5. Haɗin kai tare da wasu ayyuka:
   Google Sheets yana da alaƙa da haɗin kai tare da sauran ayyukan Google, kamar Google Drive, Google Docs, Google Slides, da ƙari, yayin da Microsoft Excel ke da haɗin kai mara kyau tare da sauran samfuran Microsoft, kamar Word, PowerPoint, Outlook, da ƙari.
6. kudin:
   Google Sheets kyauta ne ga kowa, amma dole ne ku biya kuɗin biyan kuɗi don cin gajiyar Microsoft Excel.
7. Tsaro:
   Shafukan Google sun fi aminci don adana bayanai yayin da ake ɓoye bayanai ta atomatik kuma ana adana su a cikin gajimare akan sabar Google waɗanda aka kiyaye su da kalmomin sirri masu ƙarfi da fasahar tsaro na ci gaba. Yayin da ake adana fayilolin Microsoft Excel akan na'urarka, yana buƙatar kiyayewa da adana na'urarka da kalmomin shiga masu ƙarfi.
8. goyon baya:
   Google yana ba da koyawa da kuma babban tallafin al'umma, yayin da tallafin Microsoft yana samuwa ta waya, imel, da yanar gizo.
9. Bukatun fasaha:
   Google Sheets yana kan layi, wanda ke nufin yana buƙatar haɗin intanet don samun dama da gyara bayanai. Yayin da za a iya amfani da Microsoft Excel ba tare da buƙatar haɗin Intanet ba, wanda ya sa ya fi dacewa ga masu amfani da ke buƙatar samun damar bayanai a layi.
10. Amfani akan na'urorin hannu:
    Google Sheets yana sauƙaƙa da sauƙi don samun dama da shirya bayanai akan wayoyi da Allunan, yayin da Microsoft Excel yana buƙatar shigar da ƙa'idar Excel ta hannu don samun dama da gyara bayanai.

Gabaɗaya, masu amfani yakamata su zaɓi software da ta fi dacewa da buƙatun su, walau Google Sheets ko Microsoft Excel. Dukkan shirye-shiryen za a iya sauke su kuma amfani da su kyauta don sanin wanda ya fi dacewa don amfanin mutum ko kasuwanci.

Menene gajeriyar hanyar Google Sheets da kuka fi so

Gajerun hanyoyin da aka ambata a sama wasu ne kawai waɗanda aka fi amfani da su a cikin Google Sheets, amma akwai wasu gajerun hanyoyi masu amfani da yawa waɗanda za a iya amfani da su don haɓaka inganci da aiki. Daga cikin wadannan gajerun hanyoyin:

•  Gajerun hanyoyin keyboard Shift+Space don zaɓar jere na yanzu.
•  Gajerun hanyoyin keyboard Ctrl+Space don zaɓar ginshiƙi na yanzu.
•  Ctrl+Shift+V Manna rubutu ba tare da tsarawa ba.
•  Alt + Shigar (Windows) ko Option + Shigar (macOS) gajeriyar hanyar maɓalli don saka sabon layi a cikin tantanin halitta.
•  Hanyar gajeriyar hanyar allo Ctrl+Alt+Shift+K don buɗe jerin gajerun hanyoyin da ake da su.

Lokacin da kake amfani da waɗannan gajerun hanyoyin da sauran kyawawan ayyuka, za ku iya inganta inganci da aiki a cikin Google Sheets, da kuma adana lokaci da ƙoƙarin sarrafa da tsara bayanan ku.