Kanjani uku-renamelist ku-Excel

Njengoba wazi, uhlelo lwe-Excel lunikeza amandla okusebenza kudokhumenti elilodwa kumashidi ambalwa. Igama entweni ngayinye entsha inika uhlelo lokusebenza ngokuzenzakalelayo: "Sheet 1", "Ishidi 2", njll. Lokhu akuyona nje yomile kakhulu, lapho kusenokwenzeka ukwamukela, ukusebenza ngemibhalo, kodwa futhi kuyafundisa. Umsebenzisi akakwazi ukunquma ukuthi iyiphi idatha ethunyelwe ekutshalweni kwemali ethile. Ngakho-ke, impikiswano yokuqamba kabusha amashidi iyasebenza. Ake sibhekane nokuthi kwenziwa kanjani ku-Efpelle.

Inqubo yokuqamba kabusha

Inqubo yokuqamba kabusha amashidi ku-Excel njengento ephelele. Kodwa-ke, kwabanye abasebenzisi abaqala ukukwazi kahle uhlelo, kunobunzima obuthile.

Ngaphambi kokuqhubeka ngqo encazelweni yezindlela zokuqamba kabusha, thola ukuthi imaphi amagama anganikezwa, kanye nesabelo esizolunga. Igama lingabelwa nganoma yiluphi ulimi. Lapho ubhala, ungasebenzisa izikhala. Ngokuqondene nemikhawulo eyinhloko, okulandelayo kufanele kwabelwe:

• Ngegama kufanele kube nezimpawu ezinjalo: "?", "/", "\", ":",] ";
• Igama alinakuba nalutho;
• Ubude obuphelele begama akufanele budlule uphawu lwe-31.

Lapho udweba igama leshidi, udinga ukucubungula le mithetho engenhla. Esimweni esiphambene, lolu hlelo ngeke luvumele le nqubo ukuthi igcwalise.

Indlela 1: Ilebula yemenyu yokuqukethwe

Indlela enembile kunazo zonke yokuqamba kabusha ukusizakala ngamakhono okuthi imenyu yomongo yamashidi amashidi atholakala engxenyeni engezansi yesobunxele yewindi lesicelo ngokushesha ngaphezulu kwebha yesimo.

1. Ngokuchofoza kwesokudla kwilebula, sifuna ukukhohlisa. Kumenyu yokuqukethwe, khetha u- "Qamba kabusha".



2. Njengoba ubona, ngemuva kwalesi senzo, insimu enesihloko selebula selisebenzele. Vele uthayiphe kusuka kukhibhodi noma yiliphi igama elifanelekile kumongo.



3. Chofoza inkinobho ethi Enter. Ngemuva kwalokho, ishidi lizokwabelwa igama elisha.

Indlela 2: chofoza kabili kwilebula

Kunendlela elula yokuqamba kabusha. Udinga nje ukuchofoza ngokuchofoza kabili kwilebula oyifunayo, noma kunjalo, ngokungafani nenguqulo yangaphambilini, akusona ngokuchofoza kwesokudla, kepha kwesokunxele. Lapho usebenzisa le ndlela, ayikho imenyu edingekayo. Igama lelebula lizosebenza futhi lilungele ukuqamba kabusha. Uzohlala kuphela ekushayeleni igama olifunayo kwikhibhodi.

Indlela 3: Inkinobho ku-Ribbon

Ukuqamba kabusha kungenziwa futhi kusetshenziswa inkinobho ekhethekile ethepheni.

1. Ukuchofoza kwilebula, iya ephepheni ukuze liqanjwe kabusha. Sithuthela kuthebhu "Yasekhaya". Chofoza inkinobho ethi "format", etholakala ethepheni ku- "Ithuluzi Leseli". Uhlu luyavula. Eqenjini lamapharamitha, "hlela amashidi" kumele achofoze entweni "kabusha yeshidi".



2. Emva kwalokho, igama lelebula leshidi lamanje, nalapho lisebenzisa izindlela ezedlule, liyasebenza. Kwanele ukuyishintsha kumsebenzisi oyidingayo.

Le ndlela ayinangqondo futhi ilula njengangaphambili. Noma kunjalo, abanye abasebenzisi bayayisebenzisa.

Indlela 4: Isebenzisa izengezo nama-macros

Ngaphezu kwalokho, kunezilungiselelo ezikhethekile nama-macros abhalelwe ama-Excel abathuthukisi beqembu lesithathu. Basivumela ukuthi sikhiqize amashidi amaningi aqamba kabusha, futhi angakwenzi ngelebula ngalinye lencwajana.

Ama-nuances okusebenza nezilungiselelo ezahlukahlukene zalolu hlobo ahlukaniswa ngokuya ngonjiniyela othize, kepha umthetho osebenzayo uyafana.

1. Kuyadingeka etafuleni le-Excel ukudweba uhlu lwababili: ohlwini olulodwa lwamagama amadala amashidi, nangokwesibili - uhlu lwezinto ofuna ukuzifaka esikhundleni sazo.



2. Gijimani i-superskructure noma i-macro. Singena kwizixhumanisi ezihlukile ze-Field Window Wed-on of amaseli anamagama amadala, futhi kwenye insimu - enabatsha. Sichofoza inkinobho esebenza kabusha.



3. Ngemuva kwalokho, kuzoba neqembu kabusha amashidi.

Uma kunezici eziningi ezidinga ukuqanjwa kabusha, ukusetshenziswa kwale nketho kuzoba nomthelela ekulondolozeni okukhulu kwesikhathi somsebenzisi.

QAPHELA! Ngaphambi kokufaka ama-macros kanye nezandiso zabathuthukisi abavela eceleni, qiniseka ukuthi balayishwa emthonjeni ofakazelwe futhi abanazo izinto ezinonya. Ngemuva kwakho konke, kungadala ukutheleleka ngamagciwane.

Njengoba ubona, qamba kabusha amashidi ohlelweni lwe-Excel usebenzisa izinketho eziningi zezenzo. Ezinye zazo ziqondakala kahle (imenyu yomongo yezinqamuleli), ezinye ziyinkimbinkimbi ngokwengeziwe, kodwa futhi azinankinga ezikhethekile ekubukeni. Okokugcina, okokuqala, kubhekiswa ekuqashweni kwenkinobho ethi "format" ethepheni. Ngaphezu kwalokho, ama-macros kanye nonjiniyela beqembu lesithathu nawo angasetshenziselwa ukuqamba kabusha isisindo.