Kawirikawiri, maselo okhala ndi mayina mu Excel ndi Google Sheets amasonyeza mayankho ku machitidwe onse ndi ntchito zomwe zili patsamba.
M'makalata akuluakulu, kudumpha kuzungulira ndi pointer ya mouse kuti apeze maselo omwe ali ndi machitidwe kapena ntchito izi akhoza kugunda kapena kugwira ntchito.
Onetsani mafomu mu Excel ndi Google Mapepala pogwiritsa ntchito njira zadule
Chotsani zongoganizira pamene mukupeza mayankho pogwiritsa ntchito njira yowonjezera yachinsinsi kuti muwonetse mayendedwe onse mu Excel ndi Google Mapepala:
Ctrl + `(makiyi omveka kwambiri)
Pa makibodi ambiri ofikira, makiyi amodzi oyimirira ali pafupi ndi fungulo 1 nambala kumbali yakumanzere ya makina. Zikuwoneka ngati apostrophe wambuyo.
Mgwirizanowu wamtunduwu umagwira ntchito ngati chingwe chopindulitsa, chomwe chimatanthauza kuti mutsegulire mzere wofanana kachiwiri kuti mubise mawonekedwe mukamaliza kuziwona.
Zotsatira Zowonetsera Mafomu Onse
- Dinani ndi kusunga makiyi a Ctrl pa makiyi.
- Limbikitsani ndi kumasula fungulo lachangu pamakinawo popanda kumasula makiyi a Ctrl.
- Tulutsani makiyi a Ctrl .
Tsambali liyenera kuwonetsera maulendo onse m'maselo awo apakompyuta kusiyana ndi zotsatira zake.
Kubwezeretsanso Mafomu
Kuti muwonetsenso zotsatira mmalo mwa ma formula, yesetsani makina a Ctrl + ` kachiwiri.
About Onetsani Mafomu
- Onetsani mafomu osasintha zomwe zili mu tsamba, momwe amasonyezera.
- Onetsani maulendo amachititsa kuti mupeze mosavuta maselo okhala ndi maulendo.
- Ikuthandizani kuti muwerenge mwachangu mwa njira zonse kuti muone zolakwika.
- Mbaliyi imatha kukhazikitsidwa mwa kusankha:
- Mafomu > Onetsani Mafomu pa Ribbon mu Excel
- Onani > Njira Zonse Zomwe Mungachite Mamasamba a Google
- Zolemba zojambula zojambula ndi Mawonetsedwe Owonetsedwera zikhoza kukhale zosavuta kufufuza zovuta kupeza zolakwika.
Onetsani Mafilimu Okhaokha Othandizira
M'malo mowona njira zonse, n'zotheka kuwona maulendo amodzi pamodzi pokhapokha:
- Kuphindikiza kawiri pa selo yomwe ili ndi ndondomeko ndi mbewa.
- Kusinthanitsa kamodzi pa selo yomwe ili ndi ndondomeko ndi mbewa ndikusindikizira F2 key pa makiyi.
Zonsezi zimapatsa pulogalamuyo, kaya Excel kapena Google Mapepala, kuti ikhale njira yosinthira, yomwe imawonetsera ndondomekoyi mu selo ndikuwonetsera mtundu wa mafotokozedwe a maselo omwe amagwiritsidwa ntchito mu njirayi. Izi zimapangitsa kuti zikhale zosavuta kufufuza magwero a deta akugwiritsidwa ntchito mu fomu.
Bisani Mafomu mu Excel Pogwiritsa Ntchito Pulogalamu Yotetezera
Njira ina yodzibisa mawonekedwe mu Excel ndi kugwiritsa ntchito chitetezo cha pa tsamba , chomwe chimaphatikizapo njira yopezera mazenera m'ma maselo otsekedwa kuti asawonedwe m'malo awa:
- Mu selo komwe iwo ali
- Mu barra ya formula pamene selo lokhala ndi ndondomeko imasindikizidwa
- Pamene Mawonetsero Awonetsedweratu akugwiritsidwa ntchito pogwiritsa ntchito njira yachinsinsi kapena kudzera mu riboni.
Kusunga mawonekedwe, monga maselo otsekemera, ndi njira ziwiri zomwe zimaphatikizapo kuzindikira mndandanda wa maselo amene mumabisala ndiyeno kugwiritsa ntchito tsamba la chitetezo.
Sankhani Cell Range kukabisala
- Sankhani maselo osiyanasiyana omwe ali ndi mafomu omwe abisika.
- Pabupi la kunyumba la riboni, dinani pa Bungwe la Fomu kuti mutsegule menyu otsika.
- Mu menyu, dinani pa Mawonekedwe a Maonekedwe kuti mutsegule bokosi la mauthenga a Mafomu.
- Mu bokosi la bokosi, dinani pa tsamba la Chitetezo .
- Pa tabu iyi, sankhani bokosi lobisika .
- Dinani OK kuti mugwiritse ntchito kusintha ndi kutseka bokosi la bokosi.
Ikani Chitetezo cha Tsamba la Ntchito
- Kabukhu Kakanema ka riboni, dinani pa Format kusankha kutsegula menyu pansi.
- Dinani Pewani Tsambali pamndandanda pansi pa mndandanda kuti mutsegule Bokosi la Mauthenga Otetezera.
- Fufuzani kapena osasintha zomwe mukufuna.
- Dinani OK kuti mugwiritse ntchito kusintha ndi kutseka bokosi.
Panthawiyi, mawonekedwe osankhidwa ayenera kubisika kuwona mu bar. Mpaka sitepe yachiwiri ikuchitika, mayendedwewo akuwonekabe mu selo lopangira ntchito komanso mu bar.