Njengomthetho, ngobuningi babasebenzisi, ukwengeza amaseli lapho usebenza ku-Excel akuvezi umsebenzi onzima kakhulu. Kepha, ngeshwa, akuyena wonke umuntu owazi zonke izindlela ezingenzeka zokwenza lokhu. Kepha kwezinye izimo, ukusetshenziswa kwendlela ethile kuzosiza ukunciphisa isikhathi esichithwe kwinqubo. Ake sibheke ukuthi yiziphi izindlela zokwengeza amaseli amasha ku-Excel.
Bheka futhi: Ungawengeza kanjani umugqa omusha etafuleni le-Excel
Ungayifaka kanjani ikholomu ku-Excel
Inqubo Yesengezo Seseli
Sizobheka masinyane ukuthi ngqo kusuka ohlangothini lwezobuchwepheshe inqubo yokwengeza amaseli yenziwa kanjani. Kakhulu, esikubiza ngokuthi "ukungeza" empeleni kuwukuhamba. Okusho ukuthi, amangqamuzana avele aguqukele phansi aye kwesokudla. Amanani atholakala emaphethelweni ephepha ayasuswa lapho kufakwa amaseli amasha. Ngakho-ke, kuyadingeka ukuqapha inqubo ekhonjisiwe lapho ishidi ligcwele idatha ngabangaphezulu kuka-50%. Yize, kunikezwe, ezihumusheni zanamuhla, i-Excel inezintambo eziyisigidi ezi-1 namakholamu eshidi, uma senzelwa leso sidingo akuvamile kakhulu.
Ngaphezu kwalokho, uma ungeza amaseli, kunokuba wonke imigqa namakholomu, udinga ukubheka ukuthi kuthebula lapho wenza khona umsebenzi ocacisiwe, idatha izogudlula, futhi amanani ngeke ahambisane nalawo imigqa noma amakholomu abebhaleke ngaphambili.
Ngakho-ke, manje ake siqhubekele ezindleleni ezithile zokufaka izakhi kwishidi.
Indlela yoku-1: Imenyu yokuqukethwe
Enye yezindlela ezijwayelekile zokwengeza amaseli ku-Excel ukusebenzisa imenyu yokuqukethwe.
- Khetha into eshidi lapho sifuna ukufaka iseli entsha. Sichofoza kukho inkinobho yegundane elifanele. Imenyu yokuqukethwe yethulwe. Khetha isikhundla kukho "Namathisela ...".
- Ngemuva kwalokho, kuvulwa iwindi lokufaka elincane. Njengoba sinentshisekelo ngokufakwa kwamaseli, kunokuba imigqa ephelele noma amakholomu, amaphuzu "Umugqa" futhi Ikholomu asinaki. Senza ukukhetha phakathi kwamaphuzu "Amaseli, aguqulwe kwesokudla" futhi "Amaseli ngokushintsha phansi", ngokuya ngezinhlelo zabo zokuhlela itafula. Ngemuva kokuthi ukwenziwa kwenziwe, chofoza inkinobho "Kulungile".
- Uma umsebenzisi ekhethile "Amaseli, aguqulwe kwesokudla", khona-ke izinguquko zizothatha cishe indlela efanayo naleyo esethebula elingezansi.
Uma kukhethwe ukhetho futhi "Amaseli ngokushintsha phansi", khona-ke itafula lizoshintsha kanjena.
Ngokufanayo, ungangeza wonke amaqembu amaseli, kuphela ngalokhu, ngaphambi kokuya kumenyu yokuqukethwe, uzodinga ukukhetha inombolo ehambisanayo yezinto ezisekhasini.
Ngemuva kwalokho, izakhi zizongezwa ngokuhambisana ne-algorithm efanayo nesichaze ngenhla, kodwa kuphela yiqembu lonke.
Indlela 2: Inkinobho YeRibbon
Ungangeza futhi izinto eshidini le-Excel ngokusebenzisa inkinobho kubambo. Ake sibheke ukukwenza.
- Khetha into endaweni yeshidi lapho sihlela ukufaka khona iseli. Hambisa kuthebhu "Ikhaya"uma njengamanje sikomunye. Bese uchofoza inkinobho Namathisela ebhokisini lamathuluzi "Amaseli" ekhasethini.
- Ngemuva kwalokho, into izongezwa kweshidi. Ngaphezu kwalokho, kunoma yikuphi, kuzongezwa nge-offset phansi. Ngakho-ke le ndlela isashintshashintsha kancane kunalena edlule.
Usebenzisa indlela efanayo, ungangeza amaqembu amaseli.
- Khetha iqembu elivundlile lezinto zeshidi bese uchofoza isithonjana esikwaziyo Namathisela kuthebhu "Ikhaya".
- Ngemuva kwalokho, kuzofakwa iqembu lezinto zeshidi, njengokufakelwa okukodwa, kufakwe phansi.
Kepha lapho sikhetha iqembu elime mpo lamaseli, sithola umphumela ohluke kancane.
- Khetha iqembu eliqonde mpo lezinto bese uchofoza inkinobho Namathisela.
- Njengoba ubona, ngokungafani nezinketho ezedlule, kulokhu kuhlanganiswe neqembu lezinto ezinoguquko oluya ngakwesokunene.
Kuzokwenzekani uma sengeza uhlu lwezinto ezinokuqondisa ngokuqondile nokuqondile ngokuqondile?
- Khetha uhlu lwamakhondlela afanele bese uchofoza inkinobho esivele siyayazi Namathisela.
- Njengoba ukwazi ukubona, kuleli cala, izinto ezinoshintsho ngakwesokunene zizofakwa endaweni ekhethiwe.
Uma usafuna ukucacisa ngokuqondile ukuthi izakhi kufanele ziguqulwe kuphi, futhi, ngokwesibonelo, lapho ungeza uhlu, ufuna ukuthi ukushintshana kwenzeke, khona-ke kufanele ulandele umyalo olandelayo.
- Khetha isakhi noma iqembu lezinto esizibeka endaweni yalo. Sichofoza inkinobho esingayazi Namathisela, kanye noxantathu, okukhonjiswe ngakwesokunene sakho. Uhlu lwezenzo luyavula. Khetha into ekuyo "Faka amaseli ...".
- Ngemuva kwalokho, iwindows yokufaka, esesiyijwayele indlela yokuqala, iyavula. Khetha inketho yokufaka. Uma thina, njengoba kushiwo ngenhla, sifuna ukwenza isenzo ngokushintsha phansi, bese sibeka isikhundla esimeni "Amaseli ngokushintsha phansi". Ngemuva kwalokho chofoza inkinobho "Kulungile".
- Njengoba ubona, izakhi zengezwe eshidini ngeshintshi phansi, okungukuthi, njengoba nje sihlelile kuzilungiselelo.
Indlela 3: Abashisi
Indlela esheshayo yokufaka izinto zeshidi ku-Excel ukusebenzisa inhlanganisela ye-hotkey.
- Khetha izakhi lapho sifuna ukufaka khona. Ngemuva kwalokho sithayipha kwikhibhodi inhlanganisela yezinkinobho ezishisayo I-Ctrl + Shift + =.
- Ngemuva kwalokhu, kuzovuleka iwindi elincane lokufaka izinto esezijwayele thina. Kuyo udinga ukusetha i-offset kwesokudla noma phansi bese ucindezela inkinobho "Kulungile" ngendlela efanayo njengoba sikwenze kaningi kunangaphambili ezindleleni ezedlule.
- Ngemuva kwalokho, izinto ezisekeshini zizofakwa, ngokuya ngezilungiselelo zokuqala ezenziwa esigabeni esedlule salo myalelo.
Isifundo: Ama-Hotkeys e-Excel
Njengoba ukwazi ukubona, kunezindlela ezintathu eziyinhloko zokufaka amaseli etafuleni: ukusebenzisa imenyu yokuqukethwe, izinkinobho kubambo, nezikhiye ezishisayo. Ngokuya ngokusebenza, lezi zindlela ziyafana, ngakho-ke uma ukhetha, okokuqala, ukusetshenziswa komsebenzisi kuyabhekwa. Yize kunjalo, indlela eshesha kakhulu ukusebenzisa ama-hotkeys. Kodwa, ngeshwa, akubona bonke abasebenzisi abajwayele ukugcina ukuhlanganiswa okukhona kwe-Excel hotkey kwimemori yabo. Ngakho-ke, kude nawo wonke umuntu le ndlela esheshayo izoba lula.
