Zvekuita kana vasipo muExcel

Iko kugona kwekugadzira mashitsi eumwe mune rimwe bhuku mune rimwe bhuku rinotendera, kutaura zvazviri, kuti aumbe magwaro akawanda mune imwe faira uye, kana zvichidikanwa, zvichisunga mareferenzi kana mafomu. Ehe, izvi zvinovandudza zvakanyanya basa rechirongwa uye zvinokubvumira kuti uwedzere mahombekombe emabasa. Asi dzimwe nguva zvinoitika kuti mamwe mashizha aunogadzira anonyangarika kana kunyangarika zvachose zvipfupi zvavo muhupfumi. Ngatitsvagei kuti ungavadzosa sei shure.

Kudzoreredzwa kwemashiti

Kufamba pakati pemashizha ebhuku iri kunoita kuti iwe uite zvipfupi izvo zviri kuruboshwe rwehwindo renzvimbo pamusoro peganda. Mubvunzo wekupora kwavo kana uchinyangarika isu tichakurukurwa.

Usati waenderera nekudzidza nekudzidza kweiyo Algorithm, ngationgororei kuti nei kazhinji. Pane zvikonzero zvina zvikuru zvinoita kuti zviitike:

• Disable PANEL YEMAHARA;
• Zvinhu zvakavanzika kuseri kwemupumburu wakarukwa.
• Paradzanisa mapfupi akashandurwa mumamiriro ezvinhu akavanzika kana akakuvadzwa;
• Kubviswa.

Nomuzvarirwo, chimwe nechimwe chezvinhu izvi chinokonzeresa dambudziko rine mhinduro kwayo algorithm.

Nzira 1: Kutendeuka pane iyo Label Panel

Kana pasina mapfupi mumamiriro ezvinhu mune zvakajairika, kusanganisira iyo label yeiyo inoshanda chinhu, izvi zvinoreva kuti kuratidzira kwavo kwakangobviswa muzvirongwa. Izvi zvinogona kungoitirwa bhuku razvino. Ndokunge, kana iwe ukavhura imwe faira yeFless kune imwe chete chirongwa, uye marongero emahara haachashandurwi, iyo label panoratidzwa. Kanda kunze kuti iwe ungashandise sei kuoneka zvakare kana iyo Panel yakadzimwa muzvirongwa.

1. Enda kune "faira" tab.



2. Tevere, isu tinoita kuenda kune "parameter" chikamu.



3. MuWindows Paramende Window inovhura, ita shanduko kune iyo "Yepamberi" tab.



4. Padivi chairo rewindo iro rakavhura akasiyana-siyana excel marongero ari kuwanikwa. Isu tinofanirwa kutsvaga iyo marongero evharonge "Ratidza paramita yebhuku rinotevera". Mune ichi block kune "ratidza sheet sheet label" paramende. Kana pasina cheki chiratidzo pamberi payo, ipapo inofanira kuiswa. Tevere, tinya pane "OK" bhatani pazasi pewindo.



5. Sezvauri kuona, mushure mekuita zviri pamusoro, iyo label panoratidzwa zvakare mubhuku razvino rekuwedzera.

Nzira 2: Fambisa Barroll

Dzimwe nguva pane zviitiko kana mushandisi netsaona akadhonzera mbichana spell bar pamusoro peiyo label panor. Saka, akavanda, shure kwaizvozvo, apo chokwadi ichi chakawanikwa, kutsvaga kwehushe kunotangira chikonzero chevashandi.

1. Gadzirisa dambudziko iri rakareruka. Isa iyo isaor kuruboshwe kweiyo yakatwasuka bar. Inofanira kushandurwa kuve museve wekunyepedzera. Dzvanya bhatani rekuruboshwe mbeva uye kutora kuronga kurudyi kusvikira zvinhu zvese zviri papaneri zvinoratidzwa. Pano, zvakare, hazvina kukosha kuti usakure uye usaite kuti mupumburu webhusaiti zvidiki kwazvo, nekuti zvinodikanwa kuti utungamire gwaro. Naizvozvo, iwe unofanirwa kurega kudhonza mitsetse nekukurumidza pakangovhurika.



2. Sezvauri kuona, iyo Pani inoratidzwa zvakare pachiratidziri.

Nzira 3: Kugonesa Vavariro Dzakavanzika

Zvakare, mashitsi emunhu anogona kuvanzwa. Panguva imwecheteyo, iyo Panel pachayo uye zvimwe zvipfupi pairi icharatidzwa. Musiyano wakavanzika zvinhu zvakavanzika kubva kure ndezvekuti kana uchida, unogona kugara uchiratidza. Mukuwedzera, kana pane imwe pepa pane kukosha kwakasimbiswa kuburikidza nemafomulas ari pane imwe, ipapo mune imwe nyaya yekubvisa chinhu, aya mafomula anotanga kubvisa chikanganiso. Kana chinhu chacho chakangori chakavanzika, saka hapana shanduko muFormula basa richaitika, makabhegi ekuchinja kuchisimba. Kutaura nemazwi akareruka, chinhu ichocho chicharamba chiri muchimiro chimwe chete sezvazvaive, asi zvishandiso zvekufambisa zvekuchinja kwacho zvichanyangarika.

Maitiro acho ari nyore kuvanza. Iwe unofanirwa kurudyi-tinya pane inoenderana ipfupi uye mune yakasarudzwa "kuvanza" chinhu chinoonekwa.

Sezvauri kuona, mushure mekuita uku, chinhu chakasvitswa chichavanda.

Zvino ngatifungei kuti ungaitei kuti tiratidze zvakavanzika zvinyorwa zvakare. Hazvisi zvakawanda zvakanyanya kuomarara pane kuvavanza uye zvakare zvinonzwisisika zvinonzwisisika.

1. Rudyi-tinya pane chero label. Mamino menyu anovhura. Kana paine zvakavanzika mubhuku razvino, ipapo mune ino menyu inova chinhu chinoshanda "chinoratidza ...". Dzvanya pairi neiyo kuruboshwe bhatani bhatani.



2. Mushure mekudzvanya, kuwanikwa kwehwindo diki kuvhura, uko kune rondedzero yemashitsi akavanzika mubhuku rino. Sarudza chinhu ichocho chaunoda kuratidza zvakare pane iyo pani. Mushure meizvozvo, tinya pane "ok" bhatani pazasi pewindo.



3. Sezvauri kuona, iyo label yechinhu chakasarudzwa zvakare inoratidzwa zvakare pane papaneri.

Nzira 4: Kuratidzwa kweSupercad Sheets

Kuwedzera kumasheets akavanzika, kuchine super-isina-kusununguka. Kubva pane yekutanga ivo vakasiyana mukuti iwe hausi kuzovawana mune yakajairwa yekuburitsa runyorwa pane yekutanga chinhu chechinhu. Kunyangwe kana isu tine chivimbo chekuti chinhu ichi chakarongeka uye hapana akaibvisa.

Zvinhu zvinogona kunyangarika nenzira iyi unogona chete kana mumwe munhu aine chinangwa chakavanzika kuburikidza neVba machro mupepeti. Asi nekuvawana uye vadzorere kuratidzwa papuranga hakuzoome kana mushandisi achiziva iyo algorithm yezviito zvatichataura nezve pazasi.

Tichiona, sezvatinoona, hapana mavara ezvinyorwa wechina neyechishanu.

Kuenda kuhwindo rekubuda pachiratidziro chezvinhu zvakavanzika, maitiro atakataura nezvenzira yapfuura, tinoona kuti zita rechina chete rinoratidzwa. Naizvozvo, zviri pachena kuti unofungidzira kuti kana pepa rechishanu risina kubviswa, rakavanzika uchishandisa vba editor.

1. Chekutanga pane zvese, iwe unofanirwa kugonesa macros mode uye activate iyo yekuvandudza tab, iyo yakaremara nekutadza. Kunyangwe, kana iri mubhuku rino, zvimwe zvinhu zvakapihwa chimiro chetsiva, zvinogoneka kuti maitiro akaratidzwa muchirongwa akatoitwa. Asi, zvakare, hapana vimbiso yekuti mushure mekuita izvo zvinovakira zvinhu, mushandisi akazviita, zvakare haana kudzima zvishandiso zvinodiwa kuti zvidzivirirwe mashizha ezvisikwa. Mukuwedzera, zvinokwanisika kuti kusanganisa kwekuratidzwa kwepfupi kunoitwa zvachose pakombuta kwazvakavanzika.

   Enda kune "faira" tab. Tevere, tinya pane "parameter" chinhu mumamenu emamita ari kuruboshwe rwehwindo.



2. MuWindows Paramende Window inovhura, tinya pane iyo ribbon setup chinhu. Mu "Basic tabo" block, iyo iri kurudyi kwehwindo rakavhurwa, isa tick kana risiri, padyo ne "Weruvanta" paramende "paramende. Mushure meizvozvo, isu tinofamba kuenda kuChengetedzo Management Center chikamu ichishandisa meneti menyu kuruboshwe rwehwindo.



3. Muwindo rinomhanya, tinya pane bhatani "parameter dzevakachengetedzeka manejimendi Center ...".



4. Iyo Yekuchengetedza Management Center Window inotangwa. Enda kune "macro marongero" chikamu nenzira yemamenti emidziyo. Mu "macro marongero" toolbar, iwe unoisa switch kune iyo "Gonesa ese macros" chinzvimbo. Mu "macro marongero ekuvandudza" block, isu tichaisa tick nezve chinhu "chivimbo kuwana kune chinhu chechinhu cheVBo Projects". Mushure mekushanda neMacerr inoitwa, tinya pane "OK" bhatani pazasi pewindo.



5. Kudzokera kuExcel paramita kuitira kuti zvese zvachinja kune iyo zvigadziriso zvakapinda musimba, zvakare chengetedza iyo "OK" bhatani. Mushure meizvi, iyo yekuvandudza tab uye kushanda neMacros ichaitwa.



6. Zvino, kuvhura macro mupepeti, isu tinoenda kune "yekuvandudza" tab, yatichangobva kumisikidza. Mushure meizvozvo, pane tepi mu "kodhi" chishandiso block, tinya pane yakakura "yekutanga" icon.

   

   Macro mupepeti anogona zvakare kutangwa nekunyora iyo alt + f11 keyboard.

7. Iwe unozoona macro mupews weWindows, muchikamu chekuruboshwe ndechipi icho chirongwa "chirongwa" uye "zvivakwa".

   

   Asi zvinoita kuti nzvimbo idzi dzisazove muhwindo dzinovhura.



8. Kugonesa kuratidzwa kweiyo "Project" nharaunda, tinya pane maonero akatwasuka menyu chinhu. Mune rondedzero inovhura, sarudza iyo "Project Explorer" chinzvimbo. Kana iwe unogona kuita musanganiswa weKwiyo Keys Ctrl + R.



9. Kuti uratidze "nzvimbo" nharaunda, zvakare, tinya pane zvemaonero menyu chinhu, asi panguva ino iyo "Properties hwindo" chinzvimbo chinosarudzwa mune rondedzero. Kana, seimwe nzira, unogona kungozvidzvinyirira kiyi yeF4 inoshanda.



10. Kana imwe nharaunda ichidarika imwe, sezvakaratidzwa mumufananidzo pazasi, saka iwe unofanirwa kuisa mhombwe pamuromo wenzvimbo. Panguva imwecheteyo, inofanira kutendeukira kune bidirectional museve. Wobva wachinjisa bhatani rekuruboshwe bhatani uye dhonza muganho kuti nzvimbo idzi dzese dzinoratidzwa zvizere muMacro Editor Window.



11. Mushure meizvozvo, mu "nzvimbo yeProjekiti", isu tinogovera zita reChinhu Chinotarisirwa, izvo zvatisingakwanise kuzviwana mundima kana mune rondedzero yezvakavanzika zvinyorwa. Mune ino kesi, ichi "pepa 5". Mune ino kesi, mu "zvivakwa" nharaunda, marongero echinhu ichi zvinoratidzwa. Tichanyatsofarira chinhu icho "chinoonekwa" ("kuoneka"). Parizvino, pamberi payo, iyo "2 - XLLSEEETROETREN" paramende yakaiswa. Rinoshandurwa muchiRussia, "akavanzika kwazvo" zvinoreva "akavanzika", kana sezvatakambotaura "mukuru". Kuti uchinje paramende iyi uye dzosera kuoneka kweiyo label, tinya pane iyo triangle kurudyi kwayo.



12. Mushure meizvozvo, rondedzero yemashiti matatu emashiti anotaridzika:
    • "-1 - xlsheetVisible" (inoonekwa);
    • "0 - XLLHEHIFIDDE" (Yakavanzika);
    • "2 - xlsheetveryhidden" (Superb).

    Kuti chinyorwa chacho choratidzwa zvakare pane papaneri, sarudza iyo "-1 - XLLSEHEETVITICE" chinzvimbo.



13. Asi, sezvatinorangarira, kuchine yakavanzika "pepa 4". Ehezve, haisi supercount uye saka inogona kuiswa uchishandisa nzira 3. Saka zvichave nyore uye zvakaringana. Asi, kana takatanga kukurukurirana nezve mukana wekubatanidza mapfupi kuburikidza neMacro mupepeti, ngatione kuti pamwe nazvo iwe unogona kudzorera zvinhu zvakajairika zvakavanzika.

    Mu "Project" block, tinogovera zita rekuti "runyorwa 4". Sezvatinogona kuona, mu "nzvimbo" nharaunda, pamberi pe "chinhu chinooneka" chinhu, iyo "0 - paramende, inoenderana neyakajairwa yakavanzika element. Dzvanya pane iyo triangle kuruboshwe kweichi paramende kuti ichichichinja.



14. Mune rondedzero ye parameter ayo anovhura, sarudza "-1 - XLLEHEETVENIDE".



15. Mushure mekunge tasarudza kuratidzwa kwezvese zvakavanzika zvinhu zviri papurani, iwe unogona kuvhara macro mupepeti. Kuti uite izvi, tinya pane yakajairika yekuvhara bhatani senge muchinjiro mukona yekumusoro yepahwindo.



16. Sezvauri kuona, zvino mavara ese anoratidzwa pane excel panel.

Chidzidzo: Maitiro ekuita kana kudzima macros muExcel

Nzira 5: Kudzoreredzwa kweRemote Sheets

Asi kazhinji zvinoitika kuti zvinyorwa zvakanyangarika kubva panieri nekuti zvakabviswa. Iyi ndiyo sarudzo yakaoma kwazvo. Kana mune zvakapfuura nyaya, neiyo algorithm yezviito, mukana wekudzoreredza kuratidzwa kwepfupi ndeye 100%, zvino kana ivo vakabviswa, hapana anogona kupa vimbiso yebasa rakanaka.

Bvisa iyo label ndeye yakapusa uye intuitive. Ingo tinya pairi nekoko bhatani re mbeva uye mune menyu inoita seyinosarudza "Delete" sarudzo.

Mushure meizvozvo, yambiro yekudzvanywa inoonekwa sebhokisi dialog. Kuti upedzise maitiro, zvakwana kudzvanya pane "Delete" bhatani.

Dzosera chinhu chiri kure chakanyanya kuoma.

1. Kana iwe ukapa chinyorwa, asi ivo vakaziva kuti zvakaitwa pasina kunyange kusati vangovhara iyo neiyo bhatani reSandart kuvhara gwaro riri rekona yekurudyi yewindo repahwindo. chena muchena mune tsvuku mraba.



2. Mune dialog box inovhura mushure meizvozvo, iwe unofanirwa kudzvanya pane bhatani "Usaponesa".



3. Mushure mekuvhura iyi faira zvakare, chinhu chiri kure chichava munzvimbo.

Asi inofanira kubhadharwa kuti ichidzoreredza pepa nenzira iyi, iwe ucharasikirwa nedata rese rakagadzirwa kune gwaro, kutanga nekuchengetedza kwayo kwekupedzisira. Ndokunge, kutaura zvazviri, mushandisi anozofanira kusarudza pakati pekuti iye anonyanya kukoshesa: Chinhu chiri kure kana data yaakakwanisa kuita mushure mekuchengetedza kwekupedzisira.

Asi, sezvambotaurwa pamusoro apa, iyi sarudzo yekudzora ichangoerekana yakodzera kana mushandisi asina nguva yekuchengetedza data mushure mekubviswa. Chii chandinofanira kuita kana mushandisi akachengeta gwaro kana kazhinji achibuda mazviri nekuchengetedzwa?

Kana, mushure mekubvisa chinyorwa, iwe watoponesa bhuku racho, asi hauna nguva yekuvhara, kureva kuti, zvine musoro kuchera mumhando dzefaira.

1. Kuti uende kunonhuwira, fambisa kune "faira" tab.



2. Mushure meizvozvo, enda kune "ruzivo" chikamu, chinoratidzwa mumusoro menyu. Muchikamu chepakati chewindo rakavhura hwindo racho riripo. Iyo ine rondedzero yezvinyorwa zvese zveiyi faira yakachengetwa uchishandisa excel's auto mudziyo. Ichi chishandiso chinogoneswa nekukanganisa uye chinochengetedza gwaro rega rega maminitsi gumi kana usiri kuzviita iwe pachako. Asi kana iwe waita zvekugadzirisa zvinyorwa muExcel marongero, kudzima auto kuchengetedza, hauzokwanisi kudzorera zvinhu zviri kure. Izvo zvinofanirwawo kutaurwa kuti mushure mekuvhara iyo faira, iyi rondedzero inobviswa. Naizvozvo, zvakakosha kuti uone kurasikirwa kwechinhu uye kusarudza pane kukosha kwekuidzosera iwe usati wavhara bhuku racho.

   Saka, mune rondedzero yezvidzidzo zveAthoocated, isu tiri kutsvaga iyo yazvino yekuchengetedza sarudzo, iyo yakaitwa kusvika kunze kwekubviswa. Dzvanya pane ichi chinhu mune yakatarwa rondedzero.



3. Mushure meizvozvo, hwindo idzva richazaruka muhwindo idzva. Sezvauri kuona, ine chinhu chaimbove chiri kure. Kuti upedze kupora faira, iwe unofanirwa kudzvanya pane bhatani rekudzosera kumusoro kwehwindo.



4. Mushure meizvozvo, bhokisi rekurukurirano dialog ichavhura, iyo ichapihwa kutsiva iyo yazvino yakachengetedzwa shanduro yebhuku neiyi vhezheni. Kana ikakodzera iwe, tinya pane "OK" bhatani.

   

   Kana iwe uchida kusiira ese ari maviri efaira (ine pepa rinoshanda uye neruzivo rwunowedzerwa kubhuku racho mushure mekubvisa), enda ku "Faira" tab uye tinya se "Sevha se ...".



5. Tanga hwindo rekuchengetedza. Mukati maro, zvichave zvakafanira kudzoreredza bhuku rakadzoreredzwa, wobva wadzvanya pane "Sevha" bhatani.



6. Mushure meizvozvo iwe uchagamuchira zvese shanduro dzefaira.

Asi kana iwe wakachengeta uye ukavhara iyo faira, uye nguva inotevera kana iwe waona kuti imwe yepfupi yakabviswa, saka hazviiti kuidzosera nenzira yakafanana, nekuti rondedzero yezvinyorwa zvefaira zvichave kucheneswa. Asi iwe unogona kuedza kupora kuburikidza neshanduro kutonga, kunyangwe iwo mukana wekubudirira mune ino nyaya akanyanya kuderera pane kana uchishandisa yapfuura sarudzo.

1. Enda ku "Faira" tab uye mu "Properties" Chikamu Dzvanya pane "version manegement" bhatani. Mushure meizvozvo, menyu madiki anoonekwa, inosanganisira imwe chete pfungwa - "dzosera mabhuku asingazungunuke". Dzvanya pairi.



2. Iwindo rekuvhura hwindo mune dhairekitori uko kune mabhuku asina kusarudzika mune XLSB Binary fomati. Zvisinei, neimwe sarudza mazita uye tinya pane "yakavhurika" bhatani pazasi pewindo. Zvichida imwe yeaya mafaera ichave iri bhuku rine chinhu chiri kure chaunoda.

Ndichine mukana wekuwana bhuku rerugwaro idiki. Mukuwedzera, kunyangwe kana zviripo mune ino rondedzero uye ine chinhu chiri kure, chinogona kunge chichava chekare uye chisina shanduko dzakawanda dzakaitwa gare gare.

Chidzidzo: Kudzoreredzwa kwebhuku rakaponeswa Bhuku

Sezvatinogona kuona, kunyangarika kwemabhaleti mune iyo mapaneri kunogona kukonzerwa nehuwandu hwezvikonzero, asi zvese zvinogona kukamurwa kuita mapoka maviri makuru: mashitsi zvakavanzika kana kubviswa. Muchiitiko chekutanga, mashitsi anoramba arambe ari chikamu chegwaro, chete kuwana kwavari kwakaoma. Asi kana zvichidikanwa, nekutsanangura nzira, mararamiro aive akavanzika, akaomerera kualgorithm zviito, kudzoreredza mamepu ebhuku hazvizove zvakaoma. Chimwe chinhu, kana zvinhu zvabviswa. Mune ino kesi, ivo vaive vakabviswa zvachose kubva mugwaro, uye kupora kwavo hakugone nguva dzose. Nekudaro, kunyangwe mune ino kesi, dzimwe nguva zvinogoneka kudzoreredza data.