Matchulidwe owunikira amagwiritsidwa ntchito posonyeza kukayikakayika, kusayenerana kwa chochita kapena chochitika. Nthawi zina izi zimakhala zofunikira kuzigwiritsa ntchito mu Excel. Koma, mwatsoka, palibe kiyibodi kapena gawo lowoneka la pulogalamuyo silikhala ndi zida zothandiza kuti muchite izi. Tiyeni tiwone momwe mungagwiritsire ntchito malembedwe ake mu Excel.
Phunziro: Zolemba mwamphamvu mu Microsoft Mawu
Kugwiritsa ntchito mawu osangalatsa
Kugunda mwamphamvu mu Excel ndi chinthu chosintha. Chifukwa chake, nyumbayi ikhoza kuperekedwa ku lembalo pogwiritsa ntchito zida zosintha.
Njira 1: mndandanda wanthawi zonse
Njira yofala kwambiri kwa ogwiritsa ntchito kuti aphatikize mawu pakati pa ogwiritsa ntchito ndikupita pazenera kudzera pazomwe zikuwonekera Mtundu Wa Cell.
- Sankhani khungu kapena mtundu womwe mutu womwe mukufuna kuti udutse. Dinani kumanja. Zosankha zam'mawu zimatsegulidwa. Dinani pamndandanda womwe uli mndandanda Mtundu Wa Cell.
- Tsamba losintha likutsegulidwa. Pitani ku tabu Font. Chongani bokosi pafupi ndi chinthucho Menyaniyomwe ili mgulu la zosintha "Zosintha". Dinani batani "Zabwino".
Monga mukuwonera, zitatha izi, zizindikiro zomwe zidasankhidwa zidatulukira.
Phunziro: Kukhazikitsa matebulo ku Excel
Njira 2: fotokozerani mawu amodzi m'maselo
Nthawi zambiri ndikofunikira kuti athe kufotokozera zonse zomwe sizili m'selo, koma mawu okha omwe ali mmenemo, kapena gawo la mawu. Ku Excel, izi ndizothekanso.
- Timayika cholozera mkati mwa foniyo ndikusankha gawo lomwe lingatchulidwe. Dinani kumanja kumenyu yazonse. Monga mukuwonera, ili ndi mawonekedwe osiyana pang'ono ndi momwe mumagwiritsira ntchito njira yapita. Komabe, chinthu chomwe tikufuna "Mtundu wamtundu ..." nalonso. Dinani pa izo.
- Zenera Mtundu Wa Cell kutsegula. Monga mukuwonera, nthawi ino ili ndi tabu limodzi lokha Font, zomwe zimapangitsa kuti ntchitoyi ikhale yosavuta, chifukwa palibe chifukwa chopita kulikonse. Chongani bokosi pafupi ndi chinthucho Menyani ndipo dinani batani "Zabwino".
Monga mukuwonera, zitatha izi, ndi gawo lokhalo la zilembo zomwe amapezeka mchipindamu.
Njira 3: zida za tepi
Kusintha kwa kupanga maselo kuti mitunduyo ipangitse kuti chiwongolere bwino chitha kuchitika kudzera mu nthiti.
- Sankhani khungu, gulu la maselo kapena zomwe zili mkati mwake. Pitani ku tabu "Pofikira". Timadulira chizindikirocho ngati muvi wopendekera womwe uli pakona yakumbuyo kwa chida Font pa tepi.
- Windo losintha limatsegula mwina ndi zonse kapena ndi lalifupi. Zimatengera zomwe mwasankha: maselo kapena mawu okha. Koma ngakhale zenera liri ndi magwiridwe antchito ambiri, lidzatsegulidwa tabu Font, zomwe tikufunika kuthetsa vutoli. Kenako, timachita zofanana ndi zomwe tidasankha m'mbuyomu.
Njira 4: njira yachidule
Koma njira yosavuta yopangira zolembedwazi ndikugwiritsa ntchito makiyi otentha. Kuti muchite izi, sankhani maselo kapena mawu mmawuwo ndipo lembani njira yaying'ono pa kiyibodi Ctrl + 5.
Zachidziwikire, iyi ndi njira yabwino kwambiri komanso yachangu kwambiri kuposa njira zonse zomwe zafotokozedwayu, koma chifukwa chakuti ogwiritsa ntchito ochepa sawasunga kukumbukira mitundu ingapo yamavuto, njira iyi yopangira zolemba zosavomerezeka ndizosavomerezeka kugwiritsa ntchito njirayi kudzera pazenera.
Phunziro: Ogula otentha
Ku Excel, pali njira zingapo zomwe zingapangitse kuti zolemba zikhale bwino. Zosankha zonsezi ndizokhudzana ndi mtundu wa mawonekedwe. Njira yosavuta yopangira kutembenuka kwamakhalidwe ndikugwiritsa ntchito kuphatikiza kwa hotkey.
