Lumikizani masitayilo mu Microsoft Excel

Ngati munatsegula Excel ndipo mwadzidzidzi munapeza kuti panali manambala pamitu yazagawo m'malo mwa zilembo zanthawi zonse, musataye mtima ndikuwerenga nkhaniyi mpaka kumapeto! Mu phunziro ili, muphunzira momwe mungasinthire manambala kukhala zilembo m'mizati, komanso dziwani masitaelo a maulalo mu Microsoft Excel.

Kodi link style ndi chiyani?

Tsamba lililonse la Excel limapangidwa ndi mizere ndi mizati. Nthawi zambiri, mizati imasonyezedwa ndi zilembo (A, B, C) ndipo mizere imasonyezedwa ndi manambala (1, 2, 3). Mu Excel amatchedwa njira yolumikizirana A1. Komabe, ena amakonda kugwiritsa ntchito kalembedwe kosiyana, komwe mizati imawerengedwanso. Amatchedwa Mtundu wa R1C1.

Mtundu wa ulalo wa R1C1 utha kukhala wothandiza nthawi zina, koma monga momwe zimasonyezera, izi ndizosowa. Palinso gulu la ogwiritsa ntchito omwe amakonda kugwira ntchito ndi mawonekedwe a ulalo, komabe, salinso atsopano. Nthawi zambiri, mudzagwira ntchito ndi kalembedwe ka ulalo wa A1, womwe umayikidwa mu Microsoft Excel mwachisawawa.

Maphunzirowa komanso pafupifupi maphunziro onse patsamba lino amagwiritsa ntchito ulalo wa A1. Ngati mukugwiritsa ntchito ulalo wa R1C1, muyenera kuyimitsa.

Yambitsani / zimitsani mawonekedwe a ulalo wa R1C1

  1. Dinani file, Kusamukira ku mawonekedwe akumbuyo.Lumikizani masitayilo mu Microsoft Excel
  2. Press magawo.Lumikizani masitayilo mu Microsoft Excel
  3. Mu bokosi la zokambirana lomwe likuwoneka Zosankha za Excel Sankhani gawo chilinganizo. Chongani m'bokosi Mtundu wa R1C1 Ndi kukanikiza OK. Excel idzasinthira ku mawonekedwe a ulalo wa R1C1.Lumikizani masitayilo mu Microsoft Excel

Monga momwe mungaganizire, kuti mubwerere ku kalembedwe ka ulalo wa A1, ndikokwanira kuti musayang'ane bokosi ili.

Siyani Mumakonda