Ungakhiya kanjani noma uvule kanjani amaseli ku-Excel?

Kwesinye isikhathi awufuni ukuthi amanye amaseli kushidi lakho le-excel ashintshwe. Ungakwenza lokho ngokufunda ukukhiya noma ukuvula amaseli ku-excel.

I-Microsoft Excel isinika indlela enhle kakhulu yokugcina idatha yethu efomini lethebula futhi elihlelekile. Kodwa le datha ingashintshwa lapho yabelwa phakathi kwabanye abantu. Uma ufuna ukuvikela idatha yakho ezinguqukweni zamabomu, ungavikela amashidi akho e-Excel ngokuwakhiya. Kodwa, lesi isinyathelo esidlulele okungenzeka singancomi. Kunalokho, ungakhiya amaseli athile, imigqa, namakholomu futhi. Isibonelo, ungavumela abasebenzisi ukuthi bafake idatha ethile kodwa bakhiye amaseli ngolwazi olubalulekile. Kulesi sihloko, sizobona izindlela ezahlukene vala noma uvule amaseli ku-Excel.

Okuqukethwe[ fihla ]

• Ungakhiya kanjani noma uvule kanjani amaseli ku-Excel?
• Ungawakhiya kanjani wonke amaseli ku-Excel?
• Indlela Yokukhiya Nokuvikela Amaseli Ngamunye ku-Excel?
• Ungawavula Kanjani Futhi Ungavikeli Amaseli ku-Excel Sheet?
• Ungawavula Kanjani Amaseli Akhethekile Eshidini Elivikelwe?

Ungakhiya kanjani noma uvule kanjani amaseli ku-Excel?

Ungakwazi ukukhiya ishidi lonke noma ukhethe amaseli ngamanye kuye ngezinqumo zakho.

Ungawakhiya kanjani wonke amaseli ku-Excel?

Ukuvikela wonke amaseli ku I-Microsoft Excel , kufanele nje uvikele ishidi lonke. Wonke amaseli eshidini azovikelwa kunoma yikuphi ukubhala ngokweqile noma ukuhlela ngokuzenzakalela.

1. Khetha ' Vikela Ishidi ' kusukela phansi kwesikrini ku-' Ithebhu Yeshidi Lokusebenza ' noma ngokuqondile kusukela ku-' Ithebhu yokubuyekeza 'kwe Ishintsha iqembu .

2. Ithi ‘ Vikela Ishidi ’ liyavela ibhokisi lengxoxo. Ungakhetha ukuvikela ishidi lakho le-Excel ngephasiwedi noma ushiye ' iphasiwedi vikela ishidi lakho le-Excel ' inkambu ayinalutho.

3. Khetha izenzo ohlwini ofuna ukuzivumela eshidini lakho elivikelwe bese uchofoza u-'KULUNGILE.'

4. Uma ukhetha ukufaka iphasiwedi, a ‘ Qinisekisa Iphasiwedi ' ibhokisi lengxoxo lizovela. Thayipha iphasiwedi yakho futhi ukuze uqedele inqubo.

Funda futhi: Ungalisusa kanjani iphasiwedi kufayela le-Excel

Indlela Yokukhiya Nokuvikela Amaseli Ngamunye ku-Excel?

Ungakwazi ukukhiya iseli elilodwa noma uhla lwamaseli ngokulandela lezi zinyathelo ezingezansi:

1. Khetha amaseli noma ububanzi ofuna ukuwavikela. Ungakwenza ngegundane noma ngokusebenzisa okhiye bokushintsha kanye nemicibisholo kumagama akho angukhiye. Sebenzisa i- Ctrl ukhiye kanye negundane ukukhetha amaseli angasondelene nobubanzi .

2. Uma ufuna ukukhiya amakholomu onke kanye nemigqa, ungawakhetha ngokuchofoza ikholomu yawo noma uhlamvu lwemigqa. Ungaphinda ukhethe amakholomu amaningi ancikene ngokuchofoza kwesokudla kugundane noma usebenzisa ukhiye we-shift kanye negundane.

3. Ungaphinda ukhethe amaseli anamafomula kuphela. Kuthebhu ethi Ikhaya, chofoza Iqembu lokuhlela bese ' Thola bese Khetha '. Chofoza ku- Iya kokuthi Okukhethekile .

4. Engxoxweniibhokisi, khetha i Amafomula inketho bese uchofoza KULUNGILE .

5. Uma usuwakhethile amaseli ofisa ukukhiywa, cindezela Ctrl + 1 ndawonye. ‘ Fometha Amaseli ' ibhokisi lengxoxo lizovela. Ungaphinda uchofoze kwesokudla kumaseli akhethiwe bese ukhetha inketho ethi Fometha amaseli ukuvula ibhokisi lengxoxo.

6. Hamba ku-' Ukuvikelwa ' ithebhu bese uhlola ' kukhiyiwe 'inketho. Chofoza ku- KULUNGILE , nomsebenzi wakho usuphelile.

Qaphela: Uma uzama ukukhiya amaseli eshidini le-Excel elivikelwe ngaphambilini, uzodinga ukuvula ishidi kuqala bese wenza inqubo engenhla. Wena ingakhiya noma ivule amaseli ku-Excel ngo-2007, 2010, 2013, kanye nezinguqulo zika-2016.

Ungawavula Kanjani Futhi Ungavikeli Amaseli ku-Excel Sheet?

Ungakwazi ukuvula ngokuqondile lonke ishidi ukuze uvule wonke amaseli ku-Excel.

1. Chofoza ku-' Ishidi elingavikelekile ' use ' Buyekeza ithebhu 'kwe izinguquko iqembu noma chofoza inketho ngokuchofoza kwesokudla ku- Ishidi ithebhu.

2. Manje ungenza noma yiziphi izinguquko kudatha ekumaseli.

3. Ungakwazi futhi ukuvula ishidi usebenzisa ‘ Fometha Amaseli' ibhokisi lengxoxo.

4. Khetha wonke amaseli eshidini ngawo I-Ctrl + A . Bese ucindezela Ctrl + 1 noma chofoza kwesokudla bese ukhetha Fometha Amaseli . Ku-' Ukuvikelwa ' ithebhu yebhokisi lengxoxo lamaseli Afometha, susa ukumaka okuthi ' Kukhiyiwe ' inketho bese uchofoza KULUNGILE .

Funda futhi: Ukulungisa i-Excel ilinde olunye uhlelo lokusebenza ukuqedela isenzo se-OLE

Ungawavula Kanjani Amaseli Akhethekile Eshidini Elivikelwe?

Kwesinye isikhathi ungase ufune ukuhlela amaseli athile eshidini lakho le-Protected Excel. Ngokusebenzisa le ndlela, ungavula amaseli ngamanye eshidini lakho usebenzisa iphasiwedi:

1. Khetha amaseli noma ububanzi obudingayo ukuze uvule eshidini elivikelwe ngephasiwedi.

2. Ku Buyekeza ' ithebhu, chofoza ' Vumela abasebenzisi ukuthi bahlele Ububanzi 'inketho. Udinga ukuvula ishidi lakho kuqala ukuze ufinyelele inketho.

3. Ibhokisi lengxoxo elithi ‘Vumela abasebenzisi Ukuhlela Ububanzi’ liyavela. Chofoza ku-' Okusha 'inketho.

4. A’ Ibanga Elisha ' ibhokisi lengxoxo livela nge Isihloko, Kubhekiselwa kumaseli, futhi Iphasiwedi yobubanzi inkambu.

5. Emkhakheni Wesihloko, nikeza igama ebangeni lakho . Ku-' Kubhekise kuseli ' field, thayipha ububanzi bamaseli. Isivele inabo ububanzi bamaseli akhethiwe ngokuzenzakalelayo.

6. Thayipha i iphasiwedi in the Iphasiwedi field bese uchofoza KULUNGILE .

7. Thayipha futhi iphasiwedi ku-' Qinisekisa Iphasiwedi ' ibhokisi lengxoxo bese uchofoza KULUNGILE .

8. Ububanzi obusha buzongezwa . Ungalandela izinyathelo futhi ukuze udale ububanzi obuningi.

9. Chofoza inkinobho ethi ' Vikela Ishidi ' inkinobho.

10. Thayipha iphasiwedi efasiteleni elithi 'Vikela Ishidi' kulo lonke ishidi kanye khetha izenzo ufuna ukuyivumela. Chofoza KULUNGILE .

ishumi nanye. Thayipha futhi iphasiwedi efasiteleni lokuqinisekisa, futhi umsebenzi wakho usuqedile.

Manje, nakuba ishidi lakho livikelekile, amanye amaseli avikelwe azoba nezinga elingeziwe lokuvikela futhi azovulwa kuphela ngephasiwedi. Ungakwazi futhi ukunikeza ukufinyelela kububanzi ngaphandle kokufaka iphasiwedi njalo:

eyodwa.Lapho wenza uhla, chofoza ' Izimvume 'inketho kuqala.

2. Chofoza ku- Faka inkinobho efasiteleni. Faka igama labasebenzisi ku-' Faka amagama ezinto ozozikhetha 'ibhokisi. Ungathayipha igama lomsebenzisi lomuntu njengoba ligcinwe esizindeni sakho . Chofoza ku- KULUNGILE .

3. Manje cacisa imvume yomsebenzisi ngamunye ngaphansi kokuthi ‘ Amagama eqembu noma abasebenzisi ' bese uhlola inketho ethi Vumela. Chofoza ku- KULUNGILE , nomsebenzi wakho usuphelile.

Kunconyiwe:

• Ungawashintsha kanjani Amakholomu noma Imigqa ku-Excel
• Ungaguqula kanjani ifayela le-Excel (.xls) libe ifayela le-vCard (.vcf)?
• Shintsha Ngokushesha Phakathi Kwamakhasi Okusebenzela ku-Excel
• Uzilungisa Kanjani Izithombe zikaWhatsapp ezingabonisi Kugalari

Zonke lezi bekuyizindlela ezahlukene ongenza ngazo vala noma uvule amaseli ku-Excel. Ukwazi ukuvikela ishidi lakho kuyadingeka kakhulu ukuze ulivikele ezinguqukweni zengozi. Ungakwazi ukuvikela noma ukuvikela amaseli eshidini le-Excel ngesikhathi esisodwa noma ukhethe ububanzi obuthile. Ungakwazi futhi ukunikeza abasebenzisi abathile ukufinyelela ngephasiwedi noma ngaphandle kwayo. Landela izinyathelo ezingenhla ngokucophelela, futhi akufanele ube nenkinga.

U-Pete ungumbhali wabasebenzi Omkhulu eCyber ​​S. UPete uthanda zonke izinto zobuchwepheshe futhi ungu-DIYer oshisekayo enhliziyweni. Uneminyaka eyishumi yesipiliyoni sokubhala indlela yokwenza, izici, nemihlahlandlela yobuchwepheshe ku-inthanethi.