Indlela yokutshixa umqolo kunye nekholamu kwi-Excel xa uskrola.

Kwihlabathi elikhulu le-Excel, kukho izinto ezininzi kunye nezixhobo ezenza kube lula ukukhohlisa kunye nokucwangcisa idatha. Nangona kunjalo, kukho amaxesha apho kuyimfuneko ukutshixa umqolo othile kunye nekholomu ukubathintela ukuba bangahambi xa behamba kwi-spreadsheet. Kwabo bafuna ukufunda indlela yokubhloka ngempumelelo umqolo kunye ikholamu kwi-Excel, eli phepha limhlophe liya kunika ulwazi kunye nezakhono ezifunekayo ukuze kuphunyezwe oku. Siza kuphonononga iindlela ezisisiseko kunye neziphambili eziya kukuvumela ukuba ugcine ulwazi olubalulekileyo lulungisiwe, lunikeze uzinzo olukhulu kunye nokulula ekulawuleni idatha yakho. Qhubeka ufunde ukufumanisa ukuba ungawenza njani lo msebenzi ubalulekileyo kwi-Excel!

1. Intshayelelo kwiMiqolo yokutshixa kunye nomsebenzi weKholamu kwi-Excel

I-Excel sisixhobo esinamandla sokwenza izibalo kunye nohlalutyo lwedatha. Nangona kunjalo, ngamanye amaxesha kunokuba nzima ukugcina ulwazi ngokulandelelana xa sisebenza ngezixa ezikhulu zedatha. Oku kuxa umqolo kunye nekholamu yokutshixa inqaku linokuba luncedo kakhulu.

Imisebenzi yokutshixa kunye neekholamu kwi-Excel ikuvumela ukuba ulungise imiqolo okanye iikholamu ezithile ukuze zihlale zibonakala ngelixa siskrola kulo lonke uxwebhu. Oku kuluncedo ngakumbi xa sisebenza ngeetafile ezinkulu kwaye sifuna ukugcina i-header ibonakala ngamaxesha onke.

Ukutshixa imiqolo kunye neekholamu kwi-Excel, landela la manyathelo alula:

1. Khetha umqolo ongezantsi kwalowo ufuna ukuwuvala. Ukuba ufuna ukuvala imiqolo emininzi, khetha eyona iphantsi kuyo yonke.
2. Cofa kwindawo ethi "Jonga" kwi ibar yesixhobo evela kwi-Excel.
3. Kwiqela elithi "Windows" kwithebhu ethi "Jonga", khetha "Iiphaneli zokutshixa." Ibhokisi yencoko yababini ivela kunye neenketho ezikhoyo zokutshixa imiqolo nemiqolo.
4. Kwibhokisi yencoko yababini, khetha "Iiphaneli zokutshixa" ukhetho. Oku kuya kutshixa yomibini imiqolo ephezulu kunye neekholamu ekhohlo lokhetho.
5. Cofa u-"Yamkela" ukuze usebenzise utshintsho.

Ngokulandela la manyathelo alula, uya kukwazi ukusebenzisa ngokupheleleyo umqolo kunye nekholamu yokutshixa inqaku kwi-Excel, ukugcina ulwazi olufanelekileyo luhlala lubonakala ngelixa usebenza ngedatha eninzi. Sebenzisa esi sixhobo ukuphucula imveliso yakho kunye nokusebenza kakuhle xa usebenzisa i-Excel.

2. Iindlela zokutshixa umqolo kunye nekholamu kwi-Excel xa uskrola

Kukho iindlela ezahlukeneyo ezinokusetyenziswa ukutshixa umqolo kunye nekholomu kwi-Excel xa uskrola. Ezi mpawu ziluncedo ngakumbi xa usebenza nespredishithi ezinkulu, ezinzima, njengoko zikuvumela ukuba ugcine idatha ethile okanye iiheader ezibonakalayo ngamaxesha onke.

Enye indlela yokutshixa umqolo kunye nekholamu kwi-Excel kukusebenzisa umsebenzi othi “Freeze Panes”. Ukwenza oku, kuqala kufuneka ukhethe iseli ezantsi nje komqolo ofuna ukuwutshixa kwaye ekunene koluhlu ofuna ukulutshixa. Okulandelayo, kufuneka uye kwindawo ethi "Jonga" kwibar yesixhobo kwaye ucofe u-"Freeze iiPaneli." Ngale ndlela, umqolo okhethiweyo kunye nekholamu ziya kuhlala zibonakala ngelixa uskrola lonke i-spreadsheet.

Enye indlela onokuyisebenzisa kukuqhobosha imiqolo okanye iikholamu ezithile. Ukwenza oku, khetha kuqala umqolo okanye ikholamu ofuna ukuyiqhobosha. Emva koko, yiya kwindawo ethi "Jonga" kwaye ucofe u-"Pin Dashboards." Oku kuya kugcina umqolo okhethiweyo okanye ikholamu ixinge phezulu okanye ekhohlo kwi-spreadsheet, ngokulandelelana, ngelixa uskrola kuwo wonke umxholo. Oku kunokwenza kube lula ukujonga kunye nokubhekisela kwidatha ebalulekileyo kwi-spreadsheet sakho.

Ngamafutshane, ukutshixa umqolo kunye nekholomu kwi-Excel kwi-scroll yinto eluncedo enokukunceda ugcine idatha ethile okanye iiheader zihlala zibonakala. Unokufezekisa oku ngokusebenzisa umsebenzi othi "Freeze Panels" ukutshixa umqolo wonke kunye nekholomu, okanye ngokusebenzisa indlela yokukhonkotha imigca ethile okanye iikholamu. Ezi ndlela ziya kukuvumela ukuba usebenze ngokufanelekileyo kwaye uququzelele i-spreadsheets zakho ngokufanelekileyo.

3. Inyathelo ngeNyathelo: Ukutshixa umqolo othe ngqo xa uSkrola kwi-Excel

Ukutshixa umqolo othile xa uskrola kwi-Excel, landela la manyathelo:

1. Vula ifayile ye-Excel apho ufuna ukutshixa umqolo othile xa uskrola. Cofa ithebhu ethi "Jonga" phezulu kwefestile ye-Excel.
2. Kwiqela elithi “IiPhaneli zokuMkhenkcisa”, cofa inketho ethi “Yifriza imiqolo ephezulu”. Oku kuya kutshixa umqolo wangoku kunye nayo yonke imiqolo engaphezulu kwayo. Ukuba ufuna ukutshixa umqolo owahlukileyo, nqakraza ngokulula kumqolo ofunekayo phambi kokukhetha olu khetho.
3. Uya kubona umgca wamachaphaza obonisa ukuba phi ivalile umqolo. Ukuqinisekisa ukuba itshixiwe ngokuchanekileyo, zama ukuskrolela phezulu okanye ezantsi kwi-spreadsheet. Uluhlu olutshixiweyo luya kuhlala lubonakala phezulu kwifestile njengoko uskrola.

Kwaye yiloo nto! Ngoku unokutshixa ngokufanelekileyo umqolo othile xa uskrola kwi-Excel. Khumbula ukuba le ndlela ayisayi kuchaphazela iikholamu, yimiqolo kuphela, ngoko ke uya kuba nakho ukuskrola ngokuthe tye kwi-spreadsheet sakho.

4. Inyathelo ngeNyathelo: Ukutshixa iKholamu eKhethekileyo xa uSkrola kwi-Excel

5. Indlela yokutshixa ngaxeshanye umqolo kunye nekholamu kwi-Excel xa uskrola

Ukuba usebenza kwi-Excel kwaye ufuna ukutshixa ngaxeshanye umqolo kunye nekholamu xa uskrola kwi-spreadsheet, ukwindawo elungileyo. Ngethamsanqa, i-Excel ibonelela ngenqaku elikuvumela ukuba wenze oku ngokulula nangokufanelekileyo. Landela la manyathelo ukutshixa umqolo kunye nekholamu kwi-Excel:

1. Khetha iseli ekwisiphambuka somqolo kunye nekholamu ofuna ukuyitshixa. Apha, ungakhetha iseli ethile okanye ngokulula ucofe kuyo nayiphi na iseli ngaphakathi komqolo kunye nekholamu ofuna ukuyitshixa.

2. Yiya kwi-"Jonga" ithebhu kwi-toolbar ye-Excel kwaye ucofe "IiPhenethi zokutshixa" kwiqela le-"Window". Uya kubona imenyu eyehlayo evulekileyo ngeendlela ezintathu ezahlukeneyo.

3. Ukusuka kwimenyu eyehlayo, khetha u-“Tshixa umqolo oPhezulu” ukuba ufuna ukutshixa umqolo, “Tshixa uKholamu waKhohlo” ukuba ufuna ukutshixa ikholamu, okanye “IPhaneli yokuTshixa” ukuba ufuna ukuyitshixa yomibini umqolo kunye nomqolo. ikholamu ngaxeshanye. Kwaye yiloo nto! Ngoku, xa uskrola kwi-spreadsheet, umqolo kunye nekholamu oyitshixeyo ziya kuhlala endaweni.

6. Ukutshixa iMiqolo eMininzi kunye neeKholamu kwi-Excel Xa uSkrola - Ubuchwephesha obuPhezulu

Ingxaki eqhelekileyo abanokuthi bajongane nayo abasebenzisi be-Excel sisidingo sokutshixa imiqolo emininzi kunye neekholamu xa uskrola kwi-spreadsheet ende. Ngethamsanqa, kukho iindlela eziphambili ezikuvumela ukuba uyisombulule le ngxaki. ngokufanelekileyo kwaye ngokukhawuleza. Ngezantsi, sibonisa a Inyathelo nenyathelo eneenkcukacha ukulungisa le ngxaki kwi-Excel.

Ukutshixa imiqolo kunye neekholamu njengoko uhamba kwi-spreadsheet, ungasebenzisa i Iphaneli yokutshixa yeExcel. Eli nqaku likuvumela ukuba usete yomibini imiqolo kunye neekholamu ukuze zihlale zibonakala kwisikrini njengoko uhamba kumxholo wephepha. Ukwenza oku, kufuneka ukhethe kuqala iseli ephantsi ngokuthe ngqo kwimigca ofuna ukuyitshixa kwaye ekunene kwimiqolo ofuna ukuyitshixa. Emva koko yiya kwithebhu Jonga kwaye ucofe ku Iphaneli yokutshixa. Emva koko khetha ukhetho Iiphaneli zokutshixa. Ngoku ungaskrola kwi-spreadsheet ngaphandle kokulahlekelwa ngumbono wemiqolo etshixiweyo kunye neekholamu.

Olunye ubugcisa onokulusebenzisa Lungisa iiphaneli kwi-Excel. Ubuchwephesha bukuvumela ukuba utshixe indawo ethile yespredishithi, uhlala uyigcina ibonakala ngelixa uskrola kuwo wonke umxholo. Ukuqhobosha iiphaneli, kufuneka ukhethe iseli ezantsi nje kwemigca ofuna ukuyitshixa kwaye ekunene kwemiqolo ofuna ukuyitshixa. Emva koko yiya kwithebhu Jonga kwaye ucofe ku Lungisa iiphaneli. Emva koko khetha ukhetho Lungisa iiphaneli. Ngoku loo ndawo yespreadsheet iya kutshixwa kwaye isoloko ibonakala ngelixa uqhubeka kuwo wonke umxholo.

7. Uyivula njani imiqolo etshixiweyo yangaphambili kunye neeKholamu kwi-Excel

Ukuvula iirowu ezitshixiwe ngaphambili kunye neekholamu kwi-Excel ngumsebenzi olula ukuba ulandela la manyathelo alandelayo. Okokuqala, khetha i-spreadsheet ofuna ukusebenza kuso. Emva koko, yiya kwithebhu ethi "Hlola" kwi-toolbar ye-Excel kwaye ucofe "Khusela iPhepha." Kuya kuvela ifestile ezivelelayo apho unokungakhangeli khona “Khixa iiseli” kwaye ucofe u-“Kulungile.”

Ngoku, ukuvula imiqolo ethile, khetha imiqolo ofuna ukuyivula ngokucofa amanani omqolo kwicala lasekhohlo lespreadsheet. Emva koko, cofa ekunene ukhetho kwaye ukhethe "IiSeli zokuFomatha" kwimenyu ehlayo. Kwifestile ye-pop-up, yiya kwithebhu ethi "Ukhuseleko" kwaye ungaqwalasela ukhetho "luvaliwe". Cofa "Kulungile" ukuqinisekisa utshintsho.

Ukuba ufuna ukuvula iikholamu, khetha imiqolo ofuna ukuyivula ngokucofa oonobumba bekholamu phezulu kwispreadsheet. Emva koko, cofa ekunene ukhetho kwaye ukhethe "Fomatha iiseli." Kwifestile ye-pop-up, yiya kwithebhu ethi "Ukhuseleko" kwaye ungaqwalasela ukhetho "luvaliwe". Cofa "Kulungile" ukugcina utshintsho. Ngoku unokuvula iirowu ezitshixiwe ngaphambili kunye neekholamu kwi-Excel ngokulandela la manyathelo alula.

8. Lungisa iingxaki eziqhelekileyo ngokuvala imiqolo kunye neekholamu kwi-Excel xa uskrola

Xa usebenza nge-spreadsheets kwi-Excel, kuqhelekile ukutshixa imiqolo kunye neekholamu ukugcina idatha ethile ibonakala ngelixa uskrola kuyo yonke i-spreadsheet. Nangona kunjalo, ngamanye amaxesha iingxaki zinokuvela xa uzama ukutshixa imiqolo kunye neekholamu kwi-Excel xa uskrola. Ngethamsanqa, kukho izisombululo zokusombulula ezi ngxaki ziqhelekileyo.

Okokuqala, qiniseka ukuba usebenzisa inguqulelo echanekileyo ye-Excel yakho inkqubo yokwenza. Eminye imiqolo kunye nekholamu yokutshixa iimpawu zinokwahluka kancinane phakathi kweenguqulelo ezahlukeneyo ze-Excel, ngoko ke kubalulekile ukusebenzisa inguqulelo efanelekileyo ukunqanda iingxaki.

Enye ingxaki eqhelekileyo yokutshixa imiqolo kunye neekholamu kwi-Excel kukulibala ukuyivula ngaphambi kokwenza utshintsho kwispredishithi. Ukuba ubukhe watshixa ngaphambili imiqolo okanye iikholamu kwaye ngoku awukwazi ukwenza utshintsho kuzo, kuya kufuneka uyivule. Ukwenza oku, yiya kwithebhu ethi "Hlola" kwimenyu ye-Excel kwaye ukhethe ukhetho "lwePhepha elingaKhuseli". Oku kuya kukuvumela ukuba wenze utshintsho kwimiqolo etshixiweyo kunye neekholamu.

9. Ukusetyenziswa okusebenzayo kwemiqolo yokutshixa kunye neekholamu kwi-Excel: imizekelo yokusetyenziswa

Kwi-Excel, imigca yokutshixa kunye neekholamu yinto eluncedo kakhulu ekuvumela ukuba ugcine iiseli ezithile zibonakala ngelixa uskrola kwi-spreadsheet. Olu phawu luluncedo ngakumbi xa usebenza ngeeseti ezinkulu zedatha. Ngezantsi kukho imizekelo ebonakalayo yendlela yokusebenzisa imiqolo yokutshixa kunye neekholamu kwi-Excel.

1. Ukuvala okubhalwe ngasentla: Xa uneseti yedatha enkulu, kuqhelekile ukuba kulahleke iiheader zekholamu okanye zomqolo njengoko uskrola kumxholo. Ukulungisa oku, unokutshixa imiqolo okanye iikholamu eziqulethe iiheader ukwenzela ukuba iiheader zihlale zibonakala.

2. Iimbekiselo zokuvala: Xa usenza imisebenzi okanye iifomyula kwi-Excel, iimbekiselo kwiiseli ezithile zihlala zisetyenziswa. Nangona kunjalo, xa uskrola kwi-spreadsheet, kulula ukuphulukana nomkhondo wokuba zeziphi iiseli ekubhekiselwa kuzo. Ukuze ugweme oku, unokutshixa imiqolo kunye namakholomu abandakanyekayo kwimisebenzi, eya kwenza kube lula ukugcina umkhondo weereferensi ngamaxesha onke.

3. Iiphaneli zokutshixa: Ngamanye amaxesha kunokuba luncedo ukuba nenxalenye ye-spreadsheet okwangoku ngelixa uskrola kuwo wonke umxholo. Ukufezekisa oku, unokwahlula ifestile ye-Excel kwiiphaneli kwaye utshixe iipaneli ezithile. Ngale ndlela ungagcina icandelo elithile libonakala ngelixa uskrola kuyo yonke i-spreadsheet.

Ukutshixa imiqolo kunye namakholomu kwi-Excel yinto enokugcina ixesha kwaye yenza kube lula ukuphatha idatha kwiispredishithi ezinkulu. Ngokwazi ukuba ulisebenzisa njani eli nqaku ngokufanelekileyo, unokwandisa ukuhamba kwakho komsebenzi kwaye ugqibezele imisebenzi ngokufanelekileyo. Zama ngale mizekelo kwaye usebenzise ngokupheleleyo konke okunokwenzeka ukuba i-Excel inokunikela!

10. Iingcebiso ezongezelelweyo kunye neeNgcebiso zokuSebenzisa i-Lock kwi-Excel kwi-Scroll

Kweli candelo, siza kukubonelela ngezinye iingcebiso namaqhinga iinketho ezongezelelweyo zokwandisa ukusetyenziswa kwesitshixo xa uskrola kwi-Excel. Ezi ngcebiso ziya kukunceda wenze uninzi lweli nqaku kwaye uphucule ukusebenza kakuhle kwakho xa usebenza ngeeseti ezinkulu zedatha.

1. Sebenzisa iindlela ezimfutshane zekhibhodi: I-Excel ibonelela ngeendlela ezimfutshane zebhodi yezitshixo onokuzisebenzisa ukukhawulezisa umsebenzi wakho. Umzekelo, unokutshixa ngokukhawuleza iseli ngokuyikhetha kwaye ucinezele "Ctrl + $." Oku kuya kongela ixesha lokuya kwiinketho zemenyu ngalo lonke ixesha ufuna ukutshixa iseli.

2. Thatha ithuba leembono ezikhenkcezisiweyo: Ukuba usebenza nge-spreadsheet esikhulu, ungasebenzisa i-"Frozen Views" uphawu ukugcina imiqolo ethile okanye iikholamu ezithile zibonakala ngelixa uskrola kwelinye iphepha. Ukwenza oku, khetha ngokulula umqolo okanye ikholamu ofuna ukuyigcina ibonakala, yiya kwindawo ethi "Jonga" kwaye ucofe u-"Freeze iiPaneli."

3. Tshixa iiseli ezininzi ngaxeshanye: Ukuba ufuna ukutshixa uluhlu lweeseli endaweni yeseli enye, ungakwenza oko ngokukhetha uluhlu olufunekayo kwaye ulandele la manyathelo angasentla ukutshixa iseli enye. Ngale ndlela, zonke iiseli ezikhethiweyo ziya kutshixwa kwaye azinakuguqulwa ngempazamo.

Khumbula oko la macebiso kunye namaqhinga aya kukunceda wenze amava akho xa usebenzisa isitshixo sokuskrola kwi-Excel. Zama ngazo kwaye ufumanise ukuba yeyiphi ekusebenzela ngcono. Ungalibali ukuziqhelanisa kwaye uphonononge zonke iimpawu ezinokunikezelwa ngu-Excel!

11. Iindlela ezizezinye kunye nezongezo zokutshixa imiqolo kunye neekholamu kwi-Excel

Kukho iindlela ezininzi zokhetho kunye nezongezo ezinokuthi zisetyenziswe ukutshixa imiqolo kunye neekholamu kwi-Excel. Ezi zixhobo zinokwenza kube lula ukusebenza kwiispredishithi ezinkulu kunye nokuphucula ukusebenza kakuhle komsebenzisi. Ngezantsi lukhetho olunokuba luncedo:

1. Lungisa iimbono ezifriziweyo: I-Excel inika ithuba lokukhenkceza imiqolo kunye neekholamu ukuze zigcinwe zibonakala njengoko uskrola kwiphepha. Ukwenza oku, khetha ngokulula umqolo okanye ikholamu ofuna ukuyitshixa kwaye uye kwithebhu ethi “Jonga”. Emva koko, cofa u- "Freeze Panels" kwaye ukhethe ukhetho olufanelekileyo.
2. Sebenzisa umsebenzi wokutshixa iseli: Ungasebenzisa ukhetho lweeseli zokutshixa kwi-Excel ukukhusela idatha ebalulekileyo ukuba ingalungiswa ngengozi. Ukwenza oku, khetha iiseli ofuna ukuzitshixa, cofa ekunene kuzo kwaye ukhethe u- "Format Cells." Kwithebhu ethi "Ukhuseleko", khangela ibhokisi ethi "Ivaliwe". Emva koko uye ku-"Review" kwaye ucofe "Khusela iPhepha."
3. Sebenzisa ii-plugins ezithile: Zininzi ezongezo ezikhoyo ezinokuba luncedo ekutshixeni imiqolo kunye neekholamu kwi-Excel. Ezinye zezi plugins zikuvumela ukuba uqhoboshele imiqolo okanye iikholamu ezithile kwiphepha, ngelixa ezinye zibonelela ngeempawu zokutshixa eziphambili. Phanda kwaye uvavanye iiplagi ezahlukeneyo ukuze ufumane eyona ifanelekileyo kwiimfuno zakho.

Ezi zezinye zezinye iindlela kunye nezongezo ezifumanekayo zokutshixa imiqolo kunye neekholamu kwi-Excel. Ngezi zixhobo, unokwandisa imveliso yakho kwaye ugweme iimpazamo ezingeyomfuneko xa usebenza ngeespredishithi ezinkulu. Zama ezi zikhetho kwaye ufumanise ukuba zinokuphucula njani ukuhamba kwakho komsebenzi!

12. Ukwabiwa njani kwaye usebenzisane njani kwi-Excel Spreadsheets ezineMiqolo etshixiweyo kunye neeKholamu

Ukwabelana kunye nokusebenzisana kwiispredishithi ze-Excel kunokuba ngumsebenzi onzima, ngakumbi ukuba ufuna ukutshixa imiqolo ethile kunye neekholomu ukukhusela ukuguqulwa ngengozi kwedatha ebalulekileyo. Ngethamsanqa, i-Excel ibonelela ngeendlela ezahlukeneyo zokufezekisa oku ngempumelelo. Kweli nqaku, siza kukubonisa.

Ukutshixa imiqolo kunye neekholamu kwi-Excel, ungasebenzisa inqaku lokukhusela iphepha. Okokuqala, khetha iiseli ofuna ukuzitshixa ngokucofa iseli yokuqala kwaye urhuqe ikhesa kwiseli yokugqibela. Emva koko, cofa ekunene kwiiseli ezikhethiweyo kwaye ukhethe "Iiseli zokuFomatha" kwimenyu eyehlayo. Kwithebhu ethi "Ukhuseleko", khangela ibhokisi ethi "Ivaliwe". Oku kuya kubangela ukuba iiseli ezikhethiweyo zitshixe kwaye azikwazi ukulungiswa ngaphandle kokungakhuseli ishidi.

Wakuba utshixe imiqolo kunye neekholamu ezifunekayo, ungaqhubeka nokwabelana ngespredishithi nabanye abaSebenzisi. Ukwenza oku, yiya kwithebhu ethi "Hlola" kwiribhoni ye-Excel kwaye ukhethe "Khusela iPhepha". Kwibhokisi yencoko yababini evelayo, ungacwangcisa igama lokugqitha ukukhusela iphepha okanye ulishiye lingenanto ukuba awufuni ukusebenzisa igama eligqithisiweyo. Ungakhankanya kwakhona ukuba zeziphi izinto zephepha ekufuneka zifumaneke kubaSebenzisi, ezifana neeseli ezingatshixwanga zokuhlela okanye ukukwazi ukukhetha nokuqaqambisa iiseli. Nje ukuba uqwalasele iinketho ngokweemfuno zakho, cofa u "Kulungile." Ngoku, uya kukwazi ukwabelana ngespredishithi nabanye abasebenzisana nabo kwaye baya kukwazi ukujonga kwaye bahlele kuphela iindawo ezingatshixwanga zephepha.

13. Isitshixo esongezelelweyo kwi-Excel: Usikhusela njani i-Spreadsheet kunye neDatha yaso ebuthathaka

Ukukhusela idatha ebuthathaka kwi-spreadsheet ye-Excel kubalulekile ukuqinisekisa ubumfihlo kunye nokhuseleko lolwazi. Ngethamsanqa, i-Excel ibonelela ngeendlela ezininzi ezongezelelweyo zokutshixa ezinokusetyenziswa ngokulula. Ngezantsi siza kunika inyathelo ngesinyathelo malunga nendlela yokukhusela i-spreadsheet kunye idatha yakho onovakalelo kwi-Excel.

1. Vula i-spreadsheet kwi-Excel kwaye ukhethe ithebhu ethi "Hlaziya" kwi-toolbar ephezulu. Emva koko, cofa "Khusela iPhepha."
2. Kwifestile ephumayo, unokuseta igama lokugqitha ukukhusela i-spreadsheet. Qinisekisa ukuba ukhetha igama eliyimfihlo elomeleleyo, ekulula ukulikhumbula. Emva koko, khangela iibhokisi zokukhangela ezihambelana nezenzo ofuna ukuvumela abasebenzisi ukuba benze kwiphepha elikhuselweyo, njengokukhetha iiseli okanye ukufaka imiqolo.
3. Cofa u-"Kulungile" kwaye uphinde igama lokugqitha ukuze uqinisekise.
4. Ngoku i-spreadsheet ikhuselwe kwaye abasebenzisi baya kufuna ukufaka igama eliyimfihlo ukwenza izenzo ezithile. Ukungakhuseli iphepha, khetha ngokulula inketho ethi "Khusela iPhepha" kwakhona kwaye ungachongi ibhokisi ethi "Khusela iphepha kunye nemixholo yeeseli".

Ukongeza kwisitshixo esisisiseko sokukhusela iphepha, i-Excel ikwabonelela ngeendlela zokutshixa ezongezelelweyo ukukhusela ngakumbi idatha ebuthathaka. Ezi zikhetho zifumaneka kwithebhu ethi "Hlaziya" kwaye ikuvumela ukuba ukhusele isakhiwo se-spreadsheet, uthintele utshintsho kwiifomyula, phakathi kwezinye izenzo. Xa usebenzisa ezi zikhetho, qiniseka ukuba ukhetha ngononophelo izicwangciso ezilungele ukhuseleko lwespredishithi kunye neemfuno zentsebenziswano.

14. Izigqibo kunye neengcebiso zokugqibela zokuthintela imiqolo kunye neekholamu kwi-Excel xa uskrola

Ngamafutshane, ukutshixa imiqolo kunye neekholamu kwi-Excel kuskrola yindlela eluncedo kakhulu yokugcina idatha ethile ihlala ibonakala ngelixa usebenza kwi-spreadsheet ende. Ngala manyathelo achazwe ngasentla, sifunde indlela yokwenza eli nqaku lisebenze kunye nendlela yokwenza ngokweemfuno zethu.

Kubalulekile ukukhumbula ukuba imiqolo yokutshixa kunye neekholamu kunokuphucula kakhulu ukusebenza kakuhle kunye nokuchaneka xa usebenza ngeemali ezinkulu. idatha kwi-excel. Ngokwenza oku, sinokukuphepha ukuphulukana nombono weentloko zekholamu ezibalulekileyo okanye iitotali xa uskrola kwi-spreadsheet.

Ngamafutshane, ukuba nolwazi lwendlela yokutshixa imiqolo kunye neekholamu kwi-Excel kunokusigcina ixesha kunye nomzamo. Nokuba sisebenza kwingxelo yemali, isiseko sedatha okanye naluphi na olunye uhlobo loxwebhu, imigca yokutshixa kunye neekholamu inokuba sisixhobo esixabisekileyo sokuququzelela ukuhamba kwethu komsebenzi kunye nokuqinisekisa ukuchaneka kohlalutyo lwethu kunye nokubala.

Ngamafutshane, i-Excel ibonelela ngemisebenzi eyahlukeneyo kunye neenketho zokuququzelela umsebenzi wemihla ngemihla ngeespredishithi. Phakathi kwabo, ukukwazi ukutshixa umqolo kunye nekholomu xa upheqa luncedo ngakumbi xa usebenza ngeeseti ezinkulu zedatha. Eli nqaku likuvumela ukuba ugcine ireferensi kumqolo okanye ikholamu ethile ngelixa ubrawuza uxwebhu, ukuthintela iimpazamo kunye nokwandisa ukusebenza kakuhle.

Ukutshixa umqolo okanye ikholamu kwi-Excel, kufuneka ulandele amanyathelo ambalwa alula. Okokuqala, khetha iseli ofuna ukuyitshixa, emva koko ufikelele kukhetho lwe "Freeze panels" kwindawo ethi "Jonga" kwaye ukhethe ukhetho olufunekayo. Ukongezelela, kunokwenzeka ukulungelelanisa indawo yokwahlula ukuze ihambelane neemfuno ezithile zoxwebhu ngalunye.

Nangona kunjalo, kubalulekile ukukhumbula ukuba lo msebenzi usebenza kuphela xa ujonga i-spreadsheet, ngoko ke ayichaphazeli ukuguqulwa kwedatha. Ukuba ufuna ukuvimba zombini ukujonga kunye nokuhlelwa komqolo okanye ikholomu, kuyacetyiswa ukuba usebenzise izixhobo ezongezelelweyo zokukhusela, ezifana nokuseta amagama agqithisiweyo okufikelela okanye ukunciphisa iimvume zokuhlela.

Ukwenza uninzi lwezinto ezinokwenzeka ze-Excel kuthetha ukuqhelana nabo bonke imisebenzi yayo kunye nobuchule. Imiqolo yokutshixa kunye neekholamu kwiskroli yenye yezo mpawu ezinokwenza umehluko kwimveliso kunye nokuchaneka xa usebenza ngeeseti ezinkulu zedatha. Ngokuziqhelanisa, uya kuba nakho ukufumana okuninzi kolu phawu kwaye ufezekise impumelelo enkulu kumsebenzi wakho wemihla ngemihla ngeespredishithi.