Indlela yokutshintsha iiTabs usebenzisa ikhibhodi kwi-Excel

Uhlaziyo lokugqibela: 10/08/2023

Emhlabeni yespreadsheet, isantya kunye nokusebenza kakuhle ngundoqo wokuphucula ukuhamba komsebenzi wakho. Esinye sezakhono ezisisiseko sobuchule be-Excel kukuphatha ngokukhawuleza iithebhu. Ngelixa abasebenzisi abaninzi besebenzisa imawusi ukutshintshela kwenye ithebhu ukuya kwenye, kukho indlela ekhawulezayo nesebenzayo: usebenzisa ikhibhodi. Kweli nqaku, siza kuphonononga indlela yokutshintsha iithebhu ngekhibhodi kwi-Excel, ukuthatha inzuzo yeendibaniso eziphambili kunye neendlela ezimfutshane eziququzelela ukukhangela ngaphandle komgudu ngokusebenzisa iincwadi zokusebenza ezahlukeneyo kunye ne-spreadsheets. Fumana indlela yokwandisa imveliso yakho kunye nokukhawulezisa imisebenzi yakho kwi-Excel usebenzisa obu buchule busebenzayo.

1. Intshayelelo yokukhangela ithebhu kwi-Excel usebenzisa ikhibhodi

Ukukhangela iithebhu kwi-Excel usebenzisa ikhibhodi yinto eluncedo kakhulu enokukunceda ukhawulezise umsebenzi wakho kwaye wandise imveliso yakho. Endaweni yokuba usebenzise imawusi ukutshintshela kwenye ithebhu ukuya kwenye, ungasebenzisa ngokulula indibaniselwano engundoqo ukuskrola ngokukhawuleza kwi-spreadsheets zakho.

Ukuqala ukujongisisa iithebhu kwi-Excel usebenzisa ibhodi yezitshixo, kufuneka kuqala uqinisekise ukuba amaqhosha eRibhoni oFikelelo oluKhawulezayo ukhetho luvuliwe. Olu khetho luyakuvumela ukuba usebenzise imidibaniso yezitshixo ukufikelela kwimiyalelo ekhoyo kwiribhoni. Ungaluvula olu khetho ngokuya kwi "Fayile" tab, ukhethe "EziKhetho" kwaye emva koko ukhethe "Yenza iRibhoni ngokwezifiso." Ukusuka apho, uya kufumana "Bonisa ithebhu yokufikelela ngokukhawuleza ezantsi kweribhoni" kwaye kuya kufuneka uyikhethe ukuze uyivule.

Nje ukuba uvule iqhosha elinqumlayo leribhoni ukhetho, unokuzulazula kwiithebhu kwi-Excel usebenzisa ikhibhodi. Ungasebenzisa iqhosha le-Alt kunye neqhosha elihambelana nonobumba okrwelelwe umgca ngaphantsi kwithebhu ofuna ukuyikhetha. Umzekelo, ukuba ithebhu ibizwa ngokuba yi "Data" kwaye unobumba "D" ukrwelelwe umgca, ungacofa i-Alt + D ukukhetha loo thebhu. Ukongeza, ungasebenzisa utolo olusekhohlo kunye nasekunene ukusuka kwithebhu enye ukuya kwenye.

2. Iindlela ezimfutshane ze-keyboard ukutshintshela phakathi kwe-Excel tabs

Kukho indibaniselwano ezininzi eziphambili onokuzisebenzisa ukutshintsha phakathi kweethebhu ze-Excel ngokukhawuleza nangokufanelekileyo. Nazi ezinye iindlela ezimfutshane eziluncedo kakhulu ze-keyboard:

1. Ctrl + Tab: Le ndibaniselwano yesitshixo ikuvumela ukuba uye kwithebhu elandelayo.

2. Ctrl + Shift + Tab: Sebenzisa le ndibaniselwano ukuya kwisithuba sangaphambili.

3. Ctrl + F6: Ngale ndlela imfutshane ungakhawuleza uye kwithebhu elandelayo ekhoyo.

Ezi ndlela zimfutshane zebhodi yezitshixo ziluncedo kakhulu xa uneethebhu ezininzi ezivulekileyo kwaye kufuneka uhambe ngokukhawuleza phakathi kwazo. Khumbula ukuziqhelanisa nokuziqhelanisa nezi ndlela zimfutshane ukwenza umsebenzi wakho kwi-Excel usebenze ngakumbi.

3. Uzisebenzisa njani iihotkeys ukutshintsha iithebhu kwi-Excel

IiHotkeys ziyindlela entle yokuphucula ukusebenza kakuhle xa usebenzisa iExcel. Ukuba uneethebhu ezininzi ezivulekileyo kwaye kufuneka utshintshe ngokukhawuleza phakathi kwazo, kukho imidibaniso engundoqo ekuvumela ukuba uyenze ngokukhawuleza kwaye kulula. Okulandelayo, siza kukubonisa Inyathelo nenyathelo .

1. Idibaniso engundoqo esetyenziswa kakhulu yi I-Ctrl + Ithebhu. Olu luhlu luya kukuvumela ukuba utshintshele kwithebhu elandelayo ngokulandelelana kweethebhu ezivulekileyo. Ukuba uneethebhu ezininzi ezivulekileyo, cinezela ngokulula indibaniselwano yesitshixo ngokuphindaphindiweyo ukujikeleza kuzo.

2. Ukuba ufuna ukuya kwithebhu ethile ngokuthe ngqo, ungasebenzisa indibaniselwano yesitshixo I-Ctrl + F6. Olu luhlu luza kuvula uluhlu oluhlayo kunye nazo zonke iithebhu ezivulekileyo kwaye unokukhetha ngokukhawuleza ithebhu oyifunayo usebenzisa izitshixo zotolo kunye neqhosha elithi Faka.

4. Ukudibanisa izitshixo zemaphu zokukhangela ithebhu kwi-Excel

Ukuhamba ngokufanelekileyo phakathi kweethebhu ze-Excel kunokwandisa kakhulu ukusebenza kakuhle kunye nemveliso. I-Excel ibonelela ngeendlela ezahlukeneyo zokudityaniswa kwezitshixo ezikuvumela ukuba uhambe ngokukhawuleza phakathi kwespredishithi ezahlukeneyo. Kweli candelo, ndiza kuchaza ukuba ungenza njani imephu yezi zitshixo zendibaniselwano ngokokhetho lwakho.

1. Vula i-Excel kwaye uye kwithebhu ethi "Ifayile". Cofa u-“Options” kwi-drop-down menu.

2. Kwifestile yeenketho ze-Excel, khetha ithebhu ethi "Lungisa iRibhoni".

3. Kuluhlu lwasekhohlo, uya kubona uluhlu lwayo yonke imisebenzi ekhoyo kwi-Excel. Skrolela ezantsi kwaye ufumane icandelo elithi "Iithebhu eziphambili".

4. Cofa utolo olusezantsi ecaleni kwe "Tabs eziphambili" ukwandisa iinketho. Apha uya kubona uluhlu lweethebhu eziphambili ze-Excel, ezinje nge "Ikhaya", "Faka", "Idatha", njl.

5. Khetha isithuba ofuna ukwenza imephu yendibaniselwano yesitshixo.

6. Cofa iqhosha elithi "Lungisa" ngezantsi ekunene kwefestile.

Umxholo okhethekileyo- Cofa Apha  Yintoni i-Flash Grenade kwaye isetyenziswa njani kwi-CS:GO?

7. Kwifestile evelayo ethi "Yenza ngokwezifiso izinto", khetha i "Commands" ukhetho phezulu ngasekhohlo.

8. Kwifestile entsha ethi "Yenza i-Keyboard", uya kubona uluhlu lwazo zonke iindibaniso eziphambili ezikhoyo.

9. Kwicandelo elithi "Iintlobo", khetha u- "Order" ukufumana iinketho ezinxulumene nokukhangela phakathi kweethebhu.

10. Ngasekunene, kwicandelo elithi "Imiyalelo", uya kufumana iindlela ezahlukeneyo zokudibanisa okubalulekileyo. Cofa kwinketho oyifunayo njenge "Iphepha Elilandelayo", "Iphepha elidlulileyo", "Yiya kwiphepha lokuqala", njl.

11. Emva kokuba ukhetho lukhethiwe, cofa indawo ethi "Isitshixo soFikelelo esitsha" kwaye ucinezele indibaniselwano yesitshixo ofuna ukuyisebenzisela loo msebenzi.

12. Cofa iqhosha elithi "Yabela" ukunika indibaniselwano yesitshixo kumsebenzi kwaye emva koko ucofe "Vala" ukuvala zonke iifestile.

Ngoku uya kuba nemephu yendibaniselwano engundoqo yokukhangela ithebhu kwi-Excel. Ungaphinda la manyathelo angasentla ukwenza imephu yezinye iindibaniselwano ezingundoqo kwezinye iithebhu ze-Excel ngokweemfuno zakho. Oku kulungelelaniswa kuya kukuvumela ukuba ugcine ixesha xa uhamba phakathi kwespredishithi ezahlukeneyo kwaye wenze imisebenzi yakho ngokufanelekileyo.

5. Uwenza njani umsebenzi wakho we-Excel ngokutshintsha i-keyboard tab

Ukutshintsha iithebhu kwi-Excel kunokuba yinkqubo ecothayo ukuba yenziwa ngesandla nge mouse. Nangona kunjalo, kukho indlela esebenza ngakumbi yokwenza oku usebenzisa ikhibhodi. Kweli nqaku, ndiza kukubonisa .

Inyathelo lokuqala lokukwazi ukutshintsha iithebhu usebenzisa ibhodi yezitshixo kukwenza umsebenzi omfutshane wethebhu ye-Excel. Ukwenza oku, kufuneka uye kwi "Fayile" ithebhu kwiribhoni kwaye ukhethe "Options." Okulandelayo, kwifestile yeenketho ze-Excel, khetha "Hlela iiNdlela ezimfutshane zokuKhetha" kwaye ujonge ibhokisi ethi "Iindlela ezimfutshane zeTab." Nje ukuba wenze oku, cofa u-"Kulungile" ukugcina utshintsho.

Nje ukuba wenze umsebenzi omfutshane wesithuba, uya kukwazi ukuswitsha phakathi kweethebhu ezahlukeneyo usebenzisa imidibaniso engundoqo. Umzekelo, ukuya kwithebhu ethi "Sheet2", kufuneka ucofe "Ctrl + 2". Ukuba ufuna ukuya kwithebhu ethi "Sheet3", unokwenza ngokucinezela "Ctrl + 3", njalo njalo. Ngale ndlela, unokutshintsha ngokukhawuleza phakathi kweethebhu ezahlukeneyo ze-Excel ngaphandle kokusebenzisa imawusi.

6. Funda iingenelo kunye neenzuzo zokutshintsha iithebhu kwi-Excel usebenzisa ikhibhodi

Ukutshintsha iithebhu kwi-Excel usebenzisa ikhibhodi sisakhono esiluncedo esiya kongela ixesha kwaye sikhawulezise umsebenzi wakho. Nazi ezinye iingenelo kunye neenzuzo zokusebenzisa olu phawu:

1. Isantya sokuhamba: Ngokusebenzisa ikhibhodi ukutshintsha iithebhu kwi-Excel, unokuhamba ukusuka kwelinye iphepha ukuya kwelinye ngokukhawuleza nangokufanelekileyo. Oku kuluncedo ngakumbi xa ufuna uphononongo okanye uhlele idatha kwi-spreadsheets ezahlukeneyo.

2. Ziphephe izinto ezikuphazamisayo: Ngokungathembeli kwimouse okanye kwi-touchpad, ukutshintsha iithebhu ngekhibhodi kukuvumela ukuba uhlale ugxile kumsebenzi wakho ngaphandle kokuphazamiseka okungafunekiyo. Ungajonga kumaphepha ahlukeneyo ngaphandle kokususa amehlo akho emsebenzini wakho.

3. Ukufikelela ngokuthe ngqo kwi imisebenzi ephambili: Ngokusebenzisa imidibaniso engundoqo, unokufikelela ngokukhawuleza kwimisebenzi ephambili ye-Excel, njengokufaka amaphepha amatsha, ukucima amaphepha asele ekhona, okanye ukukhangela amaphepha athile. Ezi mpawu ziya kukuvumela ukuba usebenze ngokufanelekileyo kunye nemveliso.

7. Uyenza njani imidibaniso engundoqo ukutshintsha iithebhu kwi-Excel

Ukwenza ngokwezifiso imidibaniso engundoqo yokutshintsha iithebhu kwi-Excel yindlela enhle yokuhlengahlengisa ukuhamba kwakho komsebenzi kunye nokwandisa imveliso yakho. Nangona i-Excel sele inezishunqulelo zebhodibhodi ezichazwe kwangaphambili, unokufuna ukuzenza ukuze zilungele iimfuno zakho ezithile. Ngethamsanqa, ukwenza oku kulula kakhulu kwaye kufuna abambalwa kuphela amanyathelo ambalwa.

Ukuqalisa, vula i-Excel kwaye uye kwithebhu ethi "Ifayile". Okulandelayo, khetha "EziKhetho" kwaye emva koko "Yenza iRibhoni ngokwezifiso." I-pop-up window iya kuvela apho unokwenza ngokusesikweni imidibaniso yezitshixo. Kwikholamu ekunene, uya kufumana uluhlu lwemiyalelo ekhoyo kwi-Excel.

Skrolela ezantsi de ufumane icandelo elithi "Iithebhu eziphambili" kwaye ukhethe "Ekhaya." Apha uza kubona zonke iinketho eziyelelene kwisithuba sasekhaya. Ukutshintsha indibaniselwano yesitshixo yokutshintsha iithebhu, khetha u- "Tshintshela kwithebhu elandelayo" kwaye ucofe u- "Lungisa." Okulandelayo, ngenisa indibaniselwano yeqhosha elitsha ofuna ukulisebenzisa. Qinisekisa ukuba ayisetyenziswa ngomnye umyalelo kwaye emva koko ucofe "Kulungile." Ulungile! Ngoku uya kukwazi ukutshintsha iithebhu kwi-Excel usebenzisa indibaniselwano yesitshixo esilungiselelweyo.

8. Ukuphonononga iindlela ezahlukeneyo zokutshintsha iithebhu ngekhibhodi kwi-Excel

Kukho iindlela ezininzi zokutshintsha iithebhu kwi-Excel usebenzisa ikhibhodi, enokukhawulezisa kakhulu ukuhamba kunye nokuphucula ukusebenza kakuhle ekugqibeni imisebenzi. Iindlela ezahlukeneyo kunye neendlela ezimfutshane zokutshintsha phakathi kweethebhu ziya kuphononongwa ngezantsi:

Umxholo okhethekileyo- Cofa Apha  Ungayitshintsha njani imvelaphi yakho ye-Instagram

1. Ukusebenzisa indlela emfutshane Ctrl ikhibhodi + Pg Up/Pg Dn: Ukutshintshela kwenye ithebhu ukuya kwenye, cinezela ngokulula kwaye ubambe iqhosha leCtrl kwaye emva koko ucinezele iqhosha lePhepha Phezulu (Pg Up) ukuya ngasekhohlo okanye iqhosha lePhepha phantsi (Pg Dn) ukuya ngasekunene. . Le ndlela ikhawuleza kwaye kulula ukuyikhumbula.

2. Ukusebenzisa indlela emfutshane ye-keyboard Ctrl + Shift + Pg Up/Pg Dn: Ukuba ufuna ukutshintshela ngokukhawuleza kwisithuba sokuqala okanye sokugqibela, ungasebenzisa le ndlela imfutshane yebhodibhodi. Bamba iqhosha le-Ctrl kunye neqhosha le-Shift, emva koko ucinezele iqhosha lePhepha phezulu (Pg Up) ukuya kwithebhu yokuqala okanye iqhosha lePhepha phantsi (Pg Dn) ukuya kwithebhu yokugqibela.

9. Amanyathelo alula ukuVula i-Tab Navigation usebenzisa i-Keyboard kwi-Excel

Kweli candelo siza kukubonisa indlela yokuvula kunye nokuvala ukuhamba kwethebhu usebenzisa ikhibhodi kwi-Excel. Lo msebenzi uza kukuvumela ukuba ufikelele ngokukhawuleza kwi-spreadsheets ezahlukeneyo ngaphandle kokusebenzisa imouse. Landela la manyathelo alula ukwenza olu khetho.

Inyathelo lesi-1: Vula eyakho Ifayile ye-Excel kwaye uye kwi "Fayile" isithuba phezulu ngasekhohlo ukusuka kwisikrini. Cofa kwindawo ethi "Khetha" kwimenyu eyehlayo.

Inyathelo lesi-2: Kwifestile yeenketho, khetha ithebhu ethi "Ufikelelo" kwiqela lenjongo lasekhohlo. Skrolela ezantsi de ufumane icandelo elithi "Skrolela kunye noKhetho".

Inyathelo lesi-3: Ngaphakathi kweli candelo, jonga ibhokisi ethi "Sebenzisa izitshixo zotolo ukuhamba phakathi kweeseli" ukuvula ukukhangela kwethebhu usebenzisa ibhodi yezitshixo. Ukuba ufuna ukukhubaza eli nqaku, vele ungachongi ibhokisi kwaye ucofe "Kulungile" ukugcina utshintsho lwakho.

10. Ukusombulula iingxaki eziqhelekileyo xa utshintsha iithebhu ngekhibhodi kwi-Excel

Xa utshintsha iithebhu ngekhibhodi kwi-Excel, kuqhelekile ukujongana neengxaki ezithile. Nangona kunjalo, kukho izisombululo ezilula eziza kukunceda uzisombulule ngokukhawuleza. Apha ngezantsi zezona ngxaki zixhaphakileyo kunye nendlela yokuzilungisa:

1. Ingxaki: Ayikwazanga ukutshintshela kwithebhu ethile usebenzisa ikhibhodi.

Ukuba awukwazi ukutshintshela kwithebhu ethile usebenzisa ibhodi yezitshixo, ungazama la manyathelo alandelayo:

  • Inyathelo 1: Qinisekisa ukuba ithebhu ofuna ukutshintshela kuyo ibonakala kwi-Excel tab bar.
  • Inyathelo 2: Cofa indibaniselwano isitshixo "Ctrl + Iphepha Phantsi" ukuya tab elandelayo okanye "Ctrl + Iphepha Up" ukubuyela tab yangaphambili.
  • Inyathelo 3: Ukuba awukwazi ukutshintshela kwithebhu oyifunayo, cofa iqhosha elithi "Ctrl + F6" ukuvula uluhlu lwazo zonke iithebhu ezivulekileyo kwaye ukhethe leyo oyifunayo usebenzisa izitshixo zetolo kunye neqhosha elithi "Ngena".

2. Ingxaki: Ukutshintsha iithebhu kuguqula indawo yeseli esebenzayo.

Ukuba ukutshintsha iithebhu kuguqula indawo yeseli esebenzayo kwaye ufuna ukuyigcina ikwindawo enye, ungalandela la manyathelo:

  • Inyathelo 1: Phambi kokutshintsha iithebhu, khetha iseli ofuna ukuyigcina isebenza.
  • Inyathelo 2: Cofa "Ctrl + 1" ukuvula ifomati yeseli.
  • Inyathelo 3: Cofa ithebhu ethi "Ukhuseleko" kwaye uqinisekise ukuba ibhokisi ethi "Ivaliwe" ayikhangelwanga. Emva koko, cofa "Kulungile."

3. Ingxaki: Awunakutshintsha iithebhu usebenzisa ikhibhodi kwincwadi yomsebenzi ekwabelwana ngayo.

Ukuba awukwazi ukutshintsha iithebhu usebenzisa ibhodi yezitshixo kwincwadi ekwabelwana ngayo, ungazama oku kulandelayo:

  • Inyathelo 1: Qinisekisa ukuba uneemvume zokutshintsha iithebhu kwincwadi yomsebenzi ekwabelwana ngayo.
  • Inyathelo 2: Khangela ukuba incwadi yomsebenzi ekwabelwana ngayo ivumela ukhetho lwe "Keyboard Navigation" kwiseto. Ukuba ivaliwe, qhagamshelana nomnini wencwadi ukuze uyivule.
  • Inyathelo lesi-3: Ukuba la manyathelo angasentla akayisombululi ingxaki, zama ukusebenzisa imowusi okanye iqhosha elithi “Alt + Tab” ukutshintshela phakathi kweefestile ezivuliweyo kwaye ukhethe incwadi yokusebenza efunwayo ye-Excel.

11. IiNdlela eziNgcono zokuTshintsho lweTabhu ngokuLungileyo kwi-Excel usebenzisa ikhibhodi

Ukutshintsha iithebhu ngokufanelekileyo kwi-Excel usebenzisa ikhibhodi, kukho iindlela ezilungileyo ezinokonga ixesha kunye ukwandisa imveliso. Ngezantsi kukho iingcebiso eziphambili zokwenza oku. ngokufanelekileyo:

1. Indlela emfutshane yekhibhodi: Sebenzisa Ctrl + PgUp ukuya kwithebhu yangaphambili, kwaye I-Ctrl + i-PgDn ukuqhubela phambili kwithebhu elandelayo. Ezi ndlela zimfutshane zikhawuleza kwaye kulula ukuzikhumbula, zikuvumela ukuba utshintshe iithebhu ngaphandle kokusebenzisa imouse.

2. Ukukhangela ngamagama: Ukuba iithebhu zakho zibhalwe ngamagama athile, ungasebenzisa indlela emfutshane yebhodi yezitshixo. I-Ctrl + F6 Ukuvula uluhlu lotsalo-phantsi oludwelisa zonke iithebhu ezivuliweyo. Emva koko, chwetheza ngokulula oonobumba bokuqala begama lethebhu ofuna ukutshintshela kuyo kwaye ukhethe ukhetho oluhambelanayo. Oku kuluncedo ngakumbi xa uneethebhu ezininzi ezivuliweyo.

Umxholo okhethekileyo- Cofa Apha  Ngaba unokuHlela ngePremier Pro ngaphandle kwe-Intanethi?

3. Ukulungisa iindlela ezimfutshane zebhodi yezitshixo: I-Excel ikuvumela ukuba ulungise iindlela ezimfutshane zakho zebhodi yezitshixo ukuze zihambelane neemfuno zakho ezithile. Unokwenza oku ngokufikelela kukhetho luka "Lungisa ikhibhodi" kwimenyu "yeFayile". Nje ukuba ulapho, khetha "iTab elandelayo" okanye "iTab yangaphambili" kwaye unike isinqumli sekhibhodi entsha ngokokuthanda kwakho.

12. Fumanisa iindlela ezimfutshane zebhodibhodi ezaziwa kancinci ukutshintshela iithebhu kwi-Excel

Kwi-Excel, ukutshintsha iithebhu kunokuba yinkqubo edinayo kwaye ithatha ixesha ukuba awuzazi iindlela ezimfutshane ezifanelekileyo zebhodibhodi. Ngethamsanqa, kukho iindlela ezimfutshane ezingaziwayo ezinokuthi zilungelelanise ukuhamba kwakho komsebenzi kwaye zikuvumela ukuba utshintshe iithebhu ngokukhawuleza nangokufanelekileyo. Ngezantsi, siza kukubonisa ezinye zezi ndlela zimfutshane kunye nendlela yokuzisebenzisa.

1. I-Ctrl + PgUp: Le ndlela imfutshane ikuvumela ukuba uye kwisithuba sangaphambili kwi-Excel. Cofa ngokulula iCtrl kunye nePgUp izitshixo ngaxeshanye ukwenza utshintsho. Le ndlela imfutshane iluncedo ngakumbi xa uneethebhu ezininzi ezivulekileyo kwaye ufuna ukubuyela ngokukhawuleza kwisithuba sangaphambili.

2. I-Ctrl + i-PgDn: Le ndlela imfutshane isebenza ngokufanayo naleyo yangaphambili, kodwa ikuvumela ukuba utshintshele kwithebhu elandelayo kwi-Excel. Cinezela i-Ctrl kunye ne-PgDn amaqhosha ngelixa ngaxeshanye ukwenza utshintsho. Ukuba uye kwisithuba sangaphambili usebenzisa indlela emfutshane yangaphambili, ungasebenzisa le ndlela imfutshane ukubuyela kwisithuba soqobo.

3. I-Ctrl + F6: Le ndlela imfutshane ikuvumela ukuba utshintshe phakathi kweethebhu ezivulekileyo kwi-Excel ngokulandelelana. Ngalo lonke ixesha ucofa u-Ctrl + F6, uya kuya kwithebhu elandelayo ekhoyo. Ukuba sele ukwithebhu yokugqibela, indlela emfutshane iya kukubuyisela umva kwisithuba sokuqala. Le ndlela imfutshane iluncedo xa uneethebhu ezininzi ezivuliweyo kwaye ufuna ukuhamba ngokukhawuleza phakathi kwazo.

13. Indlela yokukhawulezisa imveliso yakho kwi-Excel ngokutshintsha kwebhodibhodi

I-Excel sisixhobo esinamandla kakhulu sokwenza imisebenzi yokubala kunye nohlalutyo lwedatha. Nangona kunjalo, amaxesha amaninzi abasebenzisi banqunyelwe ixesha abalichitha betshintsha phakathi kweethebhu besebenzisa imawusi. Ngethamsanqa, kukho indlela yokukhawulezisa imveliso yakho kwi-Excel usebenzisa i-keyboard tab switching.

Inyathelo lokuqala elibalulekileyo kukuziqhelanisa nezishunquleli zebhodi ye-Excel. Umzekelo, ungasebenzisa indibaniselwano engundoqo "Ctrl + Iphepha phezulu" ukuya kwithebhu yangaphambili kwaye "Ctrl + Iphepha Ezantsi" ukuya kwithebhu elandelayo. Ezi ndlela zimfutshane ziyakuvumela ukuba utshintshe ngokukhawuleza phakathi kwespredishithi ezahlukeneyo kwifayile yakho.

Enye indlela yokukhawulezisa imveliso yakho kwi-Excel kukusebenzisa umsebenzi othi "Yiya ku" kwikhibhodi yakho. Unokufikelela kulo msebenzi ngokucinezela indibaniselwano yesitshixo "Ctrl + G." Nje ukuba "Yiya" ibhokisi yencoko yababini ivula, ungangenisa inani lethebhu ofuna ukuya kuyo kwaye ucinezele u-"Enter." Oku kuyakusa ngqo kwisithuba esikhankanyiweyo ngaphandle kokuskrola ngesandla kuzo zonke iithebhu.

14. Ukuqukumbela: Yandisa ukusebenza kwakho kwi-Excel ngokulawula ukukhangela kwethebhu ngekhibhodi

Ukwandisa ukusebenza kwakho kwi-Excel, kubalulekile ukuba ulawule ukukhangela kwethebhu ngekhibhodi. Oku kunokukhawulezisa imisebenzi yakho kwaye kukuvumela ukuba usebenze ngokufanelekileyo. Kule post, siya kukunika isikhokelo senyathelo ngenyathelo ukuze ufunde indlela yokwenza.

Ngaphambi kokuba siqale, kubalulekile ukuqaphela ukuba i-Excel inikezela ngeendlela ezimfutshane ezininzi zebhodibhodi ukwenza izenzo ezahlukeneyo. Nangona kunjalo, kulo mzekelo siza kugxila kukhangelo phakathi kweethebhu. Ukwenza oku, ungasebenzisa ukudibanisa okubalulekileyo "Ctrl" kunye nenombolo ehambelana nethebhu ofuna ukuyikhetha. Umzekelo, ukuba ufuna ukutshintshela kwinombolo ye-tab yesi-3, cinezela ngokulula "Ctrl + 3".

Olunye ukhetho lokuhamba phakathi kweethebhu kukusebenzisa indibaniselwano engundoqo "Ctrl + PgUp" ukuya kwithebhu yangaphambili kunye no "Ctrl + PgDn" ukuqhubela phambili kwithebhu elandelayo. Obu buchule buluncedo ngakumbi xa unenani elikhulu leethebhu ezivulekileyo kwaye kufuneka uhambe ngokukhawuleza phakathi kwazo.

Ukuqukumbela, ukutshintsha iithebhu ngekhibhodi kwi-Excel kunokonga ixesha kunye nokukhawulezisa ukukhangela ngaphakathi kwispredishithi. Iindlela ezimfutshane zekhibhodi ezikhankanyiweyo, ezifana neCtrl + PgUp kunye neCtrl + PgDn, kulula ukuyikhumbula kwaye isebenzise. Ngokuziqhelanisa, ukubamba kakuhle ezi ndibaniselwano zingundoqo kuya kuvumela abasebenzisi ukuba bahambe ngokukhawuleza phakathi kweethebhu ezahlukeneyo ze-Excel ngaphandle kokusebenzisa imawusi okanye ukwenza unqakrazo oluninzi. Lo msebenzi unokuba luncedo ngakumbi kwabo basebenza ngeespredishithi ezinkulu okanye ezinzima, njengoko kwenza kube lula ukucwangcisa nokulawula idatha. Ngamafutshane, ukufunda indlela yokutshintsha iithebhu ngekhibhodi kwi-Excel kunokuphucula ukusebenza kakuhle kunye nemveliso xa usebenza nesi sixhobo sinamandla.