Momwe mungabisire mapepala mu Excel, momwe mungasonyezere mapepala mu Excel (mapepala obisika)

Ubwino waukulu wamaspredishithi a Excel ndikuti wogwiritsa ntchito amatha kugwiritsa ntchito pepala limodzi ndi angapo. Izi zimapangitsa kuti zitheke kupanga chidziwitso mosavuta. Koma nthawi zina zimatha kubwera ndi zovuta zina. Chabwino, pali mitundu yonse ya zochitika, zikhoza kukhala ndi chidziwitso chokhudza chuma chofunika kwambiri kapena mtundu wina wa chinsinsi cha malonda chomwe chiyenera kubisidwa kwa ochita nawo mpikisano. Izi zitha kuchitika ngakhale ndi zida zokhazikika za Excel. Ngati wogwiritsa ntchito adabisa mwangozi pepalalo, ndiye kuti tiwona zomwe tiyenera kuchita kuti tiwonetse. Ndiye, ndi chiyani chomwe chiyenera kuchitidwa kuti mugwire ntchito yoyamba ndi yachiwiri?

Momwe mungabisire pepala pogwiritsa ntchito menyu

Njirayi ndi yosavuta kugwiritsa ntchito chifukwa imakhala ndi masitepe awiri.

1. Choyamba tiyenera kutchula mndandanda wa nkhani. Kuti muchite izi, muyenera kudina kumanja kapena kukanikiza ndi zala ziwiri pa trackpad, mutasuntha cholozera pamalo omwe mukufuna. Njira yomaliza yoyitanitsa menyu yankhaniyo imathandizidwa ndi makompyuta amakono, osati onse. Komabe, machitidwe ambiri amakono amathandizira, chifukwa ndiwosavuta kuposa kungodina batani lapadera pa trackpad.
2. Mu menyu omwe akuwoneka, sankhani "Bisani" batani ndikudina.

Chilichonse, kupitilira apo pepalali siliwonetsedwa.

Momwe mungabisire pepala mu Excel pogwiritsa ntchito zida

Njira imeneyi si yotchuka monga yapitayi. Komabe, pali kuthekera koteroko, kotero zingakhale bwino kudziwa za izo. Pali zinanso zoti muchite apa:

1. Onani ngati muli pa "Home" tabu kapena ina. Ngati wosuta ali ndi tabu ina yotseguka, muyenera kupita ku "Home".
2. Pali chinthu "Maselo". Muyenera dinani batani lolingana. Kenako mabatani ena atatu adzatuluka, omwe tikufuna kumanja (olembedwa ngati "Format").
3. Pambuyo pake, menyu ina imawonekera, pomwe pakati padzakhala njira "Bisani kapena onetsani". Tiyenera dinani "Bisani pepala".
4. Mukamaliza masitepe onsewa, pepalalo lidzabisika kwa anthu ena.

Ngati pulogalamu zenera kulola izi, ndiye "Format" batani adzakhala anasonyeza mwachindunji riboni. Sipadzakhala kuwonekera pa batani la "Maselo" izi zisanachitike, popeza tsopano pakhala chipika cha zida.

Chida china chomwe chimakulolani kubisa pepala chimatchedwa Visual Basic Editor. Kuti mutsegule, muyenera kukanikiza makiyi Alt + F11. Pambuyo pake, timadina papepala lachidwi kwa ife ndikuyang'ana zenera la katundu. Tili ndi chidwi ndi Njira Yowoneka.

Pali njira zitatu zosinthira mawonekedwe a pepala:

1. Tsamba likuwonetsedwa. Kuwonetsedwa ndi code -1 pachithunzi pamwambapa.
2. Tsambali silinawonetsedwe, koma limatha kuwoneka pamndandanda wamasamba obisika. Zowonetsedwa ndi code 0 pamndandanda wazinthu.
3. Tsamba ndi lobisika kwambiri. Ichi ndi gawo lapadera la mkonzi wa VBA lomwe limakupatsani mwayi wobisa pepala kuti lisapezeke pamndandanda wamasamba obisika kudzera pa batani la "Show" pazosankha.

Kuonjezera apo, mkonzi wa VBA amalola kuti azitha kusintha ndondomekoyi malinga ndi zomwe zili zoyenera, monga njira, zomwe zili m'maselo kapena zomwe zimachitika.

Momwe mungabisire mapepala angapo nthawi imodzi

Palibe kusiyana kwakukulu pakati pa momwe mungabisire mapepala angapo pamzere kapena momwe mungabisire limodzi la iwo. Mutha kuzibisa motsatizana monga tafotokozera pamwambapa. Ngati mukufuna kusunga nthawi pang'ono, ndiye pali njira ina. Musanagwiritse ntchito, muyenera kusankha mapepala onse omwe akuyenera kubisika. Chitani zotsatirazi kuti muchotse masamba angapo kuti asawoneke nthawi imodzi:

1. Ngati ali pafupi wina ndi mnzake, tiyenera kugwiritsa ntchito kiyi ya Shift kuti tisankhe. Poyamba, timadina papepala loyamba, kenako timakanikiza ndikugwira batani ili pa kiyibodi, kenako timadina pa pepala lomaliza la zomwe tiyenera kuzibisa. Pambuyo pake, mukhoza kumasula fungulo. Mwambiri, palibe kusiyana mu dongosolo lomwe izi ziyenera kuchitidwa. Mutha kuyamba kuchokera komaliza, gwirani Shift, kenako ndikupita koyamba. Kuti mugwiritse ntchito njirayi, muyenera kukonza mapepala obisika pafupi ndi mzake mwa kungokoka mbewa.
2. Njira yachiwiri ndiyofunika ngati mapepala sali pafupi ndi mzake. Zidzatenga nthawi yayitali. Kuti musankhe zingapo zomwe zili pamtunda wina kuchokera kwa wina ndi mzake, muyenera kudina pa pepala loyamba, ndiyeno motsatizana sankhani chilichonse chotsatira ndi Ctrl kiyi. Mwachilengedwe, iyenera kusungidwa, ndipo pa pepala lililonse, dinani kamodzi ndi batani lakumanzere.

Tikamaliza masitepe awa, masitepe otsatirawa ndi ofanana. Mutha kugwiritsa ntchito menyu yankhani ndikubisa ma tabo kapena kupeza batani lolingana pazida.

Momwe mungasonyezere mapepala obisika mu Excel

Pali njira zingapo zowonetsera mapepala obisika mu Excel. Chosavuta mwa iwo ndikugwiritsa ntchito menyu yofananira ndikuyibisa. Kuti muchite izi, muyenera dinani patsamba lililonse lomwe latsala, dinani kumanja ndi mbewa (kapena gwiritsani ntchito mawonekedwe apadera a trackpad ngati mukuchokera pa laputopu yamakono) ndikupeza batani la "Show" pamndandanda womwe ukuwoneka. Tikangodina, zenera lidzawoneka ndi mndandanda wamasamba obisika. Idzawonetsedwa ngakhale pali pepala limodzi lokha.

Ngati kubisala kunachitika pogwiritsa ntchito macro, ndiye kuti mutha kuwonetsa mapepala onse omwe adabisidwa ndi kachidindo kakang'ono.

Sub OpenAllHiddenSheets()

    Dim Sheet Monga Tsamba Logwirira Ntchito

    Pa Tsamba Lililonse Mu ActiveWorkbook.Worksheets

        Ngati Sheet.Visible <> xlSheetVisible Ndiye

            Sheet.Visible = xlSheetVisible

        Kutha Ngati

    Ena

mapeto Sub

Tsopano zimangotsala pang'ono kuyendetsa macro, ndipo mapepala onse obisika adzatsegulidwa nthawi yomweyo. Kugwiritsa ntchito macros ndi njira yabwino yosinthira kutsegulira ndi kubisala kwa mapepala kutengera zomwe zikuchitika mu pulogalamuyi. Komanso, pogwiritsa ntchito macros, mutha kuwonetsa masamba ambiri nthawi imodzi. Nthawi zonse zimakhala zosavuta kuchita izi ndi code.