Mmene Mungakwirire Malemba ndi Mafomu pa Mipingo Yambiri mu Excel

01 ya 01

Mmene Mungakwirire Malemba ndi Mafomu mu Excel

Zolemba pamanja za Excel ndizojambula bwino zomwe zimakupangitsani kuti muyang'ane mawonekedwe a ma labels ndi kumayang'ana patsamba.

Nthawi zambiri amagwiritsidwa ntchito ngati njira yowonjezera mazenera a mapepala kuti apange mutu wautali powonekera, kulembera malemba kukulolani kuyika malemba pa mizere yambiri mu selo imodzi.

Ntchito yachiwiri yogwiritsira ntchito malemba ndi kuswa mawonekedwe autali autali kupita ku mzere wambiri mumaselo kumene chigawocho chilipo kapena pamakalata omwe ali ndi cholinga chowunikira kuwerenga ndi kusintha.

Njira Zophimbidwa

Monga mu mapulogalamu onse a Microsoft, pali njira imodzi yokwaniritsira ntchito. Malangizo awa akuphimba njira ziwiri zokopera malemba mu selo limodzi:

• pogwiritsa ntchito njira yachinsinsi kuti mukulumikize malemba ndi kukulunga ma fomu
• pogwiritsa ntchito Kutsindika Malemba pa Tsamba la Home la Riboni

Kugwiritsa Ntchito Njira Zowonjezera Kulemba Malemba

Kuphatikizira kwachinsinsi kwachinsinsi polemba malemba mu Excel ndi chimodzimodzi chomwe chimagwiritsidwa ntchito kuyika kusweka kwa mzere (nthawi zina amatchedwa kubwerera kofewa ) mu Microsoft Word:

Chitsanzo: Manga Malembo Pamene Mumapanga

1. Dinani mu selo kumene mukufuna kuti lembalo likhale
2. Lembani mzere woyamba wa malemba
3. Lembani ndi kugwiritsira chingwe cha Alt pa makiyi
4. Sakanizani ndi kumasula makiyi a Kulowa pa khibhodi popanda kumasula makiyi a Alt
5. Tulutsani makiyi a Alt
6. Mfundo yolembera iyenera kusunthira kumzere uli pansipa
7. Lembani mzere wachiwiri wa malemba
8. Ngati mukufuna kulowa mizere iwiri yolemba, pitirizani kukanikiza Alt + Lowani pamapeto pa mzere uliwonse
9. Pamene malemba onse alowetsedwa, dinani makiyi a Enter mu makinawo kapena dinani ndi mbewa kuti musamuke ku selo lina

Chitsanzo: Malembo Olemba Amene Adalembedwa kale

1. Dinani pa selo yomwe ili ndi malemba kuti aphimbe pa mizere yambiri
2. Dinani pa F2 key pa kambokosi kapena dinani kawiri pa selo kuti muike Excel mu Edit mode .
3. Dinani ndi ndondomeko yamagulu kapena mugwiritsire ntchito makiyi a makani pa khibhodi kuti musunthire chithunzithunzi ku malo komwe mzerewu udzasweka
4. Lembani ndi kugwiritsira chingwe cha Alt pa makiyi
5. Sakanizani ndi kumasula makiyi a Kulowa pa khibhodi popanda kumasula makiyi a Alt
6. Tulutsani makiyi a Alt
7. Mzere wa malemba uyenera kupatulidwa pa mizere iwiri mu selo
8. Kuti muphwanye mzere womwewo wa kachiwiri kachiwiri, pita kumalo atsopano ndi kubwereza masitepe 4 mpaka 6 pamwambapa
9. Pamaliza, pindikizani fungulo lolowani mu kibokosi kapena dinani pa selo lina kuti mutuluke.

Kugwiritsa Ntchito Zowonjezera Zowonjezera Kukulunga Mafomu

Kuphatikizira kwazitsulo kazitsulo ka Alt + Kungagwiritsenso ntchito kukulunga kapena kuswa mawonekedwe aatali pa mizere yambiri mu bar.

Njira zomwe mungatsatire zikufanana ndi zomwe zanenedwa pamwambapa - malingana ndi momwe chiwerengerocho chili kale mu selo lamasewero kapena chikuphwanyidwa pamzere wambiri pamene yalowa.

Kuphwanya machitidwe omwe alipo kale kumatawu angapangidwe mu selo yamakono kapena fomu yamakono pamwamba pa tsamba.

Ngati galasi lamakono likugwiritsidwa ntchito, likhoza kufalikira kuti liwonetse mizere yonse mu fomu monga momwe tawonetsera pa chithunzi pamwambapa.

Pogwiritsa Ntchito Mpukutu Wolemba Pulogalamu

1. Dinani mu selo kapena maselo omwe ali ndi malemba kuti aphimbe pa mizere yambiri
2. Dinani pa tsamba la Pakiti.
3. Dinani pa batani lolemba Wembali pa kaboni.
4. Malemba mu selo (s) ayenera tsopano kuwonetseredwa bwino ndi malemba osweka mu mizere iwiri kapena mizere yopanda kutsanulira m'maselo apafupi.