Inani labasebenzisi ingxelo egqwesileyo ayiphenduli xa ndigcina okanye ndingawugcina njani umsebenzi wam xa i-excel ingaphenduli? Oku kwenzeka kakhulu ngenxa yokongeza okufakiweyo okuphazamisana ne-Excel okanye Enye inkqubo engqubana ne-Excel eso siphumo
I-Excel iyekile ukusebenza. Ingxaki ibangele ukuba inkqubo iyeke ukusebenza ngokuchanekileyo. IiWindows ziya kuvala inkqubo kwaye zikwazise ukuba isisombululo sikhona.
Lungisa i-Excel ingaphenduli, ijinga, imise okanye iyeke ukusebenza
Ukuba nawe Ujongene neNgxaki ngeMicrosoft Excel sheet, efana ne-Excel Sheet ayiphenduli, ijinga, ikhenkceke okanye iyeke ukusebenza ngelixa ugcina amaphepha okusebenza okanye ngelixa uzama ukongeza ifomyula, i-Excel sheet 'ifrize' okwethutyana kwaye ibonise umyalezo ongaphenduliyo. Nazi ezinye izisombululo onokufaka isicelo ukuze uzilungise.
Ngaphambi kokuba siqhubele phambili masiqale sibone indlela yokufumana kwakhona iifayile ze-Excel ezingagcinwanga xa i-Excel ingaphenduli.
- Ukuvula ngokulula iphepha elitsha lokugqwesa, Cofa kwifayile -> Incwadi Yokusebenzela yakutsha nje -> jonga amaxwebhu asele esetyenzisiwe e-Excel kwaye ukhethe uxwebhu olungagcinwanga lwe-Excel.
- Cofa Fumana kwakhona Iincwadi Zokusebenzela ezingagcinwanga kwaye ulinde de uxwebhu lwe-Excel lubuyiselwe.
- Incoko yababini evulekileyo iya kuvela, vula uxwebhu olulahlekileyo lwe-Excel kwaye ucofe Gcina njenge ukugcina uxwebhu kwidrive ekhuselekileyo kwiPC.
Ngoku landela la manyathelo angezantsi ukulungisa iPhepha le-Excel lingaphenduli, lijinga, liba ngumkhenkce okanye liyeke ukusebenza ngelixa ugcina amaphepha okusebenza.
Qala i-Excel kwiMowudi eKhuselekileyo
- Vala ngokupheleleyo ngaphandle kwe-Excel (ukuba kukho naliphi na iphepha elivuliweyo apho).
- Cinezela Windows + R, uhlobo |_+_| uze ucinezele Ngena .
Khangela Ukuba i-Excel ivula ngemo ekhuselekileyo, kwaye ingabangeli nayiphi na ingxaki, kunokwenzeka ukuba i-add-ins okanye enye i-software ifakwe ephazamisa isofthiwe. Landela la manyathelo angezantsi ukususa i-Add-ins ekusenokwenzeka ukuba ikulungisele ingxaki.
Susa ezongezo ze-excel
- Khetha Ifayile > Khetha > Izongezo .
- Khetha Excel Add-ins kwi- Lawula imenyu eyehlayo, emva koko ukhethe Hamba... .
Ukuba kukho naziphi na izinto ezikhangelweyo, zama ukungazikhangeli, emva koko ukhethe Kulungile . Oku kuya kuvala ukongeza okunokuthi kubangele umkhenkce.
Vala i-Excel, emva koko uyiqalise ngesiqhelo ukuze ubone ukuba lenze iqhinga.
Ukuba ingxaki isengasonjululwanga kwakhona Ifayile > Khetha > Yongeza-Ins ukusuka ezantsi khetha Izongezo zeCOM , Izenzo , kwaye Iipakethi zoKwandiswa kwe-XML kwaye ubone ukuba ukukhubaza izinto kwezo zikhetho kwenza iqhinga.
Ukuba umba wakho awusonjululwanga emva kokuba uqalise i-Excel ngendlela ekhuselekileyo, qhubeka uye kwinto elandelayo kolu luhlu.
Lungisa iMicrosoft Office
Ukulungisa iphakheji yeofisi yeMicrosoft, ikakhulu susa yonke imiba ngokugqwesa, igama, ukujonga ukwenza oku,
- Yiya ku 'Iphaneli yokulawula> Iinkqubo> Khipha'.
- Jonga uluhlu lwenkqubo kwaye ujonge Microsoft Office. Cofa ekunene kwaye ukhethe 'Tshintsha'.
- Khetha 'Ukulungisa ngokukhawuleza> Lungisa'.
- Lindela de inkqubo yokulungisa igqitywe kwaye uvule kwakhona i-Excel. Ukuba ingxaki isenzeka, khetha inqaku elithi 'Ukulungisa kwi-Intanethi'.
Susa iMithetho Eyiliweyo
Ukuba unengxaki nge-spreadsheet esinye kuphela, amatsha amatsha e-excel sheets asebenza ngokufanelekileyo, kodwa amadala agciniweyo Ikopi ye-excel sheet ebangela ingxaki emkhenkceni, engaphenduli, kufuneka uzame isisombululo esingezantsi.
- Vula ifayile yespreadsheet eyingxaki.
- Yiya 'kwiFayile> Gcina njenge' kwaye uchwetheze igama elahlukileyo. (Kufuneka sikhuphe i-backup sheet Ukuba kukho into engahambi kakuhle).
- Ngoku yiya 'eKhaya> ukuFomatha okuneMiqathango> Imithetho ecacileyo> Imithetho ecacileyo kwiPhepha lonke '. Ukuba i-spreadsheet ineethebhu ezininzi, kufuneka uphinde inyathelo lokucima imithetho.
- Kwaye cinezela Ctrl + S ukugcina uxwebhu, khangela ngoku iphepha lisebenza kakuhle.
Cacisa izinto (iiMilo)
Omnye wabasebenzisi ocetyisiweyo kwiforum yeMicrosoft, izinto ezicacileyo zinceda ukusombulula ukungaphenduli kwe-Excel, kumisa umba. Unokwenza oku ukusuka
- Bamba i-CTRL kwaye ucinezele G ukunyusa i Yiya e ibhokisi.
- Khetha i Ekhethekileyo... iqhosha.
- Isuka e Yiya kwiSpecial isikrini, khetha Izinto , uze ukhethe Kulungile .
- Cinezela Cima .
Lungisa iPhepha le-Excel
Ukuba i-excel sheet enye ibangela ingxaki kuphela, kukho ithuba lokuba iphepha ngokwalo lonakaliswe. Zama ukulungisa iphepha usebenzisa isixhobo sokuLungisa i-Excel.
- Yiya kwiFayile> Vula.
- Cofa kutolo oluncinci oluhlayo kwiqhosha elithi 'Vula'.
- Khetha 'Vula kwaye ulungise ...' kwaye emva koko ukhethe 'Lungisa' ukhetho lokubuyisela iphepha le-Excel.
Ngaba ezi zisombululo ziye zanceda ukubuyisela iifayile ze-Excel ezingagcinwanga xa i-Excel ingaphenduli, Lungisa iingxaki ezahlukeneyo ngamashiti e-Excel? sazise kwiikhomenti ezingezantsi, funda kwakhona Isonjululwe : Windows 10 ukuskena kunye nokulungisa i-drive c ibambelele kwi-100