I-Lattice esikhundleni sezinombolo ku-Excel. Okufanele ukwenze uma ama-lattice evezwa esikhundleni sezinombolo ku-Excel

Ngokuvamile kwenzeka ukuthi lapho ufaka idatha ku-Microsoft Excel, izinhlamvu ezikhethekile, njengezimpawu zamaphawundi, ziboniswa esikhundleni sezinombolo ezithile. Lesi simo sivimbela ukusebenza okuvamile kwedokhumenti ye-elekthronikhi, ngakho-ke udinga ukwazi ukuthi ungayilungisa kanjani le nkinga. Lesi sihloko sinikeza izindlela ezimbalwa ezisebenzayo zokuxazulula inkinga ngokushesha.

Izizathu zokuvela kwama-lattices

Amaseli e-Lattice avela lapho inani lezinhlamvu ezifakwe kuwo lidlula umkhawulo. Ngesikhathi esifanayo, uhlelo lukhumbula idatha oyifakile, kodwa ngeke ibonise kahle kuze kube yilapho inombolo eyengeziwe yezinhlamvu isusiwe. Uma ufaka izinombolo kuseli I-Excel 2003 yeqe inani lamayunithi angama-255, izobonisa i-octothorp esikhundleni sezinombolo. Yilokhu okubizwa ngokuthi i-lattice ngolimi lokuhlela.

Ngendlela efanayo, umbhalo uzoziveza uma uwufaka kuseli yenguqulo yakamuva. Inombolo enkulu yezinhlamvu ezivunyelwe kunkambu ye-Excel 2007 ngu-1024. Lokhu kujwayelekile emikhiqizweni ye-Excel ngaphambi kuka-2010. Izinguqulo ezintsha azisanikezi umkhawulo. Futhi, izizathu zingase zibe:

• ukuba khona kwamaphutha ohlelo embhalweni noma ezinhlamvu ezingavumelekile;
• amanani abalwe ngephutha;
• ukusetshenziswa okungalungile kwamafomula kanye nezibalo ezingalungile kumaseli;
• ukwehluleka ezingeni lohlelo (lokhu kunqunywa ngale ndlela elandelayo: uma uma uzulazula phezu kweseli, konke kuboniswa ngendlela efanele, futhi uma ucindezela okuthi “Enter”, inani liphenduka libe i-octotorp, kuseyinombolo eyengeziwe yezinhlamvu. ).

Nakani! Ukubonakala kwamabha ezinkambu ze-Excel kungase kube umphumela wesakhiwo sekhibhodi esethwe ngokungalungile.

Futhi, inkinga efanayo ingase ivele uma amagama amaseli angalungile akhethiwe ukuze kufinyezwe idatha. Ungakwazi ukuxazulula inkinga ngokubonisa idatha yomuntu siqu usebenzisa izindlela ezimbalwa ezisebenzayo.

Isixazululo

Ukumane usule inombolo eyengeziwe yezinhlamvu akwanele. Kuzodingeka usebenzise izindlela ezenza izinhlamvu ezingalungile zinyamalale. Masisuke kokulula siye kokuyinkimbinkimbi.

Indlela 1: ukwandisa imingcele ngesandla

Ukwandisa imingcele ku-Microsoft Excel, kwanele ukuyelula ngesandla. Lena indlela enokwethenjelwa futhi elula ezosiza ukuxazulula inkinga ngisho nakubaqalayo abasebenzisa kuqala ukusebenza kwesicelo sehhovisi.. Landela imiyalelo:

1. Ewindini le-Microsoft Excel elivulekayo, chofoza iseli lapho amabha avele khona.
2. Hambisa ikhesa emngceleni ongakwesokudla, lapho kusethwe khona igama leseli. Imingcele yeseli inganwetshwa kwesokunxele, kodwa kulokhu, amaseli atholakala ngaphambili azogudluzwa.

3. Silinde ukuthi ikhesa ithathe isimo somcibisholo okabili. Bese uchofoza emngceleni bese uhudula kuze kube yilapho zonke izinhlamvu zivela.
4. Ekupheleni kwenqubo, wonke ama-lattice azovezwa ngendlela yezinombolo ezifakwe ngaphambilini.

Le ndlela isebenza kuzo zonke izinguqulo ze-Excel.

Indlela 2: Ukunciphisa Ifonti

Isixazululo sokuqala senkinga sifaneleka kakhulu kulawo macala lapho amakholomu angu-2-3 kuphela eshidini futhi kungekho idatha eningi. Kodwa ukuze ulungise izinhlamvu ezikhethekile ku-e-ncwadi ngezinga elikhulu, udinga ukusebenzisa imiyalelo engezansi.

1. Sikhetha iseli noma ububanzi bamaseli lapho sifuna ukubona ngeso lengqondo idatha yezinombolo.

2. Senza isiqiniseko sokuthi sikuthebhu "Ekhaya", uma kungenjalo, bese uchofoza kukho phezulu ekhasini. Esigabeni esithi "Ifonti", sithola usayizi wayo futhi sinciphise kuze kube yilapho inani elidingekayo lezinhlamvu liboniswa kumaseli ngefomethi yedijithali edingekayo. Ukuze ushintshe ifonti, ungavele ufake usayizi olinganiselwe endaweni efanele.

Encwadini! Lapho uhlela ifonti futhi ushintsha ifomethi, iseli lizothatha ububanzi obuhambisana nenani lenombolo ende kakhulu elibhalwe ngaphakathi kuyo.

Indlela yesi-3: ububanzi obuzenzakalelayo

Ukushintsha ifonti kumaseli nakho kuyatholakala ngendlela echazwe ngezansi. Kubandakanya ukukhetha ububanzi usebenzisa amathuluzi akhelwe ngaphakathi e-Microsoft Excel.

1. Udinga ukugqamisa ububanzi bamaseli adinga ukufomethwa (okungukuthi, lawo aqukethe izinhlamvu ezingavumelekile esikhundleni sezinombolo). Okulandelayo, chofoza kwesokudla esiqeshini esikhethiwe futhi efasiteleni le-pop-up thola ithuluzi Lefomethi Yeseli. Ezinguqulweni zangaphambili ze-Excel, imenyu ingase iguqule indawo yamathuluzi.

2. Ewindini elivelayo, khetha ingxenye ethi "Ukuqondanisa". Sizosebenza nayo ngokuzayo, bese sibeka umaka ngaphambi kokufakwayo kokuthi “Ububanzi bokulingana ngokuzenzakalela”. Itholakala ngezansi ebhulokhini elithi “Display”. Ekugcineni, chofoza inkinobho ethi "OK". Ngemuva kwezenzo ezithathiwe, amanani ayahla futhi athole ifomethi ehambisana nosayizi wewindi ku-e-book.

Le nqubo ilula kakhulu futhi ihlukaniswa nokusebenza kahle kwayo. Ungakwazi ukuklama ishidi le-Excel kahle ngemizuzwana nje.

Nakani! Zonke izindlela zokuhlela zisebenza kuphela uma ungumbhali wefayela noma livulelwe ukuhlelwa.

Indlela yesi-4: Ukushintsha ifomethi yenombolo

Le ndlela ifaneleka kuphela kulabo abasebenzisa inguqulo endala ye-Microsoft Excel. Iqiniso liwukuthi kunomkhawulo wokwethulwa kwezinombolo, njengoba kushiwo ekuqaleni kwalesi sihloko. Cabangela inqubo yokulungisa isinyathelo ngesinyathelo:

1. Khetha iseli noma ububanzi bamaseli adinga ukufomethwa. Okulandelayo, chofoza kwesokudla kuwo. Ohlwini lwemisebenzi evelayo, thola ithuluzi elithi “Fometha Amaseli”, chofoza kulo.
2. Ngemva kokuchofoza ithebhu "Inombolo", sibona ukuthi ifomethi "Yombhalo" isethwe lapho. Lishintshe libe “Okuvamile” esigatshaneni esithi “Amafomethi Ezinombolo”. Ukuze wenze lokhu, chofoza kokugcina futhi uqinisekise isenzo sakho ngokuchofoza inkinobho ethi "KULUNGILE" ezansi kwewindi lokufometha.

Nakani! Ezinguqulweni ezibuyekeziwe ze-Excel, ifomethi Ejwayelekile isethwe ngokuzenzakalelayo.

Ngemva kokuba lo mkhawulo usususiwe, zonke izinombolo zizovezwa ngefomethi oyifunayo. Ngemuva kokukhohlisa okwenziwe, ungagcina ifayela. Ngemva kokuphinda kuvulwe, wonke amaseli azovezwa ngendlela efanele.

Ungashintsha ifomethi yenombolo ngenye indlela elula:

1. Ukuze wenze lokhu, faka ifayela lesipredishithi se-Excel, lapho amanani ezinombolo ekhonjiswe ngokungalungile, hamba kuthebhu ethi "Ekhaya" engxenyeni ethi "Inombolo".
2. Chofoza umcibisholo ukuze uveze uhlu lokudonsela phansi futhi ushintshe imodi yokusetha isuke kokuthi “Umbhalo” iye kokuthi “Okuvamile”.
3. Ungakwazi ukufometha iseli elilodwa, lapho kukhona inani lamagridi, ngokulandelana, ngaphandle kokukhetha amafomethi eshidi lonke. Ukuze wenze lokhu, chofoza iwindi oyifunayo, chofoza inkinobho yegundane kwesokudla.
4. Efasiteleni le-pop-up, thola ithuluzi lefomethi elinganiselwe, chofoza kuyo.
5. Ngaphezu kwalokho, wonke amapharamitha kufanele ashintshwe njengoba kuchazwe endleleni yangaphambilini.

Encwadini! Ukuze ushintshele ngokushesha kumafomethi weseli, vele usebenzise inhlanganisela yokhiye “CTRL + 1”. Kulula ukwenza izinguquko lapha, kokubili iseli elilodwa kanye nobubanzi balo lonke.

Ukuqinisekisa ukuthi izenzo ezenziwe zilungile, sincoma ukuthi ufake izinhlamvu zombhalo noma izinombolo ngezinombolo ezinkulu. Uma, ngemuva kokuphela komkhawulo, ama-gratings awazange avele, ngokulandelana, wenze konke okulungile.

Indlela yesi-5: Shintsha ifomethi yeseli

Kungenzeka ukushintsha ifomethi yeseli ukuze kuboniswe kahle izinhlamvu usebenzisa amathuluzi amaningana asetshenziswa ngokuzenzakalelayo kuspredishithi se-Microsoft Excel. Ake sibheke le ndlela ngokuningiliziwe:

1. Okokuqala, khetha iseli elinenkinga, bese uchofoza kwesokudla kulo. Imenyu iyavela lapho udinga ukuchofoza khona "Fometha Amaseli". Ukufometha kweseli kwenziwa kuphela ngefomu elithi “Numeric”, uma incwadi yokusebenzela iqukethe izinombolo.

2. Ebhokisini elithi "Inombolo" elivulayo, ohlwini, khetha ifomethi inani elifakiwe kumaseli elizohambisana nalo. Kulesi sibonelo, kucatshangelwa ifomethi ethi "Imali". Ngemuva kokukhetha, siqinisekisa izenzo zethu ngokuchofoza inkinobho ethi "KULUNGILE" ezansi kwewindi lezilungiselelo. Uma ufuna ukuthi kuvele ukhefana ezinombolweni, kufanele uchofoze inketho yokufometha ethi "Ezezimali".

3. Uma ungayitholi inketho yokufometha efanelekile ohlwini, zama ukubuyela ekhasini Lasekhaya futhi uye engxenyeni ethi Inombolo. Lapha kufanele uvule uhlu ngamafomethi, futhi ngezansi uchofoze "Amanye amafomethi ezinombolo", njengoba kukhonjisiwe kusithombe-skrini. Ngokuqalisa le nketho, uzothuthela kuzilungiselelo ezivele zijwayelekile zokushintsha ifomethi yeseli.

Uma kungekho neyodwa yezindlela ezisizile, ungazama ukufaka amanani hhayi esitokisini, kodwa emgqeni otholakala ngaphansi kwephaneli yokulawula ye-Microsoft Excel e-book. Vele uchofoze kuso bese uqala ukufaka idatha edingekayo.

Isiphetho

Ezimweni eziningi, ukubonisa amagridi esikhundleni sezinkulumo zezinombolo noma ze-alfabhethi kumaseli e-Microsoft Excel akulona iphutha. Ngokuyisisekelo, ukuboniswa okunjalo kwezinhlamvu kuncike kuphela ezenzweni zomsebenzisi, ngakho-ke kubalulekile ukunaka ukuthobela umkhawulo lapho usebenzisa izinguqulo ezindala zesipredishithi.