Abantu abaningi bathanda ukuxazulula amagama asetshenziswayo, kukhona nabantu abathanda ukubenza bakudale. Kwesinye isikhathi, iphazili yamagama asemqoka ayidingeki nje kuphela nje, kodwa, ngokwesibonelo, ukuhlola ulwazi lwabafundi ngendlela engeyona ejwayelekile. Kepha, bambalwa abantu ababona ukuthi iMicrosoft Excel iyithuluzi elihle kakhulu lokwakha amagama. Futhi, impela, amaseli aseshidi lalolu hlelo lokusebenza, sengathi aklanyelwe ngokukhethekile ukufaka izinhlamvu zamagama aqagelwe lapho. Ake sibheke ukuthi singayakha kanjani ngokushesha iphazili yama-crossword ku-Microsoft Excel.
Indalo Yesiphambano
Okokuqala, udinga ukuthola iphazili eyenziwe ngomumo eyenziwe lapho uzokwenza ikhophi e-Excel, noma ucabange ngesakhiwo sephazili eliyisiqalo uma uza nayo ngokwakho.
Iphazili yesiphambano idinga amaseli esikwele, hhayi awona angenxande, njengokuzenzakalelayo kuMicrosoft Excel. Sidinga ukuguqula isimo sabo. Ukuze wenze lokhu, cindezela inhlanganisela yokhiye u-Ctrl + A kwikhibhodi. Lokhu sikhetha lonke ishidi. Ngemuva kwalokho, sichofoza kwesokudla, okuletha imenyu yokuqukethwe. Kuyo, chofoza entweni "Line Height".
Kuvulwa iwindi elincane lapho udinga khona ukusetha ukuphakama komugqa. Setha inani libe ngu-18. Chofoza inkinobho ethi "Kulungile".
Ukuze ushintshe ububanzi, chofoza kuphaneli enegama lamakholomu, nakwimenyu evela, khetha into ethi "Ububanzi bekholomu ...".
Njengasesimweni esidlule, kuvela iwindi lapho udinga ukufaka idatha. Okwamanje kuzoba inombolo 3. Chofoza inkinobho ethi "Kulungile".
Okulandelayo, kufanele ubale inani lamaseli elezinhlamvu ezikumaphazili wegama eliyisiqalo ezinkombeni eziqonde ngqo naphezulu. Khetha inombolo efanelekile yamaseli ekhasini lokusebenzela le-Excel. Ukuba kuthebhu "Yasekhaya", chofoza inkinobho ethi "Border", ebekwe iribhoni ebhokisini lamathuluzi "Font". Kumenyu evelayo, khetha into ethi "Yonke Imingcele".
Njengoba ukwazi ukubona, imingcele eveza iphazili yethu yesiprofetho ibekwe.
Manje, kufanele ususe le mingcele kwezinye izindawo ukuze iphazili yesiphambano ibukeke esikudingayo. Lokhu kungenziwa kusetshenziswa ithuluzi elinjenge- "Sula", isithonjana sokuqalisa saso esinobume be-eraser, futhi sitholakala kuthebhu "Hlela" yethebhu efanayo "Ikhaya". Khetha imingcele yamaseli esifuna ukuwasusa bese uchofoza le nkinobho.
Ngakho-ke, kancane kancane sidweba iphazili yethu yesiphambano, sisusa imingcele ngamunye ngamunye, bese sithola umphumela ophelile.
Ukucaciseleka, kithi, ungakhetha umugqa oqondile wegama lesiphambano ngombala ohlukile, isibonelo ophuzi, usebenzisa inkinobho ethi "Gcwalisa umbala" kubambo.
Okulandelayo, beka phansi izinombolo zemibuzo iphazili. Okuhle kunakho konke, yenza lokhu ngefonti enkulu kakhulu. Esimweni sethu, ifonti 8 iyasetshenziswa.
Ukuze ubeke imibuzo ngokwayo, ungachofoza kunoma iyiphi indawo yamaseli kude nephazili yesiphambano, bese uchofoza inkinobho ethi "Merge Cells", ebekwe iribhoni kuthebhu efanayo kubha yamathuluzi "Alignment".
Ngaphezu kwalokho, esitokisini esikhulu esihlanganisiwe, ungaphrinta, noma ukopishe imibuzo ye-crossword puzzle.
Empeleni, iphazili yesiphambano ngokwayo ilungele lokhu. Ingaphrintwa, noma ixazululwe ngokuqondile ku-Excel.
Dala i-AutoCheck
Kepha, i-Excel ikuvumela ukuthi ungenzi nje iphazili yamagama, kodwa futhi iphazili eliyisiqalo nesheke lapho umsebenzisi ezokwazi ukuqagela igama elifanele noma cha ngokushesha.
Ukuze wenze lokhu, encwadini efanayo eshidi elisha yenza itafula. Ikholomu yayo yokuqala izobizwa ngokuthi "Izimpendulo", futhi sizofaka izimpendulo kumdwebo wephazili lapho. Ikholomu yesibili izongeniswa ngokuthi Kufakwe. Ibonisa idatha efakwe ngumsebenzisi, ezodonswa iphazili yesiphambano ngokwayo. Ikholomu yesithathu izobizwa ngokuthi "Okufanayo." Kuyo, uma iseli lekholamu lokuqala lifana neseli ehambelanayo lekholamu yesibili, kuzoboniswa inombolo "1", kungenjalo - "0". Kwikholamu efanayo ngezansi, ungenza iseli ngenani eliphelele lezimpendulo eziqageliweyo.
Manje, ngokusebenzisa amafomula, kufanele sixhumanise itafula ekhasini elilodwa netafula ekhasini lesibili.
Kungaba lula uma umsebenzisi efaka igama ngalinye lephazili yesiphambano esitokisini esisodwa. Ngemuva kwalokho besimane sihlobanise amaseli kukholomu Efakiwe namaseli ahambisanayo kwipuzzle yesiphambano. Kepha, njengoba sazi, hhayi negama elilodwa, kodwa kunhlamvu olulodwa oluhambisana neseli ngalinye lephazili. Sisebenzisa umsebenzi we- "CONNECT" ukuhlanganisa lezi zinhlamvu zibe igama elilodwa.
Ngakho-ke, chofoza kuseli lokuqala kukholamu ethi “Ungenile,” bese uchofoza inkinobho yokushayela wizadi yomsebenzi.
Ewindini elivuliwe le-Function Wizard, sithola umsebenzi we- "BONISA", ulikhethe, bese uchofoza inkinobho ethi "Kulungile".
Iwindi lokuphikisana ngomsebenzi liyavula. Chofoza inkinobho etholakala ngakwesokunene senkambu yokufaka idatha.
Iwindi lokuphikisana komsebenzi lincishisiwe, bese siya ekhasini lokusebenzela ngephazili eliyisiqalo, bese ukhetha iseli lapho kunohlamvu lokuqala lwegama oluhambelana nomugqa ekhasini lesibili ledokhumenti. Ngemuva kokuthi ukhetho lwenziwe, phinda uchofoze inkinobho ngakwesobunxele lefomu lokufaka ukubuyela kuwindi wezimpikiswano zomsebenzi.
Senza umsebenzi ofanayo ngohlamvu ngalunye lwegama. Lapho yonke idatha ifakiwe, chofoza inkinobho "Kulungile" ewindini lokuphikisana lomsebenzi.
Kepha, lapho ukuxazulula iphazili yamagama, umsebenzisi angazisebenzisa zombili izinhlamvu ezincane nezincane, futhi uhlelo luzothatha izinhlamvu ezihlukile. Ukuze uvikele lokhu kungenzeki, simi esitokisini esikudingayo, futhi kulayini wokusebenza sibeka inani ku- "LINE." Sithatha konke okuqukethwe kweseli kubakaki, njengasesithombeni esingezansi.
Manje, akunandaba ukuthi abasebenzisi babhala ziphi izinhlamvu emaphazili wesiphambano, kukholomu "Ukungenile" bazoguqulwa kube yincanyana.
Inqubo efanayo nemisebenzi ethi "IXhumanisa" ne "LINE" kumele yenziwe ngeseli ngalinye kwikholomu "Kufakiwe", kanye nohlu oluhambisanayo lwamaseli kuphazili yamagama ngokwayo.
Manje, ukuze siqhathanise imiphumela yekholomu ethi "Izimpendulo" nethi "Kufakiwe", kudingeka sisebenzise umsebenzi we- "IF" kukholomu "Okufanayo". Sizoya kuseli elihambisanayo kukholamu ethi "Matches" bese sifaka umsebenzi wokuqukethwe "= IF (izixhumanisi zekholomu" Izimpendulo "= izixhumanisi zekholomu" Kufakiwe "; 1; 0) Ngokuqondene necala lethu elithile kusuka kwisibonelo, umsebenzi uzoba nefomu" = IF ( B3 = A3; 1; 0) ". Senza umsebenzi ofanayo kuwo wonke amaseli kukholamu ye-Matches, ngaphandle kweseli eliphelele.
Bese ukhetha wonke amaseli kukholamu ethi "Matches", kufaka phakathi iseli ethi "Inani", bese uqhafaza isithonjana se-auto-sum kuriboni.
Manje, kulelishidi, ukunemba kwephazili yesolamu exazululiwe kuzohlolwa, futhi imiphumela yezimpendulo ezifanele izokhonjiswa njengamaphuzu aphelele. Esimweni sethu, uma iphazili yesiphambano lixazululwa ngokuphelele, khona-ke inombolo ye-9 kufanele ivele esitokisini sesamba, ngoba inani eliphelele lemibuzo lilingana nale nombolo.
Ukuze umphumela wesixazululo ungabonakali kuphela ephepheni elifihliwe, kepha nakumuntu oxazulula iphazili yesiphambano, ungaphinde usebenzise umsebenzi we- "IF". Iya eshidini eliqukethe iphazili yesiphambano. Sikhetha iseli, bese sifaka inani lapho ngokuya ngaleli phethini: "= UMA (I-Sheet2! Iseli lihlangana ngesibalo esiphelele = 9;" i-Crossword ixazululwe ";" Cabanga futhi ")". Esimweni sethu, ifomula ibukeka kanjena: "= UMA (I-Sheet2! C12 = 9;" I-crossword puzzle ixazululwe ";" Cabanga futhi ")."
Ngakho-ke, iphazili yesiphambano kuMicrosoft Excel isilungele ngokuphelele. Njengoba ukwazi ukubona, kulolu hlelo lokusebenza awukwazi ukwenza iphazili yamagama ngokushesha, kepha futhi ungadala isivivinyo ngokuzenzekelayo kulo.
