Ungayibeka njani isigxina se-Auto kwi-Excel

Anonim

I-Microsoft Excel

Ingathandekiyo xa kungenxa yokuphazamiseka ngamandla, ikhompyuter ixhonywe, idatha oyifumene kwitafile, kodwa ayinaxesha lokusindisa, ilahlekile. Ukongeza, ihlala isebenza ngesandla ukuze iqinisekise iziphumo zomsebenzi wakho-oku kuthetha ukuba ukuphazamiseka kwiiklasi eziphambili kwaye uphulukane nexesha elongezelelweyo. Ngethamsanqa, inkqubo ye-Excel inesixhobo esifanelekileyo esifana nokugcinwa ngokuzenzekelayo. Masijongane nendlela yokuyisebenzisa.

Ukusebenza kunye noSeto lwe-Autosove

Ukulungiselela ukukhusela ilahleko yedatha e-Excel, kuyacetyiswa ukuseta useto lwakho lwe-Authershry olwenziweyo ngokuthe ngqo phantsi kweemfuno zakho kunye nobuchule benkqubo.

Isifundo: IMicrosoft Word

Yiya kwiisetingi

Masifumanise ukuba ungafika njani kwizicwangciso ze-Autosove.

  1. Vula i- "Ifayile" yethebhu. Emva koko, sifudukela kwicandelwana elithi "parameter".
  2. Yiya kwizicwangciso zecandelo kwi-Microsoft Excel

  3. Ifestile ye-Excel Ifestile ivuliwe. Cofa kumbhalo kwicala lasekhohlo lefestile "yokonga". Ilapha ukuba zonke iisetingi ozifunayo ziposelwe.

Yiya kwicandelo leMicrosoft Excel

Ukutshintsha useto lwethutyana

Ngokuzenzekelayo, ukugcinwa ngokuzenzekelayo kwenziwa kwaye kuveliswe yonke imizuzu eli-10. Asinguye wonke umntu owanelisayo ixesha elininzi. Emva kwayo yonke loo nto, kwimizuzu eli-10 unokufumana amanqaku amakhulu edatha kwaye angathandekiyo kakhulu ukuba aphulukane kunye namandla kunye nexesha elichithwe ekugcwaliseni itafile. Ke ngoko, abasebenzisi abaninzi bakhetha ukubeka imowudi yolondolozo yemizuzu emi-5, kunye ne-1 yomzuzu.

Ngumzuzu omnye - ixesha elifutshane elinokufakwa. Kwangelo xesha, akufuneki silibale ukuba izibonelelo zenkqubo zichithwe kwinkqubo yokonga, nakwiekhompyuter ezibuthathaka, ufakelo lunokukhokelela ekubeni kuqhutyekwe kwisantya sokusebenza. Ke ngoko, abasebenzisi abaneezixhobo ezindala ngokufanelekileyo bawela kwenye i-rogs-jikelele icime i-Auto. Ewe kunjalo, akucetyiswa ukuba uyenze, kodwa, nangona kunjalo, siya kuthetha kamva, indlela yokuwugcina njani lo msebenzi. Uninzi lweekhompyuter zanamhlanje, nokuba ubeka ixesha lomzuzu omnye - awuyi kuchaphazela indlela yokusebenza kwenkqubo.

Ke, ukutshintsha igama elithi "i-autosave qho" intsimi ifanelekile ukuba ininzi yemizuzu. Imele ukuba ilingane kwaye kuluhlu ukusuka kwi-1 ukuya kwi-120.

I-Dynamics yexesha lokugcina ngokuzenzekelayo kwiMicrosoft Excel

Guqula ezinye iisetingi

Ukongeza, kwicandelo le-SET, unokutshintsha elinye inani lezinye iiparamitha, nangona zingamcebisi ngaphandle kwesidingo sokuchukumisa. Okokuqala, ungagqiba ekubeni zeziphi iifayile eziza kugcinwa ngokuzenzekelayo. Oku kwenziwa ngokukhetha igama lefomathi efanelekileyo kwi "Gcina iifayile kwintsimi elandelayo. Ngokungagqibekanga, le yincwadi ye-Excel (i-XLSX), kodwa kunokwenzeka ukutshintsha olu lwando kwezi zilandelayo:

  • Incwadi i-Excel 1993 - 2003 (XLSX);
  • Incwadi ye-Excel ngenkxaso ye-macros;
  • Itemplate ye-Excel;
  • Iphepha leWebhu (HTML);
  • Isicatshulwa esilula (txt);
  • I-CSV kunye nabanye abaninzi.

Iifomati zokulondolozwa kwiMicrosoft Excel

Kwintsimi ye "Ikhathalogu yeKhathalogu", indlela ihleliwe apho iikopi ezikhuselweyo zeefayile zigcinwa khona. Ukuba unqwenela, le ndlela inokutshintshwa ngesandla.

Indlela yokuya kwi-catogist yokufakelwa ngokuzenzekelayo kwiMicrosoft Excel

"Indawo yendawo engapheliyo" ifikelela kwiNdlela kulawulo apho inkqubo iphakamisa khona ukugcina iifayile zoqobo. Yile folda evula xa ucofa kwiqhosha elithi "Gcina".

Indawo yeefayile ngokungagqibekanga kwiMicrosoft Excel

Khubaza umsebenzi

Njengoko sele kukhankanyiwe apha ngasentla, iikopi zosindiso ezizenzekelayo zeefls ze-Excel zinokukhubazeka. Ukwenza oku, kwanele ukususa i-tick kwi "I-Autosasa yonke" kwaye ucofe iqhosha "Kulungile".

Khubaza ukugcinwa ngokuzenzekelayo kwiMicrosoft Excel

Ngokwahlukileyo, unokukhubaza ukugcinwa kwenguqulo yokugqibela ye-Auto Stop xa ukuvalwa ngaphandle kokugcina. Ukwenza oku, susa uphawu lwento ehambelana nayo.

Ukukhubaza ikopi yokugqibela yeMicrosoft Excel

Njengoko sibona, ngokubanzi, iisetingi zokugcina i-auto kwiNkqubo ye-Excel zilula kakhulu, kwaye izenzo ziqondakale ngokungathandabuzekiyo. Umsebenzisi ngokwawo unako, ethathela ingqalelo iimfuno zayo kunye nezakhono zekhompyuter yekhompyuter, setha irejista yokugcina ifayile ngokuzenzekelayo.

Funda ngokugqithisileyo