Yuav ua li cas yog hais tias lawv yog uas ploj lawm nyob rau hauv Excel

Anonim

Tej thaj chaw deb ntawv nyob rau hauv Microsoft Excel

Lub peev xwm los tsim ib tug neeg los xij nyob rau hauv ib phau ntawv nyob rau hauv ib phau ntawv pub, nyob rau hauv qhov tseeb, tsim ntau yam ntaub ntawv nyob rau hauv ib tug cov ntaub ntawv thiab, yog tias tsim nyog, khi lawv nrog ua tim khawv los yog cov qauv. Ntawm cov hoob kawm, qhov no ho pab txoj kev lub functionality ntawm cov kev pab cuam thiab tso cai rau koj mus nthuav lub horizons ntawm cov paub tab. Tab sis tej zaum nws tshwm sim hais tias ib co los xij koj tsim ploj los yog kiag li ploj tag nrho lawv tej shortcuts nyob rau hauv tus txheej xwm bar. Cia peb kawm saib yuav ua li cas koj yuav rov qab lawv rov qab.

Txum Tim Rov Qab los xij

Lub navigation ntawm cov ntawv txheeb ntawm cov phau ntawv no tso cai rau koj mus nqa tawm shortcuts uas muaj nyob rau ntawm sab laug sab ntawm lub qhov rais saum toj no tus txheej xwm bar. Cov lus nug txog lawv cov rov qab nyob rau hauv cov ntaub ntawv ntawm disappearance peb yuav tau suav hais tias.

Ntawv ntawm los xij nyob rau hauv Microsoft Excel

Ua ntej cov tswv yim nrog txoj kev tshawb no ntawm qhov rov qab algorithm, wb daim duab nws seb vim li cas lawv yuav feem ntau. Muaj plaub lub ntsiab yog vim li cas yog vim li cas nws yuav tshwm sim:

  • Lov tes taw vaj huam sib luag ntawm shortcuts;
  • Khoom raug muab zais qab cov kab rov tav scroll bar;
  • Cais shortcuts tau txhais rau hauv lub xeev ntawm muab zais los yog superblit;
  • Tshem tawm.

Lawm, txhua tus ntawm cov ua ua ib qho teeb meem uas muaj nws tus kheej cov kua algorithm.

Txoj 1: Xa rau ntawm daim ntawv lo vaj huam sib luag

Yog hais tias muaj yog tsis muaj shortcuts nyob rau hauv tus txheej xwm txoj hlua nyob rau hauv Feem ntau, nrog rau cov daim ntawv lo ntawm lub active caij, qhov no txhais tau hais tias lawv qhia tau tias tsuas yog kaw nyob rau hauv qhov chaw. Qhov no yuav tsuas ua tau rau tam sim no phau ntawv. Uas yog, yog tias koj qhib lwm Excel ntaub ntawv mus rau tib qhov kev pab cuam, thiab lub neej ntawd chaw nyob yuav tsis tsum hloov, daim ntawv lo vaj huam sib luag yuav muab tso tawm kom. Pov tseg yuav ua li cas koj yuav pab kom visibility dua yog hais tias tus vaj huam sib luag yog muab tua nyob rau hauv qhov chaw.

Tag nrho cov ntawv yog zoo nyob rau hauv Microsoft Excel

  1. Mus rau "file" tab.
  2. Mus rau hauv cov ntaub ntawv tab hauv Microsoft Excel

  3. Tom ntej no, peb hloov mus rau "tsis muaj" ntu.
  4. Hloov mus rau cov tsis muaj hauv Microsoft Excel

  5. Nyob rau hauv lub Excel parameter qhov rais uas qhib, ua rau txoj kev hloov mus rau lub "Advanced" tab.
  6. Mus rau hauv Advanced tab hauv Microsoft Excel

  7. Nyob rau sab xis ntawm lub qhov rais uas qhib ntau yam Excel chaw nyob. Peb yuav tsum nrhiav lub chaw thaiv "Qhia tsis rau tom ntej no phau ntawv". Nyob rau hauv no block muaj ib tug "Qhia ntawv ntawv" parameter. Yog hais tias muaj yog tsis muaj kos cim nyob rau hauv pem hauv ntej ntawm nws, ces nws yuav tsum tau ntsia. Tom ntej no, nyem rau ntawm "OK" khawm nyob hauv qab ntawm lub qhov rais.
  8. Enabling ntawv daim ntawv lo cov zaub nyob rau hauv Microsoft Excel

  9. Raws li koj tau pom, tom qab ua tau zoo rau saum toj no, daim ntawv lo vaj huam sib luag yog dua tso tawm nyob rau hauv lub tam sim no Excel phau ntawv.

Lub daim ntawv lo vaj huam sib luag yog dua tso tawm nyob rau hauv Microsoft Excel

Txoj 2: Txav mus rau tus scroll bar

Tej zaum kuj muaj mob thaum tus neeg siv ntawd rho tus kab rov tav scroll bar rau sab saum toj ntawm daim ntawv lo vaj huam sib luag. Yog li, nws yeej nkaum lawv, tom qab uas, thaum no fact yog pom, ib tug feverish nrhiav pib qhov ua rau ntawm cov neeg uas hlais.

Sheet ntawv muab zais scroll bar nyob rau hauv Microsoft Excel

  1. Daws qhov teeb meem no yog heev yooj yim. Nruab ib lub cursor mus rau sab laug ntawm lub kab rov tav scroll bar. Nws yuav tsum tau hloov mus rau hauv ib tug bidirectional xub. Nyem rau sab laug nas khawm thiab lub kev cursor mus rau sab xis kom txog thaum tag nrho cov khoom nyob rau hauv lub vaj huam sib luag muaj tso tawm. Ntawm no, ib yam nkaus thiab, nws yog tsis tseem ceeb tsis overdo nws thiab tsis txhob ua tej scroll bar heev me me, vim hais tias nws kuj yog yuav tsum tau mus next daim ntawv. Yog li ntawd, koj yuav tsum nres dragging lub sawb sai li sai tau raws li tag nrho cov vaj huam sib luag yuav qhib.
  2. Draxt ntawm kab rov tav scroll bar nyob rau hauv Microsoft Excel

  3. Raws li koj tau pom, lub vaj huam sib luag yog tso tawm dua ntawm qhov screen.

Cov ntawv vaj huam sib luag yog qhib Microsoft Excel

Txoj 3: Enabling Thaum ntawv

Tsis tas li ntawd, ib tug neeg los xij yuav tsum tau muab zais. Nyob rau tib lub sij hawm, lub vaj huam sib luag rau nws tus kheej thiab lwm yam shortcuts rau nws yuav muab tso tawm kom. Qhov txawv nyob rau hauv muab zais tej khoom siv los ntawm tej thaj chaw deb yog hais tias yog koj xav, koj yeej ib txwm tso saib. Nyob rau hauv tas li ntawd, yog tias nyob rau hauv ib daim ntawv muaj cov qhov tseem ceeb uas yog nruj los ntawm cov qauv nyob rau ntawm tus, ces nyob rau hauv cov ntaub ntawv ntawm Hmong tus kwv, cov qauv no yuav pib thim ib qho kev ua yuam kev. Yog hais tias qhov khoom yog tsuas muab zais, ces tsis muaj kev hloov nyob rau hauv cov mis muaj nuj nqi yuav tshwm sim, cia li ntawv yuav hloov txoj kev yuav tsis tuaj kawm ntawv. Hais lus nrog cov lus yooj yim, tus kwv yuav tau nyob twj ywm nyob rau hauv tib daim ntawv raws li nws yog, tab sis cov navigation cov cuab yeej rau switching rau nws yuav ploj.

Tus txheej txheem yog zoo nkauj yooj yim rau nkaum. Koj yuav tsum right-click nyob rau hauv lub sib nug xov shortcut thiab nyob rau hauv lub Xaiv "Hide" yam khoom tshwm.

Hide ntawv nyob rau hauv Microsoft Excel

Raws li koj tau pom, tom qab qhov kev txiav txim, lub siab lub caij yuav tsum tau muab zais.

Sheet yog muab zais rau hauv Microsoft Excel

Tam sim no cia tus duab tawm yuav ua li cas tso saib zais ntawv dua. Nws tsis yog ntau npaum li cas nyuab tshaj nkaum lawv thiab kuj intuitively to taub.

  1. Right-click nyob rau hauv tej daim ntawv lo. Cov ntawv qhia zaub mov qhib. Yog hais tias muaj yog muab zais ntsiab nyob rau hauv lub tam sim no phau ntawv, ces nyob rau hauv no cov zaub mov nws ua ib qho active khoom "qhia tau tias ...". Nyem rau ntawm nws nrog sab laug nas khawm.
  2. Kev hloov mus rau tus yeeb yam thaum ntawv ntawm los xij nyob rau hauv Microsoft Excel

  3. Tom qab txhaj, lub foundations ntawm ib tug me me qhov rais yog qhib, nyob rau hauv uas muaj yog ib daim ntawv teev zais los xij nyob rau hauv phau ntawv no. Xaiv tus kwv hais tias koj xav mus tso saib dua nyob rau hauv vaj huam sib luag. Tom qab ntawd, nyem rau ntawm "OK" khawm nyob hauv qab ntawm lub qhov rais.
  4. Tso zis rau lub latent ntawv screen

  5. Raws li koj tau pom, daim ntawv lo ntawm lub twj paj nruas yog dua tso tawm nyob rau hauv vaj huam sib luag.

Cov ntawv zoo nkaus li nyob rau hauv Microsoft Excel

Txoj 4: Zaub ntawm supercad los xij

Ntxiv nrog rau cov ntawv zais, tseem muaj super-dawb. Los ntawm thawj lawv txawv nyob rau hauv uas koj yuav tsis pom lawv nyob rau hauv cov zis ib txwm npe ntawm Latent cov tshuaj ntsuam. Txawm hais tias peb tau ntseeg siab tias cov khoom no tau muaj tseeb thiab tsis muaj ib tus neeg tau muab tshem tawm.

Cov ntsiab lus tuaj yeem ploj mus rau hauv txoj kev no tuaj yeem tsuas yog qee tus neeg ua haujlwm zais los ntawm VBA Macro Editor. Tab sis nrhiav lawv thiab rov qab cov zaub ntawm lub vaj huam sib luag yuav tsis nyuaj yog tias tus neeg siv paub txog kev ua peb yuav tham txog hauv qab no.

Nyob rau hauv peb rooj plaub, raws li peb pom, tsis muaj cov ntawv lo ntawm plaub thiab tsib daim ntawv.

Tsis muaj fette thiab daim ntawv tsibth hauv Microsoft Excel

Mus rau qhov tso zis ntawm lub vijtsam ntawm cov ntsiab lus zais, txoj kev uas peb tau hais txog hauv txoj kev yav dhau los, peb pom tias tsuas yog lub npe ntawm plaub daim ntawv tau tshwm sim. Yog li ntawd, nws yog qhov pom tseeb heev rau kev xav tias yog daim ntawv tsib thib tsib yog tsis muab tshem tawm siv cov khoom siv VBA Editor cov cuab yeej.

Hauv daim ntawv zais zais, tsuas yog daim ntawv plaub thib ob tau tshwm sim hauv Microsoft Excel

  1. Ua ntej tshaj plaws, koj yuav tsum qhib macros thiab qhib tus tsim tawm los, uas yog xiam oob qhab los ntawm lub neej ntawd. Txawm hais tias, yog nyob hauv phau ntawv no, qee cov ntsiab lus tau muab cov xwm txheej ntawm supercaded, nws yog qhov ua tau tias cov txheej txheem qhia hauv txoj haujlwm twb tau ua tiav lawm. Tab sis, dua, tsis muaj kev lees paub tias tom qab ua tiav ntawm cov ntsiab lus, tus neeg siv uas tau ua tsis tiav cov cuab yeej tsim nyog los hloov cov zaub ntawm cov nplooj ntawv super-dawb. Tsis tas li ntawd, nws yog ib qho ua tau tias kev suav nrog ntawm cov zaub ntawm sheecuts tau ua txhua yam nyob rau hauv lub khoos phis tawm uas lawv tau muab zais.

    Mus rau "file" tab. Tom ntej no, nyem rau ntawm "tsis muaj" cov khoom hauv cov ntawv qhia zaub mov ntsug uas nyob ntawm sab laug ntawm lub qhov rais.

  2. Mus rau qhov tsis muaj nyob hauv Microsoft Excel

  3. Nyob rau hauv lub qhov rais Excel qhov rais uas qhib, nyem rau ntawm Ribbon Teeb Khoom Khoom. Hauv "cov tabs pib" thaiv, uas nyob ntawm sab xis ntawm lub qhov rais uas qhib, teeb tus zuam, muab tus zuam yog tsis yog, ze ntawm "tus tsim tawm" parameter. Tom qab ntawd, peb tsiv mus rau lub Chaw Tswj Xyuas Kev Ruaj Ntseg Center siv cov ntawv qhia zaub mov ntsug ntawm sab laug ntawm lub qhov rais.
  4. Ua rau tus tsim tawm tab hauv Microsoft Excel

  5. Nyob rau hauv lub qhov rais ua si, nyem rau ntawm lub pob "tsis yog tus tswj hwm kev ruaj ntseg ...".
  6. Hloov mus rau kev ruaj ntseg tswj chaw teeb tsa hauv Microsoft Excel

  7. Lub Security Management Center qhov rais yog launched. Mus rau lub "Macro chaw" seem los ntawm txoj kev ib ntsug zaub mov. Nyob rau hauv lub "Macro chaw" toolbar, koj teem lub mus rau lub "Pab kom tag nrho cov macros" txoj hauj lwm. Nyob rau hauv lub "Macro chaw rau tsim tawm" block, Peb teem ib lub zuam txog cov yam khoom no "Trust nkag tau mus rau cov kwv qauv ntawm VBA tej yaam num". Tom qab ua hauj lwm nrog macros yog tshuab txais, nyem rau ntawm qhov "OK" khawm nyob hauv qab ntawm lub qhov rais.
  8. Enabling macros hauv Microsoft Excel

  9. Rov qab mus rau lub Excel tsis yog li ntawd tag nrho cov kev hloov mus rau lub chaw nkag mus rau hauv dag zog yuam, kuj nias lub "OK" khawm. Tom qab no, tus tsim tawm tab thiab ua hauj lwm nrog macros yuav qhib kom ua huaj.
  10. Txuag chaw nyob rau hauv lub Microsoft Excel tsis qhov rais

  11. Tam sim no, qhib lub macro editor, peb tsiv mus nyob rau lub "tsim tawm" tab, uas peb nyuam qhuav tshuab txais. Tom qab ntawd, nyob rau hauv kab xev rau hauv lub "Code" lub cuab tam thaiv, nyem rau ntawm qhov loj "Visual Basic" icon.

    Mus rau macro editor hauv Microsoft Excel

    Macro editor kuj yuav launched los ntawm typing lub Alt + F11 keyboard keyboard.

  12. Koj yuav ces pom lub macro editor qhov rais, nyob rau hauv rau sab laug ib feem ntawm uas yog cov project "Project" thiab "Properties".

    Macros Editor Chaw nyob rau hauv Microsoft Excel

    Tab sis nws yog tau hais tias tej no yuav tsis muaj nyob rau hauv lub qhov rais uas qhib.

  13. Macros Editor teb nyob rau hauv Microsoft Excel yog uas ploj lawm

  14. Yuav kom pab cov zaub ntawm lub "Project" cheeb tsam, nyem rau ntawm qhov View Kab rov tav ntawv qhia zaub mov yam khoom. Nyob rau hauv daim ntawv uas opens, xaiv cov "Project Explorer" txoj hauj lwm. Los yog koj yuav ua tau ua ke nrog ntawm kub tuav Ctrl + R.
  15. Pab kom Project cheeb tsam nyob rau hauv Macro Editor nyob rau hauv Microsoft Excel

  16. Yuav kom tso saib cov "Properties" cheeb tsam, dua, nyem rau ntawm qhov View ntawv qhia zaub mov khoom, tab sis lub sij hawm no lub "Properties Qhov rai" txoj hauj lwm yog xaiv nyob rau hauv daim ntawv teev. Los yog, raws li ib txoj kev, koj muaj peev xwm tsuas nias lub F4 muaj nuj nqi tseem ceeb.
  17. Enabling cov khoom cheeb tsam nyob rau hauv lub Macro Editor nyob rau hauv Microsoft Excel

  18. Yog hais tias ib cheeb tsam overlaps lwm, raws li nyob rau hauv cov duab hauv qab no, ces koj yuav tsum mus nruab ib lub cursor rau tus ciam ntawm cov cheeb tsam. Nyob rau tib lub sij hawm, nws yuav tsum tau hloov siab los ntseeg mus rau ib tug bidirectional xub. Ces clamp rau sab laug nas khawm thiab luag tus ciam teb thiaj li hais tias ob qhov chaw yog tag nrho tso tawm kom pom nyob rau hauv lub loj heev editor qhov rais.
  19. Dragging rau ib thaj tsam ntawm thaj chaw nyob rau hauv lub macros editor nyob rau hauv Microsoft Excel

  20. Tom qab ntawd, nyob rau hauv lub "Project" cheeb tsam, peb faib lub npe ntawm tus saib xyuas lub caij, uas peb nrhiav tsis tau nws nyob rau hauv lub vaj huam sib luag los yog nyob rau hauv daim ntawv teev cov muab zais ntawv. Nyob rau hauv cov ntaub ntawv no, qhov no yog "Sheet 5". Nyob rau hauv cov ntaub ntawv no, nyob rau hauv lub "Properties" cheeb tsam, lub chaw ntawm no kwv muaj qhia. Peb yuav hais tau txaus siab nyob rau hauv cov yam khoom no "Pom" ( "Visibility"). Tam sim no, nyob rau hauv pem hauv ntej ntawm nws, lub "2 - XLSheetVeryHidden" parameter yog teem. Txhais ua Lavxias teb sab, "Heev Muab zais" txhais tau tias "heev zais", los yog raws li peb yav tas los qhia "supercurrent". Yuav kom hloov no parameter thiab xa rov qab visibility ntawm daim ntawv lo, nyem rau ntawm daim duab peb sab mus rau sab xis ntawm nws.
  21. Fifth ntawv chaw nyob rau hauv Macro Editor nyob rau hauv Microsoft Excel

  22. Tom qab hais tias, ib daim ntawv teev txog peb cov ntawv txheeb los xij tshwm:
    • "-1 - xlsheetvisible" (pom);
    • "0 - XLSheethidden" (muab zais);
    • "2 - XLSheetVeryHidden" (superb).

    Nyob rau hauv kev txiav txim rau daim ntawv lo yuav tsum tau tso tawm kom pom dua rau lub vaj huam sib luag, xaiv cov "-1 - xlsheetvisible" txoj hauj lwm.

  23. Enabling cov zaub ntawm ib tug superblist nyob rau hauv lub loj heev editor nyob rau hauv Microsoft Excel

  24. Tab sis, raws li peb nco ntsoov, muaj yog tseem muaj ib tug muab zais "Sheet 4". Ntawm cov hoob kawm, nws tsis yog supercount thiab yog li ntawd nws yuav tsum ntsia siv tus qauv 3. Yog li ntawd txawm nws yuav yooj yim dua thiab ntau yooj yim. Tab sis, yog hais tias peb pib sib tham txog lub tseem incorporating shortcuts los ntawm lub macro editor, cia saib yuav ua li cas nrog nws koj yuav rov qab kho cov ib txwm thaum hais.

    Nyob rau hauv lub "Project" block, peb faib lub npe "Sau 4". Raws li peb tau pom, nyob rau hauv lub "Properties" cheeb tsam, nyob rau hauv pem hauv ntej ntawm lub "Pom" yam khoom, lub "0 - XLSheethidden" parameter, uas sib raug mus rau lub txwm thaum lub caij. Nyem rau daim duab peb sab mus rau sab laug ntawm no parameter hloov nws.

  25. Plaub Sheet chaw nyob rau hauv Macro Editor nyob rau hauv Microsoft Excel

  26. Nyob rau hauv daim ntawv teev cov tsis uas opens, xaiv "-1 - xlsheetvisible".
  27. Enabling cov zaub ntawm ib tug muab zais daim ntawv nyob rau hauv lub Macro Editor nyob rau hauv Microsoft Excel

  28. Tom qab peb configured cov zaub ntawm tag nrho cov muab zais tej khoom siv rau lub vaj huam sib luag, koj yuav kaw qhov macro editor. Ua li no, nyem rau ntawm qhov txheej txheem kaw khawm raws li ib tug ntoo khaub lig nyob rau hauv rau sab xis ces kaum ntawm lub qhov rais.
  29. Kaw ntawm Macro Editor qhov rais nyob rau hauv Microsoft Excel

  30. Raws li koj tau pom, tam sim no tag nrho cov ntawv yog tso tawm kom pom nyob rau hauv lub Excel vaj huam sib luag.

Tag nrho cov nplooj ntawv yog tso tawm kom pom nyob rau hauv Microsoft Excel.

Zaj lus qhia: Yuav ua li cas mus pab los yog lov tes taw macros nyob rau hauv Excel

Txoj 5: Txum Tim Rov Qab tej thaj chaw deb los xij

Tiam sis feem ntau nws tshwm sim hais tias cov ntawv zoo los ntawm lub vaj huam sib luag tsuas vim hais tias lawv raug muab tshem tawm. Qhov no yog cov feem ntau nyuaj kev xaiv. Yog hais tias nyob rau hauv dhau tus neeg mob, nrog rau cov muaj tseeb algorithm ntawm kev ua, qhov tshwm sim rau es ua kom cov zaub shortcuts yog 100%, ces yog hais tias lawv raug muab tshem tawm, tsis muaj ib tug yuav muab ib tug xws li guarantee ntawm ib tug zoo tshwm sim.

Tshem tawm ntawm daim ntawv lo yog heev yooj yooj yim thiab intuitive. Cia li nias rau ntawm nws nrog txoj cai nas khawm thiab nyob rau hauv cov zaub mov uas zoo nkaus li xaiv lub "RHO TAWM" kev xaiv.

Tshem tawm cov ntawv hauv Microsoft Excel

Tom qab hais tias, ib tug deletion ceeb toom tshwm raws li ib tug dialog box. Mus ua kom tiav rau txoj kev, nws yog txaus mus nias rau qhov "rho tawm" khawm.

Daim ntawv teev cov kev tshem tawm dialog box nyob rau hauv Microsoft Excel

Restore cov chaw taws teeb kwv yog ntau npaum li cas yooj yim.

  1. Yog hais tias koj twb muab ib daim ntawv lo, tiam sis lawv pom tau hais tias nws tau ua nyob rau hauv vain txawm ua ntej txuag cov ntaub ntawv, ces koj yuav tsum cias ze nws los txhaj rau hauv tus txheej txheem khawm kaw cov ntaub ntawv nyob rau hauv rau sab xis ces kaum ntawm lub qhov rais nyob rau hauv daim ntawv ntawm cov ib tug dawb ntoo khaub lig nyob rau hauv ib tug liab square.
  2. Kaw ib phau ntawv nyob rau hauv Microsoft Excel

  3. Nyob rau hauv lub dialog box uas opens tom qab ntawd, koj yuav tsum nias rau ntawm lub khawm "Ua cawm tsis tau".
  4. Kaw lub dialog box nyob rau hauv Microsoft Excel

  5. Tom qab koj qhib cov ntaub ntawv no dua, tej thaj chaw deb tus kwv yuav nyob rau hauv qhov chaw.

Tej thaj chaw deb Tab rau ntawm qhov chaw nyob rau hauv Microsoft Excel

Tab sis nws yuav tsum tau them mus rau lub fact tias es ua kom cov ntawv nyob rau hauv no txoj kev, koj yuav poob tag nrho cov ntaub ntawv los ua kom cov ntaub ntawv, pib nrog nws kawg preservation. Uas yog, nyob rau hauv qhov tseeb, tus neeg siv yuav tsum xaiv ntawm qhov tseeb hais tias yog rau nws ib feem: ib tug tej thaj chaw deb yam khoom los yog cov ntaub ntawv uas nws muaj kev tswj los mus ua kom tom qab kawg preservation.

Tab sis, raws li twb hais saum toj no, qhov no rov qab kev xaiv xwb yuav tsis tsim yog hais tias tus neeg siv puas tau tsis muaj sij hawm los cawm cov ntaub ntawv tom qab deletion. Yuav ua li cas yuav ua li cas yog hais tias tus neeg siv tau khaws cia rau ib daim ntawv los yog feem ntau tawm ntawm nws nrog preservation?

Yog hais tias, tom qab tshem tawm cov daim ntawv lo, koj muaj twb dim hauv phau ntawv, tab sis tsis muaj sij hawm mus kaw nws, uas yog, nws ua rau kev nkag siab rau khawb nyob rau hauv cov ntaub ntawv versions.

  1. Mus rau saib versions, txav mus rau lub "Cov ntaub ntawv" tab.
  2. Tsiv lub Cov ntaub ntawv tab los tej thaj chaw deb ntawv nyob rau hauv Microsoft Excel

  3. Tom qab ntawd, mus rau lub "Paub meej" seem, uas yog tso tawm nyob rau hauv lub ntsug zaub mov. Nyob rau hauv lub central ib feem ntawm lub qhov rais uas qhib lub qhov rais nyob. Nws muaj ib daim ntawv teev tag nrho cov versions ntawm cov ntaub ntawv no cia siv Excel pib cia lub cuab tam. Qhov cuab yeej no yog enabled los ntawm neej ntawd hais thiab tej yam hauv cov ntaub ntawv txhua txhua 10 feeb Yog hais tias koj tsis tau ua nws tus kheej. Tiam sis yog tias koj tau ua phau ntawv kho me ntsis nyob rau hauv lub Excel chaw, xa tawm cov pib cia, koj yuav tsis tau los tej thaj chaw deb yam khoom. Nws yuav tsum raug hais tias tom qab kaw cov ntaub ntawv, qhov no daim ntawv teev yog erased. Yog li ntawd, nws yog ib qho tseem ceeb rau daim ntawv ceeb toom tsis tau ntawm tus kwv thiab txiav txim siab rau qhov yuav tsum tau los nws ua ntej koj kaw phau ntawv.

    Yog li ntawd, nyob rau hauv daim ntawv teev cov autosocated versions, peb tab tom nrhiav rau qhov tseeb txuag kev xaiv, uas yog nqa tawm kom txog rau thaum qhov kev tshem tawm. Nyem rau cov khoom no nyob rau hauv lub qee daim ntawv teev.

  4. Kev hloov mus rau autosocheted version nyob rau hauv Microsoft Excel

  5. Tom qab ntawd, lub qhov rai tshiab yuav qhib rau hauv lub qhov rai tshiab. Raws li koj tuaj yeem pom, nws muaj lub ntsej muag yav dhau los. Txhawm rau kom tiav cov ntaub ntawv rov qab, koj yuav tsum nias ntawm Restore khawm nyob saum lub qhov rais.
  6. Kev Txum Tim Rov Qab Phau Ntawv Hauv Microsoft Excel

  7. Tom qab ntawd, lub thawv ntawv yuav qhib, uas yuav muaj los hloov cov ntaub ntawv tshaj tawm tshiab ntawm phau ntawv los ntawm cov ntawv no. Yog tias nws haum rau koj, nyem rau ntawm "OK" khawm.

    Hloov qhov tseeb khaws tseg ntawm cov ntaub ntawv hauv Microsoft Excel

    Yog tias koj xav tawm ob qho tib si ntawm cov ntaub ntawv (nrog cov ntaub ntawv siv tau thiab nrog cov ntaub ntawv siv tau ntxiv rau phau ntawv tom qab tshem tawm), tom qab ntawd mus rau "File" tab thiab nyem rau ntawm "Tseg li ...".

  8. Mus txuag cov ntaub ntawv hauv Microsoft Excel

  9. Pib lub qhov rais cawm. Hauv nws, nws yuav tsum tau hloov npe cov phau ntawv zoo noj qab, tom qab ntawd nyem rau ntawm "Tseg" khawm.
  10. Txuag cov ntaub ntawv hauv Microsoft Excel

  11. Tom qab ntawd koj yuav tau txais ob qho qauv ntawm cov ntaub ntawv.

Cov ntaub ntawv yog rov qab rau Microsoft Excel

Tab sis yog tias koj tau txais kev cawmdim thiab kaw cov ntaub ntawv, thiab lwm zaus koj yuav tsis muaj peev xwm tshem tawm nrog txoj kev zoo sib xws, txij li cov npe ntawm cov ntaub ntawv yuav yog ntxuav. Tab sis koj tuaj yeem sim rov qab los ntawm kev tswj hwm version, txawm hais tias qhov ntxim nyiam ntawm kev vam meej hauv qhov no yog qis dua thaum siv cov kev xaiv yav dhau los.

  1. Mus rau "cov ntaub ntawv" tab thiab hauv "cov khoom" nyem rau ntawm "khawm kev tswj hwm" version ". Tom qab ntawd, cov ntawv qhia zaub mov me me tshwm, muaj ib qho tsuas yog ib qho taw tes - "rov qab cov ntawv unshakable". Nyem rau ntawm nws.
  2. Mus rau kom rov qab cov ntaub ntawv tsis tau txais txiaj ntsig hauv Microsoft Excel

  3. Lub qhov rai qhib lub qhov rai hauv cov ntawv qhia uas muaj cov tsis muaj phau ntawv nyob rau hauv XLSB binary hom. Xaiv xaiv cov npe thiab nyem rau ntawm "Qhib" khawm nyob rau hauv qab ntawm lub qhov rais. Tej zaum yog ib qho ntawm cov ntaub ntawv no yuav yog phau ntawv muaj cov khoom nyob deb uas koj xav tau.

Rov qab sau cov phau ntawv tsis tau txais cai hauv Microsoft Excel

Tsuas yog qhov tshwm sim ntawm kev nrhiav cov phau ntawv yog yog me me. Ib qho ntxiv, txawm hais tias nws muaj nyob rau hauv cov npe no thiab muaj cov chaw taws teeb, nws yog qhov yuav muaj qub thiab tsis muaj ntau qhov kev hloov pauv uas tau ua rau tom qab.

Zaj Lus Qhia: Rov kho cov phau ntawv khaws tseg

Raws li peb tuaj yeem pom, qhov ploj ntawm cov ntawv lo hauv vaj huam sib luag tuaj yeem tshwm sim los ntawm ntau cov laj thawj, tab sis lawv tuaj yeem muab faib ua ob pawg loj: Cov ntawv sau tau zais lossis tshem tawm. Hauv thawj kis, cov ntawv sau txuas ntxiv ib feem ntawm cov ntawv, tsuas yog nkag mus rau lawv yog qhov nyuaj. Tab sis yog tias xav tau, los ntawm kev txhais txoj kev, cov ntawv lo tau muab zais, ua kom rov qab los ntawm cov kev coj ua, kom rov qab ua haujlwm hauv phau ntawv yuav tsis nyuaj. Ib qho ntxiv, yog tias cov khoom tau raug tshem tawm. Hauv qhov no, lawv tau muab tag nrho cov ntaub ntawv, thiab lawv txoj kev rov ua haujlwm tsis tu ncua. Txawm li cas los xij, txawm tias nyob rau hauv cov ntaub ntawv no, nws yog qee zaum ua tau los rov qab cov ntaub ntawv.

Nyeem ntxiv