Momwe mungachotsere kusanja mu Excel mukasunga

Mu Microsoft Office Excel, mutha kusanja zomwe zili m'matebulo ndi mawonekedwe ena pogwiritsa ntchito zida zomwe zili mu pulogalamuyi. Nkhaniyi ifotokoza momwe mungasinthire kusanja musanasunge kapena kusunga chikalatacho.

Momwe mungasinthire tebulo mu Excel

Kuti mubweretse mndandanda wa tebulo ku mawonekedwe omwe amafunidwa kwa wogwiritsa ntchito, komanso osasinthanso zomwe zili m'mizere pamanja, muyenera kuchita izi:

1. Sankhani tebulo lonse kapena gawo lake: mzere, mzere, magulu enaake. Kuti musankhe zinthu za mbale, gwirani kiyi yakumanzere ya chowongolera ndikuchikokera komwe mwatchulidwa.

2. Dinani pa liwu loti "Kunyumba" pazida zapamwamba za Microsoft Office Excel ndipo phunzirani mosamala mawonekedwe agawo la zosankha zomwe zimatsegulidwa.
3. Pamapeto pa mndandanda, pezani tabu ya "Sort and Selter" ndikudina ndi LMB. Tabu idzatsegulidwa ngati menyu yaying'ono.

4. Sankhani imodzi mwazosankha zosankhidwa kuti musanthule deta patebulo. Apa mutha kusanja motsatira zilembo kapena mobweza mobweza.

5. Onani zotsatira. Pambuyo pofotokoza chimodzi mwazosankha, tebulo kapena gawo lake losankhidwa lidzasintha, deta idzasankhidwa molingana ndi khalidwe linalake lotchulidwa ndi wogwiritsa ntchito.

Tcherani khutu! Mukhozanso kusankha Custom Sort. Pachifukwa ichi, wogwiritsa ntchitoyo adzatha kusanja magawo a tebulo mu dongosolo lokwera, ndi deti, ndi font, ndi mizati ingapo, mizere, kapena kupanga masanjidwe amphamvu.

Momwe mungasinthire kusanja mukamagwira ntchito ndi chikalata

Ngati wogwiritsa ntchito, akugwira ntchito mu chikalata cha Excel, adasankha mwangozi deta ya tebulo, ndiye kuti asinthe zochita zake, ayenera kuchita izi:

1. Tsekani zenera losankha.
2. Chotsani kusankha ma cell onse. Pachifukwa ichi, muyenera dinani batani lakumanzere la mbewa pa malo aulere a tsamba la ntchito kunja kwa mbale.
3. Dinani chizindikiro cha "Letsani", chomwe chikuwoneka ngati muvi kumanzere ndipo chili pafupi ndi batani la "Fayilo" pakona yakumanzere kwa chinsalu.

4. Onetsetsani kuti zochita mu chikalatacho zibwerera mmbuyo sitepe imodzi. Iwo. mitundu yosiyanasiyana ya ma cell iyenera kusankhidwa. Ntchito yokonzanso imakupatsani mwayi wochotsa zomwe zidachitika komaliza.
5. Mutha kusinthanso ntchito yomaliza mu Microsoft Office Excel pogwiritsa ntchito mabatani ophatikizira pa kiyibodi yapakompyuta. Pazifukwa izi, wogwiritsa ntchito ayenera kusinthana ndi masanjidwe a Chingerezi ndikugwirizira makiyi a "Ctrl + Z".

Zina Zowonjezera! Ntchito yokonzanso pogwiritsa ntchito kuphatikiza "Ctrl + Z" imagwira ntchito mu osintha onse a Microsoft Office, mosasamala kanthu za mtundu wawo.

Momwe mungasinthire kusanja mukasunga chikalata cha Excel

Ntchito ya Excel ikasungidwa ndipo wogwiritsa ntchito atseka chikalatacho, zonse zomwe zili pa clipboard zimachotsedwa zokha. Izi zikutanthauza kuti batani la "Kuletsa" silidzagwira ntchito nthawi ina mukadzayendetsa fayilo, ndipo simungathe kuchotsa kusanja kwa tebulo motere. Munthawi imeneyi, akatswiri odziwa zambiri amalangiza kuti atenge njira zingapo zosavuta malinga ndi algorithm:

1. Yambitsani fayilo ya Excel, onetsetsani kuti ntchito yapitayi yasungidwa ndikuwonetsedwa patsamba lantchito.
2. Dinani batani lakumanja la mbewa pa dzina la gawo loyamba m'mbale.
3. Pazenera lachidziwitso, dinani mzere "Ikani". Pambuyo pakuchita koteroko, gawo lothandizira lidzapangidwa patebulo.
4. Mumzere uliwonse wa gawo lothandizira, muyenera kufotokoza nambala ya serial pamizere yotsatira. Mwachitsanzo, kuyambira 1 mpaka 5, kutengera kuchuluka kwa maselo.

5. Tsopano tifunika kusanja deta mu mndandanda wa tebulo m'njira iliyonse yabwino. Momwe mungachitire izi zidafotokozedwa pamwambapa.
6. Sungani chikalatacho ndikutseka.

7. Yambitsaninso fayilo ya Microsoft Office Excel ndikusankha gawo lothandizira pokwera poyisankha ndikusankha njira yoyenera pamndandanda womwe uli patsamba la Sungani ndi Sefa.
8. Chotsatira chake, tebulo lonse liyenera kusanjidwa ngati gawo lothandizira, mwachitsanzo, kutenga mawonekedwe oyambirira.
9. Tsopano mutha kufufuta ndime yoyamba kuti musasokonezeke ndikusunga chikalatacho.

Zofunika! Mutha kuwerengera gawo lothandizira polemba mtengowo mu selo lake loyamba ndikulikulitsa mpaka kumapeto kwa gululo.

Muthanso kusanja zomwe zili patebulo la Excel pamanja powerengera zina, kusintha zomwe zili mumizere ndi mizere pakati pawo. Komabe, njirayi imatenga nthawi yambiri kwa wogwiritsa ntchito. Ndikosavuta kugwiritsa ntchito chida chopangidwa mu pulogalamu yopangidwa kuti amalize ntchitoyi. Kuphatikiza apo, magawo omwe amafunidwa amatha kusanjidwa ndi mtundu ndi kukula kwa selo.

Kutsiliza

Chifukwa chake, kusanja mu Microsoft Office Excel kumachitika munthawi yochepa kwambiri ndi njira zosavuta. Kuti mulepheretse izi mutasunga chikalatacho, muyenera kupanga gawo lina lothandizira pamndandanda wa tebulo, ndikuwerengera, kenako kuyisintha mokwera. Tsatanetsatane wa algorithm yaperekedwa pamwambapa.