Cov teeb meem qhib Excel cov ntaub ntawv

Ua tsis tiav hauv kev sim qhib Excel phau ntawv tsis yog li ntawd ntau zaus, tab sis, txawm li cas los xij, lawv tseem tshwm sim. Cov teeb meem zoo li no tuaj yeem tshwm sim los ntawm kev puas tsuaj rau daim ntawv, nrog rau kev ua haujlwm tsis zoo ntawm lub program lossis txawm tias lub Windows ua ke tag nrho. Cia peb saib cov laj thawj tshwj xeeb ntawm cov teeb meem nrog qhib cov ntaub ntawv, thiab tseem pom tias yuav kho qhov xwm txheej li cas.

Vim li cas thiab daws tau

Ib yam li lwm qhov teeb meem tam sim, kev tshawb nrhiav txoj hauv kev tawm ntawm cov teeb meem teeb meem thaum qhib Excel phau ntawv yog muab zais rau hauv qhov ua rau nws tshwm sim sai. Yog li, ua ntej ntawm txhua yam, nws yog qhov tsim nyog los tsim cov khoom ua tiav uas ua rau cov ntawv thov ua haujlwm tsis zoo.

Txhawm rau kom nkag siab txog lub hauv paus: nyob hauv cov ntaub ntawv nws tus kheej lossis teeb meem software, sim qhib lwm cov ntawv hauv tib daim ntawv thov. Yog tias lawv qhib, peb tuaj yeem xaus tias lub hauv paus cag ntawm qhov teeb meem puas tsuaj rau phau ntawv. Yog tias tus neeg siv tsis ua haujlwm qhib ntawm no, ces qhov teeb meem nyob hauv cov teeb meem ntawm Excel lossis lub operating system. Koj tuaj yeem ua tau lwm txoj kev: sim qhib phau ntawv teeb meem ntawm lwm tus ntaus ntawv. Hauv qhov no, nws txoj kev nrhiav pom muaj txiaj ntsig yuav qhia tau tias txhua yam muaj raws nraim nrog cov ntawv, thiab cov teeb meem yuav tsum tau nrhiav lwm qhov.

Qhov laj thawj 1: teeb meem sib xws

Qhov teeb meem feem ntau ntawm qhov tsis ua tiav thaum qhib Excel ntawv, yog tias nws tsis yog hais txog kev ua kom cov ntaub ntawv nws tus kheej, yog qhov teeb meem sib xyaw. Nws yog tshwm sim tsis yog los ntawm software tsis ua haujlwm, tab sis los ntawm kev siv cov qub version ntawm cov program los qhib cov ntaub ntawv uas tau ua hauv cov ntawv tshiab. Nyob rau tib lub sijhawm, nws yuav tsum raug sau tseg tias tsis yog txhua daim ntawv tsim nyob rau hauv cov ntawv tshiab yuav muaj teeb meem thaum qhib hauv cov ntawv thov dhau los. Ntawm qhov tsis sib xws, feem ntau ntawm lawv yuav pib nquag. Muaj kev zam tau yog qhov uas cov thev naus laus zis tau tshaj tawm tias kev hloov kho qub ntawm Excel tsis tuaj yeem ua haujlwm nrog. Piv txwv li, qhov ua ntej lawm ntawm tus txheej txheem cov lus no tsis tuaj yeem ua haujlwm nrog cov ntawv pov thawj ncig. Yog li ntawv, phau ntawv uas muaj cov khoom no tsis tuaj yeem qhib los ntawm cov ntawv thov qub, tab sis nws yuav nthuav tawm feem ntau ntawm lwm cov ntaub ntawv uas ua hauv cov tshiab.

Hauv qhov no, tsuas muaj ob txoj hauv kev daws qhov teeb meem: xws li qhib cov ntawv zoo li no ntawm lwm cov khoos phis tawj nrog kho tshiab software, lossis nruab ib qho tshiab ntawm Microsoft Office suite ntawm cov teeb meem PC hloov chaw dhau los.

Qhov teeb meem thim rov qab thaum qhib cov ntaub ntawv hauv qhov kev pab cuam tshiab uas tau tsim nyob rau hauv cov laus dhau ntawm daim ntawv thov tsis raug tshawb pom. Yog li, yog tias koj muaj qhov kho kho tshiab version ntawm Excel, tom qab ntawd yuav tsis muaj qhov teeb meem tsis muaj teeb meem ntsig txog kev ua haujlwm thaum qhib cov ntaub ntawv ntawm cov khoos kas ua ntej.

Nyias, nws yuav tsum tau hais txog hom xlsx. Qhov tseeb yog tias nws tau pib siv txij li Excel 2007. Txhua daim ntawv thov dhau los tsis tuaj yeem ua haujlwm nrog nws los ntawm lub neej ntawd, vim hais tias rau lawv xls yog hom "haiv". Tab sis qhov xwm txheej no, qhov teeb meem ntawm kev pib hom ntawv no tuaj yeem daws txawm tias tsis tas kho cov ntawv thov. Qhov no tuaj yeem ua tiav los nruab ib qho tshwj xeeb thaj ntawm Microsoft ntawm cov tshooj qub ntawm qhov kev zov me nyuam. Tom qab ntawd, cov phau ntawv nrog xlsx txuas ntxiv yuav qhib ib txwm.

Nruab ib thaj

Qhov laj thawj 2: kev teeb tsa tsis raug

Qee lub sij hawm qhov teeb meem thaum qhib daim ntawv yuav yog qhov tsis raug teeb tsa lub teeb tsa ntawm lub program nws tus kheej. Piv txwv li, thaum koj sim qhib txhua phau ntawv Excel los ntawm ob zaug nias sab laug nas khawm, lus yuav tshwm: "Yuam tsis xa cov lus txib rau daim ntawv thov".

Hauv qhov no, daim ntawv thov yuav pib, tab sis phau ntawv xaiv yuav tsis qhib. Nyob rau tib lub sijhawm dhau ntawm tab Cov ntaub ntawv nyob rau hauv qhov kev pab cuam nws tus kheej, daim ntawv qhib ib txwm.

Feem ntau, qhov teeb meem no tuaj yeem daws teeb meem hauv qab no.

1. Mus rau hauv lub tab Cov ntaub ntawvCov. Tom ntej no peb tsiv mus rau ntu "Xaiv".



2. Tom qab lub ciaj ciam qhov rai qhib lawm, nyob rau sab laug peb mus rau seem "Tshaj"Cov. Nyob rau sab xis ntawm lub qhov rais peb tab tom nrhiav rau pab pawg kev teeb tsa "General"Cov. Nws yuav tsum muaj qhov ntsuas tawm "Tsis quav ntsej DDE kev thov los ntawm lwm cov ntawv thov"Cov. Uncheck nws yog tias nws yog kuaj. Tom qab ntawd, txhawm rau kom txuag tau txoj haujlwm tam sim no, nyem rau lub pob "OK" nyob hauv qab ntawm qhov rais nquag.

Tom qab ua tiav cov haujlwm no, qhov thib ob los sim qhib daim ntawv nrog lub nias ob zaug yuav tsum ua tiav kom tiav.

Qhov laj thawj 3: teeb tsa daim phiaj

Qhov laj thawj uas koj tsis tuaj yeem qhib tsis tau Excel daim ntawv ntawm tus qauv kev, uas yog, los ntawm ob zaug nias lub khawm laug khawm, yuav yog vim kev teeb tsa tsis raug ntawm cov koom nrog cov ntaub ntawv. Daim paib ntawm qhov no yog, piv txwv, kev sim pib ua daim ntawv hauv lwm daim ntawv thov. Tab sis cov teeb meem no tseem tuaj yeem daws tau yooj yim.

1. Los ntawm cov ntawv qhia zaub mov Pib mus rau Tswj vaj huam sib luag.



2. Tom ntej no peb tsiv mus rau ntu "Programmes".



3. Hauv daim ntawv thov teeb tsa qhov rai uas qhib, mus rau "Lub hom phiaj ntawm lub program qhib cov ntaub ntawv ntawm hom no".



4. Tom qab ntawd, cov npe ntawm ntau hom qauv yuav tsim, rau cov ntawv thov uas qhib lawv tau taw qhia. Peb tab tom nrhiav hauv cov npe ntawm kev txuas ntxiv Excel xls, xlsx, xlsb lossis lwm tus uas yuav tsum tau qhib hauv cov program no, tab sis tsis txhob qhib. Thaum koj xaiv txhua ntawm cov ntawv txuas ntxiv no, cov lus sau ntawm Microsoft Excel yuav tsum nyob rau saum rooj. Qhov no txhais tau tias qhov chaw teeb tsa kom raug yog.

   

   Tab sis, yog tias lwm daim ntawv thov tau teev thaum lub cim tseem ceeb ntawm Excel cov ntaub ntawv, ces qhov no qhia tau tias lub kaw lus tau teeb tsa tsis raug. Txhawm rau txhim kho qhov nqis nyem rau ntawm lub pob "Hloov program" nyob rau sab xis sab sauv ntawm lub qhov rais.



5. Feem ntau hauv lub qhov rais "Qhov Kev Xaiv Qhov Kev Kawm" Excel lub npe yuav tsum nyob rau hauv pawg ntawm cov kev pab cuam uas pom zoo. Hauv qhov no, tsuas yog xaiv lub npe ntawm daim ntawv thov thiab nyem rau ntawm lub khawm "OK".

   

   Tab sis, yog tias vim qee qhov xwm txheej nws tsis nyob hauv daim ntawv teev npe, tom qab ntawd qhov no peb nyem rau ntawm lub pob "Ntsuam xyuas ...".



6. Tom qab ntawd, daim ntawv qhia txog lub qhov rais qhib hauv qhov uas koj yuav tsum qhia txoj kev mus rau qhov tseem ceeb Excel cov ntaub ntawv ncaj qha. Nws nyob hauv daim nplaub tshev ntawm qhov chaw nyob nram qab no:

   C: Program Files Microsoft Office Office№

   Hloov ntawm "Tus lej." Cim, koj yuav tsum qhia tus lej ntawm koj Microsoft Office pob. Cov lus sau ua ke ntawm Excel versions thiab Office tus naj npawb yog raws li nram no:

   • Excel 2007 - 12;
   • Excel 2010 - 14;
   • Excel 2013 - 15;
   • Excel 2016 - 16.

   Tom qab koj tau hloov mus rau hauv daim nplaub tshev tsim nyog, xaiv cov ntawv EXCEL.EXE (Yog hais tias tso saib qhov txuas ntxiv yog tsis khoom, ces nws yuav raug hu tau yooj yim KEV ZOO) Nyem rau feem khawm "Qhib".



7. Tom qab ntawd, koj rov qab mus rau qhov program xaiv lub qhov rai, koj yuav tsum xaiv lub npe "Microsoft Excel" thiab nias rau pob "OK".



8. Tom qab ntawv thov yuav rov xaiv dua los qhib cov hom ntawv xaiv. Yog tias ob peb Excel txuas ntxiv muaj lub hom phiaj tsis ncaj ncees, tom qab ntawd koj yuav tsum tau ua cov txheej txheem saum toj no rau lawv txhua tus nyias. Tom qab tsis muaj qhov sib piv tsis raug sab laug, kom ua tiav kev ua haujlwm nrog lub qhov rais no, nyem rau ntawm lub pob Kaw.

Tom qab qhov no, Excel phau ntawv yuav tsum qhib kom raug.

Vim li cas 4: ntxiv-tau ua haujlwm tsis zoo

Ib qho laj thawj uas ua rau Excel phau ntawv tsis pib yuav yog kev ua haujlwm tsis zoo ntawm kev ntxiv cov teeb meem uas sib cav sib ceg lossis nrog qhov system. Hauv qhov xwm txheej no, txoj kev tawm yog tshem tawm cov tsis raug ntxiv-ntxiv.

1. Xws li tom tus txheej txheem thib ob ntawm kev daws teeb meem los ntawm kev tab Cov ntaub ntawv, mus rau hauv lub xaiv qhov rai. Muaj peb tsiv mus rau ntu "Ntxiv-ons"Cov. Hauv qab ntawm lub qhov rais yog daim teb "Kev tswj hwm"Cov. Nyem rau nws thiab xaiv qhov txwv "COM Ntxiv-ins"Cov. Nyem rau feem khawm "Mus ...".



2. Hauv kev qhib lub qhov rais ntawm daim ntawv teev cov add-on, tsis xyuas tag nrho cov khoom. Nyem rau feem khawm "OK"Cov. Yog li txhua ntxiv-ons ntawm hom COM yuav tau neeg xiam.



3. Peb sim qhib cov ntawv nrog nyem ob npaug. Yog tias nws tsis qhib, tom qab ntawd nws tsis yog hais txog add-ons, koj tuaj yeem tig lawv dua, tab sis saib rau lub laj thawj hauv lwm qhov. Yog tias daim ntawv qhib nquag, ces qhov no tsuas txhais tau tias ib qho ntawm kev ntxiv kev ua haujlwm tsis raug. Txheeb xyuas qhov twg, rov qab mus rau qhov sib ntxiv qhov rai, teeb ib lub cim rau ntawm ib qho thiab nyem rau ntawm lub pob "OK".



4. Tshawb xyuas seb cov ntaub ntawv qhib li cas. Yog tias txhua yam zoo, tom qab ntawd tig mus rau lub thib ob txuas ntxiv, thiab lwm yam, kom txog rau thaum peb tau txais mus rau ib qho thaum koj tig qhov uas muaj teeb meem nrog qhib. Hauv qhov no, koj yuav tsum muab nws tua thiab tsis pub qhib nws ntxiv lawm, lossis nws tseem zoo dua, rho tawm nws los ntawm qhov tseem ceeb thiab nias lub pob khawm. Txhua lwm yam kev ntxiv, yog tias tsis muaj teeb meem hauv lawv txoj haujlwm, tuaj yeem muab tua.

Qhov laj thawj 5: kev kho vajtse kom nrawm dua

Teeb meem qhib cov ntaub ntawv hauv Excel tuaj yeem tshwm sim thaum kho vajtse nrawm dua. Txawm hais tias qhov zoo tshaj yuav tsis tas yuav muaj kev khuam siab rau kev qhib cov ntaub ntawv. Yog li, ua ntej txhua yam, koj yuav tsum tau kuaj xyuas seb nws puas yog vim li cas lossis tsis.

1. Mus rau ntawm lub qhov rais paub zoo Excel xaiv ntawm ntu hauv ntu "Tshaj"Cov. Nyob rau sab xis ntawm lub qhov rais peb tab tom nrhiav kev teeb tsa thaiv VijtsamCov. Nws muaj qhov ntsuas tawm "Kev kho vajtse kom ceev nrawm duab ua"Cov. Teem lub box tso rau hauv xub ntiag thiab nyem rau lub pob "OK".



2. Kuaj seb cov ntaub ntawv qhib li cas. Yog tias lawv qhib ib txwm, tom qab ntawd tsis hloov chaw. Yog tias qhov teeb meem tseem nyob, koj tuaj yeem tig rov qab kho vajtse dua thiab tshawb ntxiv qhov tseeb vim qhov teeb meem.

Qhov laj thawj 6: ua kom phau ntawv puas

Raws li tau hais dhau los, daim ntawv yuav tsis qhib tsis tau vim tias nws tau puas. Qhov no tuaj yeem ua pov thawj los ntawm qhov tseeb tias lwm cov phau ntawv hauv tib daim ntawv ntawm qhov kev zov me nyuam pib nquag. Yog tias koj tsis tuaj yeem qhib cov ntaub ntawv no ntawm lwm lub cuab yeej, tom qab ntawd nrog kev ntseeg siab peb tuaj yeem hais tias vim li cas nyob hauv nws tus kheej. Hauv qhov no, koj tuaj yeem sim ua kom rov qab tau cov ntaub ntawv.

1. Peb pib lub Excel spreadsheet tus txheej txheem los ntawm ib qho shortcut ntawm lub desktop lossis los ntawm cov ntawv qhia ua PibCov. Mus rau hauv lub tab Cov ntaub ntawv thiab nias rau pob "Qhib".



2. Cov ntaub ntawv qhib qhov rai yog qhib kom ua huaj. Hauv nws, koj yuav tsum tau mus rau hauv phau ntawv sau npe uas qhov teeb meem ntawv muaj nyob. Xaiv nws. Tom qab ntawd nyem rau ntawm daim duab peb sab inverted tom ntej no kom khawm "Qhib"Cov. Ib daim ntawv uas muaj nyob rau qhov uas yuav tau xaiv "Qhib thiab restore ...".



3. Lub qhov rai qhib uas muaj ob peb yam kev xaiv los xaiv. Ua ntej, sim cov ntaub ntawv rov qab yooj yim. Yog li ntawd, nyem rau ntawm lub pob Cuam Tshuam.



4. Tus txheej txheem rov qab yog nyob rau hauv kev kawm. Yog tias nws ua tiav qhov kev ua tiav, lub qhov rai ntaub ntawv zoo li ceeb toom txog qhov no. Nws tsuas yog yuav tsum nias lub pob KawCov. Tom qab ntawv khaws cov ntaub ntawv tshawb fawb rov qab rau hauv txoj kev ib txwm - los ntawm txhaj rau lub pob hauv daim ntawv ntawm tsis sib cais rau ntawm kaum sab laug sab sauv ntawm lub qhov rais.



5. Yog tias phau ntawv tsis tuaj yeem rov qab tau raws li txoj kev no, ces peb rov qab mus rau lub qhov rais qub thiab nyem rau ntawm lub pob "Tshawb cov ntaub ntawv".



6. Tom qab ntawd, lwm lub qhov rai qhib, uas koj yuav muab kom hloov cov qauv rau qhov tseem ceeb lossis kho lawv. Hauv thawj kis, txhua daim qauv hauv daim ntawv ploj, thiab tsuas yog muaj cov txiaj ntsig suav kev suav. Hauv rooj plaub thib ob, yuav sim ua kom txuag tau cov lus hais, tab sis tsis tuaj yeem lees tias muaj kev vam meej. Peb ua kev xaiv, tom qab ntawd, cov ntaub ntawv yuav tsum tau rov qab los.



7. Tom qab ntawv, txuag lawv li ntawv cais los ntawm nias lub khawm hauv daim foos.

Muaj lwm txoj hauv kev rau rov qab cov ntaub ntawv los ntawm cov phau ntawv puas. Lawv muaj kev sib tham hauv cov ntsiab lus sib txawv.

Tshooj: Yuav ua li cas rov qab cov ntaub ntawv Excel uas puas lawm

Qhov laj thawj 7: Excel kev noj nyiaj txiag

Lwm qhov laj thawj vim li cas ib qho kev zov me nyuam tsis tuaj yeem qhib cov ntaub ntawv yuav yog nws qhov kev puas tsuaj. Hauv qhov no, koj yuav tsum tau sim kho nws. Txoj kev rov qab los tom qab no tsuas yog tsim nyog yog tias koj muaj qhov txuas khov kho hauv is taws nem.

1. Mus rau Tswj vaj huam sib luag los ntawm khawm Pibraws li tau piav tas los. Hauv qhov rai uas qhib, nyem rau ntawm qhov khoom "Uninstall ib qho program".



2. Lub qhov rais qhib nrog rau ib daim ntawv teev txhua daim ntawv thov teeb tsa ntawm lub khoos phis tawm. Peb tab tom nrhiav ib yam khoom hauv nws "Microsoft Excel", xaiv cov khoom nkag no thiab nyem rau ntawm pob "Hloov"nyob rau ntawm lub vaj huam sib luag sab saum toj.



3. Lub qhov rais rau kev hloov pauv ntawm kev teeb tsa tam sim no qhib. Muab lub pob nyem rau hauv chaw ua haujlwm Cuam Tshuam thiab nias rau pob Txuas ntxiv mus.



4. Tom qab ntawd, los ntawm kev txuas rau Is Taws Nem, daim ntawv thov yuav raug hloov kho, thiab cov kev ua txhaum yuav raug hloov kho.

Yog tias koj tsis muaj kev sib txuas hauv Is Taws Nem lossis rau lwm qhov laj thawj koj tsis tuaj yeem siv hom no, ces hauv qhov no koj yuav tsum tau rov qab siv lub disk installation.

Vim li cas 8: teeb meem kaw lus

Yog vim li cas qhov tsis muaj peev xwm qhib Excel cov ntawv qee zaum tuaj yeem yog qhov tsis ncaj ncees hauv kev ua haujlwm. Hauv qhov no, koj yuav tsum tau ua txoj haujlwm ua los kho cov kev noj qab haus huv ntawm Windows tag nrho.

1. Ua ntej tshaj plaws, luam theej duab koj lub khoos phis tawm nrog lub chaw siv tshuaj tiv thaiv. Nws raug nquahu kom ua qhov no los ntawm lwm lub cuab yeej uas tau lees tias tsis muaj tus kabmob. Yog tias koj pom cov khoom siv tsis txaus ntseeg, ua raws li cov lus pom zoo ntawm antivirus.



2. Yog tias kev tshawb nrhiav thiab tshem tawm cov vais lav tsis daws tau qhov teeb meem, tom qab ntawd sim rov qab yob qhov system mus rau qhov kawg rov qab. Yog lawm, yuav kom siv sijhawm zoo rau lub sijhawm no, nws yuav tsum tsim ua ntej muaj teeb meem tshwm sim.



3. Yog tias cov no thiab lwm cov kev daws teeb meem tsis tau muab cov txiaj ntsig zoo, ces koj tuaj yeem sim cov txheej txheem ntawm kev rov ua haujlwm dua.

Tshooj: Yuav tsim lub Windows restore point li cas

Raws li koj tuaj yeem pom, qhov teeb meem nrog qhib Excel phau ntawv tuaj yeem tshwm sim los ntawm cov laj thawj sib txawv. Lawv tuaj yeem raug zais ob qho tib si hauv kev ua tsis ncaj, hauv cov chaw tsis raug lossis hauv kev qhia tsis ua haujlwm. Qee qhov xwm txheej, qhov ua vim li cas kuj tseem yuav muaj teeb meem hauv kev ua haujlwm. Yog li, txhawm rau rov ua haujlwm tag nrho nws yog qhov tseem ceeb heev los txiav txim siab lub hauv paus.