Momwe Mungasinthire Mizati mu Excel - Njira 3 Zokulunga Mzere mu Excel

Ogwiritsa ntchito omwe amagwira ntchito ndi ma spreadsheets mu Excel angafunikire kusinthana ndime kapena, mwa kuyankhula kwina, kukulunga gawo lakumanzere. Komabe, si aliyense amene azitha kuyenda mwachangu ndikuchita izi. Chifukwa chake, pansipa tikuwonetsani njira zitatu zomwe zimakupatsani mwayi wochitira izi, kuti mutha kusankha yabwino komanso yabwino kwa inu.

Sunthani mizati mu Excel ndi Copy and Paste

Njirayi ndiyosavuta ndipo imakhala ndi njira zomwe zimaphatikizapo kugwiritsa ntchito ntchito zophatikizika mu Excel.

1. Choyamba, muyenera kusankha selo la mzati, kumanzere komwe gawo lomwe lidzasunthidwe lidzakhalapo mtsogolo. Sankhani pogwiritsa ntchito batani lakumanja la mbewa. Pambuyo pake, zenera la pop-up la menyu ya pulogalamu lidzawonekera patsogolo panu. Momwemo, pogwiritsa ntchito cholozera cha mbewa, sankhani chinthucho "Ikani" ndikudina.
   

   

2. Mu bokosi la zokambirana lomwe likuwonekera, muyenera kufotokozera magawo a maselo omwe adzawonjezedwa. Kuti muchite izi, sankhani gawo lomwe lili ndi dzina la "Column" ndikudina batani "Chabwino".
   

   

3. Ndi masitepe omwe ali pamwambawa, mwapanga ndime yatsopano yopanda kanthu momwe deta idzasunthidwa.
4. Chotsatira ndikukopera ndime yomwe ilipo ndi zomwe zilimo muzatsopano zomwe mudapanga. Kuti muchite izi, sunthani cholozera cha mbewa ku dzina lagawo lomwe lilipo ndikudina batani lakumanja la mbewa. Dzina la mzati lili pamwamba kwambiri pa zenera la pulogalamuyo. Pambuyo pake, zenera la pop-up lidzawonekera patsogolo panu. Mmenemo, muyenera kusankha chinthucho ndi dzina lakuti "Copy".
   

   

5. Tsopano sunthani cholozera cha mbewa ku dzina la gawo lomwe mudapanga, chidziwitso chidzalowamo. Sankhani gawo ili ndikudina batani lakumanja la mbewa. Ndiye pulogalamu yatsopano menyu pop-up zenera adzaoneka pamaso panu. Mu menyuyi, pezani gawo lotchedwa "Matanidwe Mungasankhe" ndikudina chizindikiro chakumanzere, chomwe chili ndi dzina "Matani".
   

   

   Tcherani khutu! Ngati ndime yomwe mumasamutsirako ili ndi ma cell okhala ndi ma formula, ndipo muyenera kusamutsa zotsatira zomwe zakonzedwa kale, m'malo mwa chithunzi chomwe chili ndi dzina loti "Ikani", sankhani chomwe chili pafupi ndi "Ikani mtengo".

   

6. Izi zimamaliza ndondomeko yosinthira ndime bwino. Komabe, panalibe kufunikira kochotsa ndime yomwe chidziwitsocho chinasamutsidwa kuti tebulo lisakhale ndi deta yofanana m'zaza zingapo.
7. Kuti muchite izi, muyenera kusuntha cholozera cha mbewa ku dzina la ndimeyi ndikusankha podina batani lakumanja la mbewa. Pazenera lomwe limatsegulira, sankhani chinthucho "Chotsani". Ili linali gawo lomaliza la opareshoni, chifukwa chake mudamaliza ntchito yomwe mukufuna.
   

   

Sungani zipilala mu Excel pogwiritsa ntchito ntchito zodula ndi kumata

Ngati pazifukwa zina njira yomwe ili pamwambayi inkawoneka ngati ikuwonongerani nthawi, ndiye kuti mungagwiritse ntchito njira yotsatirayi, yomwe ili ndi masitepe ochepa. Zimaphatikizapo kugwiritsa ntchito kudula ndi kumata ntchito zophatikizidwa mu pulogalamuyi.

1. Kuti muchite izi, sunthani cholozera cha mbewa ku dzina la ndime yomwe mukufuna kusuntha deta ndikudina kumanja pa dzina lake. A menyu pop-up zenera adzaoneka pamaso panu. Mu menyu iyi, sankhani chinthucho "Dulani".
   

   

   Upangiri! Mukhozanso kusuntha cholozera cha mbewa ku dzina la gawoli ndiyeno, mutasankha, dinani batani lakumanzere. Pambuyo pake, dinani batani lotchedwa "Dulani", lomwe lili ndi chithunzi chokhala ndi chithunzi cha lumo.

2. Kenako sunthani cholozera cha mbewa ku dzina la gawo lomwe mukufuna kuyika lomwe lilipo kale. Dinani kumanja pa dzina la gawoli ndi menyu yowonekera yomwe ikuwonekera, sankhani chinthucho "Ikani Maselo Odula". Pa izi, ndondomeko yofunikira ikhoza kuganiziridwa bwino.
   

   

Ndikoyeneranso kudziwa kuti njira ziwiri zomwe takambiranazi zimakulolani kusuntha mizati ingapo nthawi imodzi, osati imodzi yokha.

Kusuntha mizati mu Excel pogwiritsa ntchito mbewa

Njira yomaliza ndiyo njira yachangu kwambiri yosunthira mizati. Komabe, monga momwe ndemanga zapaintaneti zimasonyezera, njirayi si yotchuka kwambiri pakati pa ogwiritsa ntchito Excel. Izi zimachitika chifukwa chakuti kukhazikitsidwa kwake kumafuna luso lamanja komanso kulamulira bwino kwa luso logwiritsa ntchito kiyibodi ndi mbewa. Kotero, tiyeni tipitirire ku kulingalira kwa njira iyi:

1. Kuti muchite izi, muyenera kusuntha cholozera cha mbewa ku gawo lomwe lasamutsidwa ndikusankha kwathunthu.
   

   

2. Kenako yang'anani malire kumanja kapena kumanzere kwa selo iliyonse mugawoli. Pambuyo pake, cholozera cha mbewa chidzasintha kukhala mtanda wakuda ndi mivi. Tsopano, mukugwira fungulo la "Shift" pa kiyibodi, ndikugwirizira batani lakumanzere la mbewa, kokerani ndimeyi pamalo patebulo pomwe mukufuna kuti ikhale.
   

   

3. Mukasamutsa, mudzawona mzere wobiriwira wobiriwira womwe umakhala ngati kulekanitsa ndikuwonetsa komwe chigawocho chingalowetsedwe. Mzerewu umagwira ntchito ngati chiwongolero.
   

   

4. Chifukwa chake, pamene mzerewu ukugwirizana ndi malo omwe muyenera kusuntha ndime, muyenera kumasula kiyi yomwe ili pa kiyibodi ndi batani pa mbewa.
   

   

Zofunika! Njirayi siyingagwiritsidwe ntchito kumitundu ina ya Excel yomwe idatulutsidwa isanafike 2007. Chifukwa chake, ngati mukugwiritsa ntchito mtundu wakale, sinthani pulogalamuyo kapena gwiritsani ntchito njira ziwiri zam'mbuyomu.

Kutsiliza

Pomaliza, ziyenera kudziwidwa kuti popeza mwazolowera njira zitatu zopangira ndime mu Excel, mutha kusankha yabwino kwambiri kwa inu.