Ukukhipha isivikelo ekhasini lokusebenzela le-Excel kanye nencwadi yokusebenzela

Ukuze kuvikelwe idatha kokubili kubantu abangagunyaziwe nasezenzweni zabo zephutha, abasebenzisi bangasetha isivikelo kumadokhumenti e-Excel. Maye, akuwona wonke umuntu owaziyo ukuthi angasisusa kanjani isivikelo esinjalo ukuze athole ukufinyelela olwazini, okuhlanganisa nokukwazi ukukuhlela. Futhi kuthiwani uma ifayela lamukelwe komunye umsebenzisi okhohlwe ukusinika igama-mfihlo, noma silikhohlwe ngephutha (lahleka)? Ake sibhekisise.

Qaphela ukuthi kunezindlela ezimbili zokukhiya idokhumenti ye-Excel: vikela ishidi lokusebenzela noma incwadi yokusebenzela. Ngakho-ke, yiziphi izinyathelo okudingeka zithathwe ukuyivula kuzoncika kulokhu.

Ukukhipha isivikelo encwadini

1. Uma sizama ukuvula idokhumenti evikelekile, esikhundleni sokuqukethwe kwayo, kuzovezwa iwindi lolwazi lapho sidinga ukufaka khona iphasiwedi ukuze sisuse ukuvikela.
2. Ngemva kokufaka iphasiwedi efanele bese ucindezela inkinobho OK, okuqukethwe kwefayela kuzovezwa.
3. Uma udinga ukususa ukuvikela kwedokhumenti unomphela, vula imenyu "Fayela".
4. Chofoza ingxenye "Intelligence". Engxenyeni engakwesokudla yewindi, chofoza inkinobho “Vikela Incwadi”, ohlwini oluvulayo, sidinga umyalo - "Bethela ngephasiwedi".
5. Iwindi lokubethela idokhumenti elinephasiwedi lizovela esikrinini. Isule, bese uchofoza OK.
6. Chofoza isithonjana se-floppy disk ukuze ulondoloze idokhumenti. Noma ungasebenzisa umyalo “Gcina” imenyu "Fayela".
7. Iphasiwedi isusiwe futhi ngesikhathi esilandelayo lapho ifayela livulwa, ngeke licelwe.

Ukukhipha isivikelo eshidini

Iphasiwedi yokuvikela ingasethwa hhayi kuphela kuyo yonke idokhumenti, kodwa neshidi elithile. Kulokhu, umsebenzisi uzokwazi ukubona okuqukethwe kweshidi, kodwa ngeke akwazi ukuhlela ulwazi.

Ukuze ungavikeli ishidi, landela lezi zinyathelo:

1. Shintshela kuthebhu "Buyekeza"… Cindezela inkinobho “Susa ukuvikelwa kweshidi”, etholakala eqenjini lamathuluzi "Ukuvikela".
2. Kuzovela iwindi elincane, lapho sifaka khona iphasiwedi esethwe ngaphambilini bese uchofoza OK.
3. Ngenxa yalokho, ukukhiya kweshidi kuzokhutshazwa, futhi manje sesingakwazi ukulungisa ulwazi ngokuphephile.

Shintsha ikhodi yefayela ukuze ususe ukuvikeleka kweshidi

Le ndlela iyadingeka ezimeni lapho iphasiwedi ilahleka noma ingadluliswanga kanye nefayela komunye umsebenzisi. Isebenza kuphela maqondana naleyo mibhalo evikelwe ezingeni lamashidi ngamanye, hhayi yonke incwadi, ngoba. sidinga ukungena kumenyu "Fayela", okuyinto engenakwenzeka uma iphasiwedi-ivikela yonke idokhumenti.

Ukuze ususe ukuvikela, kufanele wenze ukulandelana kwezenzo ezilandelayo:

1. Hamba uqonde esinyathelweni sesi-4 uma isandiso sefayela sikhona I-XLSX (Книга Excel). Uma ifomethi yedokhumenti ingu I-XLS (I-Excel Workbook 97-2003), kufanele uqale uyigcine kabusha ngesandiso osifunayo. Ukuze wenze lokhu, yiya kumenyu "Fayela".
2. Khetha ohlwini olungakwesokunxele "Igcine njenge", bese engxenyeni engakwesokudla yewindi, chofoza inkinobho “Buyekeza”.
3. Efasiteleni elivelayo, khetha noma iyiphi indawo ekahle yokugcina ifayela, setha ifomethi "Incwadi ye-Excel" bese uchofoza OK.
4. Vula ku- ukuhlola Ifolda yedokhumenti ye-XLSX (esanda kugcinwa noma ekhona ngaphambili). Ukuze unike amandla izandiso zefayela, hamba kuthebhu "Buka", lapho sinika amandla inketho oyifunayo eqenjini lamathuluzi “Bonisa noma fihla”.Qaphela: izinyathelo zesistimu yokusebenza kulesi sinyathelo nangezansi zichazwa kusetshenziswa Windows 10 njengesibonelo.
5. Chofoza kwesokudla kudokhumenti futhi ohlwini oluvulayo, chofoza umyalo "Qamba kabusha" (noma ungavele ucindezele ukhiye F2, ngemva kokukhetha ifayela).
6. Esikhundleni sokunwetshwa "xlsx" bhala "zip" futhi uqinisekise ushintsho.
7. Manje uhlelo luzohlonza ifayela njengengobo yomlando, okuqukethwe kwakho okungavulwa ngokuchofoza kabili inkinobho yegundane kwesokunxele.
8. Kufolda evuliwe, iya kuhla lwemibhalo "xl", bese - "amaphepha okusebenzela". Lapha sibona amafayela ngefomethi XML, equkethe ulwazi mayelana namashidi. Ungawavula ngokujwayelekile I-Notepad.Qaphela: ku Windows 10, unganikeza uhlelo oluzenzakalelayo ngohlobo lwefayela kuzilungiselelo zesistimu (eyethulwe ngokucindezela izinkinobho Win + Mina), Esahlukweni "Izinhlelo zokusebenza", bese - "Izinhlelo zokusebenza ezizenzakalelayo" - "Ukukhethwa kwezicelo ezijwayelekile zezinhlobo zamafayela".
9. Ngemva kokuvula ifayela ngempumelelo, sidinga ukuthola umushwana kokuqukethwe kwawo "SheetProtection". Ukuze senze lokhu, sizosebenzisa ukusesha, okungase kwethulwe kokubili ngemenyu "Hlela" (into “Thola”), noma ngokucindezela inhlanganisela yezinkinobho Ctrl + F.
10. Faka umusho owufunayo bese ucindezela inkinobho “Thola okulandelayo”.
11. Ngemva kokuthola okufanayo oyifunayo, iwindi lokusesha lingavalwa.
12. Sisula umusho nakho konke okuhlobene nawo (phakathi kwamathegi okuvula nawokuvala).
13. Kumenyu "Fayela" khetha iqembu "Igcine njenge" (noma cindezela isinqamuleli sekhibhodi Ctrl + Shift + S).
14. Ukulondoloza idokhumenti ngokushesha kungobo yomlando ngeke kusebenze. Ngakho-ke, sikwenza kunoma iyiphi enye indawo esilungele kukhompuyutha, kuyilapho singashintshi igama futhi sicacisa isandiso "xml" (uhlobo lwefayela kufanele lukhethwe - "Wonke amafayela").
15. Kopisha ifayela elisanda kwakhiwa kufolda "amaphepha okusebenzela" ingobo yomlando yethu (ngokushintshwa kweyokuqala).Qaphela: irekhodi "SheetProtection" ikhona kuwo wonke amafayela eshidi avikelwe ngephasiwedi. Ngakho-ke, izenzo ezichazwe ngenhla zokuyithola nokuyisusa zenziwa ngawo wonke amanye amafayela. XML kufolda "amaphepha okusebenzela".
16. Futhi siya kufolda equkethe ingobo yomlando yethu futhi sibuyisele emuva isandiso sisuka "zip" on "xlsx" ngokuqamba kabusha.
17. Manje usungakwazi ukuvula ifayela futhi ulihlele ngokuphephile. Awudingi ukufaka iphasiwedi ukuze ungavikeli.

Abakhiphi iphasiwedi benkampani yangaphandle

Ungasebenzisa izinhlelo zezinkampani zangaphandle ukuze ususe iphasiwedi yakho. Ngesikhathi esifanayo, kufanelekile ukukhumbula ingozi engenzeka ehlobene nokulanda, ukufaka nokusebenzisa amathuluzi angajwayelekile wesistimu yokusebenza kanye ne-Excel.

Uma, noma kunjalo, unquma ukusebenzisa leli thuba, ungakwazi ukunaka uhlelo oludumile. I-Accent OFFICE Ukubuyisela Iphasiwedi.

Xhumanisa nekhasi elisemthethweni nohlelo: .

Sicela uqaphele ukuthi ukuze uthole ukufinyelela kuyo yonke imisebenzi yohlelo, udinga ukuthenga ilayisense. Inguqulo yedemo iyatholakala ukuze ujwayelane nohlelo, nokho, ayikuvumeli ukuthi ususe amaphasiwedi.

Isiphetho

Ukuvikela incwadi yokusebenzela noma ishidi elilodwa kuyisici esiwusizo kakhulu sohlelo lwe-Excel lapho udinga ukuvikela imininingwane kubantu abangagunyaziwe noma, ngokwesibonelo, uzivikele ezinguqukweni zephutha zedatha ebalulekile yokufunda kuphela. Kodwa ngezinye izikhathi kuphakama isidingo esiphambene - ukususa isivikelo esifakwe ngaphambilini. Lokhu kungenziwa ngezindlela ezahlukene, kuye ngokuthi ifakwe kanjani. Futhi noma ngabe ukhohlwe iphasiwedi, ukukhiya kungasuswa, noma kunjalo, kuphela uma ikhodi isethelwe amashidi ngamanye, hhayi yonke incwadi.