Kusankhidwa kwanthawi yayitali

Njira 1: Kuchepetsa nthawiyo

Nthawi zambiri, wogwiritsa ntchito ayenera kuchepetsa mzerewu pa Excel, kotero tiyeni tiyambire njirayi. Zolemba zoterezi zimachitika chifukwa cha kuyika kolakwika kapena kusinthidwa kokha, koma kumakonzedwa mwachangu - muyenera kuyambitsa gawo limodzi lokha.

1. Pezani foni yomwe mukufuna kuti muchepetse mzerewo, ndikudina batani la mbewa.



2. Mu menyu wamba, dinani pa "Fomu Yanu".



3. Muzenera latsopano, pitani ku ma tabu ndi kukulitsa menyu yolunjika.



4. Khazikitsani mtengo wake "pamwamba pamphepete" ndikutseka menyu.



5. Bweretsani pagome ndikuyang'ana kulondola kwa nthawi yayitali.



6. Tsopano mutha kucheperanso nkhani zaposachedwa, chifukwa malembawo amatenga malo ochepera.

Njira yachiwiri: Onjezani nthawi yayitali

Kuwonjezeka kwa gawo la seweroli kumafunikira pakachitika komwe wosuta amafunikira kutambasulira kukula kwathunthu kwa chipikacho. Pachifukwa ichi, zosintha zomwezo zimagwiritsidwa ntchito, koma mfundo zina zimasankhidwa.

1. Tsindikani khungu ndikusindikiza PCM pa iyo, kusankha mtundu wa Codem mu Menyu.



2. Pamalo ophatikizika, onjezerani menyu otsika ".



3. Mmenemo, fotokozerani "mobwerezabwereza".



4. Bweretsani pagome kuti muwone momwe lembalo limalembedwera kutalika konse kwa khungu. Ndi kusintha kwake, kutambasula kumasinthidwa mothera.

Njira 3: Zolemba za cell

Njira yomaliza ndi yoyenera kwa ogwiritsa ntchito pofuna kukhazikitsa mwatsatanetsatane ma cell a nthawi yomweyo, lembalo sililumikizidwa patebulo linalo ndipo limakonzedwa momwe mungafunire. Pa izi, zomwe zili mu cell zimalembedwa polemba.

1. Tsindikani khungu lokha ndikudina CTRL + X.



2. Kudutsa gulu lapamwamba, pitani ku "kuyika" tabu ndikuwonjezera "mawu".



3. Ikani zolembedwa posankha chinthu choyenera.



4. Gwirani batani lamanzere la mbewa ndikusintha makona a rectangolar mpaka mtunda wofunikira popanga cholembera mtsogolo.



5. Phward Ctrl + v kuyika zomwe zili patsamba lomwe lidadulidwa kale.



6. Dinani kumanja palemba ndikusankha "ndime".



7. Pezani gawo la "Internal" ndikusintha zomwe zimafunikira chifukwa zimafunikira kwenikweni kwa inu.



8. Kusintha konse kumawonetsedwa nthawi yomweyo patebulopo, ndipo ngati kuli kotheka, atha kuyimitsidwa kudzera pa Ctrl + z.