Iyo spreadsheet Excel ine nhamba hombe yemabasa ayo anotendera iwe kuti ushande nemazvo nehuwandu hukuru hweruzivo uye akasiyana ekuverenga. Zvinowanzoitika kuti mushandisi anoda kudzima fomula iyo mhedzisiro yakaverengerwa, uye kusiya iyo yakazara muchitokisi. Chinyorwa chichakurukura nzira dzinoverengeka dzekubvisa mafomula kubva kuExcel spreadsheet maseru.
Kudzima mafomula
Chishandiso chespredishiti hachina chishandiso chakasanganiswa chekudzima fomula. Ichi chiito chinogona kuitwa nedzimwe nzira. Ngationgororei imwe neimwe zvakadzama.
Method 1: Copy Values Uchishandisa Namira Sarudzo
Sarudzo yekutanga ndiyo inokurumidza uye iri nyore. Iyo nzira inobvumidza iwe kukopa zviri mukati mechikamu uye kuendesa kune imwe nzvimbo, pasina mafomula. Detailed instructions ndeidzi:
- Isu tinosarudza sero kana huwandu hwemaseru, ayo isu tichakopa mune ramangwana.
- Isu tinodzvanya RMB pane chimwe chinhu chinopokana chenzvimbo yakasarudzwa. Menyu diki yemukati inooneka, kwaunofanirwa kusarudza iyo "Copy" chinhu. Imwe nzira yekukopa ndeye kushandisa kiyi musanganiswa "Ctrl + C". Yechitatu sarudzo yekukopa kukosha ndeye kushandisa "Copy" bhatani riri patoolbar yechikamu che "Kumba".
- Sarudza sero yatinoda kunamira ruzivo rwakambokopwa, tinya ipapo pairi. Mamenu akajairika anovhura. Isu tinowana "Paste Options" block uye tinya pane "Values" chinhu, chinotaridzika sechiratidzo chine mufananidzo wekutevedzana kwenhamba "123".
- Ready! Mashoko akakopwa asina mafomula akaendeswa kunzvimbo itsva yakasarudzwa.
Nzira 2: Shandisa Paste Special
Pane "Paste Special" inokubatsira kukopa ruzivo nekuiisa mumaseru uchichengeta iyo yekutanga fomati. Mashoko akaiswa haazove nemafomula. Detailed instructions ndeidzi:
- Isu tinosarudza huwandu hwatinoda kunamira munzvimbo chaiyo uye tokopa tichishandisa chero nzira yakakunakira iwe.
- Isu tinotamira kune sero kwatinoda kutanga kubatidza data rakakopwa, tinya-kurudyi pairi. Menyu diki yemamiriro akavhurwa. Isu tinowana chinhu "Paste Special" uye tinya pane museve icon iri kurudyi rwechinhu ichi. Mune yekuwedzera menyu inoonekwa, tinya pane zvakanyorwa "Values uye sosi fomati".
- Taita, basa rakapedzwa!
Nzira 3: Delete Formulas muKunobva Tafura
Tevere, ngatitaure nezve nzira yekudzima mafomula mutafura yekutanga. Detailed instructions ndeidzi:
- Isu tinokopa huwandu hwemasero mune chero nzira iripo. Somuenzaniso, kushandisa kiyi musanganiswa "Ctrl + C".
- Senzira yakambokurukurwa, tinonamira tichichengeta fomati yepakutanga mune imwe chikamu chebepa rebasa. Pasina kubvisa kusarudzwa, tinokopa data zvakare.
- Isu tinoenda kune chikamu chiri mukona yekumusoro kuruboshwe, tinya RMB. Iyo yakajairika menyu yemukati inooneka, umo iwe unofanirwa kusarudza iyo "Values" chinhu.
- Kuzadzwa kwemaseru pasina mafomula kwakakopwa kunzvimbo yekutanga. Iye zvino unogona kudzima mamwe matafura ataida pakuita kopi. Sarudza zvakapetwa zvetafura ine LMB uye tinya panzvimbo yekusarudza neRMB. Menyu yemamiriro ekunze inobuda, yaunofanirwa kudzvanya pane "Delete" chinhu.
- Iwindo diki "Delete masero" rakaratidzwa pachiratidziri. Pano unogona kusarudza zvokubvisa. Isu tinoisa chinhu padhuze nekunyorwa "Mutsetse" uye tinya "OK". Mumuenzaniso wedu, hapana masero ane data kudivi rerudyi rekusarudza, saka sarudzo "Masero, akachinjirwa kuruboshwe" akakodzerawo.
- Duplicate matafura anobviswa zvachose kubva papepa rebasa. Isu takaita kutsiva mafomula ane chaiwo zviratidzo mutafura yekutanga.
Nzira 4: Bvisa mafomula pasina kukopa kune imwe nzvimbo
Vamwe vashandisi veExcel spreadsheet vanogona kunge vasina kugutsikana neiyo yapfuura nzira, nekuti inosanganisira huwandu hukuru hwekunyengedza kwaunogona kuvhiringika. Pane imwe mutsauko wekudzima mafomula kubva patafura yekutanga, asi inoda kutarisirwa kune chikamu chemushandisi, sezvo zvese zviito zvichaitwa mutafura pachayo. Izvo zvakakosha kuti uite zvese nemazvo kuitira kuti usabvise netsaona kukosha kwakakosha kana kusa "kutyora" iyo data chimiro. Detailed instructions ndeidzi:
- Pakutanga, semune nzira dzakapfuura, tinosarudza nzvimbo yaunofanirwa kudzima mafomula neimwe nzira yakakunakira iwe. Tevere, isu tinotevedzera kukosha mune imwe yenzira nhatu.
- Pasina kubvisa sarudzo, tinya paRMB nzvimbo. Menyu yezvinyorwa inooneka. Mu "Namira Sarudzo" yekuraira block, sarudza iyo "Values" chinhu.
- Ready! Somugumisiro wekugadzirisa kwakaitwa mutafura yepakutanga, maitiro akatsiviwa nemaitiro chaiwo ekuverenga.
Nzira 5: Isa Macro
Nzira inotevera inosanganisira kushandiswa kwemacros. Usati watanga kudzima mafomula kubva patafura uye nekuatsiva nemakoshero chaiwo, unofanirwa kugonesa "Developer Mode". Pakutanga, iyi modhi yakavharwa muspredishiti processor. Mirayiridzo yakadzama yekugonesa "Developer Mode":
- Dzvanya pa "Faira" tab, iyo iri pamusoro pechirongwa chechirongwa.
- Hwindo idzva rakavhurwa, mune yeruboshwe runyorwa rwezvinhu iwe unofanirwa kudzika kusvika pazasi uye tinya "Parameters".
- Zvirongwa zvinoratidzwa kudivi rerudyi. Tsvaga iyo "Customize Ribhoni" chikamu uye tinya pairi. Kune maviri rondedzero mabhokisi. Mune runyorwa rwerudyi tinowana chinhu "Developer" uye isa tiki padivi payo. Mushure mekuita zvese manipulations, tinya "OK".
- Ready! Developer mode inogoneswa.
Mirayiridzo yakadzama yekushandisa macro:
- Isu tinotamira kune "Developer" tab, iyo iri pamusoro peiyo spreadsheet interface. Tevere, tsvaga iyo "Code" parameter boka uye sarudza iyo "Visual Basic" chinhu.
- Sarudza pepa raunoda regwaro, uye wobva wadzvanya pane "View Code" chinhu. Iwe unogona kuita basa rimwe chete nekudzvanya kaviri pane pepa raunoda. Mushure mekuita uku, iyo macro edhita inoonekwa pachiratidziri. Namatidza kodhi inotevera mundima yekupepeta:
Sub Delete_formulas()
Selection.Value = Selection.Value
End Sub
- Mushure mekuisa kodhi, tinya pamuchinjiko mukona yepamusoro yekurudyi yechidzitiro.
- Isu tinoita sarudzo yemhando iyo mafomula aripo. Tevere, enda kuchikamu che "Developer", tsvaga "Code" command block uye tinya pane "Macros" chinhu.
- Hwindo diki rainzi "Macro" rakaonekwa. Sarudza iyo ichangogadzirwa macro uye tinya Run.
- Ready! Ese mafomula mumaseru atsiviwa nemhinduro dzekuverenga.
Nzira 6: bvisa fomula pamwe chete nemhedzisiro yekuverenga
Zvinoitika kuti mushandisi weExcel spreadsheet processor haingodi chete kuita kudzima mafomula, asiwo kudzima mhedzisiro yekuverenga. Detailed instructions ndeidzi:
- Senge mune dzese nzira dzakapfuura, tinotanga basa redu nekusarudza huwandu mune iyo mafomula aripo. Wobva wadzvanya-kurudyi panzvimbo yekusarudza. Menyu yezvinyorwa inobuda pachiratidziri. Tsvaga chinhu "Bvisa zvirimo" uye tinya pairi. Imwe nzira yekudzima ndeye kudzvanya "Delete" kiyi.
- Nekuda kwekugadzirisa, data rese mumaseru akasarudzwa rakadzimwa.
Kudzima fomula uchichengeta zvabuda
Ngationgororei zvakadzama maitiro ekudzima fomula uchichengetedza mhedzisiro. Iyi nzira inosanganisira kushandisa iyo Paste Values pfuma. Detailed instructions ndeidzi:
- Sarudza sero kana renji panowanikwa fomula yatinoda. Kana iri array formula, saka unofanira kutanga wasarudza maseru ese ari muchikamu ane array formula.
- Dzvanya pasero mune array formula.
- Enda kuchikamu che "Kumba" uye tsvaga "Editing" bhuroka rekushandisa. Pano tinodzvanya pane "Tsvaga uye sarudza" chinhu, uye ipapo pane "Go" bhatani.
- Muhwindo rinotevera, tinya pa "Wedzero", uyezve pane chinhu "Yazvino Array".
- Isu tinodzokera kuchikamu che "Kumba", tsvaga "Copy" chinhu uye tinya pairi.
- Mushure mekuita maitiro ekukopa, tinya pane museve, uri pasi pebhatani re "Namira". Padanho rekupedzisira, tinya "Isert Values".
Kudzima fomula yakarongwa
Kuita maitiro ekudzima fomula yakarongwa, iwe unofanirwa kutanga waona kuti maseru ese ari muchikamu ane fomura yaunoda akasarudzwa. Detailed instructions ndeidzi:
- Sarudza chikamu chaunoda mune array formula.
- Isu tinotamira kune "Kumba" chikamu. Isu tinowana block yezvishandiso "Editing" uye tinya pane chinhu "Tsvaga uye sarudza".
- Tevere, tinya "Enda", uyezve pane chinhu "Yekuwedzera".
- Dzvanya pa "Current Array".
- Pakupera kwekuita, tinya "Delete".
mhedziso
Kupfupisa, tinogona kutaura kuti hapana chakaoma mukudzima mafomula kubva kumaseru espredishiti. Kune huwandu hukuru hwenzira dzekubvisa, kuitira kuti munhu wese azvisarudzire zvakanyanya nyore ivo pachavo.