Yuav ua li cas qhia ib daim ntawv zais hauv Excel

Hloov tshiab kawg: 08/16/2023
Tus sau: Sebastian Vidal

Hauv lub ntiaj teb daim ntawv qhia, Microsoft Excel Nws sawv tawm rau kev ua ntau yam thiab muaj zog cov cuab yeej. Ib qho ntawm cov txiaj ntsig zoo tshaj plaws uas nws muaj yog lub peev xwm zais cov nplooj ntawv los teeb tsa thiab tiv thaiv cov ntaub ntawv. Hauv daim ntawv dawb no, peb yuav tshawb xyuas cov txheej txheem ntawm yuav ua li cas unhide ib daim ntawv zais hauv Excel, muab kauj ruam yog kauj ruam cov lus qhia ntxaws. Txawm hais tias koj yog tus tshiab rau Excel lossis tus neeg siv paub dhau los, phau ntawv qhia no yuav pab koj paub qhov no thiab tau txais txiaj ntsig zoo tshaj plaws ntawm koj cov ntawv tshaj tawm.

1. Taw qhia txog kev zais thiab qhia cov nplooj ntawv hauv Excel

Hauv Excel, koj tuaj yeem nkaum thiab qhia cov ntawv ua haujlwm kom yooj yim saib cov ntaub ntawv thiab teeb tsa cov ntsiab lus los ntawm ib daim ntawv. Qhov kev ua haujlwm no yog qhov tshwj xeeb tshaj yog thaum ua haujlwm nrog Excel phau ntawv ua haujlwm uas muaj ntau daim ntawv. Kev zais ib daim ntawv ua rau nws tsis pom, tab sis koj tseem tuaj yeem nkag mus rau nws thiab ua haujlwm nrog nws cov ntsiab lus. Ntawm qhov tod tes, qhia ib daim ntawv ua rau nws pom dua.

Txhawm rau nkaum ib daim ntawv hauv Excel, tsuas yog ua raws cov kauj ruam no:

  • Xaiv cov ntawv koj xav nkaum los ntawm txhaj nws tab nyob hauv qab ntawm Excel qhov rais.
  • Txoj cai-nias ntawm lub tab xaiv thiab xaiv "Hide" kev xaiv los ntawm cov ntawv qhia zaub mov nco.
  • Daim ntawv xaiv yuav raug muab zais tam sim ntawd thiab yuav tsis pom nyob rau hauv Excel qhov rais.

Yog tias koj xav qhia ib daim ntawv zais hauv Excel, koj tuaj yeem ua tau raws li cov kauj ruam no:

  • Mus rau "Tsev" tab ntawm Excel ribbon.
  • Nyem qhov "Format" khawm hauv "Cells" pawg.
  • Los ntawm cov ntawv qhia zaub mov nco-down, xaiv "Sheet Visibility" kev xaiv thiab tom qab ntawd nyem "Show Sheet."
  • Daim ntawv zais yuav tshwm dua hauv Excel qhov rais.

Nkaum thiab qhia cov nplooj ntawv hauv Excel yog lub cuab yeej zoo los tswj cov ntaub ntawv thiab txhim kho lub koom haum ntawm cov ntaub ntawv. Nco ntsoov tias koj nco qab cov kauj ruam uas tau hais los saum toj no los siv cov haujlwm no zoo hauv koj cov haujlwm los ntawm Excel.

2. Cov kauj ruam rau unhide ib daim ntawv zais hauv Excel

Hauv tsab xov xwm no peb yuav muab cov kauj ruam tsim nyog rau koj kom tsis txhob zais ib daim ntawv zais hauv Excel. Nrog rau cov ntaub ntawv no koj yuav tuaj yeem nkag mus rau txhua daim ntawv uas tau muab zais rau hauv koj cov ntaub ntawv thiab rov qab tau tag nrho cov ntaub ntawv koj xav tau.

1. Qhib lub Cov ntaub ntawv Excel uas muaj cov ntawv zais koj xav kom unhide.

2. Txoj nyem rau ntawm daim ntawv tab nyob hauv qab ntawm Excel qhov rais.

3. Los ntawm cov ntawv qhia zaub mov nco, xaiv "Unhide" los qhia cov nplooj ntawv zais.

4. Lub dialog box yuav tshwm sim qhia tag nrho cov ntaub ntawv zais hauv cov ntaub ntawv. Xaiv daim ntawv koj xav kom unhide thiab nias "OK."

Thiab yog nws! Tam sim no daim ntawv koj xaiv yuav pom thiab koj tuaj yeem nkag mus rau nws cov ntsiab lus yam tsis muaj teeb meem.

3. Advanced xaiv los qhia cov nplooj ntawv zais hauv Excel

Thaum siv Microsoft Excel, koj yuav pom koj tus kheej xav tau los qhia cov ntawv zais hauv koj phau ntawv ua haujlwm. Hmoov zoo, muaj ntau ntau yam kev xaiv uas koj tuaj yeem siv kom ua tiav qhov no zoo. Hauv qab no, peb yuav nthuav qhia qee qhov kev xaiv no:

  1. Siv daim ntawv toggle feature: Excel muaj ib daim ntawv toggle feature uas tso cai rau koj kom sai sai qhia lossis zais nplooj ntawv. Koj tuaj yeem nkag mus rau qhov no los ntawm txoj cai-nias ntawm ib daim ntawv tab nyob hauv qab ntawm Excel qhov rais thiab xaiv "Qhia" lossis "Hide." Qhov no yuav ua rau koj nkag tau sai rau kev tswj cov ntawv zais.
  2. Siv lub "Saib" tab ntawm lub ribbon: Lwm qhov kev xaiv los tso saib cov nplooj ntawv zais yog siv "Saib" tab ntawm Excel ribbon. Hauv lub tab no, koj yuav pom ib ntu hu ua "Windows" uas muaj ntau yam cuab yeej siv tau. Piv txwv li, koj tuaj yeem nyem "Hloov Qhov rai" kom pom cov npe ntawm txhua nplooj ntawv hauv koj phau ntawv ua haujlwm, suav nrog cov ntawv zais. Tsuas xaiv daim ntawv koj xav tso saib thiab nyem "OK."
  3. Siv cov lub taskbar los ntawm Excel: Ntxiv nrog rau cov kev xaiv saum toj no, Excel kuj tseem muaj lub luag haujlwm tseem ceeb uas tso cai rau koj nkag mus sai sai rau cov ntawv zais. Txhawm rau nkag mus rau qhov haujlwm no, nyem rau txhua qhov chaw ntawm Excel lub npe bar thiab xaiv "Cov Ntawv." Ib daim ntawv teev npe ntawm tag nrho cov nplooj ntawv hauv koj phau ntawv ua haujlwm yuav tshwm sim, suav nrog cov ntawv zais. Nyem rau ntawm daim ntawv koj xav tso saib thiab nws yuav qhib rau hauv lub qhov rais Excel tshiab.

Cov no tsuas yog qee qhov kev xaiv siab heev Excel muab rau kev qhia cov ntawv zais. Los ntawm kev siv cov cuab yeej no, koj tuaj yeem tswj hwm koj cov nplooj ntawv yooj yim thiab nkag mus rau cov ntaub ntawv koj xav tau hauv koj phau ntawv ua haujlwm. Yog tias koj xav kawm los ntawm cov lus qhia ntxaws ntxaws, koj tuaj yeem nrhiav ntau cov kev pabcuam hauv online uas yuav coj koj mus rau kauj ruam los ntawm cov txheej txheem no. Xav tias dawb tshawb nrhiav tag nrho cov kev xaiv no thiab nrhiav seb qhov twg ua haujlwm zoo tshaj rau koj!

4. Siv Unprotect Sheets Option hauv Excel

Hauv qee qhov xwm txheej, koj yuav tsum tsis txhob tiv thaiv Excel nplooj ntawv txhawm rau hloov lossis hloov qee cov ntaub ntawv. Hmoov zoo, Excel muaj kev xaiv yooj yim kom ua tiav txoj haujlwm no. Ntawm no peb yuav qhia koj yuav ua li cas ua nws ib kauj ruam:

Cov ntsiab lus tshwj xeeb - Nyem qhov no  Yuav Ua Li Cas Qhib Lub Tsheb Tsis Muaj Tus Yuam Sij

1. Qhib cov ntaub ntawv Excel uas muaj cov nplooj ntawv koj xav kom tsis txhob tiv thaiv.
2. Nyem qhov "Saib xyuas" tab hauv lub cuab yeej los ntawm Excel.
3. Nyob rau hauv "Hloov" pab pawg ntawm "Saib xyuas" tab, nrhiav thiab nias lub pob "Unprotect Sheet" khawm. Qhov no yuav qhib "Unprotect Sheet" dialog box.

Thaum koj tau ua raws li cov kauj ruam no, cov nplooj ntawv koj xaiv yuav tsis muaj kev tiv thaiv thiab koj tuaj yeem hloov pauv rau lawv. Nco ntsoov tias nws yog ib qho tseem ceeb uas yuav tsum xav txog kev ruaj ntseg ntawm koj cov ntaub ntawv thiab tiv thaiv cov nplooj ntawv dua thaum koj ua tiav koj cov kev hloov pauv.

5. Yuav ua li cas rov qab tau ib daim ntawv yuam kev deleted hauv Excel

Rov qab tau ib daim ntawv tsis raug tshem tawm hauv Excel tuaj yeem ntxhov siab, tab sis hmoov zoo muaj ntau txoj hauv kev los kho nws. Hauv qab no, peb yuav muab koj cov kauj ruam yooj yim los ntawm kauj ruam kom koj tuaj yeem rov qab tau koj cov ntaub ntawv yam tsis muaj teeb meem.

1. Ua ntej, qhib Excel thiab mus rau hauv qab ntawm lub qhov rais, qhov chaw koj yuav pom cov ntawv tab. Right-click rau ntawm ib lub tab thiab xaiv "Rov qab Deleted Sheet." Qhov no yuav qhib "Rov qab Cov Ntawv" dialog box uas koj tuaj yeem pom tag nrho cov nplooj ntawv tshem tawm.

2. Nyob rau hauv lub "Rov qab nplooj ntawv" dialog box, xaiv cov ntawv koj xav rov qab thiab nias rau "OK" khawm. Daim ntawv deleted yuav rov qab los thiab yuav tshwm sim dua nyob rau hauv qab ntawm Excel lub qhov rais, nyob ib sab ntawm lwm cov ntawv nthuav qhia.

6. Tricks los txheeb xyuas thiab qhia tag nrho cov ntawv zais hauv Excel

Kev txheeb xyuas thiab qhia tag nrho cov ntawv zais hauv Excel tuaj yeem yog qhov kev sib tw, tab sis nrog ob peb lub tswv yim thiab cov tswv yim, koj tuaj yeem kho qhov teeb meem no sai. Ntawm no kuv nthuav qhia qee cov tswv yim uas yuav pab koj txheeb xyuas thiab qhia cov ntawv zais hauv Excel:

1. Siv cov ntaub ntawv tshawb xyuas: Qhov no feature yuav tso cai rau koj los txheeb xyuas tag nrho cov ntawv zais hauv koj daim ntawv Excel. Txhawm rau nkag mus rau qhov tshwj xeeb no, mus rau "Tshawb xyuas" tab hauv toolbar thiab nyem "Tshem Cov Ntaub Ntawv." Thaum koj nyem qhov kev xaiv no, Excel yuav pom thiab tso saib tag nrho cov ntawv zais hauv koj daim ntawv.

2. Siv lub vaj huam sib luag navigation: Lub pane navigation yog cov cuab yeej muaj txiaj ntsig uas tso cai rau koj taug qab thiab tswj tag nrho cov nplooj ntawv hauv koj daim ntawv Excel. Txhawm rau qhib lub pane navigation, mus rau "Saib" tab hauv toolbar thiab nyem "Navigation Pane." Tom ntej no, siv cov kev xaiv muaj nyob rau hauv navigation pane los txheeb xyuas thiab tso saib cov nplooj ntawv zais hauv koj daim ntawv.

3. Siv qhov "Kho khoom yam khoom" toolbar: Lwm txoj hauv kev los txheeb xyuas thiab qhia cov ntawv zais hauv Excel yog los ntawm kev siv "Kho Khoom Siv" toolbar. Txhawm rau nkag mus rau qhov toolbar no, mus rau "Tsev" tab hauv toolbar thiab nyem "Nrhiav thiab Xaiv." Tom ntej no, xaiv "Hloov Khoom" los ntawm cov ntawv qhia zaub mov. Siv cov kev xaiv muaj nyob rau ntawm lub toolbar no txhawm rau txheeb xyuas thiab tso saib cov nplooj ntawv zais hauv koj daim ntawv.

7. Yuav ua li cas qhia ib daim ntawv zais hauv Excel

Ib qho ntawm cov txiaj ntsig zoo ntawm Excel yog lub peev xwm zais cov nplooj ntawv hauv phau ntawv ua haujlwm. Txawm li cas los xij, qee zaum qhov kev xav tau yuav tshwm sim los unhide ib daim ntawv tshwj xeeb uas tau muab zais. Hmoov zoo, Excel muaj txoj hauv kev yooj yim los ua qhov no, thiab hauv qab no yog cov kauj ruam ua raws.

1. Qhib phau ntawv ua haujlwm hauv Excel thiab mus rau "Tsev" tab ntawm kab.

2. Txoj nyem rau ntawm daim ntawv pom nyob hauv qab ntawm Excel qhov rais. Tom qab ntawd lub ntsiab lus teb yuav tshwm sim.

3. Los ntawm cov ntawv qhia zaub mov, xaiv qhov "Show" xaiv thiab ces nias "Qhia zais daim ntawv". Lub dialog box qhib qhia cov npe ntawm tag nrho cov ntawv zais hauv phau ntawv ua haujlwm.

Hauv luv luv, kom pom cov ntawv zais tshwj xeeb hauv Excel, koj yuav tsum nkag mus rau "Show Hidden Sheet" dialog box los ntawm cov ntawv qhia zaub mov ntawm cov ntawv tabs pom. Los ntawm qhov ntawd, koj tuaj yeem xaiv cov ntawv zais uas xav tau thiab nyem "OK" los tso saib nws. Cov txheej txheem no yog qhov ceev thiab yooj yim, thiab tuaj yeem pab tau thaum koj xav tau ceev nrooj nkag mus rau cov ntaub ntawv zais hauv daim ntawv nthuav dav.

8. Qhia ntau daim ntawv zais hauv Excel ib txhij

Qee lub sij hawm nws tuaj yeem muaj txiaj ntsig los tso saib ntau daim ntawv zais hauv Excel tib lub sijhawm es tsis txhob nyem rau ntawm txhua lub tab saib nws cov ntsiab lus. Hmoov zoo, Excel muab txoj hauv kev yooj yim los ua kom tiav qhov no yam tsis tas yuav manually unhide txhua daim ntawv ib tus zuj zus.

Txhawm rau qhia ntau daim ntawv zais hauv Excel, ua ntej koj yuav tsum xaiv tag nrho cov nplooj ntawv koj xav tso rau tib lub sijhawm. Koj tuaj yeem ua qhov no los ntawm kev tuav tus yuam sij Ctrl thiab nyem rau ntawm cov ntawv zais tabs. Thaum koj tau xaiv tag nrho cov nplooj ntawv, koj tuaj yeem xaiv txoj cai-nias ib qho tab thiab xaiv qhov "Show" kev xaiv los ntawm cov ntawv qhia zaub mov nco.

Cov ntsiab lus tshwj xeeb - Nyem qhov no  Puas siv tau DAEMON Tools los saib cov ntsiab lus ntawm lub virtual disk?

Lwm txoj hauv kev los qhia ntau daim ntawv zais yog siv cov keyboard shortcut. Tom qab xaiv tag nrho cov ntawv zais koj xav qhia, tsuas yog nias Ctrl + Ua haujlwm + 9 tib lub sijhawm. Qhov no yuav ua rau tag nrho cov ntawv xaiv tau tso tawm tam sim. Nco ntsoov tias cov keyboard shortcut no tsuas ua haujlwm yog tias tag nrho cov ntawv xaiv tau sib txuas. Yog tias muaj cov ntawv tsis sib txuas uas koj xav tso tawm, koj yuav tsum siv txoj kev dhau los.

9. Yuav ua li cas npaj thiab hloov npe zais cov nplooj ntawv hauv Excel

Kev npaj thiab hloov npe zais cov nplooj ntawv hauv Excel tuaj yeem muaj txiaj ntsig zoo los khaws koj cov ntaub ntawv thiab tuaj yeem nrhiav cov ntaub ntawv sai thiab yooj yim. Hmoov zoo, Excel muaj ntau txoj hauv kev los ua kom tiav txoj haujlwm no. ua tau zooTom ntej no, peb mam li qhia koj yuav ua li cas ua nws ib kauj ruam zuj zus.

1. Txhawm rau npaj cov ntawv zais, thawj qhov koj yuav tsum tau ua yog xaiv "Cov Ntawv" tab nyob hauv qab sab laug ntawm Excel qhov rai. Cov ntawv qhia zaub mov poob yuav tshwm sim nrog tag nrho cov nplooj ntawv hauv phau ntawv ua haujlwm. (Hloov siab)

2. Txoj cai-nias rau ntawm daim ntawv koj xav hloov npe thiab xaiv "Rename" kev xaiv los ntawm cov ntawv qhia zaub mov nco. Lub qhov rais pop-up yuav qhib qhov twg koj tuaj yeem nkag mus rau daim ntawv tshiab lub npe. Nco ntsoov xaiv lub npe piav qhia uas yuav pab koj txheeb xyuas cov ntsiab lus ntawm daim ntawv sai sai. (Hloov siab)

3. Txhawm rau nkaum ib daim ntawv hauv Excel, tsuas yog nyem rau ntawm daim ntawv koj xav nkaum thiab xaiv qhov "Hide" xaiv los ntawm cov ntawv qhia zaub mov nco. Daim ntawv yuav muab zais tam sim ntawd, tab sis tseem yuav muaj rau siv hauv phau ntawv ua haujlwm. Txhawm rau qhia cov ntawv zais, tsuas yog rov ua cov txheej txheem tib yam thiab xaiv qhov "Show" xaiv tsis yog "Hide". (Hloov siab)

10. Kev daws teeb meem thaum qhia cov ntawv zais hauv Excel

Muaj ntau ntau yam teeb meem thaum sim unhide zais cov nplooj ntawv hauv Excel, tab sis hmoov zoo muaj cov kev daws teeb meem yooj yim. Ntawm no peb nthuav qhia qee qhov kev daws teeb meem los daws cov teeb meem no:

1. Txheeb xyuas cov ntawv zais cia: Cov nplooj ntawv yuav raug muab zais vim qhov teeb tsa tsis raug. Txhawm rau txheeb xyuas qhov no, mus rau "Tsev" tab hauv Excel thiab nyem lub pob "Format" hauv pawg "Cells". Tom ntej no, xaiv "Pib" thiab tom qab ntawd "Show Sheet." Yog tias qhov kev xaiv daim ntawv qhia tau raug kaw, tsuas yog qhib qhov kev xaiv no thiab cov ntawv zais yuav tsum pom dua.

2. Siv cov keyboard shortcuts: Lwm qhov kev xaiv los qhia cov ntawv zais hauv Excel yog siv cov keyboard shortcuts. Tsuas yog nias "Ctrl" + "Shift" + "9" thiab cov ntawv zais yuav tshwm. Yog tias koj muaj ntau daim ntawv zais, koj tuaj yeem siv "Ctrl" + "Shift" + "sab laug / sab xis" txav ntawm lawv.

3. Siv cov haujlwm "Show all": Yog tias tsis muaj cov kev daws teeb meem saum toj no ua haujlwm, koj tuaj yeem sim siv qhov "Show All" feature. Mus rau "Tshawb xyuas" tab hauv Excel thiab nyem "Qhia tag nrho" hauv pawg "Hloov". Qhov no yuav qhia tag nrho cov ntawv zais hauv koj cov ntaub ntawv.

11. Kev txiav txim siab txog kev nyab xeeb thaum qhia cov ntawv zais hauv Excel

Txhawm rau kom muaj kev ruaj ntseg thaum pom cov ntawv zais hauv Excel, nws yog ib qho tseem ceeb uas yuav tsum ua raws li qee qhov kev txiav txim siab tseem ceeb. Ua ntej tshaj plaws, nws raug nquahu kom tiv thaiv daim ntawv nthuav dav nrog tus password kom tsis txhob muaj kev tso cai nkag mus rau cov ntaub ntawv zais. Qhov no Nws ua tau los ntawm kev xaiv "Tshawb xyuas" tab hauv toolbar thiab tom qab ntawd nyem "Protect Sheet."

Lwm qhov kev ntsuas kev nyab xeeb tseem ceeb yog los xyuas kom meej tias tsis muaj cov ntaub ntawv rhiab lossis tsis pub lwm tus paub pom ntawm cov ntawv zais. Nws yog ib lub tswv yim zoo kom ua tib zoo tshuaj xyuas cov ntsiab lus ua ntej zais ib daim ntawv thiab xyuas kom tsis txhob muaj cov ntaub ntawv ntiag tug, xws li passwords, social security naj npawb, lossis lwm yam ntaub ntawv ntiag tug, suav nrog.

Tsis tas li ntawd, nws tseem ceeb heev uas yuav tsum nco ntsoov tias cov ntawv zais hauv Excel tseem tuaj yeem pom rau txhua tus neeg uas nkag mus rau cov ntaub ntawv. Yog xav tau ib theem ntxiv ntawm kev ruaj ntseg, koj tuaj yeem xav siv cov cuab yeej encryption los tiv thaiv cov ntaub ntawv zais. Muaj ntau ntau txoj kev xaiv uas tso cai rau koj nkag mus rau tag nrho cov ntawv nthuav qhia lossis tsuas yog qee lub hlwb lossis cov ntaub ntawv tshwj xeeb.

12. Yuav ua li cas qhia ib daim ntawv tiv thaiv yav dhau los hauv Excel

Thaum peb ua haujlwm nrog cov ntawv Excel tiv thaiv, tej zaum yuav muaj lub sijhawm uas peb xav tau los qhia lawv cov ntsiab lus yam tsis muaj kev tiv thaiv tag nrho. Qhov no yog qhov tshwj xeeb tshaj yog thaum peb xav nthuav tawm cov ntaub ntawv hauv daim ntawv tiv thaiv rau tus neeg siv khoom lossis tus neeg koom tes yam tsis pub lawv hloov pauv. Hmoov zoo, Excel muaj txoj hauv kev yooj yim los tso saib daim ntawv tiv thaiv yav dhau los yam tsis tas yuav qhib qhov kev tiv thaiv.

Txhawm rau tso saib daim ntawv tiv thaiv yav dhau los hauv Excel, ua raws cov kauj ruam no:

  1. Qhib Excel cov ntaub ntawv uas muaj cov ntawv tiv thaiv.
  2. Nyem "Tshawb xyuas" tab ntawm Excel toolbar.
  3. Hauv pab pawg "Hloov", nyem "Unprotect Sheet."
  4. Yog tias koj raug ceeb toom rau tus password, sau tus password koj siv los tiv thaiv daim ntawv.
  5. Thaum daim ntawv txheeb xyuas tawm, xaiv cov ntsiab lus koj xav tso saib.
  6. Right-click qhov kev xaiv thiab xaiv "Copy" los ntawm cov ntawv qhia zaub mov nco-down.
  7. Qhib ib daim ntawv tshiab hauv tib phau ntawv ua haujlwm Excel thiab txoj cai-nias ntawm tes A1. Tom qab ntawd, xaiv "Paste" los ntawm cov ntawv qhia zaub mov.
Cov ntsiab lus tshwj xeeb - Nyem qhov no  Daim iav Cheats

Los ntawm ua raws li cov kauj ruam no, koj yuav tuaj yeem tso saib cov ntsiab lus ntawm daim ntawv tiv thaiv yav dhau los hauv Excel yam tsis tas yuav qhib tag nrho cov kev tiv thaiv. Qhov no tso cai rau koj los nthuav qhia cov ntaub ntawv muaj kev nyab xeeb thiab zam kev hloov pauv tsis raug los ntawm lwm tus neeg. Nco ntsoov tias thaum koj ua tiav daim ntawv qhia, koj tuaj yeem tiv thaiv nws dua los ntawm kev ua raws li cov kauj ruam qub thiab xaiv "Protect Sheet" es tsis yog "Unprotect Sheet."

13. Cov cuab yeej siv tau los qhia thiab tswj cov ntawv zais hauv Excel

Cov nplooj ntawv zais hauv Excel tuaj yeem yog qhov tsis meej pem thiab nyuaj thaum ua haujlwm nrog cov ntaub ntawv loj. Hmoov zoo, muaj ntau yam cuab yeej siv tau uas ua rau nws yooj yim los tso saib thiab tswj cov ntawv zais no zoo. Hauv qab no yog qee qhov kev xaiv uas yuav pab koj daws qhov teeb meem no:

1. Unhide nplooj ntawv: Txhawm rau qhia cov ntawv zais hauv Excel, koj tuaj yeem ua raws li cov kauj ruam hauv qab no: Txoj cai-nias ntawm cov ntawv pom nyob hauv qab ntawm lub vijtsam, tom qab ntawd xaiv "Unhide" kev xaiv los ntawm cov ntawv qhia zaub mov nco-down. Koj tuaj yeem rov ua cov txheej txheem no rau txhua daim ntawv uas koj xav kom unhide.

2. Cov keyboard luv luv- Excel kuj tseem muaj cov keyboard shortcuts tseem ceeb rau kev qhia thiab zais cov ntawv. Txhawm rau qhia cov ntawv zais, koj tuaj yeem siv qhov tseem ceeb ua ke "Ctrl + Ua haujlwm + 9". Ntawm qhov tod tes, txhawm rau nkaum ib daim ntawv pom, koj tuaj yeem nias "Ctrl + Ua haujlwm + 0".

3. Siv "Format Cell" muaj nuj nqi: Lwm qhov kev xaiv yog siv "Format Cell" muaj nuj nqi hauv Excel. Xaiv cov ntawv zais koj xav tso saib, tom qab ntawd mus rau "Tsev" tab hauv toolbar thiab nyem "Format Cell." Hauv qhov rai uas tshwm, mus rau "Kev Tiv Thaiv" tab thiab xaiv lub thawv "Hidden". Nrog rau qhov no, daim ntawv zais yuav tshwm rau hauv phau ntawv ua haujlwm dua.

Cov cuab yeej thiab cov tswv yim no yuav tso cai rau koj los qhia thiab tswj cov ntawv zais hauv Excel hauv txoj kev ua tau zoo thiab siv tau. Txawm hais tias cov ntaub ntawv loj npaum li cas los yog muaj pes tsawg daim ntawv zais koj muaj, nrog rau cov kauj ruam no koj tuaj yeem nkag tau yooj yim rau txhua cov ntaub ntawv koj xav tau. Nco ntsoov siv qhov kev paub no thiab ua kom yooj yim rau koj txoj haujlwm nrog Excel!

14. Cov lus xaus thiab cov lus pom zoo rau kev qhia cov ntawv zais hauv Excel

Hauv cov ntsiab lus, kom pom cov ntawv zais hauv Excel, muaj ntau txoj hauv kev los mus. Ua ntej, koj tuaj yeem siv txoj kev cai ntawm txoj cai-nias ntawm daim ntawv pom nyob hauv qab ntawm qhov screen thiab xaiv "Qhia" los ntawm cov ntawv qhia zaub mov nco. Qhov no yuav qhia koj tag nrho cov ntawv zais hauv koj cov ntaub ntawv Excel.

Lwm qhov kev xaiv yog siv qhov shortcut Ctrl cov keyboard + Ua haujlwm + 9 los qhia tag nrho cov ntawv zais rau tib lub sijhawm. Txoj kev no muaj txiaj ntsig tshwj xeeb yog tias koj muaj ntau daim ntawv zais uas koj xav qhia ib zaug.

Yog tias koj xav tau qhia ib daim ntawv tshwj xeeb thiab tsis yog txhua daim ntawv zais, koj tuaj yeem siv Task Pane hauv Excel. Txhawm rau qhib Task Pane, mus rau "Saib" tab hauv toolbar thiab xaiv "Task Pane." Tom ntej no, xaiv "Sheet Browser" tab nyob rau hauv Task Pane thiab kos lub thawv nyob ib sab ntawm cov nplooj ntawv koj xav kom tso saib. Nyem qhov "Show" khawm kom tso saib cov nplooj ntawv xaiv.

Hauv kev xaus, qhia cov ntawv zais hauv Excel yog txoj haujlwm yooj yim nrog ntau txoj kev xaiv muaj. Koj tuaj yeem siv txoj kev cai lij choj ib txwm muaj, keyboard shortcut Ctrl + Ua haujlwm + 9, lossis Task Pane los qhia cov ntawv zais. Xaiv txoj kev uas haum koj xav tau thiab ua haujlwm tau zoo dua hauv koj cov ntaub ntawv los ntawm Excel.

Nco ntsoov tias nws yog ib qho tseem ceeb uas yuav tsum khaws koj cov ntaub ntawv zais cia kom raug, tshwj xeeb tshaj yog tias lawv muaj cov ntaub ntawv tsis pub lwm tus paub lossis cov ntaub ntawv rhiab. Tsis txhob hnov ​​​​qab khaws koj cov haujlwm tsis tu ncua thiab siv cov passwords ruaj khov los tiv thaiv koj cov ntaub ntawv Excel. Nrog cov lus pom zoo no, koj yuav tuaj yeem tso saib thiab tiv thaiv koj cov ntawv zais tau zoo.

Hauv kev xaus, kev kawm yuav ua li cas los qhia ib daim ntawv zais hauv Excel yog qhov txuj ci tseem ceeb rau txhua tus neeg siv uas xav ua kom siv tau zoo ntawm cov cuab yeej no muaj zog. Los ntawm cov ncauj lus kom ntxaws cov kauj ruam hauv tsab xov xwm no, peb tau tshawb xyuas ntau yam kev xaiv thiab txoj hauv kev uas tso cai rau peb los tso saib cov ntawv zais sai thiab yooj yim. Txawm hais tias siv cov ntawv qhia zaub mov xaiv, cov kab ribbon lossis pawg tshuaj ntsuam xyuas, peb tuaj yeem nkag mus tau yooj yim thiab saib cov ntawv zais yav dhau los hauv peb cov ntawv Excel. Tsis tas li ntawd, peb tau tham txog qee qhov kev txiav txim siab tseem ceeb, xws li tsis yog sib qhia cov ntaub ntawv nrog cov ntaub ntawv tsis pub lwm tus paub yam tsis tau ua raws li qhov tsim nyog ceev faj thiab nco ntsoov tias txhua qhov kev hloov pauv peb ua rau daim ntawv zais yuav tshwm sim pom thaum peb tsis tau zais nws. Excel muaj ntau yam haujlwm thiab cov yam ntxwv, thiab qhia cov nplooj ntawv zais tsuas yog ib qho ntawm ntau yam txuj ci tseem ceeb uas peb tuaj yeem kawm los txhim kho peb txoj haujlwm nrog cov ntawv nthuav qhia. Yog li txuas ntxiv tshawb nrhiav thiab sim nrog Excel kom tau txais txiaj ntsig zoo tshaj plaws ntawm cov cuab yeej no thiab ua rau koj cov ntaub ntawv tswj hwm txhua hnub thiab kev txheeb xyuas cov haujlwm yooj yim dua. Hmoov zoo thiab tsis txhob yig xa mus rau cov lus no txhua zaus koj yuav tsum tau qhia ib daim ntawv zais hauv Excel!