Momwe mungapangire zolemba mu Excel

Pogwira ntchito pamawonekedwe azithunzi pamatebulo a Excel, nthawi zambiri ndikofunikira kuwunikira izi kapena zambiri. Izi zimatheka ndi kusintha magawo monga mtundu wa font, kukula kwake, mtundu, kudzaza, kutsindika, kuyanjanitsa, mawonekedwe, ndi zina zotero. Zida zodziwika bwino zimawonetsedwa pa riboni ya pulogalamu kuti zikhale pafupi. Koma palinso zinthu zina zomwe sizikufunika nthawi zambiri, koma ndizothandiza kudziwa momwe mungazipezere ndikuzigwiritsa ntchito ngati mukufuna. Izi zikuphatikiza, mwachitsanzo, mawu opambana. M'nkhaniyi, tiwona momwe mungachitire izi mu Excel.

Njira 1: Menyani Selo Yonse

Kuti tikwaniritse cholingachi, timatsatira ndondomeko zotsatirazi:

1. Mwanjira iliyonse yabwino, sankhani selo (kapena dera la ma cell), zomwe tikufuna kudutsa. Kenako dinani kumanja pazosankha ndikusankha chinthucho pamndandanda wotsitsa "Cell Format". Mutha kungodinanso njira yachidule ya kiyibodi m'malo mwake Ctrl + 1 (pambuyo posankha).
2. Zenera la mtundu lidzawonekera pazenera. Kusintha kwa tabu "Fonti" mu parameter block "Sinthani" pezani njira "kudutsa", ikani chizindikiro ndikudina OK.
3. Zotsatira zake, timapeza mawu opambana m'maselo onse osankhidwa.

Njira 2: Kutulutsa liwu limodzi (chidutswa)

Njira yomwe tafotokozayi ndiyoyenera ngati mukufuna kudutsa zonse zomwe zili mu cell (ma cell osiyanasiyana). Ngati mukufuna kuchotsa tizidutswa tating'ono (mawu, manambala, zizindikilo, ndi zina), tsatirani izi:

1. Dinani kawiri pa selo kapena ikani cholozera pamenepo ndiyeno dinani kiyi F2. Munjira zonse ziwiri, njira yosinthira imatsegulidwa, yomwe itilola kusankha gawo la zomwe tikufuna kuyikapo masanjidwe, yomwe ndi strikethrough.Monga m'njira yoyamba, podina kumanja pazosankha, timatsegula menyu, momwe timasankha chinthucho - "Cell Format".Zindikirani: kusankha kungathenso kuchitidwa mu bar ya fomula posankha kaye cell yomwe mukufuna. Pakadali pano, menyu yankhaniyo imapemphedwa ndikudina kachidutswa komwe kasankhidwa pamzerewu.
2. Titha kuzindikira kuti zenera la masanjidwe a cell lomwe limatsegulidwa nthawi ino lili ndi tabu imodzi yokha "Fonti", zomwe ndi zomwe timafunikira. Apa tikuphatikizanso parameter "kudutsa" ndipo dinani OK.
3. Chigawo chosankhidwa chazomwe zili m'maselo sichidziwika. Dinani Lowanikuti amalize kukonza.

Njira 3: Ikani Zida pa Riboni

Pa riboni ya pulogalamuyo, palinso batani lapadera lomwe limakulolani kuti mulowe muwindo la masanjidwe a cell.

1. Poyamba, timasankha selo/chidutswa cha zomwe zili mkati mwake kapena ma cell angapo. Kenako mu tabu yayikulu mu gulu la zida "Fonti" dinani pa chithunzi chaching'ono chokhala ndi muvi wolozera pansi.
2. Kutengera zomwe zasankhidwa, zenera la masanjidwe lidzatsegulidwa - kaya ndi ma tabo onse, kapena ndi imodzi ("Fonti"). Zochita zina zafotokozedwa m'magawo ofunikira pamwambapa.

Njira 4: ma hotkeys

Ntchito zambiri mu Excel zitha kukhazikitsidwa pogwiritsa ntchito njira zazifupi za kiyibodi, ndipo mawu opitilira muyeso ndi chimodzimodzi. Zomwe muyenera kuchita ndikusindikiza kuphatikiza Ctrl + 5, pambuyo posankhidwa.

Njirayi, ndithudi, ikhoza kutchedwa yofulumira komanso yabwino kwambiri, koma chifukwa cha izi muyenera kukumbukira kuphatikiza kwachinsinsi ichi.

Kutsiliza

Ngakhale kuti mawu opitilira muyeso sali otchuka monga, mwachitsanzo, molimba mtima kapena mopendekera, nthawi zina ndikofunikira kuti zidziwitso ziwonetsedwe m'matebulo. Pali njira zambiri zothanirana ndi ntchitoyi, ndipo wogwiritsa ntchito aliyense amatha kusankha yomwe ikuwoneka kuti ndi yabwino kwambiri kuti agwiritse ntchito.