Njengase-"Excel" yenza uhlu lokudonsa phansi (imiyalo yesinyathelo ngesinyathelo)

Ukwengeza uhlu lokudonsa phansi ku-spreadsheet ye-Excel kuzokusiza ukufaka idatha ngokusheshisa ngokunikeza abasebenzisi uhlu lwezinto okumele ukhethe okudingekayo esikhundleni sokwenza ulwazi lokufaka isikhathi ngasinye. Uma ufaka idatha enjalo esitokisini kuspredishithi, iqala ukubonisa umcibisholo. Ufaka idatha ngokuchofoza umcibisholo, bese ukhetha ukungena okufisayo. Ungasetha uhlu lokudonsa phansi ohlelweni lwe-Excel imizuzu eminingana, ngaleyo ndlela uthuthukise kakhulu ijubane lokungena kwedatha. Ngezansi incazelo yale nqubo.

Imiyalo ye-Excel

Vula itafula ekhasini lapho ufuna ukudala uhlu lokudonsa phansi. Yakha uhlu lwezinto okufanele ziboniswe ohlwini. Faka idatha ngendlela eyovulelwa ngayo kamuva. Amarekhodi kumele asebenze emgqeni ofanayo noma ikholomu, futhi akufanele abe namaseli angenalutho.

Ukuze wenze uhlu lwezinto ezidingekayo kushidi elihlukile, chofoza ithebhu ithebhu lapho ufuna ukungena khona idatha. Khetha uhlobo bese ukhetha okuqukethwe okuvela kuhlu. Chofoza ngakwesokudla ububanzi bamakheli bese ufaka igama lobubanzi ebangeni "Igama", bese ukhetha "Kulungile". Ungavikela noma ufihle ishidi ukuze abanye abasebenzisi bangakwazi ukwenza ushintsho ohlwini.

Izinsisekelo zendlela yokwenza uhlu lokudonsa phansi ku-Excel

Chofoza kuseli olikhethile kule njongo. Iya kuthebhu "Idatha" ku-Ribbon ye-Microsoft Excel. Ibhokisi lengxoxo elibizwa ngokuthi "Ukuqinisekiswa Kwemininingwane" livela. Yiya kuthebhu "Izilungiselelo" bese uchofoze "Uhlu" kusuka kwimenyu ethi "Vumela", etholakala kuhlu lokudonsa phansi. Chofoza inkinobho yomsakazo kwimenyu yomthombo. Khetha uhlu lwezinto ofuna ukuzifaka ohlwini lwakho lokudonsa ku-Excel.

Uma wadala igama lebanga emkhakheni wemthombo, faka uphawu olulinganayo, bese ufaka igama lobubanzi.

Izilungiselelo ezidingekayo zokudala

Hlola noma ungacwengi ibhokisi "Yekani okungenalutho", kuye ngokuthi ngabe iseli eliqukethe uhlu lokudonsa lingasala lutho.

Chofoza ithebhu "Faka umyalezo" ukuze ubonise ibhokisi lomlayezo ovula uma uchofoza uhlu lokudonsa phansi. Qinisekisa ukuthi ibhokisi lokuhlola eliseduze nento yemenyu "Bonisa umlayezo wokufaka uma ukhetha iseli" isethwe, bese ufaka isihloko. Ngakho ulandela yonke imiyalo yokwenza uhlu lokudonsa phansi ku-Excel.

Chofoza ithebhu ethi "Iphutha lesaziso" ukuze ubonise umlayezo wephutha uma idatha engalungile ingenwe. Qinisekisa ukuthi isixwayiso "Bonisa Iphutha" sinikwe amandla ngokuhlola ibhokisi elihambelanayo.

Chofoza u- "Kulungile" ukuze ulondoloze izindlela zokuqinisekisa bese udala uhlu lokudonsa phansi.

Indlela yokwenza uhlu lokudonsa phansi ku-Excel: amanothi abalulekile

Uma irekhodi elidonsela phansi ohlwini likhulu kunosayizi weseli equkethe uhlu, ungashintsha ububanzi beseli ukubuka wonke umbhalo.

Ukususa uhlu lokudonsa phansi, khetha iseli eliqukethe. Chofoza ithebhu yedatha ku-Ribbon ye-Microsoft Excel. Chofoza inkinobho ethi "Hlola Idatha" kuqembu elithi "Ukusebenza neDatha". Iya kuthebhu "Izilungiselelo", chofoza okuthi "Sula Konke", bese uchofoza u- "Kulungile".

Njengoba ungabona, umhlahlandlela wokuthi ungayenza kanjani uhlu lokudonsa phansi ku-Excel lulula kakhulu. Le myalelo ayidingi nolwazi olukhethekile, kubalulekile kuphela ezingeni lokuqala ukuthi likwazi ukusebenza nama-spreadsheet. Kuyafaneleka futhi ukuphawula ukuthi ezinhlokweni ezihlukahlukene zohlelo lwe-Excel, izinto zemenyu zingase zibe nokungafani nalokho okungenhla, lokhu kufanele kucatshangelwe uma kusebenza.