Mukati
Kana mafomati emavara akagadzirirwa chero maseru ari pabepa (izvi zvinogona kuitwa nemushandisi kana chirongwa pakurodha data kuExcel), ipapo manhamba anozopinda mumasero aya eExcel anotanga kufunga semavara. Dzimwe nguva maseru akadaro anoiswa chiratidzo chegirinhi, chaungangove wakaona:
Uye dzimwe nguva chiratidzo chakadaro hachioneki (izvo zvakanyanya kuipa).
Kazhinji, kutaridzika kwenhamba-se-zvinyorwa mune yako data kazhinji kunotungamira kune yakawanda inosiririsa mhedzisiro:
- kuronga kunomira kushanda zvakajairika - "pseudo-nhamba" dzakadzvanywa, uye hadzina kurongeka muhurongwa sezvainotarisirwa:
- mhando mabasa VLOOKUP (VLOOKUP) usawane hunhu hunodiwa, nekuti kwavari nhamba uye nhamba yakafanana-se-zvinyorwa zvakasiyana:
- pakusefa, pseudo-nhamba dzinosarudzwa zvisizvo
- mamwe akawanda eExcel mabasa anomirawo kushanda nemazvo:
- etc.
Zvinonyanya kusekesa kuti chishuwo chechisikigo chekungochinja sero fomati kuita nhamba haibatsire. Avo. iwe unonyatso sarudza maseru, kurudyi tinya paari, sarudza Sero format (Mafomati Masero), chinja chimiro kuti Nhamba (nhamba), kudzvinya OK - uye hapana chinoitika! Zvachose!
Zvichida, "ichi hachisi chirwere, asi chimiro", hongu, asi izvi hazviiti kuti zvive nyore kwatiri. Saka ngatitarisei nzira dzinoverengeka dzekugadzirisa mamiriro acho - imwe yacho inonyatso kukubatsira.
Nzira 1. Kona yechiratidzo chegirini
Kana iwe ukaona kona yegirini chiratidzo pane sero ine nhamba mune zvinyorwa zvemafomati, wobva wazviona uine rombo rakanaka. Unogona kungosarudza maseru ese ane data uye wodzvanya pane pop-up yero icon ine chiratidzo chekushamisika, wobva wasarudza iwo murairo. Shandura kuita Nhamba (Shandura kuita nhamba):
Nhamba dzese dziri muchikamu chakasarudzwa dzichashandurwa kuita nhamba dzakazara.
Kana pasina makona akasvibira zvachose, wobva watarisa kana akadzimwa mumasetirwo ako eExcel (Faira - Sarudzo - Mafomura - Nhamba dzakarongwa semavara kana kutangirwa neapostrophe).
Nzira 2: Kupinda zvakare
Kana pasina masero akawanda, saka unogona kuchinja maitiro avo kuva nhamba, uye wozoisa zvakare data kuitira kuti shanduko yefomati iite. Nzira iri nyore yekuita izvi ndeyekumira pasero uye nekudzvanya makiyi achitevedzana F2 (pinda edit mode, sero rinotanga blinking cursor) uyezve pinda. Uyewo panzvimbo F2 unogona kungodzvanya kaviri pasero nebhatani rekuruboshwe.
Zvinopera pasina kutaura kuti kana pane masero akawanda, zvino nzira iyi, zvechokwadi, haigoni kushanda.
Nzira 3. Formula
Iwe unogona kukurumidza kushandura pseudo-nhamba kune dzakajairwa kana iwe ukaita imwe koramu ine yekutanga fomula padivi peiyo data:
Kubvisa kaviri, muchiitiko ichi, zvinoreva, kutaura zvazviri, kuwanda ne -1 kaviri. A minus by minus ichapa plus uye kukosha musero hakuzoshanduki, asi chokwadi chekuita masvomhu chinochinja chimiro chedata kuenda kune nhamba yatinoda.
Ehe, pachinzvimbo chekuwanza ne1, unogona kushandisa chero imwe isingakuvadze masvomhu: kupatsanura ne1 kana kuwedzera nekubvisa zero. Mhedzisiro yacho ichave yakafanana.
Nzira 4: Namira Yakakosha
Iyi nzira yakashandiswa mushanduro dzekare dzeExcel, apo vatungamiri vemazuva ano vanobudirira vakaenda pasi petafura pakanga pasina kona yegirini yechiratidzo asi mumusimboti (yakaonekwa chete muna 2003). Iyo algorithm ndeiyi:
- isa 1 musero chero risina chinhu
- ikopa
- sarudza maseru ane manhamba mufomati yemavara uye shandura fomati yavo kuita manhamba (hapana chichaitika)
- tinya-kurudyi pamaseru ane pseudo-nhamba uye sarudza kuraira Namatidza special (Namira Special) kana kushandisa nzira yekudimbudzira kiibhodhi Ctrl + Alt + V
- pahwindo rinovhurwa, sarudza sarudzo Zvinokosha (Values) и Wedzera (Wanza)
Muchokwadi, isu tinoita chinhu chimwechete senge mune yakapfuura nzira - kuwedzera zviri mukati memasero neimwe - asi kwete nemafomula, asi zvakananga kubva kune buffer.
Method 5. Zvinyorwa nemakoroni
Kana pseudonumbers dzinofanirwa kushandurwa dzakanyorwawo nedecimal isiriyo kana zviuru zvinopatsanura, imwe nzira inogona kushandiswa. Sarudza iyo sosi renji ine data uye tinya bhatani Mavara nezvikamu (Chinyorwa kuzvikamu) Tab Data (Zuva). Muchokwadi, chishandiso ichi chakagadzirirwa kupatsanura mavara anonamira mumakoramu, asi, mune ino kesi, tinoishandisa kune chimwe chinangwa.
Svetuka matanho maviri ekutanga nekudzvanya pabhatani Next (Inotevera), uye yechitatu, shandisa bhatani Kuwedzerwa (Yakasimudzwa). Bhokisi renhaurirano rinovhurika paunogona kuseta mavara anopatsanura aripo muzvinyorwa zvedu:
Mushure mekunge mavharidza pedza Excel inoshandura zvinyorwa zvedu kuita nhamba dzakajairika.
Nzira 6. Macro
Kana iwe uchifanira kuita shanduko dzakadaro kazhinji, saka zvine musoro kuita otomatiki iyi maitiro neiyo nyore macro. Dzvanya Alt+F11 kana kuvhura tab yokuvaka (Mugadziri) Uye chengetedza Visual Basic. Muhwindo remupepeti rinoonekwa, wedzera module nyowani kuburikidza nemenyu Pinza – Module uye kopira kodhi inotevera ipapo:
Sub Convert_Text_to_Numbers() Selection.NumberFormat = "General" Selection.Value = Selection.Value End Sub
Iye zvino mushure mekusarudza huwandu, iwe unogona kugara uchivhura iyo tab Mugadziri - Macros (Mugadziri - Macros), sarudza yedu macro mune rondedzero, tinya bhatani manya (Mhanya) - uye ipapo shandura pseudo-nhamba kuita dzizere.
Iwe unogona zvakare kuwedzera iyi macro kubhuku rako pachako macro kuti ushandise gare gare mune chero faira.
PS
Nyaya imwe chete inoitika nemazuva. Mamwe misi anogonawo kuzivikanwa neExcel semavara, saka kuisa mumapoka uye kuronga hakushande. Mhinduro dzakafanana nedzenhamba, chimiro chete chinofanira kutsiviwa nemazuva-nguva pachinzvimbo chenhamba.
- Kupatsanura mavara anonamira kuita makoramu
- Maverengero asina mafomula nekunamira kwakakosha
- Shandura mavara kuti ave manhamba neiyo PLEX yekuwedzera