Yuav ua li cas mus kho Excel ntaub ntawv yuam kev: Cov ntaub ntawv Tej zaum muaj tau poob lawm

Thaum koj tso rau hauv lub Microsoft Excel Daim ntawv thov, koj yuav pom tias ib tug ntau ntawm me me hlwb nyob qhov twg koj yuav tau sau thiab muab sib txawv cov ntaub ntawv. Tam sim no qhov no ua hauj lwm qhov chaw kawm qhov twg txhua lub cell yog qhia siv ib tsab ntawv thiab ib tug xov tooj no yog hu ua ib tug Ntawv. Yog lub neej ntawd, thaum tsim ib tug tshiab Excel ntaub ntawv, uas koj tau txais 3 txawv ntawv uas lub koom haum, nyob rau hauv tabs, uas koj muaj peev xwm soj ntsuam nyob rau hauv qab ntawm daim ntawv thov qhov rais. Txhua tab muaj ib tug neej ntawd hais npe tab sis tus neeg siv yuav rename nws nyob rau txhua lub sij hawm.

• Part 1: Qhov zoo tshaj plaws MS Excel yuam kev Kho software
• Part 2: Yuav ua li cas mus kho Excel ntaub ntawv yuam kev: Cov ntaub ntawv Tej zaum muaj tau poob lawm

Koj yeej ib txwm ntxig rau ib tug tshiab tsab ntawv khom nqi hais tias koj xav mus, los yog tsiv mus nyob nws los ntawm kev siv cov nias thiab luag cov txheej txheem. Tej zaum tej zaum koj yuav tau replicate ib tug ntawv thiab hloov ntaub ntawv. Koj tau ntawm chav kawm ua li ntawd ib yam nkaus thiab siv commands xws li "Copy" los yog "Txav thiab Copy". Txawm li cas los, tej zaum siab phem tej yam uas tej zaum yuav tshwm sim, thiab koj tsab ntawv khom nqi tsis tau muab qhib los yog edited ntawm tag nrho cov. Nyob rau hauv no tsab xov xwm, peb yuav tham yuav ua li cas rau Txhim kho Excel ntaub ntawv yuam kev thiab yog dab tsi Excel kho lub cuab tam koj yuav tsum tau siv rov qab poob cov ntaub ntawv.

Txheej txheem cej luam ntawm cov ntaub ntawv tej zaum yuav muaj tau poob yuam kev

Yog li ntawd koj tau txais lub "Cov ntaub ntawv yuam kev - Cov ntaub ntawv Tej zaum muaj tau poob lawm" cov lus. Yuav ua li cas tam sim no? Lub sober kev muaj tiag yog tias koj qhib tsis tau koj cov ntaub ntawv vim hais tias nws tau raug corrupted los yog poob lawm. Nws yog lub npe hu hais tias tus newest Microsoft Excel versions yog displaying qhov yuam kev cov lus thaum ua tau qhib Excel ntaub ntawv tsim nyob rau hauv ua ntej lawm versions. Ib yam li ntawd, tsis txuag koj cov ntaub ntawv thaum editing ib cov ntaub ntawv nyob rau ntawm lwm tsav ua ntej rub nws tawm kuj yuav tsim kom raug. Muaj tseem ib co yuav hais tias koj cov ntaub ntawv tau corrupted vim tsis tsim los ntawm daim ntawv thov ntawm nws tus kheej. Tej zaum cov ua hauj lwm ntawm koj lub zos tsav siv los khw ntaub ntawv yog ib tug corrupting cov ntaub ntawv.

Lwm yam uas tej zaum yuav ua rau muaj qhov yuam kev lus tshwm yog: tus kab mob no tawm tsam, operating system uas tsis, thiab txhua yam uas muaj lwm yam software los yog kho vajtse txog qhov teeb meem. Koj muaj peev xwm tsis qhib cov ntaub ntawv, cuaj kaum nkag muaj ntaub ntawv raws li ntev raws li cov lus no yuav qhia txog kev tshuaj ntsuam. Kho no Excel ntaub ntawv yuam kev yuav tsis yeej ib txwm ua tau siv lub Microsoft Excel nrog rov qab cov cuab yeej, yog li koj mam li yuav tau hu ua deductible ib yam dab tsi ntau npaum li cas hwj chim heev ib Excel kho lub cuab tam . Nyob twj ywm ze, thiab koj yuav nrhiav tau tawm yog nyob rau hauv lub tom ntej no seem ntawm no cov khoom dab tsi cuab tam uas yuav tsum tau rov qab poob mus zoo ua ntaub ntawv thov thiab yuav ua li cas siv nws.

Part 1: Qhov zoo tshaj plaws MS Excel yuam kev Kho software

Yog hais tias koj xav mus Txhim kho Excel ntaub ntawv yuam kev muab qhov yuam kev cov lus sib tham nyob rau hauv lub yav dhau los tshooj, koj xav tau ib tug haib Excel kho lub cuab tam. Peb zoo tuaj tos yog Stellar Phoenix Excel Kho thiab nyob rau hauv lub tom ntej no kab kuv yuav muaj tseeb qhia rau koj paub yog vim li cas. Zoo, ua ntej ntawm tag nrho cov, nws yuav pab tus neeg siv kho ob .xls thiab .xlsx Excel ntaub ntawv tawm tswv tsis ua tej yam kev hloov rau cov ntaub ntawv muaj nyob rau ntawm ib tug tej yam ntawv. Yog tsis yog nws txias tau hais tias koj tau txais kom koj tus thawj tsim txawm tom qab rov qab?

Ib tug zoo Excel kho lub cuab tam yuav tsum tau kho yuav luag tag nrho cov kev noj nyiaj txiag uas tsis, txoj cai? Zoo qhov kev pab cuam, muaj peev xwm tsis tsuas ua li ntawd, tab sis kuj kho ntau yam zoo cov ntaub ntawv nyob rau hauv tib sib kho, thiab kuj muab ib tug ceev saib ua ntej ntawm cov ntaub ntawv ua ntej yuav nriav cov tag nrho daim ntawv tso cai. Tam sim no koj tsis txawm muaj kev txhawj yog tias koj muaj ib tug Microsoft Excel 2000 version, los yog qhov tseeb tawm muaj. Qhov kev pab no yog tsis tau tshaj nrog rau tej Microsoft Excel version. Tsis tas li ntawd, tus neeg siv interface yog heev yooj yim mus use thiab qhov zoo tshaj plaws yog hais tias koj tau mus rau kho koj "Cov ntaub ntawv yuam kev: Cov ntaub ntawv Tej zaum muaj tau poob lawm" kev ua yuam kev. Ua li. Cov seem tom ntej no yuav qhia koj li cas yuav ua rau nws.

Part 2: Yuav ua li cas mus kho Excel ntaub ntawv yuam kev: Cov ntaub ntawv Tej zaum muaj tau poob lawm

Ua ntej uas qhia rau koj ib tug step-by-step rau yuav ua li cas kho Excel ntaub ntawv uas tsis koj yuav tsum xub mus muab tau cov Excel kho lub cuab tam peb hais nyob rau hauv lub yav dhau los seem ntawm qhov tsab xov xwm.

Kauj ruam 1 Teem lub tsav koj xav tau tus system mus nrhiav nyob rau hauv thiab coj mus rhaub "Nrhiav Cov ntaub ntawv (s)" khawm. Xwb, tej zaum koj yuav xaiv "Xaiv nplaub tshev" kom meej lub caij nyoog nplaub tshev, los yog nias "Xaiv cov ntaub ntawv" kom tau ib cov ntaub ntawv nyob rau hauv tej lwm qhov chaw;

Kauj ruam 2 Qhov kev tshawb tshwm sim box tam sim no qhia tau hais tias ib daim ntawv teev cov ntaub ntawv. Xaiv ib los yog ntau yam ntaub ntawv uas koj yuav tsum rov qab, thiab coj mus rhaub "Scan" khawm. Tom qab lub system ua tiav PP txheej txheem koj yuav saib koj cov ntaub ntawv;

Kauj ruam 3 Tom qab cov ntaub ntawv twb tau kiag li zoo tu qab tso tej zaum koj yuav tam sim no export cov ntsiab lus nyob rau hauv ib tug tshiab daim ntawv ntawm cov tib daim ntawv uas yog uncorrupted.

Kauj ruam 4 Nias lub "Txuag" khawm thiab teem caij rau kev kawm qhov chaw. Coj mus rhaub "ok".

Koj yuav tsum nco ntsoov hloov koj qhov system operating mus rau qhov tseeb version, nruab ib tug zoo antivirus kev pab cuam ntawd thiab kom nws kho tshiab raws li zoo, thiab thaum kawg set-up ib tug rov qab-up system uas yuav pab tau koj ua cov ntawv luam ntawm cov ntaub ntawv tseem ceeb nyob rau hauv cov ntaub ntawv muaj kev puas tsuaj ntaus dua

Kho vajtse malfunction yog ib tug zoo-paub teeb meem ua rau cov ntaub ntawv kev noj nyiaj txiag. Koj yuav tsum nco ntsoov xyuas koj cov tsav rau kom raug thiab yog hais tias koj siv ib tug sab nraud ntaus ntawv raws li ib tug thaub qab daim ntawv, tsis format lub drive ua ntej. Thaum editing ib cov ntaub ntawv khaws tseg rau sab nraud ntaus ntawv, yeej ib txwm tseg rau lub daim ntawv thiab siv lub "ruaj ntseg zoo tshem ntaus ntawv" kev xaiv ua ntej disconnecting nws los ntawm koj lub computer.