Yuav ua li cas mus kho Excel ntaub ntawv qauv yuam kev

Kuv paub tseeb tias muaj ntau yam ntawm cov txawj nyeem ntawv paub hais tias Microsoft Excel yog ib tug software tsim los ntawm Microsoft thawj rau lub qhov rais thiab mac OS, thiab ces nyob rau hauv lub xyoo tas los lawv txawm launched mobile versions rau hauv thiab iOS no. Yog li ntawd cia li, nws yog ib tug spreadsheet pab cuam uas muab rau tus neeg siv lub peev xwm los mus ua kom txoj laij siv engineered qauv, graphing cov cuab yeej, cov ntxhuav, thiab macro programming rau txawm ntau muab xam apps. Excel yuav txawm pab kom koj daws tau differential sib npaug ntawm zauv physics thiab lwm yam advanced khoom. Niaj hnub no, nws yuav siv ob hom: "XLS" thiab "xlsx".

• Part 1: Excel ntaub ntawv qauv yuam kev Kho Tool
• Part 2: tshuaj mus rau Txhim kho Excel ntaub ntawv qauv yuam kev

Koj puas paub hais tias cov thawj spreadsheet software tsim los ntawm Microsoft twb tsis muaj ib tug neeg interface thiab hais tias nws twb khiav rau MS-DOS? Ib yam li ntawd, Microsoft Excel yog tus thawj spreadsheet software uas tso cai rau cov neeg siv cov txhais style thiab formatting mus rau lub hlwb. Excel kuj nkag tau pib-sau, luag-thiab nco thiab nws kim heev graphing cov cuab yeej. Nrog lub xyoo, Excel tau ua heev poplar thiab li tau tau tsom los ntawm hackers. Yog hais tias koj lub computer tau txais tus kab mob no kis tus kab mob, los yog nws malfunctions, cov ntaub ntawv yuav tau corrupted thiab nyeem. Nyob rau hauv no tsab xov xwm, koj mam li kawm ua li cas mus kho tau zoo ua ntaub ntawv thov cov qauv kev ua yuam kev uas siv ib tug Excel kho lub cuab tam uas zoo tham txog tom qab rau.

Txheej txheem cej luam ntawm Excel ntaub ntawv qauv yuam kev

Ob peb lub sij hawm nyob rau hauv Excel yog tias koj nkag mus rau ib lub mis uas tsis yog lawm, qhov kev pab cuam yuav qhia ib qho kev ua yuam kev muaj nuj nqis nyob rau hauv cov mis nkag teb. Excel muaj ntau yuam kev qhov tseem ceeb thiab lawv feem ntau yog pib nrog hashtag cim ( "#") Yuav kom kho tau zoo ua ntaub ntawv thov cov qauv yuam kev koj thawj yuav tsum paub dab tsi tshwm sim no kev ua yuam kev thiab thaum kawg yog lub mis. Kuv pom zoo, hais tias muaj mus nrhiav tej kev yuam kev nyob rau hauv ib tug 14 los xij ntawv yuav sound raws nraim li nrhiav tus koob nyob rau hauv lub haystack. Kuv twv ib tug zoo pib yuav paub koj tus kheej nrog cov uas tsis, yuav tsum paub dab tsi lawv yeej tshwm sim los ntawm thiab kawm tau li cas los txhim kho cov lawv, los yog tsuas yog siv ib tug Excel kho lub cuab tam rau nws ua.

Ib txhia hlwb uas muaj siv rau lwm lub hlwb yog nruj me ntsis khi nyob rau hauv cov nqe lus ntawm cov ntaub ntawv lawv yuav tso saib. Piv txwv li, yog hais tias tus cell A1 muaj ib tug formula uas qhia txog cov kev tshwm sim nyob rau hauv A2 thiab hais tias mis muaj ib qho yuam kev nqi, A2 yuav tso saib qhov yuam kev nqi li zoo. Qhov no yog dab tsi ua rau nws nyuaj mus nrhiav cov cell uas muaj kev ua tsis yog mis. Ib co ntawm cov uas tsis yog: # Div / 0- uas txhais tau tias koj tseem tabtom mus faib los ntawm xoom, #NAME? - thaum Excel tsis paub txog ib tug lub npe, #NULL! -when koj ntxig ib qhov chaw es tsis txhob ntawm ib tug tsis nco qab thaum editing ib tug muaj nuj nqi sib cav, #NUM! - thaum muaj ib qho teeb meem nrog ib tug xov tooj nyob rau hauv cov mis, thiab thiaj li nyob.

Part 1: Excel ntaub ntawv qauv yuam kev Kho Tool

Yog hais tias koj nrhiav tau nws ib tug astonishing nra mus txhim kho tau zoo ua ntaub ntawv thov cov qauv uas tsis, tej zaum koj yuav tsum tau xav txog kev siv ib qho Excel kho lub cuab tam. Peb tuaj tos rau hnub no yog Stellar Phoenix Excel Kho . Qhov no software yog tau txhim kho tag nrho cov ntau Excel ntaub ntawv kev noj nyiaj txiag uas tsis, tshwj xeeb tshaj yog cov neeg tom tsim mus txog unrecognizable hom ntawv, nyeem cov ntaub ntawv, los yog txawm cov ntaub ntawv uas tsis tau muab qhib rau tag nrho cov. Nws tsis yog hais tias koj cov ntaub ntawv muaj cov "XLS" los yog "xlsx" hom. Ib tug zoo tshaj plaws txog nws yog qhov tseeb hais tias qhov kev pab cuam muaj peev xwm kom tau khaws cia rau hauv lub formatting ntawm cov ntaub ntawv uas koj recovering. Tej zaum koj kuj rov qab cov ntaub ntawv nrog complex engineering qauv.

Yuav tsum ib yam dab tsi tau tau tshwm sim rau koj lub cev thiab tag nrho koj cov excel cov ntaub ntawv yog displaying uas tsis, qhov no software yuav pab kom koj zoo ntau yam ntaub ntawv nyob rau hauv ib repairing kev sib kho. Siv cov kev mus sib hais version koj muab koj lub peev xwm saib lub xaiv cov ntaub ntawv ua ntej rov qab, tiam sis koj yuav tsum yuav tag nrho daim ntawv tso cai rau txuag tej ntaub ntawv. Qhov no software muab kev pab rau tej Microsoft Excel version thiab yuav tsum khiav rau tej Microsoft lub qhov rais Operating System version. Tej zaum koj kuj khiav qhov kev pab cuam nyob rau hauv ib tug mac Operating System. Lwm cov nta xws li: teev lus ceeb toom, thiab yooj yim rau siv interface.

Part 2: tshuaj mus rau Txhim kho Excel ntaub ntawv qauv yuam kev

Ua ntej yuav pib peb cov nyeem yuav ua li cas los txhim kho cov zoo cov ntaub ntawv qauv kev ua yuam kev thov download tau lub Excel kho lub cuab tam peb tau sib tham txog nyob rau hauv lub yav dhau los version. Yog hais tias koj nrhiav tau koj tus kheej nyob rau thaum xaus ntawm lub txhim kho cov txheej txheem, cia li coj mus rhaub lub xeem khawm thiab tos rau lub system tso lub software. Ua raws li cov kauj ruam tom ntej:

Kauj ruam 1 Yog hais tias koj xav tau tus system mus nrhiav cov ntaub ntawv rau koj, xaiv ib tug tsav qhov chaw tsim txoj kev nco-down ntawv qhia zaub mov thiab coj mus rhaub "Nrhiav Cov ntaub ntawv (s)" khawm. Txwv tsis pub, nias "Xaiv nplaub tshev", los yog "Xaiv ntaub ntawv" thiab mus de tau ib cov ntaub ntawv nyob rau hauv ib qhov chaw;

Kauj ruam 2 Tom ntej, koj yuav tsum xaiv ib co ntaub ntawv uas koj xav tau rau rov qab los ntawm cov kev tshawb fawb tau box uas tau cia li tau populated nrog cov ntaub ntawv. Coj mus rhaub cov "Scan" khawm;

Kauj ruam 3 Tom qab lub PP txheej txheem yog ua li cas, kev saib ua ntej ntawm cov ntaub ntawv yog raug generated. Siv ib tug los ze zog saib thiab txiav txim siab uas cov ntaub ntawv rau txuag;

Kauj ruam 4 Yuav kom export ib daim qauv ntawm cov zoo tu qab tso cov ntaub ntawv, coj mus rhaub "Txuag" khawm, de tau ib cov ntaub ntawv qhov chaw nyob, thiab nias lub "Aws" khawm.

Yog, kuv pom zoo tias nws yog ib tug zoo tshaj plaws kom paub yuav ua li cas siv cov qauv nyob rau hauv Excel, tab sis tus tshaj plaws yog hais tias koj kuj tau mus kawm yuav ua li cas hnov ​​thiab muaj tseeb uas tsis nyob rau hauv cov qauv. Tus thawj yam uas koj yuav tau ua yog kawm tau dab tsi txhua kev ua yuam kev txhais tau tias. Sai li sai tau raws li koj paub dab tsi ua rau nws tej zaum koj yuav ntse txhim kho uas zoo cov ntaub ntawv qauv kev ua yuam kev. Ntawm no yog ob peb ceev cov tswv yim rau peb lub ntsiab lus:

• Peb Excel kho lub cuab tam yog sib koom tej yam nrog rau Microsoft Excel, li ntawd ua ntej pib rov qab sib kho, thov kaw Excel rau ib tug thaum;
• Yog hais tias cov ntaub ntawv koj yuav tau rov qab muaj engineering qauv, koj yuav tsum nruab ib lub "Analysis ToolPak". Yog hais tias koj muaj peev xwm tseem qhib lub corrupted ntawv, next rau cov cuab yeej rau> Ntxiv-ins thiab tos "Analysis ToolPak";
• Lub #Ref uas tsis txhais tau hais tias yog ib tug uas tsis yog-siv tau siv nyob rau hauv koj lub mis. Tsis txhob rho tawm hlwb, txhua, los yog kab li ntawd cia li, Yog hais tias xav kom tsis txhob muaj qhov yuam kev no.