Ungayindlisela kanjani iseli e-Excel

I-Excel amatafula ashukumisayo, lapho usebenza lapho izinto ziguqulwa khona, zibhekana nokushintsha, njll. Kepha kwezinye izimo udinga ukulungisa into ethile noma, njengoba besho ngendlela ehlukile, ukuze iqhwa ukuze ingashintshi indawo yayo. Ake sibheke ukuthi yikuphi ukukhetha okuvumela ukuthi kwenziwe.

Izinhlobo zokulungiswa

Masinyane kudingeka ukuthi usho ukuthi izinhlobo zokulungiswa ekudingisweni zingahluka ngokuphelele. Ngokuvamile, zingahlukaniswa ngamaqembu amathathu amakhulu:

1. Amakheli Okuqhwa;
2. Amaseli aqinile;
3. Ukuvikela izinto kusuka ekuhlelweni.

Lapho kufriza ikheli, isixhumanisi esiya esitokisini asiguquki lapho sikopisha, okungukuthi, kuyeka ukuba yizihlobo. I-Consignment of Amaseli ikuvumela ukuba uwabone njalo esikrinini, noma ngabe umsebenzisi angabheki phansi kangakanani ephepheni phansi noma kwesokudla. Ukuvikelwa kwezinto ezivela kumabhulokhi okuhlela noma yiziphi izinguquko zedatha entweni ebekiwe. Ake sibheke ngokuningiliziwe ngakunye kwalezi zinketho.

Indlela 1: Amakheli we-Freeze

Okokuqala, sizogxila ekulungiseni amakheli eseli. Ukuze uyiqede, kusuka kwisethenjwa esilinganiselwe, yini noma yiliphi ikheli eliku-Excel ngokuzenzakalelayo, udinga ukwenza isixhumanisi esiphelele esingaguquki izixhumanisi lapho zikopisha. Ukuze wenze lokhu, udinga ukufaka ikheli lesibonakaliso sedola ($) kusuka ekuxhumaniseni ngakunye.

Ukusetha uphawu lwedola kwenziwa ngokucindezela uphawu olufanele kwikhibhodi. Itholakala kukhiye owodwa ngenombolo "4", kepha ukususa isikrini udinga ukucindezela ukhiye ekuhlelweni kwekhibhodi yesiNgisi ecaleni eliphezulu (ngokhiye we- "Shift"). Kunendlela elula futhi esheshayo. Kufanele ukhethe ikheli le-element eseli noma emugqeni wemisebenzi bese uqhafaza kukhiye we-F4 function. Uma uqala chofoza, isibonakaliso sedola sizovela ekhelini lentambo nekholamu, ngesikhathi sokuchofoza kwesibili kule khiye kuzohlala ekhelini lomugqa, ngesikhathi sokuchofoza kwesithathu - ekhelini lekholomu. Okwesine ukucindezela ukhiye we-F4 ususa uphawu lwedola ngokuphelele, futhi okulandelayo kuqala le nqubo ngombuthano omusha.

Ake sibheke ikheli leqhwa ngesibonelo esithile.

1. Ukuqala, kopisha ifomula ejwayelekile kwezinye izinto zekholomu. Ukuze wenze lokhu, sebenzisa umaki wokugcwalisa. Faka isikhombisi ekhoneni elingezansi kwesokudla seseli, idatha ofuna ukukopisha ngayo. Ngasikhathi sinye, iguqulwa ibe yisiphambano, esiphethe igama lomaki wokugcwalisa. Cindezela inkinobho yegundane kwesokunxele bese udonsa lokhu kunqamula kuze kube sekupheleni kwetafula.



2. Ngemuva kwalokho, sabela into ephansi kakhulu yetafula bese sibheka umugqa wefomula, njengoba ifomula selishintshile ngesikhathi likopisha. Njengoba ukwazi ukubona, konke ukuxhumanisa okwakusengxenye yokuqala yekholomu, lapho ukukopishwa kuguqulwe. Ngenxa yalokhu, ifomula likhipha umphumela ongalungile. Lokhu kungenxa yokuthi ikheli lesici sesibili, ngokungafani nolokuqala, akufanele liguqulwe ukuze sibalwe elifanele, okungukuthi, kudingeka liphelele noma lilungiswe.



3. Sibuyela kwinto yokuqala yekholomu bese sifaka uphawu lwedola eduze nezixhumanisi zesici sesibili kwesinye salezo zindlela esazikhulume ngenhla. Manje lesi sixhumanisi siqandisiwe.



4. Ngemuva kwalokho, usebenzisa umaki wokugcwalisa, ukukopisha kuhlu lwetafula elisendaweni engezansi.



5. Ngemuva kwalokho sabela into yokugcina yekholomu. Njengoba singabona ngentambo yefomula, izixhumanisi zento yokuqala zisasuswa lapho zizowukopishwa, kepha ikheli elisesiteji esiphindaphindayo, esasingenzi kahle, asiguquki.



6. Uma ubeka uphawu lwedola kuphela kwikholamu, khona-ke leli kheli lekholomu yesixhumanisi lizolungiswa, futhi izixhumanisi zentambo zishintshiwe lapho zikopishwa.



7. Ngakolunye uhlangothi, uma usetha uphawu lwedola eduze nekheli lomugqa, lapho ukukopisha ngeke kuguqukele, ngokungafani nekheli lekholomu.

Le ndlela ikhiqiza izixhumanisi zeqhwa zamaseli.

Isifundo: Ukulungiswa ngokuphelele ku-Excel

Indlela 2: ukulungisa amaseli

Manje sifunda ukuthi singalungisa kanjani amaseli ukuze njalo bahlale esikrinini lapho umsebenzisi bengakwazi ukuya khona ngaphakathi kwemingcele yamaqabunga. Ngasikhathi sinye, kufanele kuqashelwe ukuthi into ngayinye ayikwazi ukufakwa, kepha ungalungisa indawo lapho itholakala khona.

Uma iseli elifiselekayo litholakala emgqeni ongenhla leshidi noma kwikholomu yesobunxele, khona-ke ukulungiswa kuyinto yokuqala.

1. Ukuvikela intambo, yenza izenzo ezilandelayo. Iya kuthebhu ethi "View" nobumba kwinkinobho ethi "Feght Area", etholakala efasiteleni le-Toolbar "yewindi". Uhlu lwezinketho ezabelwe ezabelwe. Khetha igama elithi "Vikela umugqa ongaphezulu".



2. Manje noma ngabe wehlela phansi kweshidi, umugqa wokuqala, okusho ukuthi into oyidingayo, etholakala kuyo, isazobe iphezulu kakhulu ewindini.

Ngokufanayo, ungakhipha ikholomu yesokunxele ngokweqile.

1. Iya kuthebhu ethi "View" bese uqhafaza inkinobho ethi "Faka indawo". Kulokhu ngikhetha inketho ethi "Vikela ikholomu yokuqala".



2. Njengoba ubona, ikholomu yesobunxele eyedlulele kakhulu manje isilungisiwe.

Cishe indlela efanayo ongayihlanganisa hhayi kuphela ikholomu yokuqala nentambo yokuqala, kepha ngokuvamile, yonke indawo ishiywe futhi ngenhla kusuka entweni ekhethiwe.

1. I-algorithm ye-algorithm yalo msebenzi ihluke kancane kusuka kwangaphambilini. Okokuqala, kuyadingeka ukugqamisa into yamaqabunga, indawo evela phezulu nangakwesobunxele okuzolungiswa. Ngemuva kwalokho, iya kuthebhu ethi "View" bese uqhafaza kwisithonjana esijwayelekile ". Kumenyu evula, khetha into ngegama elifanayo.



2. Ngemuva kwalesi senzo, yonke indawo etholakala ngakwesobunxele nangaphezulu kwento enikezelwe izolungiswa ephepheni.

Uma ufisa, susa iqhwa elenziwe ngale ndlela, elula impela. I-algorithm yokubulawa iyafana kuzo zonke izimo ukuthi kuzoba ngumsebenzisi ongeke avikele: intambo, ikholamu noma indawo. Sithuthela kwithebhu ethi "View", chofoza ku- "Lungisa indawo" isithonjana "ohlwini oluvula, khetha inketho yokususa ukuhlanganiswa kwezifunda". Emva kwalokho, wonke amabanga ahleliwe eshidi lamanje azokwehliswa.

Isifundo: Ungayilungisa kanjani le ndawo e-Excel

Indlela 3: Ukuvikela Ukuvikelwa

Ekugcineni, ungavikela iseli ekuhleleni ngokuvimba amandla okwenza ushintsho kubasebenzisi. Ngakho-ke, yonke imininingwane ekuyo izoba yiqhwa empeleni.

Uma itafula lakho lingashukumi futhi alihlinzeki ngokwethulwa kwanoma yiziphi izinguquko kulo, awukwazi ukuvikela hhayi kuphela amaseli athile, kepha futhi nephepha lonke eliphelele. Kulula kakhulu.

1. Hambisa kuthebhu "yefayela".



2. Efasiteleni elivula kumenyu yesobunxele mpo, iya engxenyeni ethi "Imininingwane". Engxenyeni ephakathi yewindi, ubumba kulowo olotshiweyo "Vikela incwadi". Kuluhlu lwezenzo zokuphepha ezivula, khetha inketho ethi "Vikela Ishidi Lamanje".



3. Kwethulwa iwindi elincane, elibizwa ngokuthi "Ukuvikelwa Kweshidi". Okokuqala, kuwo ensimini ekhethekile udinga ukufaka iphasiwedi yokuphikisana, ezodingeka ngumsebenzisi uma ifisa ukukhubaza ukuvikelwa esikhathini esizayo ukuhlela idokhumenti. Ngaphezu kwalokho, ngentando, ungafaka noma ususe inani lemikhawulo eyengeziwe, ukufaka noma ukususa amafulegi eduze kwezinto ezifanele ohlwini olwethulwe kule windi. Kepha ezimweni eziningi, izilungiselelo ezizenzakalelayo ziyahambisana nomsebenzi, ukuze umane uchofoze inkinobho ethi "KULUNGILE" ngemuva kokufaka iphasiwedi.



4. Ngemuva kwalokho, elinye iwindi liqala, lapho iphasiwedi efakwe ngaphambili kufanele iphindwe khona. Lokhu kwenzelwa ukuqinisekisa ukuthi umsebenzisi ubezethemba ukuthi wethula ngqo iphasiwedi engiyikhumbule futhi ngabhala ekuhlelweni okufanele kwekhibhodi nerejista, ngaphandle kwalokho kungalahlekelwa ukufinyelela ekuhleleni idokhumenti. Ngemuva kokufaka kabusha iphasiwedi, cindezela inkinobho ethi "Kulungile".



5. Manje lapho uzama ukuhlela noma iyiphi into eshidi, lesi senzo sizovinjwa. Iwindi lemininingwane lizovula, libika ngento engenakwenzeka yokushintsha idatha eshidini elivikelwe.

Kunenye indlela yokuvimba noma yiziphi izinguquko ezintweni eziseshidini.

1. Iya kufasitela elithi "Ukubukeza" noClay on the "Vikela iqabunga" isithonjana, esitholakala etheyipini ebhuthini "yokushintsha".



2. Kuvulwe vele ujwayele iwindi lokuvikelwa kwewindi lase-US. Konke okunye ukwenza ngendlela efanayo njengoba kuchaziwe kunguqulo yangaphambilini.

Kepha okufanele ukwenze uma udinga ukufrizwa kuphela amaseli owodwa noma amaningi, futhi kwabanye kucatshangwa, njengakuqala, ukwenza idatha ngokukhululekile? Kukhona indlela yokuphuma kulesi sikhundla, kepha isixazululo saso siyinkimbinkimbi ngokwengeziwe kunomsebenzi owedlule.

Kuwo wonke amaseli wedokhumenti ezenzakalelayo kwizakhiwo, ukuvikelwa kuyakhonjiswa, lapho kukhiya ukukhiya kweshidi kusebenze ngokujwayelekile, izinketho ezishiwo ngenhla. Sizodinga ukususa i-parameter yokuvikela ezizakhiweni zazo zonke izinto zeshidi, bese sizibeka futhi kulezo zinto esifisa ukuzibanda ngezinguquko.

1. Chofoza kunxande, okutholakala emhlanganweni wamaphaneli wokuxhumanisa ovundlile futhi mpo. Futhi, uma isikhombisi sisendaweni ethile yeshidi ngaphandle kwetafula, cindezela inhlanganisela yezinkinobho ezishisayo ku-CTRL + ikhibhodi. Umphumela uzofana - zonke izinto eziseshidi ziyaqokonyiswa.



2. Ngemuva kwalokho thina se-Clas endaweni egqamile ngokuchofoza kwesokudla. Kumenyu yokuqukethwe eyenziwe yasebenza, khetha i- "Cell format ...". Futhi, esikhundleni salokho, ungasebenzisa isethi yenhlanganisela ye-CTRL + 1.



3. Iwindi le- "Cell format" licushiwe. Ngokushesha ukuguqukela kuthebhu "yokuvikelwa". Kufanele isuswe ibhokisi lokuhlola eduze kwepharamitha "evikelwe". Chofoza inkinobho ethi "KULUNGILE".



4. Okulandelayo, sibuyela ephepheni futhi sabelwa into ethile noma iqembu lapho sizokhipha khona imininingwane. Sichofoza ngokuchofoza kwesokudla esiqwini esizinikezele nakumenyu yokuqukethwe, iya egameni elithi "Ifomethi Yeseli ...".



5. Ngemuva kokuvula iwindi lokufomatha, futhi liye kwithebhu ethi "Ukuvikelwa" bese usetha ibhokisi lokuhlola eduze kwento "evikelwe". Manje usungachofoza inkinobho ethi "Kulungile".



6. Emva kwalokho, sibeka ukuvikelwa kwephepha nganoma iyiphi yalezo zindlela ezimbili ezazichazwe phambilini.

Ngemuva kokukhipha zonke izinqubo ezichazwe ngokuningiliziwe US ​​ngenhla, yilawo maseli kuphela esiwavikele kuwo ngezakhiwo zefomethi zizovinjelwa ezinguquko. Kuzo zonke ezinye izinto zeshidi, njengakuqala, ungafaka isandla ngokukhululekile noma iyiphi idatha.

Isifundo: Ungayivikela kanjani iseli kusuka ekushintsheni kuya ku-Excel

Njengoba ubona, kunezindlela ezintathu zokuhambisa amaseli. Kepha kubalulekile ukuqaphela ukuthi kuyahluka kubo ngamunye wabo hhayi kuphela ubuchwepheshe bokwenza le nqubo, kodwa futhi nomongo wesithwalo uqobo. Ngakho-ke, kwesinye isikhathi, yilelo kheli le-leaf element liqoshwa, ngokwesibili - indawo ihlelwe esikrinini, kanti okwesithathu - ukuvikela izinguquko zedatha kumaseli kusethiwe. Ngakho-ke, kubaluleke kakhulu ukuqonda ngaphambi kokwenza inqubo, ukuthi uzovimbani ngempela futhi kungani ukwenze.