Chotsani maselo opanda kanthu mu Microsoft Excel

Mukamagwira ntchito mu Excel, zingakhale zofunikira kuchotsa maselo opanda kanthu. Nthaŵi zambiri zimakhala zosafunikira ndipo zimangowonjezera chiwerengero chonse cha deta, osati kusokoneza wogwiritsa ntchito. Timafotokoza njira zothetsera zinthu zopanda kanthu msanga.

Kuchotsa machitidwe

Choyamba, muyenera kumvetsetsa, ndipo kodi n'zotheka kuchotsa maselo opanda kanthu padera kapena tebulo? Njirayi imatsogolera ku deta, ndipo izi sizinali zoyenera nthawi zonse. Ndipotu, zinthu zikhoza kuchotsedwa pazigawo ziwiri zokha:

• Ngati mzere (mzere) ulibe kanthu (mu magome);
• Ngati maselo omwe ali mumzere ndi mzerewo ali osagwirizanirana wina ndi mzake (muzokambirana).

Ngati pali maselo osowa kanthu, akhoza kuchotsedwa mosavuta pogwiritsira ntchito njira yochotsera njira. Koma, ngati pali zifukwa zambiri zosakwanira, ndiye kuti izi ziyenera kukhala zodziwika.

Njira 1: Sankhani Magulu a Magulu

Njira yosavuta yochotsera zinthu zopanda kanthu ndiyo kugwiritsa ntchito chida chosankhira gulu.

1. Sankhani zolemba pa pepala, zomwe tidzayesa kufufuza ndi kuchotsa zinthu zopanda kanthu. Timakanikiza pa fungulo la ntchito pa makiyi F5.



2. Amathamangitsira zenera laling'ono lotchedwa "Kusintha". Timakanikiza batani mmenemo "Konzani ...".



3. Mawindo otsatirawa akuyamba - "Kusankha magulu a maselo". Ikani kasinthasintha pamalo "Maselo opanda kanthu". Dinani pa batani. "Chabwino".



4. Monga momwe mukuonera, zinthu zonse zopanda kanthu zadasankhidwa zinasankhidwa. Dinani pa aliyense wa iwo ndi batani labwino la mouse. Muzondomeko zomwe zakhala zikuyambidwa, dinani pa chinthucho "Chotsani ...".



5. Fasilo yaying'ono imatsegulidwa kumene muyenera kusankha chomwe chingachotsedwe. Siyani zosintha zosasinthika - "Maselo, ndi kusintha kwake". Timakanikiza batani "Chabwino".

Zitatha izi, zinthu zonse zopanda kanthu mkati mwazitalizo zidzachotsedwa.

Njira 2: Kupanga Maonekedwe ndi Kusinkhasinkha

Mukhozanso kutulutsa maselo opanda kanthu pogwiritsa ntchito maonekedwe oyenera ndikusintha deta. Njirayi ndi yovuta kwambiri kuposa yoyamba, koma, komabe, ena amagwiritsa ntchito. Kuonjezerapo, mukufunika kupanga mwatsatanetsatane kuti njirayi ndi yoyenera kokha ngati zikhulupiliro ziri mu gawo limodzi ndipo ziribe fomu.

1. Sankhani mtundu umene tikukambirana. Kukhala mu tab "Kunyumba"dinani pazithunzi "Mafomu Okhazikika"zomwe, zowonjezera, ziri mu bokosi la zida "Masitala". Pitani ku chinthucho m'ndandanda yomwe imatsegulidwa. "Malamulo a kusankha kusankhidwa". Mundandanda wa zochita zomwe zikuwonekera, sankhani malo. "Zambiri ...".



2. Zenera zowonetsera zovomerezeka zimatsegula. Lowani nambala kumbali yakumanzere "0". Kumalo abwino, sankhani mtundu uliwonse, koma mukhoza kusiya zosasintha. Dinani pa batani "Chabwino".



3. Monga mukuonera, maselo onse omwe alipo, omwe amatsatira, adasankhidwa mu mtundu wosankhidwa, pamene zopanda kanthu zinakhala zoyera. Apanso timasankha wathu. M'mabuku omwewo "Kunyumba" dinani pa batani "Sankhani ndi kusefera"ili mu gulu Kusintha. Mu menyu yomwe imatsegula, dinani pa batani "Fyuluta".



4. Zitatha izi, monga momwe tingathe kuwonera, chizindikiro choyimira fyuluta chimaoneka pamwamba pa gawolo. Dinani pa izo. M'ndandanda yotsegulidwa, pitani ku chinthu "Sungani ndi mtundu". Kenako mu gululo "Sankhani ndi mtundu wa selo" sankhani mtundu umene unasankhidwa chifukwa cha maonekedwe ovomerezeka.

   

   Mukhozanso kuchita pang'ono mosiyana. Dinani pa chithunzi cha fyuluta. Mu menyu yomwe ikuwonekera, chotsani chitsimikizo kuchokera pa malo "Sungani". Pambuyo pake dinani pa batani "Chabwino".



5. Mulimonse mwazinthu zomwe tawonera m'ndime yapitayi, zida zopanda kanthu zidzabisika. Sankhani mtundu wa maselo otsalirawo. Tab "Kunyumba" mu bokosi lokhalamo "Zokongoletsera" dinani pa batani "Kopani".



6. Kenaka sankhani malo opanda kanthu pamodzi kapena pa pepala losiyana. Chitani chofufumitsa. Mundandanda wazinthu zomwe mwaziika muzowonjezera magawo, sankhani chinthucho "Makhalidwe".



7. Monga mukuonera, panali kulembedwa kwa deta popanda kupanga maonekedwe. Tsopano mukhoza kuchotsa mtundu waukulu, ndipo m'malo mwake muikepo zomwe tinalandira panthawiyi, ndipo mukhoza kupitiriza kugwira ntchito ndi deta m'malo atsopano. Zonse zimadalira ntchito yeniyeni ndi zofunikira za munthu wogwiritsa ntchito.

Phunziro: Mafomu omvera mu Excel

Phunziro: Sakanizani ndi kusinkhira deta mu Excel

Njira 3: Gwiritsani ntchito njira yovuta

Kuwonjezera pamenepo, mukhoza kuchotsa maselo opanda kanthu pamagulu pogwiritsa ntchito njira yovuta yomwe ili ndi ntchito zingapo.

1. Choyamba, tifunikira kupereka dzina kumasintha omwe akusinthidwa. Sankhani dera lanu, dinani pomwepo pa mouse. Mu menyu yoyanjidwa, sankhani chinthucho "Lembani dzina ...".



2. Mawindo otsegula amatsegula. Kumunda "Dzina" Timapatsa dzina lililonse labwino. Chikhalidwe chachikulu ndi chakuti pasakhale malo okhalamo. Mwachitsanzo, tapatsa dzina kumtunduwu. "Sungani". Sipanso kusintha pawindo limenelo. Timakanikiza batani "Chabwino".



3. Sankhani kulikonse pa pepala chimodzimodzi kukula kwa maselo opanda kanthu. Mofananamo, timakanikiza ndi batani labwino la mbewa ndipo, poyitanitsa mndandanda wazomwekugwiritsiridwa ntchito, pendani muyeso "Lembani dzina ...".



4. Pawindo lomwe limatsegulira, monga kale, timapatsa dzina lililonse kuderali. Tinaganiza zomupatsa dzina. "Popanda_panda kanthu".



5. Dinani kawiri pa batani lakumanja lamanzere kuti musankhe selo yoyamba ya mndandanda wazinthu. "Popanda_panda kanthu" (mukhoza kuitcha mosiyana). Tikaikapo mndandanda wa mtundu wotsatirawu:

   = IF (STRING () - STRING (Sungani) +1)> BLOCKS (Blank) - SANKANI MAFUNSO (Osasamala); (C_nthu))); LINE () - LINE (Popanda_blank) +1); COLUMN (C_blank); 4)))

   Popeza ichi ndi ndondomeko yambiri, kuti mupeze mawerengedwe pawindo, muyenera kusindikiza kuphatikiza Ctrl + Shift + Lowanimmalo mongofuna batani Lowani.



6. Koma, monga tikuonera, selo imodzi yokha idadzazidwa. Kuti mudzaze zonsezo, mukuyenera kufotokozera ndondomekoyi yonseyi. Izi zingatheke ndi chizindikiro chodzaza. Ikani cholozera kumbali ya kumanja ya selo yomwe ili ndi ntchito yovuta. Chotsegulacho chiyenera kutembenuzidwa ku mtanda. Gwiritsani batani lamanzere pansi ndikukankhira mpaka kumapeto kwake. "Popanda_panda kanthu".



7. Monga mukuonera, patatha izi timakhala ndi mazere omwe maselo odzaza ali mzere. Koma sitidzatha kuchita zosiyana siyana ndi deta iyi, popeza ikugwirizana ndi ndondomeko yambiri. Sankhani lonseli "Popanda_panda kanthu". Timakanikiza batani "Kopani"yomwe imayikidwa pa tab "Kunyumba" mu chigawo cha zipangizo "Zokongoletsera".



8. Pambuyo pake, sankhani deta yapachiyambi. Dinani botani lamanja la mouse. Mndandanda umene umatsegulidwa pagulu "Njira Zowonjezera" dinani pazithunzi "Makhalidwe".



9. Zitatha izi, deta idzalowetsedwa kumalo oyambirira a malo akenthu popanda maselo opanda kanthu. Ngati mukufuna, ndondomeko yomwe ili ndi ndondomeko ikhoza kuchotsedwa tsopano.

Phunziro: Momwe mungapezere dzina la selo ku Excel

Pali njira zambiri zochotsera zinthu zopanda kanthu mu Microsoft Excel. Kusiyanasiyana ndi kugawa kwa magulu a maselo ndikosavuta komanso mofulumira. Koma zosiyana ndizo. Choncho, monga njira zina, mungagwiritse ntchito zosankha ndi kusefera ndikugwiritsa ntchito njira yovuta.