Njira 6 Zochotsera Fomula mu Ma cell a Excel

Spreadsheet Excel ili ndi ntchito zambiri zomwe zimakulolani kuti muzigwira ntchito moyenera ndi zidziwitso zambiri komanso mawerengedwe osiyanasiyana. Nthawi zambiri zimachitika kuti wogwiritsa ntchito ayenera kuchotsa chilinganizo chomwe zotsatira zake zidawerengedwa, ndikusiya zonse mu cell. Nkhaniyi ifotokoza njira zingapo zochotsera mafomula m'maselo a spreadsheet a Excel.

Kuchotsa mafomu

Spreadsheet ilibe chida chophatikizika chofufutira. Izi zitha kukhazikitsidwa ndi njira zina. Tiyeni tipende chilichonse mwatsatanetsatane.

Njira 1: Koperani Makhalidwe Pogwiritsa Ntchito Zosankha Zolemba

Njira yoyamba ndiyofulumira komanso yosavuta. Njirayi imakupatsani mwayi wokopera zomwe zili m'gawoli ndikusunthira kumalo ena, popanda mafomu. Malangizo atsatanetsatane ndi awa:

1. Timasankha selo kapena maselo angapo, omwe tidzakopera mtsogolo.

2. Timakanikiza RMB pachinthu chokhazikika chamalo omwe mwasankha. Mndandanda wawung'ono umawonekera, pomwe muyenera kusankha chinthu "Koperani". Njira ina kukopera ndi kugwiritsa ntchito kuphatikiza kiyi "Ctrl + C". Njira yachitatu yokopera mfundo ndikugwiritsa ntchito batani la "Copy" lomwe lili pazida za gawo la "Home".

3. Sankhani selo lomwe tikufuna kuyika zomwe zidakopera kale, dinani pomwepa. Menyu yodziwika bwino imatsegulidwa. Timapeza chipika cha "Paste Options" ndikudina chinthu cha "Values", chomwe chimawoneka ngati chithunzi chokhala ndi chithunzi cha mndandanda wa manambala "123".

4. Okonzeka! Zomwe zidakopedwa popanda ma fomula zidasamutsidwa kumalo osankhidwa atsopano.

Njira 2: Gwiritsani Ntchito Matani Apadera

Pali "Paste Special" yomwe imakuthandizani kukopera zambiri ndikuziyika m'maselo pomwe mukusunga mawonekedwe oyamba. Zomwe zayikidwa sizikhala ndi ma fomula. Malangizo atsatanetsatane ndi awa:

1. Timasankha mitundu yomwe tikufuna kuyiyika pamalo enaake ndikuyikopera pogwiritsa ntchito njira iliyonse yabwino kwa inu.

2. Timasunthira ku selo lomwe tikufuna kuyamba kumata zomwe zakopedwa, dinani pomwepa. Mndandanda wazinthu zazing'ono zatsegulidwa. Timapeza chinthucho "Paste Special" ndikudina pazithunzi zomwe zili kumanja kwa chinthuchi. Muzowonjezera zomwe zikuwonekera, dinani "Makhalidwe ndi Mapangidwe Amtundu".

3. Mwamaliza, ntchito yamalizidwa bwino!

Njira 3: Chotsani Mafomula mu Gulu Lochokera

Kenako, tiyeni tikambirane mmene kuchotsa mafomula mu tebulo loyambirira. Malangizo atsatanetsatane ndi awa:

1. Timakopera ma cell angapo mwanjira iliyonse yomwe ilipo. Mwachitsanzo, kugwiritsa ntchito kiyi kuphatikiza "Ctrl + C".

2. Monga momwe tafotokozera m'mbuyomu, timamata pomwe tikusunga mawonekedwe oyambira mu gawo lina la tsamba logwirira ntchito. Popanda kuchotsa zosankhidwazo, timakoperanso deta.

3. Timapita kugawo lomwe lili kumanzere chakumanzere, dinani RMB. Menyu yodziwika bwino imawonekera, momwe muyenera kusankha chinthu cha "Values".

4. Kudzazidwa kwa ma cell popanda ma formula kudakopera pamalo oyamba. Tsopano mutha kufufutanso matebulo ena onse omwe timafunikira pakukopera. Sankhani zobwereza za tebulo ndi LMB ndikudina pagawo losankhira ndi RMB. Menyu yankhani ikuwoneka, momwe muyenera kudina "Chotsani".

5. Zenera laling'ono "Chotsani maselo" linawonetsedwa pazenera. Apa mutha kusankha zomwe mungachotse. Timayika chinthu pafupi ndi "Line" ndikudina "Chabwino". Mu chitsanzo chathu, palibe maselo omwe ali ndi deta kumanja kwa zosankha, kotero kusankha "Maselo, kusunthira kumanzere" kulinso koyenera.

6. Matebulo obwereza amachotsedwa pamasamba. Takhazikitsa m'malo mwa ma formula ndi zizindikiro zenizeni mu tebulo loyambirira.

Njira 4: Chotsani mafomu osakopera kumalo ena

Ogwiritsa ntchito ena a Excel spreadsheet sangakhale okhutitsidwa ndi njira yapitayi, chifukwa imaphatikizapo zosokoneza zambiri zomwe mungasokonezeke. Palinso kusintha kwina kochotsa mafomu patebulo loyambirira, koma kumafunikira chisamaliro kwa wogwiritsa ntchito, popeza zochita zonse zidzachitidwa patebulo lokha. Ndikofunika kuchita zonse mosamala kuti musachotse mwangozi zofunikira kapena "kusaphwanya" dongosolo la data. Malangizo atsatanetsatane ndi awa:

1. Poyambirira, monga m'njira zam'mbuyomu, timasankha malo omwe muyenera kufufuta mafomu ndi njira iliyonse yabwino kwa inu. Kenako, timatengera zikhalidwe mu imodzi mwa njira zitatu.

2. Popanda kuchotsa zomwe zasankhidwa, dinani pagawo la RMB. Menyu yachidziwitso ikuwoneka. Mu "Paste Options" lamulo block, sankhani chinthu cha "Values".

3. Okonzeka! Chifukwa cha zosinthika zomwe zidachitika patebulo loyambirira, mafomuwa adasinthidwa ndi mawerengedwe apadera.

Njira 5: Ikani Macro

Njira yotsatira ikuphatikiza kugwiritsa ntchito ma macros. Musanayambe deleting formulas pa tebulo ndi m'malo ndi makhalidwe enieni, muyenera athe "Madivelopa mumalowedwe". Poyamba, njirayi imayimitsidwa mu purosesa ya spreadsheet. Malangizo atsatanetsatane oyambitsa "Developer Mode":

1. Dinani pa "Fayilo" tabu, yomwe ili pamwamba pa mawonekedwe a pulogalamuyi.

2. Zenera latsopano latsegulidwa, momwe mndandanda wakumanzere wa zinthu muyenera kupita pansi ndikudina "Parameters".

3. Zokonda zikuwonetsedwa kumanja. Pezani gawo la "Sinthani Riboni" ndikudina pamenepo. Pali mitundu iwiri yamabokosi. Pamndandanda wolondola timapeza chinthucho "Wopanga Mapulogalamu" ndikuyika chizindikiro pafupi ndi icho. Mukamaliza zosintha zonse, dinani "Chabwino".

4. Okonzeka! Madivelopa asinthidwa.

Malangizo atsatanetsatane ogwiritsira ntchito macro:

1. Timasunthira ku "Developer" tabu, yomwe ili pamwamba pa mawonekedwe a spreadsheet. Kenako, pezani gulu la "Code" ndikusankha chinthu cha "Visual Basic".

2. Sankhani chikalata chomwe mukufuna, kenako dinani "Onani Code". Mutha kuchitanso chimodzimodzi podina kawiri papepala lomwe mukufuna. Pambuyo pa izi, mkonzi wamkulu amawonekera pazenera. Matani khodi ili m'gawo la mkonzi:

Sub Delete_formulas()

Selection.Value = Selection.Value

mapeto Sub

3. Mukalowa kachidindo, dinani pamtanda pakona yakumanja kwa chinsalu.
4. Timasankha mitundu yomwe mafomuwa ali. Kenako, pitani kugawo la "Developer", pezani "Code" block block ndikudina chinthu cha "Macros".

5. Zenera laling'ono lotchedwa "Macro" linawonekera. Sankhani Macro yomwe yangopangidwa kumene ndikudina Run.

6. Okonzeka! Mafomu onse m'maselo asinthidwa ndi zotsatira zowerengera.

Njira 6: chotsani chilinganizo pamodzi ndi zotsatira zowerengera

Zimachitika kuti wogwiritsa ntchito purosesa ya Excel spreadsheet sayenera kungochotsa mafomu, komanso kuchotsa zotsatira za kuwerengera. Malangizo atsatanetsatane ndi awa:

1. Monga m'njira zonse zam'mbuyomu, timayamba ntchito yathu posankha mitundu yomwe mafomuwa ali. Kenako dinani kumanja pamalo osankhidwa. Menyu yankhani imawonekera pazenera. Pezani chinthucho "Chotsani zomwe zili" ndikudina. Njira ina yochotsera ndikusindikiza batani la "Delete".

2. Chifukwa cha zosinthazo, zonse zomwe zili m'maselo osankhidwa zidachotsedwa.

Kuchotsa chilinganizo pamene mukusunga zotsatira

Tiyeni tiwone mwatsatanetsatane momwe mungachotsere fomula ndikusunga zotsatira. Njira iyi imaphatikizapo kugwiritsa ntchito katundu wa Paste Values. Malangizo atsatanetsatane ndi awa:

1. Sankhani selo kapena mtundu womwe fomula yomwe tikufuna ili. Ngati ili mndandanda, ndiye kuti choyamba muyenera kusankha ma cell onse omwe ali ndi masanjidwewo.
2. Dinani pa selo mumtundu wotsatira.
3. Pitani ku gawo la "Home" ndikupeza "Editing" chipika chida. Apa ife alemba pa "Pezani ndi kusankha" chinthu, ndiyeno pa "Pitani" batani.
4. Pazenera lotsatira, dinani "Zowonjezera", kenako pagawo la "Current Array".
5. Timabwerera ku gawo la "Home", pezani chinthu cha "Copy" ndikudina.
6. Mukamaliza kukopera, dinani muvi womwe uli pansi pa batani la "Paste". Pa sitepe yomaliza, dinani "Insert Values".

Kuchotsa fomula yofananira

Kuti mufufuze njira yofufutira, choyamba muyenera kuwonetsetsa kuti ma cell onse omwe ali ndi fomula yomwe mukufuna asankhidwa. Malangizo atsatanetsatane ndi awa:

1. Sankhani gawo lomwe mukufuna mumitundu yosiyanasiyana.
2. Timapita ku gawo la "Home". Timapeza chipika cha zida "Sinthani" ndikudina chinthucho "Pezani ndikusankha".
3. Kenako, dinani "Pitani", ndiyeno pa chinthu "Zowonjezera".
4. Dinani pa "Current Array".
5. Pamapeto pa ndondomekoyi, dinani "Chotsani".

Kutsiliza

Mwachidule, titha kunena kuti palibe chovuta pakuchotsa mafomu kuchokera ku ma spreadsheet cell. Pali njira zambiri zochotsera, kotero kuti aliyense akhoza kusankha yabwino kwambiri kwa iwo okha.