Izindlela Ezi-3 Zokusetha Iphasiwedi Ukuze Uvikele Idokhumenti ye-Excel

Amanye amaspredishithi e-Microsoft Excel kufanele avikelwe emehlweni, isibonelo, lokhu kuyasiza kumadokhumenti anedatha yebhajethi. Kunengozi yokulahleka kwedatha ngephutha kumathebula aphethwe abantu abambalwa, futhi ukuze uvimbele lokhu kungenzeki, ungasebenzisa ukuvikela okwakhelwe ngaphakathi. Ake sihlaziye wonke amathuba okuvimbela ukufinyelela kumadokhumenti.

Ukusetha iphasiwedi yamashidi nezincwadi

Kunezindlela eziningana zokuvikela yonke idokhumenti noma izingxenye zayo - amashidi. Ake sicabangele ngayinye yazo isinyathelo ngesinyathelo. Uma ufuna ukuyenza ukuze ukwaziswa kwephasiwedi kuvele lapho uvula idokhumenti, kufanele usethe ikhodi lapho ulondoloza ifayela.

1. Vula ithebhu yemenyu ethi "Ifayela" bese uthola ingxenye ethi "Londoloza Njenge". Inenketho ethi "Phequlula", futhi kuzodingeka ukuthi usethe iphasiwedi. Ezinguqulweni ezindala, ngokuchofoza okuthi “Londoloza Njenge” kuvula iwindi lokuphequlula ngokushesha.
2. Lapho iwindi lokulondoloza livela esikrinini, udinga ukuthola ingxenye ethi “Amathuluzi” ezansi. Ivule bese ukhetha inketho ethi "Izinketho Ezijwayelekile".

3. Iwindi lezinketho ezijwayelekile likuvumela ukuthi ukhawulele ukufinyelela kudokhumenti. Ungasetha amaphasiwedi amabili - ukubuka ifayela kanye nokuguqula elikuqukethe. Ukufinyelela kokufunda Kuphela kusethwe njengokufinyelela okukhethwa kukho ngefasitela elifanayo. Gcwalisa izinkambu zokufaka iphasiwedi bese uchofoza inkinobho ethi "KULUNGILE" ukuze ulondoloze izinguquko.

4. Okulandelayo, kuzodingeka uqinisekise amaphasiwedi - uphinde uwafake ngendlela efanele ngokulandelana. Ngemva kokuchofoza inkinobho ethi "KULUNGILE" efasiteleni lokugcina, idokhumenti izovikelwa.

5. Kuhlala kuphela ukulondoloza ifayela, ngemva kokusetha amaphasiwedi uhlelo lubuyisela umsebenzisi efasiteleni lokulondoloza.

Ngokuzayo uma uvula incwadi yokusebenzela ye-Excel, kuzovela iwindi lokufaka iphasiwedi. Uma amakhodi amabili esethiwe - ukubuka nokushintsha - ukungena kwenzeka ngezigaba ezimbili. Akudingekile ukufaka iphasiwedi yesibili uma ufuna ukufunda idokhumenti kuphela.

Enye indlela yokuvikela idokhumenti yakho ukusebenzisa izici ezisengxenyeni ethi Ulwazi.

1. Vula ithebhu "Ifayela" futhi uthole ingxenye "Imininingwane" kuyo. Enye yezinketho zesigaba ithi “Izimvume”.
2. Imenyu yezimvume ivulwa ngokuchofoza inkinobho ethi “Vikela Ibhuku”. Into yesibili ohlwini iyadingeka - "Bethela ngephasiwedi". Ikhethe ukuze usethe ikhodi yokufinyelela.

3. Faka iphasiwedi entsha ebhokisini lokubethela. Okulandelayo, uzodinga ukukuqinisekisa kuwindi elifanayo. Ekugcineni, cindezela inkinobho ethi "OK".

Nakani! Ungaqonda ukuthi inketho inikwe amandla uhlaka oluwolintshi oluzungeza isigaba "Izimvume".

Ukusetha iphasiwedi yamaseli ngamanye

Uma udinga ukuvikela amanye amaseli ekuguquleni noma ekususeni ulwazi, ukubethela kwephasiwedi kuzosiza. Setha isivikelo usebenzisa umsebenzi othi “Vikela Ishidi”. Isebenza kulo lonke ishidi ngokuzenzakalelayo, kodwa ngemva kwezinguquko ezincane kuzilungiselelo izogxila kuphela ebangeni elifunekayo lamaseli.

1. Khetha ishidi bese uchofoza kwesokudla kulo. Kuzovela imenyu lapho udinga ukuthola khona umsebenzi othi “Fometha Amaseli” bese uwukhetha. Iwindi lezilungiselelo lizovuleka.
2. Khetha ithebhu "Ukuvikela" efasiteleni elivulayo, kukhona amabhokisi okuhlola amabili. Kudingekile ukuthi ungakhethi iwindi eliphezulu - "Iseli elivikelwe". Iseli okwamanje alivikelekile, kodwa alikwazanga ukushintshwa uma iphasiwedi isisethiwe. Okulandelayo, chofoza "OK".

3. Sikhetha amaseli adinga ukuvikelwa, bese senza isenzo sokuhlehla. Udinga ukuvula okuthi “Fometha amaseli” futhi bese uqoka ibhokisi elithi “Iseli elivikelwe”.
4. Kuthebhu ethi "Buyekeza" kunenkinobho ethi "Vikela ishidi" - chofoza kulo. Iwindi lizovuleka ngochungechunge lwephasiwedi kanye nohlu lwezimvume. Sikhetha izimvume ezifanele - udinga ukuhlola amabhokisi eduze kwazo. Okulandelayo, udinga ukuza nephasiwedi ukuze ukhubaze ukuvikela. Lapho konke kwenziwa, chofoza "OK".

Uma uzama ukushintsha okuqukethwe kweseli, umsebenzisi uzobona isexwayiso sokuvikela kanye nemiyalelo yokuthi usisusa kanjani isivikelo. Labo abangenalo iphasiwedi ngeke bakwazi ukwenza izinguquko.

Qaphela! Ungathola nomsebenzi othi “Vikela Ishidi” kuthebhu ethi “Ifayela”. Udinga ukuya esigabeni solwazi futhi uthole inkinobho ethi “Izimvume” enokhiye nokhiye.

Ukusetha iphasiwedi esakhiweni sebhuku

Uma ukuvikelwa kwesakhiwo kusethiwe, kunemikhawulo eminingana ekusebenzeni nedokhumenti. Awukwazi ukwenza okulandelayo ngencwadi:

• kopisha, qamba kabusha, susa amashidi ngaphakathi kwencwadi;
• dala amashidi;
• vula amashidi afihliwe;
• kopisha noma uhambise amashidi kwezinye izincwadi zokusebenza.

Ake sithathe izinyathelo ezimbalwa ukuvimba izinguquko zesakhiwo.

1. Vula ithebhu ethi "Buyekeza" bese uthola inketho ethi "Vikela incwadi". Le nketho ingabuye itholakale kuthebhu ethi "Ifayela" - isigaba "Imininingwane", umsebenzi "wemvume".

2. Iwindi lizovuleka ngenketho yokuvikela kanye nenkundla yokufaka iphasiwedi. Faka uphawu eduze kwegama elithi “Isakhiwo” bese uqhamuka nephasiwedi. Ngemva kwalokho, udinga uchofoze inkinobho "OK".

3. Siqinisekisa iphasiwedi, futhi isakhiwo sencwadi siyavikeleka.

Ungayikhipha kanjani iphasiwedi kudokhumenti ye-Excel

Ungakhansela ukuvikelwa kwedokhumenti, amaseli noma incwadi yokusebenzela endaweni efanayo lapho ifakwe khona. Isibonelo, ukuze ususe iphasiwedi kudokhumenti futhi ukhansele umkhawulo wezinguquko, vula iwindi lokulondoloza noma lokubethela bese usula imigqa ngamaphasiwedi ashiwo. Ukuze ususe amaphasiwedi kumashidi nezincwadi, udinga ukuvula ithebhu ethi “Buyekeza” bese uchofoza izinkinobho ezifanele. Kuzovela iwindi elinesihloko esithi “Susa ukuvikela”, elidinga ukuthi ufake iphasiwedi. Uma ikhodi ilungile, ukuvikela kuzokwehla futhi izenzo ezinamaseli namashidi zizovuleka.

Kubalulekile! Uma iphasiwedi ilahleka, ayikwazi ukutholwa. Uhlelo luhlale luxwayisa ngalokhu uma ufaka amakhodi. Kulokhu, izinsizakalo zezinkampani zangaphandle zizosiza, kodwa ukusetshenziswa kwazo akuphephile ngaso sonke isikhathi.

Isiphetho

Ukuvikelwa okwakhelwe ngaphakathi kwedokhumenti ye-Excel ekuhleleni kunokwethenjelwa impela - akunakwenzeka ukuthola iphasiwedi, idluliselwa kubantu abathembekile noma ihlala nomdali wetafula. Ukufaneleka kwemisebenzi yokuvikela ukuthi umsebenzisi akakwazi ukukhawulela ukufinyelela hhayi kuphela kuthebula lonke, kodwa namaseli ngamanye noma ukuhlela ukwakheka kwebhuku.