DAB TSI YOG IB DAIM ID ID?

Thaum ua haujlwm hauv Microsoft Excel, tej zaum nws yuav tsum qhib ntau daim ntawv los yog tib cov ntaub ntawv nyob rau ntau qhov rais. Nyob rau hauv laus dua versions thiab hauv versions pib nrog Excel 2013, qhov no tsis suav rau cov teeb meem tshwj xeeb. Cia li qhib cov ntaub ntawv hauv txoj kev txheem, thiab lawv txhua tus yuav pib hauv qhov rais tshiab. Tiam sis nyob rau hauv versions ntawm daim ntawv thov 2007 - 2010 ib tsab ntawv tshiab qhib los ntawm neej ntawd nyob rau hauv lub qhov rais niam txiv. Qhov kev qhia no yog siv cov kev pab cuam hauv computer, tab sis tib lub sij hawm tsim muaj ntau yam kev tsis txaus siab. Piv txwv, yog tias tus neeg siv xav sib piv ob cov ntaub ntawv, tso cov qhov rais ntawm sab sab, ces nrog qhov chaw nws yuav tsis ua tiav. Xav seb qhov no yuav ua tau li cas rau txhua txoj hau kev.

Qhib ntau qhov rais

Yog tias nyob rau hauv Excel 2007 - 2010, koj twb muaj cov ntaub ntawv qhib, tabsis koj sim tso lwm cov ntaub ntawv, nws yuav qhib rau tib lub qhov rais niam txiv, tsuas hloov cov ntsiab lus ntawm daim tseem ntawv nrog cov ntaub ntawv los ntawm tus tshiab. Nws yuav nco ntsoov hloov mus rau tus thawj cov ntaub ntawv. Ua li no, yuj tus cursor rau ntawm Excel icon ntawm daim phiaj. Ib lub qhov rai me me yuav tshwm sim rau tag nrho cov ciav ntaub ntawv. Mus rau ib qho ntaub ntawv, koj tuaj yeem nias ntawm qhov rai no. Tab sis nws yuav yog qhov hloov, thiab tsis tag nrho cov qhov qhib ntawm ob peb qhov rais, txij li thaum tib lub sij hawm tus neeg siv yuav tsum tsis txhob tso lawv ntawm qhov screen li no.

Tab sis muaj ntau lub tswv yim nrog uas koj tuaj yeem tso ntau yam ntaub ntawv hauv Excel 2007 - 2010 ntawm qhov kev tshuaj ntsuam tib lub sijhawm.

Ib qho ntawm cov kev ceev tshaj plaws los daws qhov teeb meem ntawm qhib ntau lub qhov rais hauv Excel ib zaug thiab rau tag nrho yog los nruab ib lub thaj MicrosoftEasyFix50801.msi. Tab sis, hmoov tsis, Microsoft tau ceased los txhawb tag nrho cov Yooj Yim Yooj Yim Kho, nrog rau cov khoom saum toj no. Yog li ntawd, mus download tau nws nyob rau hauv lub tsev kawm ntawv yog tam sim no tsis yooj yim sua. Yog tias koj xav tau, koj tuaj yeem rub thiab nruab ib thaj ntawm lwm cov kev pabcuam hauv lub vev xaib ntawm koj tus kheej, tabsis yuav tsum paub hais tias cov haujlwm no yuav ua rau koj qhov kev pheej hmoo.

Method 1: Taskbar

Ib qho ntawm cov kev yooj yim rau kev qhib tau ntau lub qhov rais yog ua cov haujlwm no los ntawm cov ntsiab lus teb ntawm lub cim ntawm lub Taskbar.

Tom qab ib daim ntawv luam Excel twb tau pib, txav tus cursor rau qhov kev pabcuam icon uas muab tso rau ntawm Taskbar. Nias rau ntawm nws nrog txoj kev nas khawm. Launches lub ntsiab lus teb lus qhia. Nyob rau hauv peb xaiv, nyob ntawm seb qhov version ntawm qhov kev pab cuam, qhov khoom Microsoft Excel 2007 los yog "Microsoft Excel 2010".
Koj tuaj yeem nias ntawm Excel cim nyob rau ntawm cov neeg ua hauj lwm nrog cov laug nas khawm thaum tuav tus yuam sij Ua haujlwm. Lwm qhov kev xaiv yog kom yooj yim dua lub icon, ces nias lub tswb puav. Nyob rau hauv tag nrho cov teeb meem, cov nyhuv yuav zoo li qub, tab sis koj tsis tas yuav qhib lub ntsiab lus teb cov ntawv qhia.
Ib daim ntawv dawb paug qhib hauv ib lub qhov rai txawv. Yuav kom qhib tau ib daim ntaub ntawv, mus rau lub tab "Cov Ntaub Ntawv" qhov rais tshiab thiab nias rau yam khoom "Qhib".

Nyob rau hauv cov ntaub ntawv qhib qhov rai uas qhib, mus rau hauv cov ntaub ntawv uas yuav tsum tau ua nyob rau hauv, xaiv nws thiab nias rau khawm "Qhib".

Tom qab ntawd, koj tuaj yeem ua haujlwm nrog cov ntaub ntawv nyob hauv ob lub qhov rais ib zaug. Tib txoj kev, yog tias tsim nyog, koj tuaj yeem khiav ntau dua.

Txoj kev 2: Khiav qhov rai

Qhov thib ob hom yuav ua yeeb yam los ntawm qhov rais. Khiav mus.

Peb ntaus lub ntsiab ua ke ntawm cov keyboard Yeej + R.
Kaw lub qhov rais Khiav mus. Peb ntaus hauv nws cov lus txib "zoo".

Tom qab ntawd, lub qhov rais tshiab yuav pib, thiab yuav kom qhib qhov kev tsim nyog cov ntaub ntawv rau hauv nws, peb ua cov yeeb yam tib yam li hauv yav dhau los.

Txoj Cai 3: Pib Ua Ub No

Cov nram qab no yog tsim rau cov neeg siv ntawm lub qhov rais 7 los yog ua ntej versions ntawm qhov system.

Ndliv lub khawm "Pib" OS Qhov rai. Mus dhau qhov khoom "Txhua qhov khoos kas".

Nyob rau hauv cov npe qhib cov kev pab cuam mus rau lub nplaub tshev "Microsoft Office". Tom ntej no, nias lub pob nyem khawm ntawm luv taw "Microsoft Excel".

Tom qab cov kev ua no, lub qhov rais tshiab yuav pib, uas koj tuaj yeem qhib tau cov ntaub ntawv hauv txoj kev.

Txoj kev 4: Cov Shortcut Shortcuts

Kom khiav Excel rau hauv ib lub qhov rais tshiab, ob npaug nias ntawm daim ntawv thov tus shortcut ntawm lub desktop. Yog tias tsis yog, tom qab ntawd koj yuav tsum tsim kom tau ib qho shortcut.

Qhib qhov rais Explorer thiab yog tias koj muaj Excel 2010, ces mus rau:
C: Cov ntaub ntawv Microsoft Office Office14
Yog tias Excel 2007 muab ntsia, ces qhov chaw nyob yuav yog raws li nram no:
C: Cov ntaub ntawv Microsoft Office Office12

Ib zaug hauv qhov directory directory, peb nrhiav tau ib daim ntawv hu ua "EXCEL.EXE". Yog tias koj qhov kev txuas ntxiv tsis muaj nyob rau hauv koj qhov kev khiav hauj lwm, nws yuav raug hu ib tsab "HNAV". Nias ntawm cov khoom no nrog tus mouse nas khawm. Hauv cov ntawv qhia ua cov ntawv teb qhib, xaiv qhov khoom "Tsim Tsa Shortcut".

Lub thawv sab nraud tuaj yeem hais tias koj tsis tuaj yeem tsim qhov shortcut hauv phau ntawv no, tab sis koj tuaj yeem tso rau hauv koj lub desktop. Peb pom zoo los ntawm txhaj "Muaj".

Tam sim no nws yuav tau tso lub qhov rais tshiab los ntawm daim ntawv thov shortcut ntawm lub Desktop.

Txoj kev 5: qhib los ntawm lub ntsiab lus teb lus qhia

Tag nrho cov hau kev uas tau muab piav qhia saum toj no qhia tawm thawj zaug kom qhib qhov rais Excel, thiab tsuas yog los ntawm lub tab "Cov Ntaub Ntawv" qhib ib daim ntawv tshiab, uas yog txoj kev coj tsis zoo. Tab sis nws yog ua tau kom yoojyim qhib cov ntaub ntawv los ntawm kev siv cov ntsiab lus teb lus qhia.

Tsim ib qho Shortcut Excel rau hauv koj lub desktop siv cov algorithm piav saum toj no.
Nias ntawm qhov shortcut nrog rau txoj kev nas khawm. Hauv cov ntawv qhia zaub mov, nres qhov xaiv ntawm qhov khoom "Daim qauv" los yog "Txiav" nyob ntawm seb tus neeg siv xav qhov shortcut mus txuas ntxiv mus tso rau hauv Desktop lossis tsis tau.

Tom ntej, qhib lub Explorer, ces mus rau qhov chaw nyob nram no:
C: Cov neeg siv UserName AppData Roaming Microsoft Windows SendTo
Tsis muaj nqis "Lub npe" koj yuav tsum hloov lub npe ntawm koj tus account hauv Windows, uas yog, tus neeg siv cov npe.
Qhov teeb meem tseem yog lus dag hauv qhov tseeb uas yog vim li cas cov npe no nyob rau hauv cov ntawv nplaub tshev. Yog li, koj yuav tsum tau pab kom cov duab ntawm cov ntawv qhia thaum.

Hauv daim nplaub tshev uas qhib, nyem rau ntawm qhov chaw seem nrog tus nas khawm. Nyob rau hauv cov ntawv qhia zaub mov pib, nres qhov xaiv ntawm qhov khoom Muab tshuaj txhuam. Tom qab ntawv tas, daim ntawv no yuav muab ntxiv rau hauv phau ntawv no.

Tom qab ntawd qhib lub nplaub tshev uas cov ntaub ntawv nyob hauv uas koj xav khiav. Peb nyem rau ntawm nws nrog rau txoj kev nas khawm. Hauv cov ntawv qhia zaub mov, kauj ruam yog kauj ruam "Xa" thiab "Excel".

Daim ntawv no yuav pib hauv lub qhov rais tshiab.

Ib zaug ua haujlwm nrog ntxiv qhov shortcut rau daim nplaub tshev "Xa mus", peb tau txais lub sijhawm los qhib Excel cov ntaub ntawv nyob rau hauv lub qhov rais tshiab los ntawm cov ntawv qhia zaub mov.

Txoj Kev 6: Kev Hloov Pauv Hloov

Tab sis koj tuaj yeem ua kom qhib Excel cov ntaub ntawv nyob rau hauv ntau qhov rais txawm yooj yim dua. Tom qab ntawm txoj haujlwm, uas yuav piav qhia rau hauv qab no, tag nrho cov ntaub ntawv qhib hauv txoj kev li ib txwm, uas yog, ob npaug nias ntawm nas, yuav muab tso rau hauv nov. Yeej muaj tseeb, txoj kev ua haujlwm no yuav siv txoj haujlwm ntawm txoj haujlwm. Qhov no txhais tau tias koj yuav tsum muaj kev ntseeg siab rau koj tus kheej ua ntej koj coj nws, vim hais tias cov kauj ruam tsis ncaj ncees tuaj yeem mob siab ua rau lub cev tag nrho. Yuav kom kho qhov teeb meem no thaum muaj teeb meem, ua kom lub cev rov qab taw tes dua ua ntej pib ua haujlwm.

Khiav lub qhov rais Khiav mus, nias qhov ua ke tseem ceeb Yeej + R. Nyob hauv thaj chaw uas qhib, nkag mus rau qhov kev hais kom ua "RegEdit.exe" thiab nyem rau ntawm lub pob "OK".

Tus Registry Editor pib. Nyob rau hauv nws mus rau qhov chaw nyob nram no:
HKEY_CLASSES_ROOT Excel.Sheet.8 plhaub qhib hais kom ua
Hauv ib sab ntawm lub qhov rais, nyem qhov khoom. "Lub sijhawm".

Kho qhov rais qhib. Hauv kab "Tus nqi" peb hloov "/ dde" on "/ e"% 1 "". Tus so ntawm kab yog sab laug raws li yog. Peb nias lub khawm "OK".

Nyob hauv tib seem, peb muaj cai-nias ntawm lub caij "hais kom ua". Nyob rau hauv lub ntsiab lus teb cov ntawv qhia uas qhib, mus txog qhov khoom Rename. Randomly rename qhov khoom no.

Peb txoj cai-nias lub npe ntawm seem "ddeexec". Hauv cov ntawv qhia zaub mov, xaiv cov khoom Rename thiab tseem pheej yaum cov npe khoom no.
Yog li, peb tau ua kom qhib tau cov ntaub ntawv nrog xls txuas ntxiv nyob hauv ib txoj hauv kev hauv ib lub qhov rai tshiab.
Yuav kom ua tau tus txheej txheem no rau cov ntaub ntawv nrog xlsx txuas, hauv Registry Editor, mus rau:
HKEY_CLASSES_ROOT Excel.Sheet.12 plhaub qhib hais kom ua
Peb ua tib txoj kev nrog cov ntsiab lus ntawm cov ceg no. Ntawd yog, peb hloov qhov tsis tau ntawm lub caij. "Lub sijhawm"cov khoom tshiab "hais kom ua" thiab ceg "ddeexec".

Tom qab ua tiav cov txheej txheem no, xlsx cov ntaub ntawv tseem yuav qhib rau hauv lub qhov rais tshiab.

Txoj kev 7: Kev Xaiv Excel

Qhib ntau cov ntaub ntawv nyob rau hauv cov qhov rais tshiab kuj tau teeb tsa ntawm Excel xaiv.

Thaum nyob hauv tab "Cov Ntaub Ntawv" ua nas nias rau yam khoom "Kev xaiv".

Lub qhov ntsuas tsis qhib pib. Mus rau seem "Qib Siab". Nyob rau hauv txoj cai ntawm lub qhov rais peb tab tom nrhiav rau ib pawg ntawm cov cuab yeej. "General". Teem ib lub zuam ntawm xub ntiag ntawm qhov khoom "Ignore DDE kev thov los ntawm lwm cov kev siv". Peb nias lub khawm "OK".

Tom qab ntawd, cov ntaub ntawv tshiab yuav qhib hauv nyias qhov rais. Tib lub sij hawm, ua ntej ua tiav cov hauj lwm hauv Excel, nws raug pom zoo kom tsis pom qhov khoom "Ignore DDE kev thov los ntawm lwm cov kev siv", vim yog lwm zaus koj pib qhov kev pab, koj yuav muaj teeb meem nrog qhib cov ntaub ntawv.

Yog li, hauv qee txoj kev, hom no tsis yooj yim dua li yav dhau los.

Txoj kev 8: qhib ib daim ntawv ntau zaus

Raws li nws paub, feem ntau Excel tsis qhib tib cov ntaub ntawv hauv ob lub qhov rais. Txawm li cas los, qhov no kuj ua tau.

Khiav cov ntaub ntawv. Mus rau lub tab "Saib". Nyob rau hauv lub block ntawm cov cuab yeej "Qhov rai" nyob rau hauv daim kab xev nyem rau ntawm lub pob "Tshiab qhov rais".

Tom qab cov kev ua no, cov ntaub ntawv no yuav qhib ib zaug ntxiv. Nyob rau hauv Excel 2013 thiab 2016, nws yuav pib tam sim ntawd nyob rau hauv lub qhov rais tshiab. Hauv kev txiav txim siab rau versions 2007 thiab 2010 los qhib cov ntaub ntawv nyob rau hauv nyias muaj nyias cov ntaub ntawv, thiab tsis nyob hauv cov tab tshiab, koj yuav tsum tau muab cov npe, uas tau tham txog saum toj no.

Raws li koj tuaj yeem pom, txawm tias ua neej nyob hauv Excel 2007 thiab 2010, thaum qhib ntau cov ntaub ntawv, lawv yuav qhib rau hauv tib lub qhov rais niam txiv, muaj ntau txoj hau kev los tso rau hauv ntau qhov rais. Tus neeg siv yuav xaiv ib txoj kev yooj yim dua uas tsim nyog nws xav tau.