Momwe mungapangire fomu mu Excel

Kawirikawiri, ogwiritsa ntchito mkonzi wa spreadsheet amakumana ndi ntchito yotere monga kupanga mawonekedwe apadera kuti alowetse zofunikira. Mafomu ndi mawonekedwe omwe amathandiza kutsogolera ndondomeko yodzaza chikalata cha spreadsheet. Mkonzi ali ndi chida chophatikizika chomwe chimakulolani kuti mudzaze tsambalo motere. Kuphatikiza apo, wogwiritsa ntchito pulogalamuyi, pogwiritsa ntchito macro, amatha kupanga mawonekedwe akeake, osinthidwa ndi ntchito zosiyanasiyana. M'nkhaniyi, tikambirana mwatsatanetsatane njira zosiyanasiyana zomwe zimakulolani kupanga mawonekedwe mu chikalata cha spreadsheet.

Kugwiritsa ntchito zida zodzaza mumkonzi wa spreadsheet

Fomu yodzaza ndi chinthu chapadera chokhala ndi minda yomwe mayina awo amafanana ndi mayina a mizati ya mbale yomwe ikudzazidwa. Ndikofunikira kuyendetsa chidziwitso m'minda, yomwe nthawi yomweyo idzalowetsedwa ngati mzere watsopano m'dera losankhidwa. Mawonekedwe apaderawa angagwiritsidwe ntchito ngati chida choyimira chokha chophatikizira cha spreadsheet kapena angapezeke pa pepala lokhalokha ngati mndandanda. Tiyeni tipende kusiyana kulikonse mwatsatanetsatane.

Njira yoyamba: chinthu chophatikizika cholowetsa chidziwitso

Choyamba tiyeni tiwone momwe tingagwiritsire ntchito fomu yophatikizika kuti muwonjezere zambiri ku chikalata chamkonzi cha spreadsheet. Malangizo atsatanetsatane amawoneka motere:

1. Zindikirani kuti poyamba, chithunzi chomwe chili ndi mawonekedwe awa chimabisika. Tiyenera kuchita ndondomeko yotsegulira chida. Timasunthira ku submenu ya "Fayilo", yomwe ili kumtunda kumanzere kwa mawonekedwe a spreadsheet editor. Timapeza apa chinthu chomwe chili ndi dzina "Parameters", ndikudina ndi batani lakumanzere.

2. Zenera lotchedwa "Zosankha za Excel" lidawonekera pachiwonetsero. Timapita ku gawo la "Quick Access Panel". Pali makonda osiyanasiyana apa. Kumanzere kuli zida zapadera zomwe zimatha kutsegulidwa muzitsulo, ndipo kumanja kuli zida zophatikizidwa kale. Wonjezerani mndandanda pafupi ndi mawu akuti "Sankhani malamulo kuchokera:" ndikusankha chinthu "Malamulo pa riboni" ndi batani lakumanzere. Pamndandanda wa malamulo omwe akuwonetsedwa motsatira zilembo, tikuyang'ana chinthucho "Fomu ..." ndikusankha. Dinani "Add".

3. Timadina batani "Chabwino".

4. Tatsegula chida ichi pa riboni yapadera.

5. Tsopano tikuyenera kuyamba kupanga mutu wa mbale, ndikulowetsamo zizindikiro zina. Gome lathu lidzakhala ndi mizati 4. Timayendetsa mu mayina.

6. Timayendetsanso mtengo wina mumzere woyamba wa mbale yathu.

7. Timasankha gawo lililonse la mbale yokonzedwa ndikudina chinthu cha "Fomu ..." chomwe chili pa riboni ya chida.

8. Zenera la zoikamo zida limatsegulidwa. Nayi mizere yogwirizana ndi mayina a mizati ya mbale.

Ndizofunikira kudziwa kuti mzere woyamba wadzaza kale ndi deta, popeza tidawalowetsa kale patsamba logwirira ntchito.

9. Timayendetsa zisonyezo zomwe timawona kuti ndizofunikira m'mizere yotsalayo. Dinani pa "Add" batani.

10. Zizindikiro zomwe zidalowetsedwa zidasamutsidwa ku mzere wa 1 wa tebulo, ndipo mu mawonekedwe omwewo, kusintha kunapangidwira ku minda ina yofanana ndi mzere wa 2 wa tebulo.

11. Timadzaza zenera la chida ndi zizindikiro zomwe tikufuna kuziwona mu mzere wa 2 wa mbale. Timadina "Add".

12. Zizindikiro zomwe zidalowetsedwa zidasamutsidwa ku mzere wa 2 wa mbale, ndipo mu mawonekedwe omwewo, kusintha kunapangidwira ku minda ina yofanana ndi mzere wa 3 wa mbale.

13. Mwa njira yofananira, timadzaza mbale ndi zizindikiro zonse zofunika.

14. Pogwiritsa ntchito mabatani a "Next" ndi "Back", mutha kuyang'ana pazizindikiro zomwe zidalowa kale. Njira ina ndi mpukutu bala.

15. Ngati mungafune, mutha kusintha zizindikiro zilizonse patebulo pozisintha mu mawonekedwe omwewo. Kuti musunge zosintha zanu, dinani "Add".

16. Tikuwona kuti zosintha zonse zidawonetsedwa mu mbale yomwe.

17. Pogwiritsa ntchito batani la "Delete", mutha kugwiritsa ntchito kuchotsa mzere wina.

18. Pambuyo kuwonekera, zenera lapadera lochenjeza lidzawonekera, lomwe limasonyeza kuti mzere wosankhidwa udzachotsedwa. Muyenera dinani "Chabwino".

19. Mzere wachotsedwa patebulo. Pambuyo pa njira zonse zomwe zachitika, dinani "Tsegulani".

20. Kuphatikiza apo, mutha kuyipanga kuti mbaleyo ikhale yowoneka bwino.

Njira yachiwiri: kudzaza mafomu ndi chidziwitso cha piritsi

Mwachitsanzo, tili ndi mbale yomwe ili ndi zambiri zamalipiro.

Cholinga: kudzaza fomuyo ndi deta iyi kuti ikhale yosavuta komanso yosindikizidwa. Malangizo atsatanetsatane amawoneka motere:

1. Pa pepala lina lachikalatacho, timapanga fomu yopanda kanthu.

Ndizofunikira kudziwa kuti mawonekedwe a mawonekedwewo amatha kupangidwa mwaokha kapena mutha kutsitsa mafomu okonzeka kuchokera kuzinthu zosiyanasiyana.

2. Musanatenge zambiri mu mbale, muyenera kusintha pang'ono. Tiyenera kuwonjezera ndime yopanda kanthu kumanzere kwa tebulo loyambirira. Apa chizindikiro chidzayikidwa pafupi ndi mzere umene tikukonzekera kuwonjezera pa mawonekedwe omwewo.

3. Tsopano tiyenera kukhazikitsa kumanga mbale ndi mawonekedwe. Kuti tichite izi, tikufuna woyendetsa VLOOKUP. Timagwiritsa ntchito fomula iyi: =VLOOKUP(“x”,Data!A2:G16).

4. Mukayika chizindikiro pafupi ndi mizere ingapo, ndiye kuti woyendetsa VLOOKUP angotenga chizindikiro choyamba chomwe chapezeka. Kuti muthane ndi vutoli, muyenera dinani kumanja pa chithunzi cha pepala lomwe lili ndi mbale yoyambira ndikudina chinthu cha "Source text". Pazenera lomwe likuwoneka, lowetsani nambala iyi:

Private Sub Worksheet_Change (ByVal Target As Range)

Dim r As Long

Dim str Monga Chingwe

Ngati Target.Count> 1 Ndiye Tulukani Sub

Ngati Target.Column = 1 Ndiye

str = Target.Value

Application.EnableEvents = Zabodza

r = Maselo(Rows.Count, 2).Mapeto(xlUp).Row

Range(«A2:A» & r).Chotsani Zamkatimu

Target.Value = str

Kutha Ngati

Application.EnableEvents = Zoona

mapeto Sub

5. Macro iyi sikulolani kuti mulowetse zilembo zingapo pamndandanda woyamba.

Mapeto ndi ziganizo za kupanga mawonekedwe.

Tapeza kuti pali mitundu ingapo yopangira mawonekedwe mumkonzi wa spreadsheet. Mutha kugwiritsa ntchito mafomu apadera omwe ali pa tepi ya chida, kapena mutha kugwiritsa ntchito woyendetsa VLOOKUP kusamutsa zambiri kuchokera pa mbale kupita ku fomuyo. Kuphatikiza apo, ma macros apadera amagwiritsidwa ntchito.