Iikhowudi zemposiso eziqhelekileyo zeMicrosoft Excel kunye nendlela yokuzilungisa
Nantsi ukujonga kwezinye zeekhowudi zempazamo zeMicrosoft Excel kunye nendlela onokuzilungisa ngayo.
- I-Excel ayikwazi ukuvula (igama lefayile) .xlsx : Ukuba ubona le mpazamo, zama ukuvula ifayile Windows 10 File Explorer.Okanye uyikhangele ngesandla. Ifayile isenokuba isusiwe okanye icinyiwe kwaye ayilungiswanga kuluhlu lweefayile ze-Excel.
- Le fayile yonakele kwaye ayikwazi ukuvulwa: Ngale mpazamo, vula ifayile njengesiqhelo nge-Excel. Kodwa, cofa kwitolo ecaleni kweqhosha ukuvula kwaye ucofe vula kwaye ulungise . Uya kukwazi ukubuyisela idatha.
- Olu xwebhu lubangele impazamo enkulu ngexesha lokugqibela lwaluvulwa: Ukusombulula le ngxaki, iMicrosoft icebisa ukuba ucime izongezo.
- Kwenzeke imposiso xa kuthunyelwa imiyalelo kwinkqubo: Ukuba ufumana le mpazamo, kunokwenzeka ukuba kungenxa yenkqubo ethile esebenza kwi-Excel, ethintela i-Excel ngokwayo ekuvaleni.
Ngamanye amaxesha xa usebenzisa iMicrosoft Excel, unokuphela nekhowudi yempazamo. Oku kusenokuba ngenxa yezizathu ezininzi. Ifayile yakho inokuba ilahlekile okanye yonakele. Ungakhathazeki, nangona kunjalo, singakwicala lakho. Nantsi ukujonga kwezinye zeekhowudi zempazamo zeMicrosoft Excel kunye nendlela onokuzilungisa ngayo.
I-Excel ayikwazi ukuvula (igama lefayile) .xlsx
Eyokuqala kuluhlu lwethu yimpazamo eqhelekileyo enxulumene ne-Exel engavuli ukuvula ifayile. Oku kwenzeka xa ifayile oyivulayo yonakele, yonakele, okanye isusiwe kwindawo yayo yokuqala. Inokwenzeka kwakhona xa ulwandiso lwefayile lungasebenzi. Ukuba ujonge ukusombulula le ngxaki, sicebisa ukuba ukhangele ngesandla kwaye uvule ifayile kwindawo oye wayikhumbula ngexesha lokugqibela uyigcinile, ngokufumana kunye nokucofa kabini kwifayile. Musa ukuyivula ngokuthe ngqo kwi-Excel okanye kuluhlu lweefayile ze-Excel. Sikwacebisa ukuba ujonge iintlobo zeefayile xa ugcina iifayile kwaye uqiniseke ukuba zikwi-.xlsx okanye ifomathi ehambelanayo ye-Excel.
Le fayile yonakele kwaye ayikwazi ukuvulwa
Okulandelayo yimposiso malunga urhwaphilizo lwefayile. Ukuba ubona le mpazamo, ingxaki inokwenzeka ngefayile. Kukho into malunga nefayile eyenza ukuba i-Excel ihlehle.
Ukusombulula le ngxaki, i-Excel iya kuzama ukuyilungisa ngokuzenzekelayo incwadi yomsebenzi. Kodwa, ukuba oko akusebenzi, sicebisa ukuba uzilungise ngokwakho. Ukwenza oku, cofa ifayile , ilandelwe ngu vula . Emva koko, cofa uphononongo Yiya kwindawo kunye nefolda apho incwadi yomsebenzi ikhoyo.
Emva kokuba uyifumene, cofa utolo olusecaleni kwayo ukuvula iqhosha kwaye ucofe vula kwaye ulungise . Uya kuba nakho ukufumana kwakhona idatha, kodwa ukuba oko akusebenzi, unokukhupha idatha ukuze ukhuphe amaxabiso kunye neefomula kwincwadi yomsebenzi. Ukuba konke okunye kuyasilela.
Olu xwebhu lubangele impazamo enkulu ngexesha lokugqibela luvulwa ngalo
Ikhowudi yesithathu eqhelekileyo yempazamo ye-Excel yeyona ixhaphakileyo kwiinguqulelo ezindala ze-Excel (eyayifudula iqala ukukhutshwa kweMicrosoft 365.) Ukuba ubona impazamo ethi "Olu xwebhu lubangele impazamo enkulu ngexesha lokugqibela luvulwa," mhlawumbi ithetha ukuba Inxulumene nomba wokuseta kwi-Excel. Ngokutsho kweMicrosoft, oku kuya kwenzeka xa ifayile ibandakanyiwe kuluhlu lweefayile ezikhubazekileyo zeOfisi. Inkqubo iyakongeza ifayile kolu luhlu ukuba ifayile ibangela impazamo ebulalayo.
Ukusombulula le ngxaki, iMicrosoft icebisa ukuba ucime izongezo. Okokuqala, cofa ifayile , Emva koko Iinketho , Emva koko cofa imisebenzi eyongezelelweyo. kuluhlu Ulawulo Cofa Izongezo zeCOM , emva koko ucofe utshintsho . Kwi-COM Izongezo zebhokisi yencoko yababini, cima ibhokisi yokukhangela kuyo nayiphi na izongezo kuluhlu olunikiweyo, kwaye ngoku nqakraza KULUNGILE. Emva koko kufuneka uqale kabusha i-Excel, kwaye uxwebhu kufuneka luphinde luvuleke.
Kwenzeke imposiso ngexesha kuthunyelwa imiyalelo kwinkqubo
Ekugqibeleni, kukho enye ingxaki eqhelekileyo kwiinguqulelo ezindala ze-Excel. Ngale nto, uya kufumana umyalezo wempazamo othi "Kwenzeke impazamo ngelixa uthumela imiyalelo kwinkqubo". Ukuba ufumana le mpazamo, kunokwenzeka ukuba kungenxa yenkqubo ethile esebenza kwi-Excel, ethintela i-Excel ngokwayo ekuvaleni.
Kwakhona, lo ayisingomba ngeMicrosoft 365 apps yanamhlanje, kwaye igubungela kuphela iinguqulelo ezindala zeExcel. Njengesigqibo, khetha ifayile , ilandelwe ngu ngokhetho . Ukusuka apho, khetha phambili kwaye uskrolele ezantsi ukuya ngokubanzi icandelo, cima ibhokisi yokukhangela Ungazihoyi ezinye iinkqubo ezisebenzisa utshintshiselwano lwedatha oluguqukayo (DDE) Emva kokuba wenze oku, cofa u-Kulungile. Oku kufuneka kuyisombulule ingxaki.
Jonga enye i-coverage yethu
Njengoko singena nzulu kwii-apps zikaMicrosoft 365, olu lukhuselo lwethu lwamva nje. Siphinde sajonga ezinye zeempazamo zefomula ye-Excel kunye nendlela yokuzilungisa. Siye sachaza ngaphambili Top 5 Excel Tips kunye namaqhinga I-Excel, yabaqalayo kunye nabanobuchule kwi-Excel.
