Yuav ua li cas nkaum cov ntawv hauv Excel, yuav ua li cas qhia cov ntawv hauv Excel (cov ntawv zais)

Ib qho txiaj ntsig loj ntawm Excel spreadsheets yog tias tus neeg siv tuaj yeem ua haujlwm nrog ib daim ntawv thiab ob peb. Qhov no ua rau nws tuaj yeem tsim cov ntaub ntawv yooj yim dua. Tab sis qee zaum nws tuaj yeem nrog qee qhov teeb meem. Zoo, muaj txhua yam xwm txheej, nws yuav muaj cov ntaub ntawv hais txog nyiaj txiag tseem ceeb lossis qee yam kev lag luam zais cia uas yuav tsum tau muab zais los ntawm cov neeg sib tw. Qhov no tuaj yeem ua tiav txawm tias cov cuab yeej Excel txheem. Yog tias tus neeg siv yuam kev zais daim ntawv, ces peb yuav txiav txim siab seb yuav tsum ua li cas los qhia nws. Yog li, dab tsi yuav tsum tau ua los ua ob qho tib si thawj thiab thib ob?

Yuav ua li cas nkaum ib daim ntawv ntawm cov ntawv qhia zaub mov

Txoj kev no yog qhov yooj yim tshaj plaws los siv vim nws muaj ob kauj ruam.

1. Ua ntej peb yuav tsum hu rau cov ntawv qhia zaub mov. Txhawm rau ua qhov no, koj yuav tsum nyem rau sab xis lossis nias nrog ob ntiv tes ntawm lub trackpad, tom qab txav tus cursor mus rau qhov chaw koj xav tau. Qhov kev xaiv kawg hu rau cov ntawv qhia zaub mov tsuas yog txhawb nqa los ntawm cov khoos phis tawj niaj hnub, thiab tsis yog tag nrho. Txawm li cas los xij, feem ntau cov kev khiav hauj lwm niaj hnub no txhawb nqa nws, vim nws yooj yim dua li tsuas yog nias lub pob tshwj xeeb ntawm lub trackpad.
2. Hauv cov ntawv qhia zaub mov uas tshwm sim, nrhiav "Hide" khawm thiab nyem rau ntawm nws.

Txhua yam, ntxiv daim ntawv no yuav tsis tso tawm.

Yuav ua li cas nkaum ib daim ntawv hauv Excel siv cov cuab yeej

Txoj kev no tsis nrov npaum li yav dhau los. Txawm li cas los xij, muaj qhov ua tau zoo li no, yog li nws yuav zoo kom paub txog nws. Muaj ob peb yam uas yuav tsum tau ua ntawm no:

1. Xyuas seb koj nyob rau ntawm "Tsev" tab lossis hauv lwm qhov. Yog tias tus neeg siv muaj lwm lub tab qhib, koj yuav tsum txav mus rau "Lub Tsev".
2. Muaj ib yam khoom "Cells". Koj yuav tsum nyem rau ntawm lub pob sib txuas. Tom qab ntawd peb lub khawm ntxiv yuav tshwm sim, uas peb txaus siab rau txoj cai tshaj plaws (kos npe ua "Format").
3. Tom qab ntawd, lwm cov ntawv qhia zaub mov tshwm, qhov twg hauv nruab nrab yuav muaj kev xaiv "Hide lossis qhia". Peb yuav tsum nyem rau ntawm "Hide sheet".
4. Tom qab ua tiav tag nrho cov kauj ruam no, daim ntawv yuav muab zais ntawm qhov muag ntawm lwm tus neeg.

Yog hais tias qhov kev pab cuam lub qhov rais tso cai rau qhov no, ces lub "Hom ntawv" khawm yuav tso tawm ncaj qha rau ntawm lub ribbon. Yuav tsis muaj kev nyem rau ntawm "Cells" khawm ua ntej no, txij li tam sim no nws yuav yog ib qho thaiv ntawm cov cuab yeej.

Lwm lub cuab yeej uas tso cai rau koj los nkaum ib daim ntawv hu ua Visual Basic Editor. Txhawm rau qhib nws, koj yuav tsum nias qhov tseem ceeb ua ke Alt + F11. Tom qab ntawd, peb nyem rau ntawm daim ntawv txaus siab rau peb thiab saib rau lub qhov rais khoom. Peb txaus siab rau qhov Visible xaiv.

Muaj peb txoj kev xaiv rau customizing daim ntawv zaub:

1. Daim ntawv qhia. Denoted los ntawm code -1 nyob rau hauv daim duab saum toj no.
2. Daim ntawv tsis qhia, tab sis nws tuaj yeem pom hauv daim ntawv teev cov ntawv zais. Denoted los ntawm code 0 nyob rau hauv daim ntawv teev cov khoom.
3. Cov nplooj yog heev khov kho zais. Qhov no yog qhov tshwj xeeb ntawm VBA editor uas tso cai rau koj los nkaum ib daim ntawv kom nws tsis tuaj yeem pom hauv cov npe ntawm cov ntawv zais los ntawm "Show" khawm hauv cov ntawv qhia zaub mov.

Tsis tas li ntawd, VBA editor ua rau nws muaj peev xwm ua kom cov txheej txheem automate nyob ntawm seb qhov tseem ceeb, raws li kev xaiv, muaj nyob rau hauv lub hlwb los yog dab tsi tshwm sim.

Yuav ua li cas nkaum ntau nplooj ntawv ib zaug

Tsis muaj qhov sib txawv ntawm yuav ua li cas nkaum ntau tshaj ib daim ntawv hauv kab lossis yuav ua li cas nkaum ib qho ntawm lawv. Koj tuaj yeem nkaum lawv ua ntu zus raws li tau piav qhia saum toj no. Yog tias koj xav txuag sijhawm me ntsis, ces muaj lwm txoj hauv kev. Ua ntej koj siv nws, koj yuav tsum xaiv tag nrho cov nplooj ntawv uas yuav tsum tau muab zais. Ua raws li cov kev ua hauv qab no kom tshem tawm ob peb nplooj ntawv los ntawm kev saib tib lub sijhawm:

1. Yog tias lawv nyob ib sab, peb yuav tsum siv tus yuam sij Shift los xaiv lawv. Txhawm rau pib, peb nyem rau ntawm thawj daim ntawv, tom qab ntawd peb nias thiab tuav lub pob no ntawm cov keyboard, tom qab ntawd peb nyem rau ntawm daim ntawv kawg ntawm cov uas peb yuav tsum tau nkaum. Tom qab ntawd, koj tuaj yeem tso tus yuam sij. Feem ntau, tsis muaj qhov txawv ntawm qhov kev txiav txim no yuav tsum tau ua. Koj tuaj yeem pib ntawm qhov kawg, tuav Shift, thiab tom qab ntawd mus rau thawj tus. Txhawm rau siv txoj kev no, koj yuav tsum npaj cov nplooj ntawv kom muab zais ib sab ntawm ib leeg los ntawm kev rub tus nas.
2. Txoj kev thib ob yog xav tau yog tias cov nplooj ntawv tsis nyob ib sab. Nws yuav siv sij hawm ntev me ntsis. Txhawm rau xaiv ob peb uas nyob ntawm ib qho kev ncua deb ntawm ib leeg, koj yuav tsum nyem rau ntawm thawj daim ntawv, thiab tom qab ntawd xaiv ib qho txuas ntxiv nrog Ctrl tus yuam sij. Lawm, nws yuav tsum tau khaws cia nias, thiab rau txhua daim ntawv, ua ib zaug nias nrog rau sab laug nas khawm.

Thaum peb ua tiav cov kauj ruam no, cov kauj ruam tom ntej zoo ib yam. Koj tuaj yeem siv cov ntawv qhia zaub mov thiab zais cov tabs lossis nrhiav cov khawm sib raug ntawm lub toolbar.

Yuav ua li cas qhia cov ntawv zais hauv Excel

Muaj ntau txoj hauv kev los qhia cov ntawv zais hauv Excel. Qhov yooj yim tshaj plaws ntawm lawv yog siv tib lub ntsiab lus qhia zaub mov kom zais nws. Txhawm rau ua qhov no, koj yuav tsum nyem rau ntawm ib qho ntawm cov nplooj ntawv seem, nyem nyem rau ntawm tus nas (lossis siv qhov tshwj xeeb trackpad taw qhia yog tias koj los ntawm lub laptop niaj hnub) thiab nrhiav lub pob "Qhia" hauv cov npe uas tshwm. Tom qab peb nyem nws, lub qhov rais yuav tshwm sim nrog cov npe ntawm cov ntawv zais. Nws yuav tshwm sim txawm tias tsuas muaj ib daim ntawv xwb.

Yog tias kev zais tau ua tiav siv macro, ces koj tuaj yeem qhia tag nrho cov nplooj ntawv uas tau muab zais nrog me ntsis code.

Sub OpenAllHiddenSheets()

    Dim Sheet As Worksheet

    Rau Txhua Daim Ntawv Hauv ActiveWorkbook.Worksheets

        Yog Sheet.Visible <> xlSheetVisible Ces

            Sheet.Visible = xlSheetVisible

        Xaus Yog

    Tom ntej no

End Sub

Tam sim no nws tseem tsuas yog khiav qhov macro no, thiab tag nrho cov ntawv zais yuav qhib tam sim ntawd. Siv macros yog ib txoj hauv kev yooj yim rau kev qhib thiab zais cov nplooj ntawv nyob ntawm seb muaj xwm txheej dab tsi tshwm sim hauv qhov program. Tsis tas li ntawd, siv macros, koj tuaj yeem pom ntau cov nplooj ntawv ib zaug. Nws yog ib txwm yooj yim ua qhov no nrog code.