Shandura Rugwaro kuNhamba Ne Excel Paste Special

01 ye 04

Shandura Dhina Dheyo Kubva Kuchimbwa Nhamba Yenhamba

Dzimwe nguva, kana hutsika huri kutengeswa kana kunyoreswa muExpcel worksheet mazano anozoguma semashoko panzvimbo pekuverenga nhamba.

Mamiriro aya anogona kukonzera matambudziko kana kuedza kunogadziriswa kugadzirisa deta kana kana data inoshandiswa mukuverenga iyo inosanganisira dzimwe dzeExcel dzakavakwa mumabasa.

Mumufananidzo wepamusoro, somuenzaniso, basa reSUM rinowedzera kuwedzera hutatu hutsika-23, 45, uye 78-iri mumasero D1 kusvika kuD3.

Pane kudzoka 146 semhinduro; zvisinei, basa rinodzoka zero nokuti zvitatu zvakatorwa zvakanyorwa semashoko kwete sekuverenga nhamba.

Pepa Rokushanda

Excel's default formatting for different types of data is often one indicator that shows when data has been imported or entered incorrectly.

Nokusagona, nhamba yedata, pamwe chete nemafuta uye zvigumisiro zvebasa, zvakanyatsoenderana nechokurudyi chesekeri, apo mavara ezvinyorwa akabatanidzwa kuruboshwe.

Nhamba nhatu - 23, 45, uye 78 - mumufananidzo wepamusoro dzakanamatira kurutivi rworuboshwe rwemasero avo nokuti dziri mutsara mitemo apo basa reSUM rinowedzera muchitsetse D4 rakanamatirwa kurudyi.

Mukuwedzera, Excel inowanzoratidza zvinetso zvingangodaro nezviri mukati memusero pakuratidza katatu kadiki gorosi mune kona yepamusoro yekona yesero.

Muchiitiko ichi, ruvara rwebhuruu rinoratidza kuti maitiro mumasero D1 kusvika kuD3 akanyorwa semashoko.

Fixing Problem Data nePaste Special

Zvasarudzo zvekuchinja deta iyi kudzokera kuhuwandu hwemajeri ndeyokushandisa VALUE basa muExcel uye unyore zvakakosha.

Nyaya yakakosha ihurukuro yakawedzerwa yemirairo yekunyorera iyo inokupa huwandu hwezvingasarudzwa maererano neicho chinotamirwa pakati pemasero panguva yekushandura / kushandiswa .

Izvi zvinosanganisira masvomhu ekushanda zvakadai sekuwedzera uye kuwedzera.

Wedzerai Maitiro e1 ne Paste Special

Kuwedzerwa kwekuwedzera muhutu hunokosha hakusi kungowedzera nhamba dzose nehumwe huwandu uye kuisa mhinduro mukati memunzvimbo yekuenda, asi ichashandura maonero ezvinyorwa kuverenga nhamba apo imwe yega inowanikwa nenhamba ye1.

Muenzaniso pane peji rinotevera unoshandisa ichi chiitiko chekunyanya kukanganiswa nemigumisiro yebasa iri:

• mhinduro yebasa reSUM iri kubva ku zero kusvika 146
• iyo mitatu mitemo inoshandura kuenzaniswa kubva kuruboshwe rwesero kusvika kurudyi
• iyo yeguru triangle kukanganisa mafungiro okubviswa kubva kumasero ane data

02 of 04

Nyora Muenzaniso Wakakosha: Kuchinyorera Rugwaro kune Numeri

Kuti tishandure zvinyorwa zvinyorwa kuverenga nhamba, isu chokutanga tinoda kupinda dzimwe nhamba semagwaro.

Izvi zvinoitwa nekunyora apostrophe ( ' ) pamberi pe nhamba imwe neimwe sezvainopinda muchitokisi.

1. Vhura pepa rekushanda muExcel rine masero ose akaiswa kuGeneral format
2. Dzvanya pane sero D1 kuti uite sero rinoshanda
3. Tora apostrophe inotevera nhamba 23 muchikamu
4. Dhinda pikicha inopinda mubhokisi
5. Sezvinoratidzwa mumufananidzo wepamusoro, sero D1 rinofanira kuva nekatatu yakasvibirira kumusoro kwekona yakasara rekamuri uye nhamba 23 inofanira kuenzaniswa nechokurudyi. Apo apostrophe haisi kuonekwa muchitokisi
6. Dzvanya pane cell D2, kana zvichifanira
7. Tora apostrophe inotevera nhamba 45 kupinda muchitokisi
8. Dhinda pikicha inopinda mubhokisi
9. Dzvanya pane cell D3
10. Tora apostrophe inotevera nhamba 78 mujeri
11. Dhinda pikicha inopinda mubhokisi
12. Dzvanya pane cell E1
13. Tora iyo nhamba 1 (hapana apostrophe) muchitokisi uye shandisai Enter key pane keyboard
14. Nhamba 1 inofanirwa kuenzaniswa nechepamusoro kwekamuri, sezvinoratidzwa mumufananidzo uri pamusoro

Cherechedza: Kuona apostrophe pamberi pe nhamba ichi kupinda D1 kusvika D3, chovha pane imwe yemasero, akadai seD3. Mubhokisi yepamusoro pepamusoro pebasa rekushanda, inopinda '78 inofanira kuonekwa.

03 of 04

Bata Muenzaniso Wakakosha: Kuchinyorera Rugwaro Ku Numeri (Cont.)

Kupinda Basa reSUM

1. Dzvanya pane cell D4
2. Tanga = SUM (D1: D3)
3. Dhinda pikicha inopinda mubhokisi
4. Mhinduro 0 inofanira kuonekwa muchitokisi D4, sezvo hutsika mumasero D1 kusvika kuD3 dzakapinda semashoko

Cherechedza: Mukuwedzera pakudhinda, nzira dzekupinda muSUM basa mukati memusero webasa rinobatanidza:

• Shortcut keys
• SUM function dialog box
• AutoSum

Kuchinyorera Rugwaro kuNumeri neKutepa Kakawanda

1. Dzaira sejeri E1 kuti riite sero rinoshanda
2. PaImba yebhu yebhoni , tsvaga pane Kopi icon
3. Nyeredzi dzinofamba dzinofanirwa kuonekwa dziri pedo nesero E1 ichiratidza kuti zviri mukati mechere iri zviri kunyorwa
4. Simbisai masero D1 kuD3
5. Dzvanya pasi pemusara wezasi pasi peKutanidza icon paImba yebhu yebhoni kuitira kuti uzarure menyu
6. Mune menyu, chengetai Paste Special kuti uzarure Bhuku Rinokosha rebhokisi
7. Pasi pechikamu cheOp Operation chebhokisi rebhokisi, tanga pane bhodhi redhiyo pedyo nekuwedzera kuti uite basa iri
8. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda

04 we 04

Bata Muenzaniso Wakakosha: Kuchinyorera Rugwaro Ku Numeri (Cont.)

Tsvakurudzo yeZvashandi

Sezvinoratidzwa mumufananidzo uri pamusoro, mhinduro dzebasa iri mubasa rinofanira kuva:

• iyo mitatu mitero mumasero D1 kusvika kuD3 inofanira kunge yakanyatsoenderana nekodzero mumasero avo
• iyo katatu temavara inofanira kuve yakabva kubva kumusoro kwekona yekona yesero rimwe nerimwe
• zvinokonzerwa nebasa reSUM muchitokisi D4 rinofanira kuverengwa zvino 146 iyo iyo yose yezvikamu zvitatu mumasero D1 kusvika kuD3