Nzira Yokubatanidza nayo nekudhonza Excel Files muShoko reMagwaro

Gona nyore nyore ruzivo rwaunoda

Kana uri kushandisa Microsoft Word kugadzira zvinyorwa zvemabhizimisi zvakadai semishumo nezvirongwa zvebhizimisi, hazvigoneki kuti iwe unoda kuisa data yakagadzirwa muExpcel . Iwe une zvingasarudzwa zviviri zvinowanikwa pane izvi: Unogona kugoverana pamwe neyedzimberi yeExcel kuti udonhe data yaunoda muShoko rako reShoko, kana iwe unogona kuvhara dhipatimendi reExcel pachayo mukati meShoko file pacharo.

Kunyange zvazvo izvi zviri nyore nzira, iwe unofanirwa kuziva nezvesarudzo dzako uye kukanganisa kune imwe neimwe. Pano, iwe uchanodzidza kuunganidzana uye kuisa mukana we Excel mune zvinyorwa zveShoko rako.

Kubatanidza kune Excel Spreadsheet

Kune vashandisi vanoda kuve nechokwadi chokuti ruzivo rwuri kuongororwa nguva dzose kana shanduko ichigadzirwa papasiteti, kubatanidza ndiyo nzira yekuenda nayo. Nzira imwechete yekugadzira inosikwa iyo inopa deta kubva pane yako Excel file muDhidziso yeShoko. Kubatanidza imwe yeExcel kuchaitawo kuti Shoko rako rive duku shoma, sezvo data pachayo isina kuchengetwa neDhidziso reShoko.

Kubatanidza kune rimwe bhuku reEccel kune zvimwe zvisingakwanisi:

Cherechedza: Kana uri kushandisa Shoko 2007, iwe unoda kuverenga nyaya yekuti inganamatira sei kune Excel data muShoko 2007.

Kana uri kushandisa shanduro yekare yeShoko, tevera matanho aya akareba:

  1. Vhura zvose zvinyorwa zveShoko uye Excel spreadsheet uchange uchisangana nazvo.
  2. MuExcel, sarudza uye ukopa mararamiro emasero aunoda kuaisa (kana iwe uronga kuisa mamwe mahwendefa kana mitsetse mupasiteteti yako, sarudza pepa rese rekushanda nekukanda bhokisi riri mune imwe kona yepamusoro kuruboshwe panotangira mutsara yemutsara uye mabhokisi emutsara).
  3. Mune zvinyorwa zveShoko rako rinongedza nzvimbo iyo iwe unoda tafura yakabatanidzwa yakaiswa.
  4. PaIndaneti menyu, sarudza Itai Zaka ...
  5. Dzvanya bhodhi redhiyo pedyo neKutunga link .
  6. Pasi pezita racho Se ::, sarudza Microsoft Excel Worksheet Object .
  7. Dzvanya OK .

Your Excel data inofanira kuiswa ikozvino uye inobatanidza neExpcel spreadsheet. Kana iwe uchiita shanduko kune source Excel file, nguva inotevera kana uzarura chikwata chako cheShoko iwe uchakurudzirwa kuvandudza data yakabatana.

Kubudisa imwe Excel Spreadsheet

Nzira yekuiswa kweExpcel worksheet muDhipatimendi reShoko rako inonyanya kufanana nekubatanidza kune Excel worksheet. Misiyano chete iri mumasarudzo aunotsanangura muPaste Special dialog box. Kunyange zvazvo zvigumisiro zvingaita zvakafanana pakutanga, zvinoshamisa zvakasiyana.

Cherechedza kuti kana uchinge uvhara dhipatimendi reExcel mukati megwaro reShoko, iyo yose yeExcel inyaya ichabatanidzwa. Shoko rinogadzira data yakabatanidzwa kuti iratidze zvawakasarudza, asi iyo yose yeExcel inyaya ichabatanidzwa muShoko file.

Kushandura dhidhiyo yeExcel kuchaita kuti Shoko rako rekunyora faira riwedzere.

Kana uri kushandisa Shoko 2007, dzidza sei kuvhara data ye Excel muShoko 2007. Kwemashoko eShanduro yapfuura, tevera matanho aya akajeka kuvhara ye Excel file mune zvinyorwa zveShoko rako:

  1. Vhura zvose zvinyorwa zveShoko uye Excel spreadsheet.
  2. MuchiExcel, kopota mararamiro emasero aunoda kuaisa.
  3. Mune zvinyorwa zveShoko renyu munoisa chitubu chaunoda kuti tafura iiswe.
  4. PaIndaneti menyu, sarudza Itai Zaka ...
  5. Dzvanya bhodhi redhiyo pedyo neChita .
  6. Pasi pemashoko ekuti "As :," sarudza Microsoft Excel Worksheet Object .
  7. Dzvanya OK .

Your Excel spreadsheet ikozvino yakabatanidzwa mune dhidhiro reShoko renyu.