Kusintha kwachikhalidwe pamwambapa / pansipa Miyeso

Zosankha za mtundu wa Excel zovomerezeka zimakulolani kuti mugwiritse ntchito njira zosiyana siyana monga maonekedwe a m'mbuyo, malire, kapena maonekedwe a ma foni ku deta yomwe ili ndi zikhalidwe zina. Mwachitsanzo, masiku angapo amatha kufotokozedwa kuti awonekere ndi chiyambi chofiira kapena mtundu wobiriwira.

Maonekedwe ovomerezeka amagwiritsidwa ntchito kwa maselo amodzi kapena angapo, ndipo pamene deta mu maselowa imakumana ndi chikhalidwe kapena zinthu zomwe zafotokozedwa, mawonekedwe osankhidwa akugwiritsidwa ntchito. Kuyambira ndi Excel 2007 , Excel ili ndi njira zingapo zomwe zisanayambe kusinthidwa zomwe zimapangitsa kuti zikhale zosavuta kugwiritsira ntchito zizolowezi zomwe zimagwiritsidwa ntchito nthawi zambiri. Zosankhazi zisanachitikezi zikuphatikizapo kupeza manambala omwe ali pamwamba kapena pansi pa mtengo wapadera wa deta.

Kupeza Pamwamba Pa Miyoyo Yomwe Ili ndi Maonekedwe Okhazikika

Chitsanzo ichi chikutsatira ndondomeko zomwe mungatsatire kuti mupeze manambala omwe ali pamwamba pa mausankhidwe osiyanasiyana. Miyendo yomweyoyi ingagwiritsidwe ntchito kupeza zotsatira zapafupi.

Maphunziro Otsogolera

1. Lowani deta zotsatirazi mu maselo A1 mpaka A7:
   1. 8, 12, 16, 13, 17, 15, 24
2. Sungani maselo A1 ku A7
3. Dinani pa tsamba la Pakiti
4. Dinani pajambula Yopanga Maonekedwe Pachibvundi kuti mutsegule menyu
5. Sankhani Pamwamba / Malamulo Otsatira> Pamwamba Pa Avereji ... kutsegula mafotokozedwe ofotokoza malemba
6. Bokosi la bokosili lili ndi mndandanda wa zolemba zomwe zisanachitike zomwe zingagwiritsidwe ntchito pa maselo osankhidwa
7. Dinani pamsana wotsika kumbali yakanja ya mndandanda wotsegula
8. Sankhani zojambula zosankhidwa pa deta - chitsanzo ichi chikugwiritsa ntchito Kuwala Kuwala Kuwala ndi Mdima Wofiira
9. Ngati simukukonda zosankha zanu zisanachitike, gwiritsani ntchito mtundu wa Custom Format pansi pa mndandanda kusankha zosankha zanu zokhazokha
10. Mutasankha mtundu wosankha, dinani Kulungani kuti muvomereze kusintha ndikubwezereni pa tsamba
11. Maselo A3, A5, ndi A7 mu ofesi ya ntchito ayenera tsopano kukonzedwa ndi zosankhidwa zosankhidwa
12. Chiwerengero cha mtengo wa deta ndi 15 , choncho, nambala yokha mu maselo atatuwa ali ndi manambala omwe ali pamwambapa

Kulemba Kulemba sikunagwiritsidwe ntchito pa selo A6 chiwerengero cha selo chiri chofanana ndi mtengo wapatali osati pamwamba pake.

Kupeza Pansi pa Miyeso Yopangidwe ndi Mafomu Okhazikika

Kuti mupeze manambala omwe ali m'munsimu, pa gawo lachisanu ndi chimodzi mwazomwe mwasankha, sankhani Zolemba Pansipa .

Zolemba Zowonjezera Zowonjezera