Lapho usebenza ohlelweni lwe-Excel, kuvame kakhulu kudingekile ukwengeza imigqa emisha etafuleni. Kepha, ngeshwa, abanye abasebenzisi abazi ukuthi bazenza kanjani izinto ezilula kangaka. Kuliqiniso, kufanele kuqashelwe ukuthi lokhu kusebenza kunezinye "izingibe". Ake sibheke ukuthi ungafaka kanjani intambo ku-Microsoft Excel.
Faka izintambo phakathi kwemigqa
Kumele kwaziwe ukuthi inqubo yokufaka yomugqa omusha ezinguqulweni zanamuhla zoHlelo lwe-Excel cishe azinalo ukungezwani komunye nomunye.
Ngakho-ke, vula itafula lapho udinga ukwengeza intambo. Ukufaka intambo phakathi kwemigqa ngokuchofoza inkinobho yegundane efanelekile kunoma yimuphi umugqa wentambo, esihlela ukufaka into entsha. Kumenyu yokuqukethwe evula, chofoza ku- "Namathisela ...".
Futhi, kukhona amathuba okufaka ngaphandle kokubiza imenyu yokuqukethwe. Ukuze wenze lokhu, mane uchofoze kukhibhodi ukhiye wekhibhodi "Ctrl +".
Ibhokisi lengxoxo liyavulwa, elinikezela nge-US Faka etafuleni leseli nge-Shift Down, amaseli anokushintshwa kwesokudla, ikholamu, kanye nentambo. Sisungula ukushintshela esimweni esithi "String", bese uqhafaza inkinobho ethi "KULUNGILE".
Njengoba ukwazi ukubona, umugqa omusha ohlelweni lweMicrosoft Excel lungezwe ngempumelelo.
Ukufaka izintambo ekugcineni kwetafula
Kepha yini okufanele yenze uma udinga ukufaka iseli hhayi phakathi kwemigqa, kepha engeza intambo ekugcineni kwetafula? Ngemuva kwakho konke, uma usebenzisa leyo ndlela engenhla, umugqa ongeziwe ngeke ufakwe etafuleni, kepha uzohlala ngaphandle kwemingcele yawo.
Ukuze uthuthukise itafula phansi, khetha intambo yokugcina yetafula. Ekhoneni layo elingakwesokudla, kwakhiwa isiphambano. Ngiyidonsela phansi emigqeni eminingi njengoba sidinga ukunweba itafula.
Kepha, njengoba sibona, wonke amaseli aphansi akhiwa nedatha egcwele kwiseli lomama. Ukususa le datha, khetha amaseli asanda kwakhiwa, bese uqhafaza inkinobho yegundane elifanele. Kumenyu yokuqukethwe evelayo, khetha into ethi "Okuqukethwe okucacile".
Njengoba ubona, amaseli ahlanzwa, futhi alungele ukugcwalisa imininingwane.
Kuyadingeka ukubheka ukuthi le ndlela ilungele kuphela uma kungekho umugqa ophansi wemiphumela etafuleni.
Ukudala Ithebula Elihlakaniphile
Kepha, kulula kakhulu ukudala, okuthiwa okubizwa ngokuthi, "Ithebula elihlakaniphile". Lokhu kungenziwa kanye, bese kungakhathazeki ukuthi uhlobo oluthile lomugqa lapho kungenwe kungangeni imingcele yetafula. Leli thebula lizokwelulwa, futhi ngaphandle kwalokho, yonke imininingwane enomthelela kuyo ngeke ivele kumafomula asetshenziswe etafuleni, ephepheni nasencwadini ephelele.
Ngakho-ke, ukuze wakhe "itafula elihle", sabela wonke amaseli okufanele awufake. Ethebhu yasekhaya, chofoza inkinobho ethi "format njengeThefa". Uhlu lwezitayela ezitholakalayo, sikhetha isitayela osicabangele kakhulu. Ukwakha "Ithebula elihlakaniphile", ukukhethwa kwesitayela esithile akunandaba.
Ngemuva kwesitayela kukhethiwe, ibhokisi lengxoxo liyavuleka, lapho uhla lwamaseli olukhethwe yi-US lucacisiwe, ngakho-ke awudingi ukwenza ushintsho. Mane ucindezele inkinobho ethi "Kulungile".
"Ithebula elihlakaniphile" selilungile.
Manje, ukwengeza intambo, chofoza esitokisini lapho intambo izokwakhiwa khona. Kumenyu yokuqukethwe, khetha "Insert Tarce Lines ngenhla" yento.
Intambo yengezwa.
Intambo phakathi kwemigqa ingangezwa ngokumane ucindezele inhlanganisela yokhiye we- "CTRL +". Akudingeki ukuthi ngingene noma yini enye kulokhu.
Faka intambo ekugcineni kwetafula elihlakaniphile ngezindlela eziningana.
Ungavuka esitokisini sokugcina somugqa wokugcina, bese uqhafaza kwikhibhodi inkinobho yeTabe (ithebhu).
Futhi, ungasukuma isikhombisi ekhoneni elingezansi elingezansi leseli lokugcina, bese ulidonsela phansi.
Kulokhu, amaseli amasha azogcwala ngokungelutho ekuqaleni, futhi ngeke adinge ukuhlanzwa kusuka kudatha.
Futhi ungamane ufake noma iyiphi idatha ngaphansi komugqa ongaphansi kwetafula, futhi izofakwa ngokuzenzakalelayo etafuleni.
Njengoba ubona, engeza amaseli etafuleni kuhlelo lweMicrosoft Excel kungaba ngezindlela ezahlukahlukene, kodwa ukuze kungabikho zinkinga ngokungeza, ngaphambili, kungcono ukudala "itafula elihle" usebenzisa ukufomatha.