Gwiritsani Zosankha za Shortcut Keys ndi Ribbon kuti muwonjezere malire mu Excel

Mu Excel, malire ndi mizere yowonjezera pamphepete mwa selo kapena gulu la maselo.

Miyendo ya mzere yomwe ingagwiritsidwe ntchito pamalire ili ndi mizere yosakwatiwa, iwiri, ndi nthawi zina. Kutalika kwa mizere kungapangidwe mosiyana monga momwe kulili mtundu.

Zokongoletsa ndi zojambula zomwe zimagwiritsidwa ntchito kuti ziwoneke mawonekedwe anu. Iwo angathandize kuti mupeze mosavuta kupeza ndi kuwerenga deta yeniyeni.

Zitha kugwiritsidwanso ntchito kugwiritsira ntchito zofunikira zofunika monga zotsatira za malemba .

Kuwonjezera mizere ndi malire ndi njira yofulumira yopangira zofunikira zofunika mu Excel.

Ma totali a phukusi, mazenera a deta , kapena maudindo ofunika ndi mitu yonse akhoza kuwonetseredwa ndi kuwonjezera mizere ndi malire.

Kuwonjezera Mipandamo Pogwiritsa Ntchito Njira Yowonjezera

Zindikirani: Njirayi ikuwonjezera malire kumbali yapakati ya maselo amodzi kapena ambiri osankhidwa pogwiritsa ntchito mzere wosasinthika mtundu ndi makulidwe.

Mgwirizano wowonjezera kuwonjezera malire ndi:

Ctrl + Shift + & (keyers ampersand)

Chitsanzo cha Mmene Mungakwirire Mipandamo Pogwiritsa ntchito njira yofikira

1. Gwiritsani ntchito maselo ofunika omwe mukufunayo pa tsamba
2. Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.
3. Dinani ndi kumasula chiwerengero cha ampersand (&) - pamwamba pa nambala 7 pa kibodiboli - popanda kumasula makiyi a Ctrl ndi Shift .
4. Maselo osankhidwa ayenera kuzunguliridwa ndi malire akuda.

Kuwonjezera Mipandanda mu Excel Pogwiritsa Ntchito Zowonjezera

Monga momwe zasonyezera mu chithunzi pamwambapa, njira ya Borders ili pansi pa tsamba la Home la nthiti .

1. Gwiritsani ntchito maselo ofunika omwe mukufunayo pa tsamba
2. Dinani pa tsamba la Home la riboni;
3. Dinani pazithunzi za m'mphepete mwaboni kuti mutsegule menyu otsika pansi monga momwe tawonetsera pa chithunzi pamwambapa;
4. Dinani pa mtundu wofunidwa wa malire kuchokera pa menyu;
5. Malire osankhidwa ayenera kuwonekera kuzungulira maselo osankhidwa.

Zosankha Zam'mbali

Pali njira zambiri zowonjezera pazowonjezera ndi kupanga mizere ndi malire:

• Malire akhoza kuwonjezeredwa kumodzi kapena mbali zonse za selo kapena maselo a maselo;
• kukula kwa mizere kungagwiritsidwe ntchito;
• mitundu yosiyanasiyana ya mzere ikupezeka;
• pali mitundu yambiri yosankha kuchokera;
• Zolemba zojambula za Excel zingagwiritsidwe ntchito kujambula malire kuzungulira deta yosasinthika, monga momwe zasonyezera muchitsanzo cha chithunzi.

Zojambula Zojambula

Monga momwe chikuwonetsedwera mu chithunzichi, Chidule Chajambula Chakum'mwera chili pansi pa Masitepe Otsika pansi monga momwe asonyezedwera pamwambapa.

Njira imodzi yogwiritsira ntchito malire ndi kuti sikofunika kusankha maselo poyamba. M'malo mwake, kamodzi kokhala malire osankhidwa ndi osankhidwa malire akhoza kuwonjezedwa mwachindunji pa tsamba, monga momwe akusonyezera kumanja kwa chithunzichi.

Kusintha Mzere wa Mzere ndi Mtambo wa Line

Dulani Malire amakhalanso ndi njira zosinthira mtundu wa mzere ndi machitidwe a mzere, zomwe zimapangitsa kuti zikhale zosavuta kusinthasintha maonekedwe a malire omwe akugwiritsidwa ntchito poyang'ana zofunikira zamadontho.

Zosankha zamasitala zimakulolani kuti mupange malire ndi:

• mizere yosiyanasiyana ya makulidwe
• mizere yodzala ndi yosweka
• mizere iwiri

Kugwiritsa Ntchito Zojambula Zojambula

1. Dinani pa tsamba la Home la riboni;
2. Dinani pa njira ya Borders pa riboni kuti mutsegule menyu otsika;
3. Sinthani mtundu wa mzere ndi / kapena ndondomeko ya mzere ngati mukufuna;
4. Dinani pajambula Border kumunsi kwa menyu otsika;
5. Choyimira phokoso chimasintha penipeni - monga zikuwonetsekera kumanja kwa chithunzi;
6. Dinani pa selo imodzi ya gridlines kuti muwonjezere malire amodzi m'madera awa;
7. Dinani ndi kukoka ndi pointer kuti muwonjezere malire akunja ku selo kapena maselo.

Dulani Border Grid

Njira ina yojambula Border ndiyo kuwonjezera malire akunja ndi mkati mkati mwa maselo amodzi kapena angapo panthawi yomweyo.

Kuti muchite zimenezo, dinani ndikukoka kudutsa maselo ndi "kujambula grid border" kuti mupange malire kuzungulira maselo onse omwe ali mbali ya kusankha.

Lekani Kujambula Malire

Kuti muleke kujambula malire, dinani kanthawi kachiwiri pa chithunzi cha malire pamzere.

Mtundu womaliza wa malire omwe amagwiritsidwa ntchito umakumbukiridwa ndi pulogalamu, komabe, kotero kudindikiza chizindikiro cha malire kachiwiri kumathandizanso kuti izi zichitike.

Dulani malire

Njirayi, monga dzina limatanthawuzira, zimapangitsa kuti zisakhale zosavuta kuchotsa malire kumaselo apakompyuta. Koma mosiyana ndi chisankho cha No Border kuchokera pa mndandanda wa malire, Malire Otsuka amakulolani kuchotsa mizere ya malire payekha - pokhapokha mwa kuwatsata.

Malire ambiri angathenso kuchotsedwa pogwiritsa ntchito dinani ndikukoka.