Madera ozizira mu Microsoft Excel

Momwe mungasinthire mzere, mzere kapena dera mu Excel? ndi funso lofala lomwe ogwiritsa ntchito novice amafunsa akayamba kugwira ntchito ndi matebulo akuluakulu. Excel ili ndi zida zingapo zochitira izi. Muphunzira zida zonsezi powerenga phunziro ili mpaka kumapeto.

Pogwira ntchito ndi data yambiri, zimakhala zovuta kugwirizanitsa zomwe zili mubuku la ntchito. Komabe, Excel ili ndi zida zingapo zomwe zimapangitsa kuti zikhale zosavuta kuwona zomwe zili m'magawo osiyanasiyana a bukhu logwirira ntchito nthawi imodzi, monga ma pining mapanelo ndi mazenera ong'ambika.

Sungani mizere mu Excel

Nthawi zina mungafune kuwona madera ena patsamba lanu la Excel nthawi zonse, makamaka mitu. Mwa kukanikiza mizere kapena mizati, mudzatha kupyola muzomwe zili, pamene maselo osindikizidwa adzakhalabe akuwoneka.

1. Onetsani mzere womwe uli pansipa womwe mukufuna kuusindikiza. Mu chitsanzo chathu, tikufuna kujambula mizere 1 ndi 2, kotero timasankha mzere 3.
2. Dinani View pa tepi.
3. Kankhani lamulo Kukonza madera ndikusankha chinthu cha dzina lomwelo kuchokera pa menyu yotsitsa.
4. Mizere idzakhomedwa, ndipo malo okhomawo adzawonetsedwa ndi mzere wotuwa. Tsopano mutha kusuntha tsamba la Excel, koma mizere yokhonidwa ikhalabe ikuwonekera pamwamba pa pepalalo. M'chitsanzo chathu, tapukuta pepalalo mpaka mzere 18.

Zozizira zozizira mu Excel

1. Sankhani ndime ili kumanja kwa ndime yomwe mukufuna kuyimitsa. Muchitsanzo chathu, tiwumitsa gawo A, kotero tiwunikira gawo B.
2. Dinani View pa tepi.
3. Kankhani lamulo Kukonza madera ndikusankha chinthu cha dzina lomwelo kuchokera pa menyu yotsitsa.
4. Mizatiyo idzatsekedwa ndipo malo osungirako adzawonetsedwa ndi mzere wotuwa. Tsopano mutha kupukuta tsamba la Excel, koma mizati yokhonidwa ikhalabe ikuwonekera kumanzere kwa tsambalo. Mu chitsanzo chathu, tasunthira ku gawo E.

Kuti musamangirire mizere kapena mizati, dinani Kukonza madera, ndiyeno kuchokera ku menyu yotsitsa sankhani Chotsani madera.

Ngati mukufuna kuzizira pamzere wapamwamba (Row1) kapena gawo loyamba (Mzere A), mutha kusankha lamulo loyenera kuchokera pamenyu yotsitsa.