Zosavuta komanso zotsika mtengo za Excel - momwe mungagwirizanitse maselo ku Excel

Excel ndi pulojekiti yogwiritsidwa ntchito kwambiri yomwe imakupatsani mwayi wochita ntchito yowonongeka, kudziunjikira ndikukonzekera deta mu mawonekedwe a matebulo omwe amatha kupanga malemba ndi mawerengedwe odzidzimutsa a zotsatira. Ma sheet spreadsheets amagwiritsidwa ntchito osati zokhazokha zokhudzana ndi nkhani ndi zolemba. Iwo akupezeka kutchuka pafupifupi pafupifupi magawo onse a ntchito. Izi ziyenera kuchitika makamaka kuntchito, ndikugwiritsa ntchito pulogalamuyo, popeza Excel ikukulolani kuti muwonetse zambiri zomwe mwapeza m'mabuku ndi mizere. Kuti muthe kupanga zolemba zazikulu ndi zogwira mtima, wogwiritsa ntchito ayenera kudziwa momwe angagwirizanitse maselo ku Excel. Kuyimira zithunzi pamasom'pamaso kumakhala kosavuta kumvetsetsa, kuwonetseratu maonekedwe ndi mafotokozedwe ake, komanso kusanthula deta yomwe ilipo.

Chifukwa cha kuchuluka kwa ntchito za pulogalamuyi, ogwiritsa ntchito makasitomala amakumana ndi mavuto osiyanasiyana. Pogwiritsa ntchito matebulo ovuta, zimakhala zofunikira kuti mugwirizanitse deta. Pachifukwa ichi, pa gawo loyamba la kulenga tebulo, funso limabwera: "Kodi tingagwirizanitse bwanji maselo apamwamba?". N'zosavuta kuchita izi. Tiyeni tifotokoze njira yogwirizanitsa maselo:

1. Sankhani nambala yofunikira ya maselo, yomwe tidzasinthanitsa. Kuti tichite izi, timakanikiza batani lamanzere pa selo yoyamba yomwe tifuna ndikuigwiritsira pansi, kukoketsa mndandanda womwe ukufunidwa mwa kukokera. Kenaka kumasula batani.
2. Pambuyo pake, sungani ndondomeko ya mouse pakasankhidwa . Dinani botani lamanja la mouse, pulogalamu ya pop-up ikuwonekera. Mu mndandanda wa zotsatirazi, sankhani chinthu "Mafomu Mafomu".

3. Zenera zowonjezera ndi zizindikiro zambiri zimatsegulidwa. Tiyenera kutsegula tabu yachiwiri "Kugwirizana". Kenaka mu gawo la "Display" timasankha chinthu "Kuyanjana maselo", dinani "Chabwino". Tsopano tikuwona kuti maselo osankhidwa ndi ife agwirizana chimodzi. Tebulo ili m'munsi likuwonetsa momwe maselo ogwirizana angayang'ane:

Podziwa momwe mungagwirizanitse maselo mu Excel, mungathe kukhazikitsa zida zina - maonekedwe, kukula kwa mazenera ndi mtundu, malo a zolembazo ndi ndondomeko, malangizo a mawu mu selo. Mukhozanso kupanga malire awo, ndiko kuti, sankhani makulidwe oyenera, mawonekedwe ndi mtundu wa mizere. Tsamba la "Nambala" limakulolani kuti mupange mawonekedwe oyenera a deta ngati mawonekedwe wamba kapena malemba. Mpangidwe wa ndalama ndi yabwino kwa ziwerengero, chifukwa zimatsindika zoyipa zomwe zimapezeka muzofiira zofiira. Zopanga "Date" ndi "Time" zili ndi njira zingapo, zimangokhala kusankha zosangalatsa kwambiri.

Kufunika kophatikiza maselo opambana kumaonekera mwa ogwiritsa makamaka popanga mutu, pamene tebulo liri ndi deta yambiri. Kuti mukhale ndi malingaliro owonetsera, maonekedwe owonetserako a deta, komanso mwamsanga kwambiri komanso momwe mungapezere zambiri, mungagwiritsenso ntchito ntchito yodzaza. Mungathe kuchita izi mwachindunji kuchokera pa gulu loyendetsa ntchito pogwiritsa ntchito botani Lembani, kapena musankhe mtundu wofunidwa kuchokera m'ndandanda wotsika. Monga momwe mukuonera, Excel ndi yabwino kwambiri, chifukwa imakupatsani mwayi wokhala ndi deta yomwe ilipo payekha, malinga ndi zosowa za munthu wina. Tikuyembekeza kuti mtsogolomu funso la momwe mungagwirizanitse maselo mu Excel sichidzakuika pa chiwonongeko.