Cómo Cambiar de Pestaña con el Teclado en Excel

Isibuyekezo sokugcina: 10/08/2023

Emhlabeni yesipredishithi, isivinini nokusebenza kahle kuyisihluthulelo sokuthuthukisa ukuhamba kwakho komsebenzi. Elinye lamakhono ayisisekelo wokwazi i-Excel ukuphatha ngokushesha amathebhu. Nakuba abasebenzisi abaningi basebenzisa igundane ukushintsha ithebhu eyodwa baye kwenye, kunendlela eshesha kakhulu nesebenza kahle kakhulu: ukusebenzisa ikhibhodi. Kulesi sihloko, sizohlola ukuthi ungashintsha kanjani amathebhu ngekhibhodi ku-Excel, ukusebenzisa inhlanganisela yokhiye nezinqamuleli ezisiza ukuzulazula kalula ngezincwadi zokusebenza namaspredishithi ahlukene. Thola ukuthi ungawandisa kanjani umkhiqizo wakho futhi usheshise imisebenzi yakho ku-Excel usebenzisa le ndlela esebenzayo.

1. Isingeniso sokuzulazula kwethebhu ku-Excel usebenzisa ikhibhodi

Ukuzulazula kumathebhu ku-Excel usebenzisa ikhibhodi kuyisici esiwusizo kakhulu esingakusiza ukusheshisa umsebenzi wakho futhi wandise umkhiqizo wakho. Esikhundleni sokusebenzisa igundane ukuze ushintshe usuka kwenye ithebhu uye kwenye, ungavele usebenzise inhlanganisela yokhiye ukuze uskrole ngokushesha kumaspredishithi akho.

Ukuze uqale ukuzulazula kumathebhu ku-Excel usebenzisa ikhibhodi, okokuqala udinga ukuqiniseka ukuthi inketho Yokufinyelela Ngokushesha Okhiye BeRibhoni ivuliwe. Le nketho izokuvumela ukuthi usebenzise izinhlanganisela zokhiye ukuze ufinyelele imiyalo etholakala kuribhoni. Ungakwazi ukusebenzisa le nketho ngokuya kuthebhu ethi "Ifayela", ukhethe "Izinketho" bese ukhetha "Yenza ngokwezifiso Iribhoni." Ukusuka lapho, uzothola inketho ethi "Bonisa ithebhu yokufinyelela okusheshayo ngaphansi kweribhoni" futhi uzodinga ukuyikhetha ukuze uyiqalise.

Uma usuvule inketho yesinqamuleli sikakhiye weribhoni, ungazulazula kumathebhu ku-Excel usebenzisa ikhibhodi. Ungasebenzisa ukhiye we-Alt kanye nokhiye ohambisana nohlamvu oludwetshelwe kuthebhu ofuna ukuyikhetha. Isibonelo, uma ithebhu ibizwa ngokuthi "Idatha" futhi uhlamvu "D" ludwetshelwe, ungacindezela u-Alt + D ukuze ukhethe leyo thebhu. Ukwengeza, ungasebenzisa okhiye bemicibisholo yesokunxele nesokudla ukuze usuke kuthebhu eyodwa uye kwenye.

2. Izinqamuleli zekhibhodi zokushintsha phakathi kwamathebhu e-Excel

Kunezinhlanganisela ezibalulekile ezimbalwa ongazisebenzisa ukushintsha phakathi kwamathebhu e-Excel ngokushesha nangempumelelo. Nazi izinqamuleli zekhibhodi eziwusizo kakhulu:

1. Ctrl + Tab: Le nhlanganisela yokhiye ikuvumela ukuthi uye kuthebhu elandelayo.

2. Ctrl + Shift + Tab: Sebenzisa le nhlanganisela ukuze uye kuthebhu edlule.

3. Ctrl + F6: Ngalesi sinqamuleli ungaya ngokushesha kuthebhu elandelayo etholakalayo.

Lezi zinqamuleli zekhibhodi ziwusizo kakhulu uma unamathebhu amaningi avuliwe futhi udinga ukuhamba ngokushesha phakathi kwawo. Khumbula ukuzijwayeza nokuzijwayeza lezi zinqamuleli ukuze wenze umsebenzi wakho ku-Excel usebenze kahle kakhulu.

3. Usetshenziswa kanjani okhiye bokushisa ukuze ushintshe amathebhu ku-Excel

Ama-hotkeys ayindlela enhle yokuthuthukisa ukusebenza kahle lapho usebenzisa i-Excel. Uma unamathebhu amaningana avuliwe futhi udinga ukushintsha ngokushesha phakathi kwawo, kunenhlanganisela yokhiye ekuvumela ukuthi ukwenze ngokushesha futhi kalula. Okulandelayo, sizokukhombisa Igxathu emvakwe gxathu .

1. Inhlanganisela yokhiye esetshenziswa kakhulu yile I-Ctrl + Ithebhu. Le nhlanganisela izokuvumela ukuthi ushintshele kuthebhu elandelayo ngokulandelana kwamathebhu avuliwe. Uma unamathebhu amaningi avuliwe, mane ucindezele inhlanganisela yokhiye ngokuphindaphindiwe ukuze ujikeleze kuwo.

2. Uma udinga ukuya kuthebhu ethize ngokuqondile, ungasebenzisa inhlanganisela yokhiye I-Ctrl + F6. Le nhlanganisela izovula uhlu lokudonsela phansi nawo wonke amathebhu avuliwe futhi ungakhetha ngokushesha ithebhu oyifunayo usebenzisa okhiye bemicibisholo kanye nokhiye u-Enter.

4. Inhlanganisela yokhiye bemephu yokuzulazula kwethebhu ku-Excel

Ukuzulazula okusebenzayo phakathi kwamathebhu e-Excel kungakhuphula kakhulu ukusebenza kahle nokukhiqiza. I-Excel inikeza inhlanganisela yezikhiye ezihlukahlukene ezikuvumela ukuthi uhambe ngokushesha phakathi kwamaspredishithi ahlukene. Kulesi sigaba, ngizochaza ukuthi ungazibala kanjani lezi zinhlanganisela eziyisihluthulelo ngokuya ngokuthanda kwakho.

1. Vula i-Excel bese uya kuthebhu ethi "Ifayela". Chofoza "Izinketho" kumenyu yokudonsela phansi.

2. Ewindini lezinketho ze-Excel, khetha ithebhu ethi “Yenza ngokwezifiso Iribhoni”.

3. Ohlwini lwesobunxele, uzobona uhlu lwayo yonke imisebenzi etholakala ku-Excel. Skrolela phansi futhi uthole isigaba "Amathebhu Ayinhloko".

4. Chofoza umcibisholo oya phansi eduze kokuthi “Amathebhu Ayinhloko” ukuze unwebe izinketho. Lapha uzobona uhlu lwamathebhu amakhulu e-Excel, njengokuthi "Ekhaya", "Faka", "Idatha", njll.

5. Khetha ithebhu ofuna ukufaka kuyo inhlanganisela yokhiye.

6. Chofoza inkinobho ethi “Enza ngendlela oyifisayo” ezansi kwesokudla sewindi.

Okuqukethwe okukhethekile - Chofoza Lapha  Cómo crear servidores de Minecraft

7. Efasiteleni elithi “Yenza ngokwezifiso Into” elivelayo, khetha inketho ethi “Imiyalo” phezulu kwesokunxele.

8. Efasiteleni elisha elithi “Enza ngendlela oyifisayo Ikhibhodi”, uzobona uhlu lwazo zonke izinhlanganisela zokhiye ezitholakalayo.

9. Esigabeni esithi "Izigaba", khetha okuthi "Oda" ukuze uthole izinketho ezihlobene nokuzulazula phakathi kwamathebhu.

10. Ngakwesokudla, esigabeni esithi “Imiyalo”, uzothola izinhlobonhlobo zezinketho zezinhlanganisela zokhiye. Chofoza inketho oyifunayo njengokuthi "Ishidi Elilandelayo", "Ishidi elandulele", "Hamba eshidini lokuqala", njll.

11. Uma inketho isikhethiwe, chofoza inkambu ethi “Ukhiye Wokufinyelela Omusha” bese ucindezela inhlanganisela yokhiye ofuna ukuyisebenzisela lowo msebenzi.

12. Chofoza inkinobho ethi "Yabela" ukuze unikeze inhlanganisela yokhiye emsebenzini bese uchofoza okuthi "Vala" ukuze uvale wonke amawindi.

Manje uzobe wenze imephu yenhlanganisela yokhiye yokuzulazula kwethebhu ku-Excel. Ungaphinda lezi zinyathelo ezingenhla ukuze wenze imephu ezinye izinhlanganisela zokhiye zamanye amathebhu e-Excel ngokwezidingo zakho. Lokhu kulungiselelwa kuzokuvumela ukuthi wonge isikhathi lapho uzulazula phakathi kwamaspredishithi ahlukene futhi wenze imisebenzi yakho ngokuphumelelayo.

5. Ungakuthuthukisa kanjani ukuhamba komsebenzi kwakho kwe-Excel ngokushintsha ithebhu yekhibhodi

Ukushintsha amathebhu ku-Excel kungaba inqubo enensa uma kwenziwa ngesandla ngegundane. Nokho, kunendlela esebenza kahle kakhulu yokwenza lokhu usebenzisa ikhibhodi. Kulesi sihloko, ngizokukhombisa.

Isinyathelo sokuqala sokukwazi ukushintsha amathebhu usebenzisa ikhibhodi ukunika amandla umsebenzi wesinqamuleli sethebhu ye-Excel. Ukuze wenze lokhu, udinga ukuya kuthebhu ethi "Ifayela" kuribhoni bese ukhetha "Izinketho." Okulandelayo, kuwindi lezinketho ze-Excel, khetha okuthi “Hlela Izinqamuleli Zezinketho” bese uqoka ibhokisi elithi “Izinqamuleli Zethebhu.” Uma usukwenzile lokhu, chofoza okuthi "KULUNGILE" ukuze ulondoloze izinguquko.

Uma usunike amandla isici sesinqamuleli sethebhu, uzokwazi ukushintsha phakathi kwamathebhu ahlukene usebenzisa izinhlanganisela zokhiye. Isibonelo, ukuya kuthebhu ethi “Sheet2”, kufanele ucindezele u-“Ctrl + 2”. Uma ufuna ukuya kuthebhu ethi “Sheet3”, ungakwenza lokho ngokucindezela u-“Ctrl + 3”, njalonjalo. Ngale ndlela, ungakwazi ukushintsha ngokushesha phakathi kwamathebhu e-Excel ahlukene ngaphandle kokusebenzisa igundane.

6. Funda izinzuzo nezinzuzo zokushintsha amathebhu ku-Excel usebenzisa ikhibhodi

Ukushintsha amathebhu ku-Excel usebenzisa ikhibhodi kuyikhono eliwusizo elizokongela isikhathi futhi lisheshise umsebenzi wakho. Nazi ezinye izinzuzo nezinzuzo zokusebenzisa lesi sici:

1. Isivinini sokuzulazula: Ngokusebenzisa ikhibhodi ukushintsha amathebhu ku-Excel, ungakwazi ukusuka kwelinye ishidi uye kwelinye ngokushesha nangempumelelo. Lokhu kubaluleke kakhulu uma udinga ukubuyekeza noma ukuhlela idatha kumaspredishithi ahlukene.

2. Evita distracciones: Ngokungathembeli kugundane noma kuphedi yokuthinta, ukushintsha amathebhu ngekhibhodi kukuvumela ukuthi uhlale ugxile emsebenzini wakho ngaphandle kokuphazamiseka okungadingekile. Ungazulazula emashidini ahlukene ngaphandle kokuthi ususe amehlo akho emsebenzini wakho.

3. Ukufinyelela okuqondile ku imisebenzi eyinhloko: Ngokusebenzisa izinhlanganisela zokhiye, ungakwazi ukufinyelela ngokushesha imisebenzi eyinhloko ye-Excel, njengokufaka amashidi amasha, ukususa amashidi akhona, noma ukuzulazula kumakhasi athile. Lezi zici zizokuvumela ukuthi usebenze ngokuphumelelayo nangempumelelo.

7. Uzenza kanjani ngokwezifiso izinhlanganisela zokhiye ukuze ushintshe amathebhu ku-Excel

Ukwenza ngendlela oyifisayo inhlanganisela yokhiye yokushintsha amathebhu ku-Excel kuyindlela enhle yokwenza lula ukuhamba kwakho komsebenzi futhi wandise umkhiqizo wakho. Nakuba i-Excel isivele inazo izinqamuleli zekhibhodi ezichazwe ngaphambilini, ungase ufune ukuzenza ngendlela oyifisayo ukuze zihambisane nezidingo zakho ezithile. Ngenhlanhla, ukwenza lokhu kulula kakhulu futhi kudinga abambalwa kuphela izinyathelo ezimbalwa.

Ukuze uqalise, vula i-Excel bese uye kuthebhu ethi “Ifayela”. Okulandelayo, khetha "Izinketho" bese "Yenza ngokwezifiso Iribhoni." Iwindi le-pop-up lizovela lapho ungenza ngokwezifiso izinhlanganisela zokhiye. Kukholomu engakwesokudla, uzothola uhlu lwemiyalo etholakala ku-Excel.

Skrolela phansi uze uthole ingxenye ethi “Amathebhu Ayinhloko” bese ukhetha “Ekhaya.” Lapha uzobona zonke izinketho ezihlobene nethebhu yasekhaya. Ukuze ushintshe inhlanganisela yokhiye yokushintsha amathebhu, khetha inketho ethi “Shintshela kuthebhu elandelayo” bese uchofoza okuthi “Lungisa.” Okulandelayo, faka inhlanganisela yokhiye omusha ofuna ukuyisebenzisa. Qiniseka ukuthi ayisetshenziswa ngomunye umyalo bese ucindezela "KULUNGILE." Ilungile! Manje usuzokwazi ukushintsha amathebhu ku-Excel usebenzisa inhlanganisela yokhiye wangokwezifiso oyimisile.

8. Ukuhlola izindlela ezahlukene zokushintsha amathebhu ngekhibhodi ku-Excel

Kunezindlela ezimbalwa zokushintsha amathebhu ku-Excel usebenzisa ikhibhodi, engasheshisa kakhulu ukuzulazula futhi ithuthukise ukusebenza kahle ekuqedeni imisebenzi. Izindlela ezihlukene nezinqamuleli zokushintsha phakathi kwamathebhu zizohlolwa ngezansi:

Okuqukethwe okukhethekile - Chofoza Lapha  Ungamfaka kanjani Umhumushi ku-WhatsApp.

1. Ukusebenzisa isinqamuleli Ikhibhodi ye-Ctrl + Pg Up/Pg Dn: Ukuze ushintshe usuka kwenye ithebhu uye kwenye, mane ucindezele ubambe ukhiye u-Ctrl bese ucindezela ukhiye we-Page Up (Pg Up) ukuya kwesokunxele noma ukhiye we-Page Down (Pg Dn) ukuya kwesokudla. . Le ndlela iyashesha futhi kulula ukuyikhumbula.

2. Ukusebenzisa isinqamuleli sekhibhodi Ctrl + Shift + Pg Up/Pg Dn: Uma ufuna ukushintshela ngokushesha kuthebhu yokuqala noma yokugcina, ungasebenzisa lesi sinqamuleli sekhibhodi. Bamba phansi ukhiye u-Ctrl kanye nokhiye u-Shift, bese ucindezela inkinobho ye-Page Up (Pg Up) ukuze uye kuthebhu yokuqala noma ukhiye we-Page Down (Pg Dn) ukuze uye kuthebhu yokugcina.

9. Izinyathelo Ezilula Zokuvula Ukuzulazula Kwethebhu Usebenzisa Ikhibhodi Ukuvula Nokuvala ku-Excel

Kulesi sigaba sizokukhombisa ukuthi ungakwenza kanjani kusebenze futhi uvale ukuzulazula kwethebhu usebenzisa ikhibhodi ku-Excel. Lo msebenzi uzokuvumela ukuthi ufinyelele ngokushesha amaspredishithi ahlukene ngaphandle kokuthi usebenzise igundane. Landela lezi zinyathelo ezilula ukuze unike amandla le nketho.

Isinyathelo 1: Vula eyakho Ifayela le-Excel bese uye kuthebhu ethi “Ifayela” phezulu kwesokunxele kusukela esikrinini. Chofoza inketho ethi "Izinketho" kumenyu yokudonsela phansi.

Isinyathelo 2: Ewindini lezinketho, khetha ithebhu "Ukufinyeleleka" kuphaneli engakwesokunxele. Skrolela phansi uze uthole ingxenye ethi "Skrola futhi Khetha".

Isinyathelo 3: Ngaphakathi kwalesi sigaba, khetha ibhokisi elithi “Sebenzisa okhiye bemicibisholo ukuhamba phakathi kwamaseli” ukuze wenze kusebenze ukuzulazula kwethebhu usebenzisa ikhibhodi. Uma ufuna ukukhubaza lesi sici, vele ususe ukumaka ibhokisi bese uchofoza okuthi "KULUNGILE" ukuze ulondoloze izinguquko zakho.

10. Ukuxazulula izinkinga ezivamile lapho ushintsha amathebhu ngekhibhodi ku-Excel

Lapho ushintsha amathebhu ngekhibhodi ku-Excel, kuvamile ukubhekana nezinkinga ezithile. Nokho, kunezixazululo ezilula ezizokusiza uzixazulule ngokushesha. Ngezansi ezinye zezinkinga ezivame kakhulu nokuthi zingalungiswa kanjani:

1. Inkinga: Ayikwazi ukushintshela kuthebhu ethile isebenzisa ikhibhodi.

Uma ungakwazi ukushintshela kuthebhu ethile usebenzisa ikhibhodi, ungazama izinyathelo ezilandelayo:

  • Isinyathelo 1: Qiniseka ukuthi ithebhu ofuna ukushintshela kuyo iyabonakala kubha yethebhu ye-Excel.
  • Isinyathelo sesi-2: Cindezela inhlanganisela yokhiye “Ctrl + Page Down” ukuze uye kuthebhu elandelayo noma “Ctrl + Page Up” ukuze ubuyele kuthebhu yangaphambilini.
  • Isinyathelo sesi-3: Uma namanje ungakwazi ukushintshela kuthebhu oyifunayo, cindezela ukhiye "Ctrl + F6" ukuze uvule uhlu lwawo wonke amathebhu avuliwe bese ukhetha okufunayo usebenzisa okhiye bemicibisholo kanye nokhiye othi "Enter".

2. Inkinga: Ukushintsha amathebhu kushintsha indawo yeseli esebenzayo.

Uma ukushintsha amathebhu kushintsha indawo yeseli esebenzayo futhi ufuna ukuyigcina isendaweni efanayo, ungalandela lezi zinyathelo:

  • Isinyathelo 1: Ngaphambi kokushintsha amathebhu, khetha iseli ofuna ukuyigcina isebenza.
  • Isinyathelo sesi-2: Cindezela u-“Ctrl + 1” ukuze uvule ifomethi yeseli.
  • Isinyathelo sesi-3: Chofoza ithebhu ethi "Ukuvikela" futhi uqiniseke ukuthi ibhokisi elithi "Kuvinjiwe" alihloliwe. Bese, chofoza "KULUNGILE."

3. Inkinga: Awukwazi ukushintsha amathebhu usebenzisa ikhibhodi ebhukwini lokusebenza okwabelwana ngalo.

Uma ungakwazi ukushintsha amathebhu usebenzisa ikhibhodi ebhukwini lokusebenza okwabelwana ngalo, ungazama lokhu okulandelayo:

  • Isinyathelo 1: Qiniseka ukuthi unezimvume zokushintsha amathebhu ebhukwini lokusebenza okwabelwana ngalo.
  • Isinyathelo sesi-2: Hlola ukuthi ibhuku lokusebenza okwabelwana ngalo liyayivumela yini inketho ethi "Ukuzulazula Kwekhibhodi" kuzilungiselelo. Uma likhutshaziwe, xhumana nomnikazi webhuku ukuze ulinike amandla.
  • Isinyathelo sesi-3: Uma izinyathelo ezingenhla zingayixazululi inkinga, zama ukusebenzisa igundane noma inhlanganisela yokhiye othi “Alt + Tab” ukuze ushintshe phakathi kwamafasitela avuliwe bese ukhetha incwadi yokusebenzela ye-Excel oyifunayo.

11. Izindlela Ezinhle Kakhulu Zokushintsha Okuphumelelayo Kwethebhu ku-Excel Ukusebenzisa Ikhibhodi

Ukushintsha amathebhu ngempumelelo ku-Excel usebenzisa ikhibhodi, kukhona izinqubo ezingcono kakhulu ezingonga isikhathi futhi khulisa umkhiqizo. Ngezansi kukhona amathiphu abalulekile okwenza lokhu. ngempumelelo:

1. Isinqamuleli sekhibhodi: Sebenzisa u-Ctrl + PgUp ukuya kuthebhu edlule, futhi Ctrl + PgDn ukuze uthuthukele kuthebhu elandelayo. Lezi zinqamuleli ziyashesha futhi kulula ukuzikhumbula, zikuvumela ukuthi ushintshe amathebhu ngaphandle kokusebenzisa igundane.

2. Ukuzula ngamagama: Uma amathebhu akho ebhalwe ngamagama athile, ungasebenzisa isinqamuleli sekhibhodi. I-Ctrl + F6 ukuze uvule uhlu lokudonsela phansi olufaka kuhlu wonke amathebhu avuliwe. Bese, mane uthayiphe izinhlamvu zokuqala zegama lethebhu ofuna ukushintshela kuyo bese ukhetha inketho ehambisanayo. Lokhu kuwusizo ikakhulukazi uma unamathebhu amaningi avuliwe.

Okuqukethwe okukhethekile - Chofoza Lapha  Ungakha kanjani isikhumba ku-Minecraft?

3. Ukwenza ngendlela oyifisayo izinqamuleli zekhibhodi: I-Excel ikuvumela ukuthi wenze ngendlela oyifisayo izinqamuleli zekhibhodi yakho ukuze zivumelane nezidingo zakho ezithile. Ungakwenza lokhu ngokufinyelela inketho ethi “Yenza ngokwezifiso ikhibhodi” kumenyu ethi “Ifayela”. Uma usufikile, khetha "Ithebhu Elandelayo" noma "Ithebhu Yangaphambilini" bese unikeza isinqamuleli sekhibhodi esisha ngokuya ngokuthanda kwakho.

12. Zitholele izinqamuleli zekhibhodi ezaziwa kancane ukuze ushintshe amathebhu ku-Excel

Ku-Excel, ukushintsha amathebhu kungaba inqubo eyisicefe futhi edla isikhathi uma ungazazi izinqamuleli zekhibhodi ezifanele. Ngenhlanhla, kunezinqamuleli ezingaziwa kancane ezingahle zihlele ukuhamba kwakho komsebenzi futhi zikuvumele ukuthi ushintshe amathebhu ngokushesha nangempumelelo. Ngezansi, sizokukhombisa ezinye zalezi zinqamuleli nokuthi zisetshenziswa kanjani.

1. Ctrl + PgUp: Lesi sinqamuleli sikuvumela ukuthi uye kuthebhu yangaphambilini ku-Excel. Vele ucindezele izinkinobho ze-Ctrl ne-PgUp ngesikhathi esifanayo ukwenza ushintsho. Lesi sinqamuleli siwusizo ikakhulukazi uma unamathebhu amaningi avuliwe futhi udinga ukubuyela ngokushesha kuthebhu yangaphambilini.

2. Ctrl + PgDn: Lesi sinqamuleli sisebenza ngendlela efanayo nedlule, kodwa ikuvumela ukuthi ushintshele kuthebhu elandelayo ku-Excel. Cindezela izinkinobho ze-Ctrl kanye ne-PgDn ngenkathi ngesikhathi esifanayo ukwenza ushintsho. Uma uye kuthebhu yangaphambilini usebenzisa isinqamuleli sangaphambilini, ungasebenzisa lesi sinqamuleli ukuze ubuyele kuthebhu yokuqala.

3. I-Ctrl + F6: Lesi sinqamuleli sikuvumela ukuthi ushintshe phakathi kwamathebhu avuliwe ku-Excel ngokulandelana. Ngaso sonke isikhathi uma ucindezela u-Ctrl + F6, uzodlulela kuthebhu elandelayo etholakalayo. Uma usuvele ukuthebhu yokugcina, isinqamuleli sizokubuyisela kuthebhu yokuqala. Lesi sinqamuleli siwusizo uma unamathebhu amaningi avuliwe futhi ufuna ukuzulazula ngokushesha phakathi kwawo.

13. Ungasheshisa kanjani ukukhiqiza kwakho ku-Excel ngokushintsha ikhibhodi

I-Excel iyithuluzi elinamandla kakhulu lokwenza imisebenzi yokubala nokuhlaziya idatha. Nokho, izikhathi eziningi abasebenzisi banqunyelwe inani lesikhathi abasichitha beshintsha phakathi kwamathebhu besebenzisa igundane. Ngenhlanhla, kunendlela yokusheshisa ukukhiqiza kwakho ku-Excel usebenzisa ukushintsha ithebhu yekhibhodi.

Isinyathelo sokuqala esibalulekile ukuzijwayeza izinqamuleli zekhibhodi ye-Excel. Isibonelo, ungasebenzisa inhlanganisela yokhiye “Ctrl + Page Up” ukuze uye kuthebhu yangaphambilini kanye nokuthi “Ctrl + Page Down” ukuze uye kuthebhu elandelayo. Lezi zinqamuleli zizokuvumela ukuthi ushintshe ngokushesha phakathi kwamaspredishithi ahlukene kufayela lakho.

Enye indlela yokusheshisa ukukhiqiza kwakho ku-Excel ukusebenzisa umsebenzi othi "Iya ku-" kukhibhodi yakho. Ungakwazi ukufinyelela lo msebenzi ngokucindezela inhlanganisela yokhiye "Ctrl + G". Lapho ibhokisi lengxoxo elithi “Yiya Ku” selivuleka, ungafaka inombolo yethebhu ofuna ukuya kuyo bese ucindezela u-“Enter.” Lokhu kuzokuyisa ngqo kuthebhu eshiwo ngaphandle kokuthi uskrole mathupha kuwo wonke amathebhu.

14. Isiphetho: Khulisa ukusebenza kwakho ku-Excel ngokuba ngumpetha wokuzulazula kwethebhu ngekhibhodi

Ukuze ukhulise ukusebenza kwakho ku-Excel, kubalulekile ukuba umpetha wokuzulazula kwethebhu ngekhibhodi. Lokhu kungasheshisa imisebenzi yakho futhi kukuvumele ukuthi usebenze ngokuphumelelayo. Kulokhu okuthunyelwe, sizokunikeza umhlahlandlela wesinyathelo ngesinyathelo ukuze ufunde ukuthi ungakwenza kanjani.

Ngaphambi kokuthi siqale, kubalulekile ukuqaphela ukuthi i-Excel inikeza izinqamuleli zekhibhodi eziningi ukwenza izenzo ezihlukene. Nokho, kulesi simo sizogxila ekuzulazuleni phakathi kwamathebhu. Ukuze wenze lokhu, ungasebenzisa inhlanganisela yokhiye "Ctrl" kanye nenombolo ehambisana nethebhu ofuna ukuyikhetha. Isibonelo, uma ufuna ukushintshela kunombolo yethebhu 3, mane ucindezele u-“Ctrl + 3”.

Enye inketho yokuzula phakathi kwamathebhu ukusebenzisa inhlanganisela yokhiye "Ctrl + PgUp" ukuze uye kuthebhu yangaphambilini kanye no-"Ctrl + PgDn" ukuze uqhubekele kuthebhu elandelayo. Le nqubo iwusizo ikakhulukazi uma unenombolo enkulu yamathebhu avuliwe futhi udinga ukuhamba ngokushesha phakathi kwawo.

Sengiphetha, ukushintsha amathebhu ngekhibhodi ku-Excel kungonga isikhathi futhi kusheshise ukuzulazula ngaphakathi kwesipredishithi. Izinqamuleli zekhibhodi ezishiwo, ezifana no-Ctrl + PgUp no-Ctrl + PgDn, kulula ukuzikhumbula nokusebenzisa. Ngokuzijwayeza, ukwazi lezi zinhlanganisela zokhiye kuzovumela abasebenzisi ukuthi bahambe ngokushesha phakathi kwamathebhu e-Excel ahlukene ngaphandle kokusebenzisa igundane noma ukwenza ukuchofoza okuningi. Lokhu kusebenza kungaba usizo ikakhulukazi kulabo abasebenza ngamaspredishithi amakhulu noma ayinkimbinkimbi, njengoba kwenza kube lula ukuhlela nokuphatha idatha. Ngamafuphi, ukufunda ukushintsha amathebhu ngekhibhodi ku-Excel kungathuthukisa ukusebenza kahle nokukhiqiza lapho usebenza naleli thuluzi elinamandla.