Matebulo mu Microsoft Excel

Payokha, pepala la Excel ndi kale tebulo lalikulu lopangidwa kuti lisunge zambiri zamitundu yosiyanasiyana. Kuphatikiza apo, Microsoft Excel imapereka chida chapamwamba kwambiri chomwe chimatembenuza ma cell angapo kukhala tebulo "lovomerezeka", imathandizira kwambiri kugwira ntchito ndi data, ndikuwonjezera zopindulitsa zambiri. Phunziroli lifotokoza zoyambira zogwirira ntchito ndi spreadsheets mu Excel.

Mukalowetsa deta papepala, mungafune kuisintha patebulo. Poyerekeza ndi masanjidwe anthawi zonse, matebulo amatha kuwongolera mawonekedwe a bukhu lonse, komanso kuthandizira kukonza deta ndikufewetsa kachitidwe kake. Excel ili ndi zida ndi masitayelo angapo okuthandizani kupanga matebulo mwachangu komanso mosavuta. Tiyeni tionepo.

Lingaliro lenileni la "tebulo mu Excel" lingatanthauzidwe m'njira zosiyanasiyana. Anthu ambiri amaganiza kuti tebulo ndi mawonekedwe opangidwa ndi maselo papepala, ndipo sanamvepo za china chake chogwira ntchito. Matebulo omwe akukambidwa m'phunziroli nthawi zina amatchedwa matebulo "anzeru" chifukwa cha magwiridwe antchito komanso magwiridwe antchito.

Momwe mungapangire tebulo mu Excel

1. Sankhani maselo omwe mukufuna kusintha kukhala tebulo. Kwa ife, tidzasankha mitundu yosiyanasiyana ya maselo A1: D7.
2. Pa Advanced tabu Kunyumba mu command group masitaelo press command Pangani ngati tebulo.
3. Sankhani kalembedwe katebulo kuchokera pa menyu yotsitsa.
4. Bokosi la zokambirana lidzawoneka momwe Excel imakonza mndandanda wa tebulo lamtsogolo.
5. Ngati ili ndi mitu, ikani njira Tebulo yokhala ndi mitundiye akanikizire OK.
6. Maselo osiyanasiyana adzasinthidwa kukhala tebulo mumayendedwe osankhidwa.

Mwachikhazikitso, matebulo onse mu Excel amakhala ndi zosefera, mwachitsanzo, Mutha kusefa kapena kusanja deta nthawi iliyonse pogwiritsa ntchito mabatani amivi pamitu yazagawo. Kuti mumve zambiri za kusanja ndi kusefa mu Excel, onani Kugwira Ntchito ndi Data mu Maphunziro a Excel 2013.

Kusintha matebulo mu Excel

Powonjezera tebulo papepala, mukhoza kusintha maonekedwe ake nthawi zonse. Excel ili ndi zida zambiri zosinthira matebulo, kuphatikiza kuwonjezera mizere kapena mizati, kusintha masitayilo, ndi zina zambiri.

Kuwonjezera mizere ndi mizati

Kuti muwonjezere zambiri patebulo la Excel, muyenera kusintha kukula kwake, mwachitsanzo, onjezani mizere kapena mizere yatsopano. Pali njira ziwiri zosavuta zochitira izi:

• Yambani kulowetsa deta mumzere wopanda kanthu (gawo) moyandikana ndi tebulo ili m'munsimu (kumanja). Pamenepa, mzere kapena chigawocho chidzaphatikizidwa patebulo.
• Kokani m'munsi kumanja kwa tebulo kuti muphatikizepo mizere kapena mizati yowonjezera.

Kusintha masitayelo

1. Sankhani selo lililonse patebulo.
2. Kenako tsegulani tabu Constructor ndikupeza gulu lolamula Masitayilo a tebulo. Dinani pa chithunzi Zosankha zinakuti muwone masitayilo onse omwe alipo.
3. Sankhani masitayilo omwe mukufuna.
4. Ndondomekoyi idzagwiritsidwa ntchito patebulo.

Sinthani zosintha

Mutha kuloleza ndikuletsa zina mwazosankha pa tabu Constructorkusintha maonekedwe a tebulo. Pali zosankha 7 zonse: Mzere Wapamutu, Mzere Wonse, Mizere Yamizere, Mzere Woyamba, Mzere Womaliza, Mizere Yamizere ndi Batani Losefera.

1. Sankhani selo lililonse patebulo.
2. Pa Advanced tabu Constructor mu command group Zosankha zamtundu wa tebulo yang'anani kapena chotsani zomwe mukufuna. Tithandizira kusankha Mzere wonsekuwonjezera mzere wonse patebulo.
3. Gome lidzasintha. Kwa ife, mzere watsopano udawonekera pansi pa tebulo ndi chilinganizo chomwe chimawerengera zokha kuchuluka kwa zomwe zili mugawo la D.

Zosankha izi zimatha kusintha mawonekedwe a tebulo m'njira zosiyanasiyana, zonse zimadalira zomwe zili. Muyenera kuyesa pang'ono ndi zosankha izi kuti muwone momwe mukufunira.

Kuchotsa tebulo mu Excel

Pakapita nthawi, kufunikira kwa magwiridwe antchito a tebulo kumatha kutha. Pachifukwa ichi, ndi bwino kuchotsa tebulo mu bukhu la ntchito, ndikusunga deta yonse ndi zinthu zofooketsa.

1. Sankhani selo lililonse patebulo ndikupita ku tabu Constructor.
2. Mu gulu lolamula Service sankhani timu Sinthani kukhala osiyanasiyana.
3. Bokosi lotsimikizira lidzawonekera. Dinani inde .
4. Gome lidzasinthidwa kukhala lanthawi zonse, komabe, deta ndi masanjidwe zidzasungidwa.