Pezani Duplicate kapena Data Yopadera mu Excel ndi Mafomu Okhazikika

01 ya 01

Kujambula Zomwe Zimapangidwira

Zowonongeka Zopangira Maonekedwe

Kuwonjezera maonekedwe ovomerezeka mu Excel amakulolani kugwiritsa ntchito njira zosiyana siyana zomwe mungapangire maselo kapena maselo osiyanasiyana omwe amakumana ndi zikhalidwe zina zomwe mumayika.

Zosankha zojambula zimagwiritsidwa ntchito pamene maselo osankhidwa amakwaniritsa zinthu izi.

Zokonzekera zomwe mungathe kuzigwiritsa ntchito ndizojambula ndi maonekedwe a mtundu wa m'mbuyo, mafashoni a mazenera, malire a maselo, ndi kuwonjezera chiwerengero cha nambala ku deta.

Kuchokera mu Excel 2007, Excel yakhala ndi njira zingapo zoyenera kukhazikitsa zomwe zingagwiritsidwe ntchito kawirikawiri monga kupeza ziwerengero zazikulu kapena zochepa kuposa mtengo wina kapena kupeza manambala omwe ali pamwamba kapena pansi pa mtengo wapatali .

Pezani Zophatikiza ndi Kujambula Momwe Mungakhalire

Zina zomwe mungakonzekere ndi Excel ndi kupeza ndi kupanga ndondomeko ya deta ndi maonekedwe ovomerezeka - ngati deta yanu ikhale yolemba, manambala, masiku, ma fomu, kapena mizera yonse kapena zolemba .

Maonekedwe ovomerezeka amagwiritsanso ntchito deta yowonjezeredwa pambuyo pa maonekedwe ovomerezeka agwiritsidwa ntchito pazambiri za deta, kotero n'zosavuta kutenga deta yosawerengeka pamene ikuwonjezeredwa pa tsamba.

Chotsani Duplicates Data mu Excel

Ngati cholinga chake ndi kuchotsa deta yosadziwika osati kungoipeza - kaya ndi maselo osakwatira kapena zolemba zonse, m'malo mogwiritsa ntchito maonekedwe oyenera, Excel imapereka njira ina yodziwika, osadabwitsa, monga Chotsani Zophatikiza .

Chida ichi chikhoza kugwiritsidwa ntchito kupeza ndi kuchotsa magawo ena a deta kuchokera pa tsamba.

Pezani Zophatikiza ndi Chithunzi Chokhazikitsa Maonekedwe

M'munsimu muli njira zomwe zimagwiritsidwa ntchito kuti mupeze maselo ofotokozera deta ya E1 mpaka E6 (zobiriwira zobiriwira) zomwe zikuwonetsedwa mu chithunzi pamwambapa.

1. Sungani maselo E1 ku E6 pa tsamba la ntchito.
2. Dinani pa tabu la Home la riboni
3. Dinani pajambula Yokonzera Zokhazikika mu Riboni kuti mutsegule menyu
4. Sankhani Makhalidwe Osewera Mipukutu> Makhalidwe Ofunika ... kuti mutsegule zolemba zomwe zimakonzedweratu
5. Sankhani Zobiriwira Zodzala ndi Mdima Wakuda Wakuda kuchokera pa mndandanda wazomwe mungakonzeke

1. Dinani OK kuti mulandire zosankha ndi kutseka bokosi la dialog
2. Maselo E1, E4, ndi E6 ayenera kupangidwa ndi mtundu wobiriwira wobiriwira ndi mdima wobiriwira popeza zonse zitatu zili ndi deta - mwezi wa January

Pezani Deta Yapadera ndi Kujambula Momwe Mungakhalire

Njira ina yokhala ndi machitidwe ovomerezeka ndi osapezekanso minda ya deta, koma malo apadera - omwe ali ndi deta omwe amapezeka kamodzi kokha m'masankhidwe - monga momwe amasonyezera m'maselo ang'onoang'ono (red formatting) mu chithunzi pamwambapa.

Njirayi ndi yopindulitsa pazochitika zomwe deta ikuyembekezeredwa - monga ngati ogwira ntchito akuyenera kupereka mauthenga kapena mawonekedwe nthawi zonse kapena ophunzira amapereka magawo ambiri - omwe akupezeka pa tsamba. Kupeza minda yapadera kumapangitsa kuti mudziwe ngati zosowa zoterezi zikusowa.

Kuti mupeze malo apaderadera a deta musankhe Njira yapaderadera kuchokera ku maselo ofiira omwe ali: lembani mndandanda monga momwe tawonetsera pa chithunzi pamwambapa.

M'munsimu muli njira zomwe zimagwiritsidwa ntchito kupeza maselo apadera a deta pa F6 mpaka F11 (zofiira zofiira) zomwe zikuwonetsedwa mu chithunzi pamwambapa.

1. Onetsetsani maselo F6 mpaka F11 mu worksheet
2. Dinani pa tabu la Home la riboni
3. Dinani pajambula Yokonzera Zokhazikika mu Riboni kuti mutsegule menyu
4. Sankhani Makhalidwe Osewera Mipukutu> Makhalidwe Ofunika ... kuti mutsegule zolemba zomwe zimakonzedweratu
5. Dinani pamsana wotsika pansi pa maselo ophatikiza omwe ali nawo: njira yotsegula mndandanda wotsika - Kuphindikizira ndi chikhazikitso chosasinthika
6. Sankhani njira yapaderadera m'ndandanda
7. Sankhani Kuwala Kuwala Kuwala ndi Mdima Wakuda Wofiira kuchokera pa mndandanda wazomwe mungakonzeke
8. Dinani OK kuti mulandire zosankha ndi kutseka bokosi la dialog.
9. Maselo E7 ndi E9 ayenera kupangidwa ndi mtundu wofiira wofiira ndi mdima wofiira popeza ndiwo maselo okhawo apadera a deta