Warasa faira rako reExcel? Nhungamiro yakakwana yekunzwisisa uye kudzivirira kuchengetedza zvikanganiso

Uri kunetseka kuchengetedza mafaera ako muExcel? Mamiriro ezvinhu aya anogona kushungurudza, kunyanya kana wapedza nguva yakawanda uchishanda paspredishiti uye uchitya kurasikirwa neshanduko dzako dzese. Microsoft Excel ndechimwe chezvishandiso zvakanyanya kushandiswa zvekutarisira data uye kuongorora, saka Kusangana nezvikanganiso paunenge uchiedza kuchengetedza zvinyorwa ndeimwe yemibvunzo inowanzo zivikanwa uye kunetseka pakati pevashandisi vayo.

Muchikamu chino, tichaongorora zvose Zvinogona zvikonzero zvinogona kudzivirira Excel kubva pakuchengetedza mafaera akouye isu tichapa mhinduro dzakadzama kune yega yega kesi. Pano iwe hauzowani chete nhanho-ne-nhanho maitiro, asiwo zvakajeka tsananguro uye anobatsira mazano ekudzivisa aya marudzi ematambudziko mune ramangwana. Huya, gara tikutsanangurire. nzira yekupora kubva mumamiriro ezvinhu aya uye kudzivirira.

Iyo nzira yekuchengetedza inoshanda sei muExcel uye nei ichigona kutadza

Usati wapinda mumhinduro, zvakakosha kunzwisisa kuti Excel inochengetedza sei mafaira, sezvo nzira yacho isiri nyore sezvainoita. Excel, iwe paunochengeta nemaoko kana otomatiki bhuku rebasa, tanga wagadzira faira rechinguva munzvimbo imwechete segwaro rekutanga.. Kana kuchengetedza kwapera, bvisa faira rekutanga uye upe faira renguva pfupi zita chairo. Kana paine nyaya dzikamuka panguva iyi, mhando dzakasiyana dzekukanganisa dzinogona kuitika, uye faira rine shanduko nyowani rinogona kusachengetwa nemazvo.

Kuvhiringwa muhurongwa hwekuchengetedza zvinogona kukonzerwa nezvikonzero zvakawanda: kubva pakudzvanya kiyi ye "Esc", matambudziko ehardware, matambudziko esoftware, matambudziko eantivirus, kukakavara kwemvumo, nzira dzefaira dzakarebesa, kana kushaikwa kwedhisiki nzvimbo. Iwe zvakare unofanirwa kungwarira netiweki nzvimbo kana ekunze madhiraivha, sekunge iyo yekubatanidza yakarasika apo Excel iri kuchengetedza, unogona kupedzisira uine akaora mafaira kana shanduko dzisina kuchengetwa.

Yakajairika mhosho meseji kana uchichengeta mafaera muExcel

Pakati peakajairika mameseji ekukanganisa kana Excel isingachengete faira, zvinotevera zvinomira pachena:

• "Gwaro harina kuchengetwa"
• "Gwaro harina kuponeswa zvachose"
• "Gwaro rekuverenga chete harigone kuwanikwa. »
• "Dhisiki Rizere"
• "Mhosho dzakaonekwa tichichengeta..."
• "Zita refaira harisi kushanda"

Imwe neimwe yezvikanganiso izvi inonongedza kune chakasiyana chikonzero., saka zviri nani kuziva meseji chaiyo usati watsvaga mhinduro yakakodzera.

Zvikonzero zvikuru nei Excel isingachengetedze shanduko

Zvinoenderana nezvinyorwa zvepamutemo, maforamu ekubatsira uye ruzivo rwevashandisi, Zvikonzero zvinowanzoitika nei Excel ichipa matambudziko kana uchichengetedza mafaera ari:

• Kushaikwa kwemvumo pafolda yekuenda+
• Wechitatu Bato Plugins: Mamwe ma-add-ins akaiswa muExcel anogona kukanganisa maitiro ekuchengetedza, zvichikonzera kuparara kusingatarisirwe kana kukanganisa.
• Mafaira akakuvadzwa kana kuti ane huori: Kana iyo yekutanga faira yakaora, Excel inogona kudzivirira shanduko kubva mukuchengetwa nemazvo.
• Nzvimbo isina kukwana disk: Kana iyo nzvimbo yekuenda isina nzvimbo yemahara, Excel haipedze basa rekuchengetedza.
• Antivirus software: Zvimwe zvirongwa zveantivirus zvinogona kuvharisa maitiro ekuchengetedza, kunyanya kana vakatarisa mafaera matsva kana kushandura mafaera akavhurika panguva yekutariswa.
• Kugovera makakatanwa kana kukiya: Kana iyo faira yakavhurwa nemumwe munhu kana mune imwe muenzaniso yeExcel, zvikanganiso zvinogona kuitika kana uchichengeta.
• Nzira yefaira yakarebesa: Excel inomisa zita refaira uye nzira yakazara kune 218 mavara. Kana ikadarika, uchawana zita risiri iro.
• Matambudziko ekubatanidza munzvimbo dzenetiweki: Kana iwe ukachengeta mafaera kunetiweki dhiraivha uye kubatana kwarasika, iyo savha inogona kutadza uye iwe unogona kurasikirwa neazvino data.
• Mafaira ari mumodhi yekuverenga chete: Iyo faira inogona kuita iyi modhi yakagoneswa kana iwe unogona kunge usiri muridzi, uchidzikamisa kugona kuichengeta nekuchinja.
• Hardware kukanganisa (dhisiki, USB madhiraivha, nezvimwewo): Kutadza kwemuviri kana kubviswa kwedhiraivha paunenge uchichengetedza kunogona kukonzera kukanganisa uye mafaera akaora.
• Mafaira akavharwa nehurongwa kana imwe application: Kana iyo faira iri kushandiswa neimwe chirongwa, inogona kudzivirira kuchengetedza.

Maitiro ekugadzirisa Excel kwete kuchengetedza shanduko?

Ngationgororei imwe neimwe mhinduro dzinoshanda pane imwe neimwe nyaya.

1. Tarisa uye gadzirisa mvumo yeforodha

Kutanga Kwazvose Tarisa kuti une mvumo yakakwana mufolda yaunochengeta faira. Kurudyi tinya pane folda, sarudza Propiedades, pinda tabhu Chengetedzo uye tarisa mvumo yakapihwa mushandisi wako. Kana iwe usina mvumo yekunyora kana kugadzirisa, kumbira maneja wechikwata kuti akupe iwo kana kuedza kuchengetedza faira kune imwe nzvimbo yaunayo.

2. Chengetedza faira sebhuku idzva rekushanda kana nerimwe zita

Imwe yekutanga yakakurudzirwa zviito kana Excel isingakusiye iwe kuchengetedza ndeye kushandisa sarudzo Sevha se uye shandura zita refaira kana nzira. Nenzira iyi, iwe unodzivirira kunyora pasi iyo yekutanga faira uye kudzivirira kubonderana kana nguva yekumisikidza. Kuita izvi:

1. Wana menyu Archive uye sarudza Sevha se.
2. Isa rimwe zita uye edza kurichengeta kune imwe nzvimbo.

Iri zano rinowanzoshanda kana kupokana kuri pamusoro pemvumo, kushatiswa kwemafaira enguva pfupi, kana kubondera kwechinguvana.

3. Fambisa maspredishiti ekutanga kune rimwe bhuku rebasa

Kana iyo faira ichiita seyakaora kana kuramba ichitadza kuchengetedza, nzira inobatsira ndeye fambisa mapepa ose (kunze kwepepa rimwe chete rekuzadza) kubhuku rekushanda idzva. A) Hongu:

1. Wedzera pepa rekuzadza ne Shift + F11.
2. Boka mapepa ese epakutanga kunze kwepepa rekuzadza (tinya pane yekutanga, Shift-tinya pane yekupedzisira).
3. Kurudyi tinya uye sarudza Fambisa kana Kopa... > sarudza (Bhuku idzva) > Bvuma.

Nenzira iyi, iwe unogona kazhinji kuchengetedza iyo faira nyowani pasina zvikanganiso uye kudzoreredza zvese zvirimo, kusanganisira VBA macros, nekukopa mamodule neruoko. Kana iwe uchida kudzidza zvakawanda nezve nzira yekudzivirira zvikanganiso muExcel, tinokurudzira kuongorora chinyorwa chedu BitLocker kukanganisa muWindows.

4. Sevha semhando yefaira yakasiyana (.xlsx, .xlsm, nezvimwewo)

Dzimwe nguva iyo yekutanga faira fomati inoshatiswa. Kuchinja rudzi rwefaira kunogona kugadzirisa nyaya. Kuita izvi:

1. En Archive, wokudhinda Sevha se.
2. Mukusarudza Tipo, sarudza imwe fomati (semuenzaniso, .xlsm yemafaira ane macros kana .xxx kana yekutanga yaive .xls).

Neizvi unogona kubvisa kusawirirana kwekare kana zvikanganiso zvefomati.

5. Edza kuchengetedza faira kune imwe nzvimbo

Kana iwe uchifungidzira kuti dambudziko ringave riri pakutyaira kwekuenda (semuenzaniso, dhiraivha yekunze, network drive, kana dhairekitori rakarambidzwa), chengetedza faira kune desktop kana imwe yenzvimbo folda wechikwata chako. Izvi zvinobvisa network, mvumo, kana nyaya dzemuchadenga. Zvakare, kana uine chero mibvunzo nezve kudzoreredza mafaera asina kuchengetwa, unogona kutarisa dzidziso yedu pa dzora mafaira eShoko asina kuchengetwa.

6. Chengetedza mafaira matsva kunzvimbo yepakutanga

Gadzira bhuku idzva reExcel uye chengetedza kopi mune imwecheteyo folda pakanga paine yekutanga. Kana usingakwanise, dambudziko ringangove mvumo, nzvimbo isina kukwana padhiraivha, kana kunetsana kwesoftware. Kana iwe ukakwanisa kuchengetedza faira idzva, dambudziko rinogona kunge riri nefomati kana zvirimo zvepakutanga.

7. Tanga Excel mune yakachengeteka mode

Kazhinji Wechitatu-bato plugins anokonzera matambudziko kana uchichengeta mafaera. Kuti uone kana ichi chiri chikonzero:

• 1 sarudzo: Bata pasi kiyi Ctrl uye vhura Excel, simbisa iyo yakachengeteka mode meseji.
• 2 sarudzo: Dhinda Windows + R, anonyora excel / safe ndokurova Enter.

Kana iwe uchikwanisa kuchengetedza mune yakachengeteka modhi, dzima kana bvisa ma-add-ons chimwe nechimwe kusvikira wawana akonzeresa. Kuita izvi:

1. Vhura Excel kazhinji.
2. menyu Archive > mikana > Complements.
3. Pazasi, sarudza COM plugins uye tinya Ir.
4. Bvisa zvese zvekuwedzera uye wotangazve Excel.

8. Tarisai iripo disk nzvimbo

Chimwe chezvikonzero zvechinyakare kusave nenzvimbo yakakwana yemahara. Shandisa File Explorer kutarisa nzvimbo iripo. Kana yakazara, sunungura nzvimbo nekubvisa marara, kudzima mafaira enguva pfupi, kana kuwedzera kupatsanura nemidziyo yakaita se. EaseUS Partition Master kana zvakafanana.

9. Kudzima kwekanguva antivirus software

Mamwe mapurogiramu eantivirus anogona kuongorora mafaera matsva kana zvinyorwa munguva chaiyo, achivharisa kwenguva pfupi kuti asachengetedzwe. Dzima antivirus yako kwenguva uchichengeta, asi yeuka kuimutsa pashure. Kana kukanganisa kwanyangarika, tarisa yako antivirus marongero kuti usasanganise maforodha kwaunochengeta Excel magwaro.

10. Gadzirisa yako Office installation

Kana pasina chinoshanda, kuisirwa kwako Hofisi kunogona kukanganisa. Kugadzirisa:

1. Enda ku Control Panel> Zvirongwa uye Zvimiro.
2. Tsvaga Microsoft Office, tinya kurudyi uye sarudza Kugadziriswa.
3. Sarudza Kugadzirisa nekukurumidza (nekukurumidza) kana Online kugadzirisa (zvakadzama).

Mushure mezvo, edza kuchengetedza mafaera ako eExcel zvakare.

Mhosho chaidzo nemhinduro dzadzo

"Gwaro rekuverenga chete harigone kuwanikwa."

Izvi zvinogona kunge zviri nekuti faira rakanyorwa sekuverenga-chete kana nekuti imwe muenzaniso yakakiyiwa. Mhinduro:

• Ita shuwa kuti une mvumo yekugadzirisa.
• Sevha faira rine zita rakasiyana kana mune imwe nzvimbo.
• Vhara ese maekisi eExcel uye vhurazve imwe chete.

"Disiki rakazara"

Sezvatataura, sunungura nzvimbo padhiraivha kana edza kuchengetedza kune imwe dhisiki. Kana iwe ukachengeta kune ekunze madhiraivha, ita shuwa kuti akabatana nemazvo uye usazodimburwa panguva yekuchengeta.

"Zita refaira harisi kushanda"

Tarisa kuti nzira yese (kusanganisira maforodha nemazita emafaira) haipfuure mavara 218. Kana zvirizvo, pfupisa nzira nekuchengetedza faira mumudziyo folda (senge C: \) uye shandisa zita pfupi.

Zvikanganiso paunenge uchichengetedza kunetiweki nzvimbo

Kana iwe uri kushanda panetiweki uye uchirasikirwa nekubatana kwako uchishanda, Excel inogona kudzivirira kuchengetedza uye kunyange kuratidza mhosho meseji nezve isingasvikike network nzira. Kana izvi zvikaitika:

• Sevha faira munzvimbo uye ikopidze kumashure kune network drive kana kubatana kwadzoreredzwa.
• PaWindows network, unogona kushandura registry kuti uvandudze kusimba kune netsaona kubviswa.

Zvikanganiso zvine chekuita neVisual Basic for Applications (VBA)

Kana iyo faira ichisanganisira macros kana VBA uye ikashatiswa, Unogona kuedza kuigadzirisa nekudzima mapurojekiti eVBA akakuvadzwa.. Semhinduro yepamusoro, Inokurudzirwa kugadzira kopi yekuchengetedza uye shandisa yakarongeka yekuchengetedza yekuona maturusi kubvisa zvinhu zvine huori usati wavhurazve uye kuchengetedza gwaro.

Matambudziko nemafaira akakuvadzwa kana akashatiswa

Kana iwe uchifungidzira kuti faira rako raora, Excel inosanganisira basa rekuita kuvhura uye kugadzirisa:

1. Vhura Excel, enda ku Archive > Vhura.
2. Sarudza faira ine dambudziko.
3. Pabhatani rakavhurika, tinya museve wepasi uye sarudza kuvhura uye kugadzirisa.

Muzviitiko zvakaoma, iwe unogona kutendeukira kune wechitatu-bato maturusi akadai Wondershare Dzosera o Stellar Kugadzirisa kweExcel, iyo inokutendera kuti ugadzirise mafaira akakuvadzwa nekudzoreredza matafura, mafomula uye zvimwe zvinhu.

Mazano ekudzivirira uye kudzoreredza kwemafaira asina kuchengetwa

Kuti udzivise kurasikirwa nebasa rako mune ramangwana, zvakakosha kuti:

• Gonesa uye gadzirisa autosave: Nenzira iyi Excel inochengetedza otomatiki shanduro nguva nenguva.
• Batanidza account yako yeMicrosoft uye shandisa OneDrive: Izvi zvinokutendera kuti uchengetedze otomatiki backups mugore.
• Gadzirisa iyo auto-save frequency: Unogona kuderedza nguva kuti uwedzere kuchengetedzeka kwedata rako.

Nzira yekudzorera sei mafaira asina kuchengetwa?

Kana iwe wakavhara Excel usina kuchengetedza, edza nzira idzi:

• Vhura Excel, enda ku Archive > Mashoko > Manage book > Dzora mabhuku asina kuchengetwa. Pano unogona kuwana shanduro dzenguva pfupi.
• Tsvaga mafaira enguva pfupi mukati C:\Users\YourName\AppData\Local\Temp (chinja "Zita Rako" kune zita rako rekushandisa). Tsvaga mafaira ane extension .tmp.

Idzi nzira dzinowedzera mikana yekudzoreredza basa rako mushure mekutadza kusingatarisirwe.

Mazano uye matipi ekudzivirira zvikanganiso zvenguva yemberi muExcel

• Gara uchichengeta Office ichienderana kutora mukana wekuchengetedza zvigamba uye kugadzirisa.
• Dzivisa kushanda pamafaira akachengetwa chete pa USB madhiraivha kana nzvimbo dzisina kugadzikana dzenetiweki.
• Ita kakawanda makopi munzvimbo dzakasiyana (munharaunda, gore, kunze drive).
• Chenjerera kune zvisina kusimbiswa yechitatu-bato maadd-ons wodzidzima kana usingadzide.
• Tarisa nzvimbo yako yekuchengetedza usati washanda nemafaira makuru.

Iyi seti yemazano inobatsira kuderedza mikana yekukanganisa paunenge uchichengetedza muExcel uye chengetedza kuvimbika kwedata rako nguva dzese.