Maselo a selo mu pulogalamu ya Excel samangokhala maonekedwe a deta, koma amasonyezanso pulogalamu momwe ziyenera kukhazikitsidwa: monga malemba, monga manambala, ngati tsiku, ndi zina zotero. Choncho, ndikofunika kwambiri kuti muyankhe bwino khalidwe ililo momwe deta idzalowe. Koma, zowerengera zonse sizikhala zolakwika. Tiyeni tione momwe tingasinthire mawonekedwe a maselo a Microsoft Excel.
Phunziro: Kulemba Malemba mu Microsoft Word
Mitundu yayikulu ya maonekedwe ndi kusintha kwawo
Nthawi yomweyo mudziwe mawonekedwe omwe alipo. Pulogalamuyi imapereka kusankha imodzi mwa mitundu ikuluikulu yotsatirayi:
- Wamba;
- Ndalama;
- Numeric;
- Ndalama;
- Malemba;
- Tsiku;
- Nthawi;
- Zosakaniza;
- Chiwongoladzanja;
- Mwasankha.
Kuonjezerapo, pali kusiyana pakati pa magawo ang'onoang'ono omwe ali pamwambawa. Mwachitsanzo, nthawi ndi nthawi zimakhala ndi subspecies zingapo (DD.MM.GG., DD.myats.GG, DD.M, FM MM PM, HH.MM, etc.).
Mukhoza kusintha mawonekedwe a maselo mu Excel m'njira zingapo kamodzi. Tidzakambirana za iwo mwatsatanetsatane.
Njira 1: mndandanda wamakono
Njira yodziwika kwambiri yosintha mawonekedwe a deta ndi kugwiritsa ntchito makondomu.
- Sankhani maselo omwe amafunika kukonzedwa molingana. Dinani ndi batani lamanja la mouse. Zotsatira zake, mndandanda wa zochitika zikutsegulidwa. Muyenera kuyimitsa kusankha pa chinthucho "Sungani maselo ...".
- Kujambula zenera kuyatsegulidwa. Pitani ku tabu "Nambala"ngati zenera linali lotseguka kwina. Icho chiri muzomwe zimapangidwira "Maofomu Owerengeka" Pali njira zonse zomwe mungasinthire kusintha makhalidwe omwe takambirana pamwambapa. Sankhani chinthu chomwe chikugwirizana ndi deta yomwe ili yosankhidwa. Ngati ndi kotheka, mbali yeniyeni yawindo timatanthauzira chidziwitso cha deta. Timakanikiza batani "Chabwino".
Zitatha izi, mawonekedwe a selo amasinthidwa.
Njira 2: Chiwerengero cha chida chojambulidwa pa riboni
Kupangidwanso kungasinthidwenso pogwiritsira ntchito zipangizo pa tepi. Njira iyi imakhala yofulumira kuposa yomwe yapitayo.
- Pitani ku tabu "Kunyumba". Pankhaniyi, muyenera kusankha maselo oyenerera pa pepala, ndipo muzitseko musatseke "Nambala" Pa riboni, tsegula bokosi losankhika.
- Ingopanga chisankho chofuna. Mitunduyi idzasinthira nthawi yomweyo.
- Koma zokhazokha zimapangidwa mndandandawu. Ngati mukufuna kufotokozera maonekedwe moyenera, muyenera kusankha "Maofomu Ena".
- Zitatha izi, zenera zidzatsegulidwa kuti zikhazikike, zomwe zafotokozedwa kale. Wosuta angathe kusankha pano iliyonse yowonjezera kapena yowonjezera ma data.
Njira 3: Bokosi la Tool
Njira ina yothetsera khalidweli ndi kugwiritsa ntchito chida ichi muzitsulo. "Maselo".
- Sankhani zolemba pa pepala, zomwe ziyenera kupangidwira. Ili pa tabu "Kunyumba", dinani pazithunzi "Format"zomwe ziri mu gulu la zida "Maselo". Mundandanda wa zochita zomwe zatsegula, sankhani chinthucho "Sungani maselo ...".
- Pambuyo pake, mawindo omwe kale akudziwika bwino amawonekera. Zochita zonse zoonjezera ziri chimodzimodzi ndizofotokozedwa kale.
Njira 4: Hotkeys
Ndipo potsiriza, mawindo a mawonekedwe osiyana angatchulidwe pogwiritsa ntchito otchedwa mafungulo otentha. Kuti muchite izi, choyamba sankhani dera kuti lisinthidwe pa pepala, ndiyeno tekanitsani kuphatikiza pa makiyi Ctrl + 1. Pambuyo pake, mawindo omasulira mazenera adzatsegulidwa. Timasintha makhalidwe monga momwe tafotokozera pamwambapa.
Kuonjezerapo, kuphatikiza kwachinsinsi pamodzi kumakupatsani kusintha maonekedwe a maselo mutatha kugawa, ngakhale popanda kutchula zenera lapadera:
- Ctrl + Shift + - - mtundu wonse;
- Ctrl + Shift + 1 - manambala ndi olekanitsa;
- Ctrl + Shift + 2 - nthawi (maola.mphindi);
- Ctrl + Shift + 3 - masiku (DD.MM.GG);
- Ctrl + Shift + 4 - ndalama;
- Ctrl + Shift + 5 - chidwi;
- Ctrl + Shift + 6 - mawonekedwe O.OOE + 00.
Phunziro: Keyi Zowonjezera mu Excel
Monga mukuonera, pali njira zingapo zojambula malo a pepala la Excel. Njirayi ikhoza kugwiritsidwa ntchito pogwiritsira ntchito zipangizo pa tepiyo, poyitanitsa mawindo ojambula kapena kugwiritsa ntchito mafungulo otentha. Wosuta aliyense amadzipangira yekha njira yomwe ndi yabwino kwambiri yothetsera ntchito yeniyeni, chifukwa nthawi zina zimakhala zokwanira kugwiritsa ntchito mawonekedwe odziwika, ndi zina, ndondomeko yeniyeni ya makhalidwe ndi subspecies ndi yofunikira.
