Abantu abaningi bathanda ukuxazulula i-crosswords, kukhona nabantu abathanda ukuzenza. Ngezinye izikhathi, ukwenza iphazili ye-crossword kuyadingeka hhayi nje kumnandi, kodwa, isibonelo, ukuhlola ulwazi lwabafundi ngendlela engavamile. Kodwa bambalwa abantu abaqaphela ukuthi i-Microsoft Excel iyithuluzi elihle kakhulu lokudala amaphuzu e-crossword. Futhi, ngempela, amaseli eshidi lalo hlelo lokusebenza, njengokungathi lenzelwe ukufaka khona izinhlamvu zamagama aqagele. Ake sithole ukuthi singadala kanjani ukudala iphazili elingenayo i-Microsoft Excel.
Dala iphazili elandelwayo
Okokuqala, udinga ukuthola i-puzzle eyakhelwe ngokuzenzakalelayo eyenziwe ngomumo, okuzokwenza ikhophi ku-Excel, noma ucabange ngesakhiwo se-crossword, uma uyisungula ngokwakho.
Ukuze iphazili ehamba phambili idinga amangqamuzana asesigcawini, kunokuba i-rectangular, njenge-default ku-Microsoft Excel. Kudingeka sishintshe ukuma kwawo. Ukuze wenze lokhu, cindezela isinqamuleli sekhibhodi Ctrl + A ekhibhodi. Lokhu sikhetha lonke ishidi. Bese uchofoza inkinobho yesokudla yegundane, okubangela imenyu yokuqukethwe. Kulo sizochofoza entweni "Ukuphakama komugqa".
Iwindi elincane livuleka lapho udinga ukusetha ukuphakama komugqa. Beka inani ku-18. Chofoza inkinobho ethi "Kulungile".
Ukuze ushintshe ububanzi, chofoza iphaneli ngegama lamakholomu, futhi kwimenyu evelayo, khetha into "Ububanzi bekholomu ...".
Njengokwesikhashana esidlule, iwindi livela lapho udinga ukufaka idatha. Lesi sikhathi kuyoba yinombolo 3. Chofoza inkinobho ethi "Kulungile".
Okulandelayo, kufanele ubale inani lamaseli ezinhlamvu ku-puzzle engena e-crossword esiqondisweni esiqondile nesiqondile. Khetha inani elifanele lamaseli efayeleni le-Excel. Ngenkathi kuthebhu ethi "Ekhaya", chofoza inkinobho ethi "Border", esitholakala kubhebhoni ebhokisini lamathuluzi ethi "Font". Emenyu evelayo, khetha into "Yonke imingcele".
Njengoba ubona, imingcele ehlukanisa iphazili yethu ye-crossword isethwe.
Manje, kufanele sisuse lezi zimingcele kwezinye izindawo, ukuze i-puzzle ye-crossword ibonakale sidinga. Lokhu kungenziwa ngokusebenzisa ithuluzi elinjengokuthi "Sula", isithonjana sakhe sokuqaliswa sinesimo se-eraser, futhi sitholakala ku-"Hlela" ibha yamathuluzi yethebhu efanayo "Ekhaya". Khetha imingcele yamaseli esifuna ukusula bese uchofoze kule nkinobho.
Ngakho-ke, kancane kancane sidonsela iphazili yethu ye-crossword, ngokukhipha eceleni imingcele, futhi sithola umphumela ophelile.
Ukuze kucaciswe, kithi, ungakhetha umugqa olinganiselwe wephazili eliphambene nombala ohlukile, isibonelo, ophuzi, usebenzisa inkinobho Yombala Yokugcwalisa kulayini.
Okulandelayo, faka inani lemibuzo ku-crossword. Okuhle kunakho konke, yenzeni enfonini enkulu kakhulu. Esimweni sethu, ifonti isetshenzisiwe ngu-8.
Ukuze ubeke le mibuzo ngokwayo, ungachofoza noma iyiphi indawo yamaseli kude nephazili elingenayo, bese uchofoze inkinobho ethi "hlanganisa amaseli", ekhonobheni konke kuthebhu elifanayo ebhokisini lamathuluzi "Ukuqondanisa".
Ngaphezu kwalokho, kuseli elikhulu elihlanganisiwe, ungaphrinta, noma ukopishe imibuzo ye-crossword lapho.
Empeleni, i-crossword ngokwayo ilungele lokhu. Ingadluliswa noma ixazululwe ngqo ku-Excel.
Dala i-AutoCheck
Kodwa, i-Excel ikuvumela ukuthi ungenzi nje iphazili elandelwayo, kodwa futhi i-crossword ngesheke, lapho umsebenzisi azobonisa ngokuqondile ngokuzenzakalelayo igama noma cha.
Kulokhu, encwadini efanayo ngeshidi elisha senza itafula. Ikholomu yayo yokuqala izobizwa ngokuthi "Izimpendulo", futhi sizofaka izimpendulo kuphazili elingenelela lapho. Ikholomu yesibili izobizwa ngokuthi "Ukungena". Lokhu kubonisa idatha efakwe ngumsebenzisi, okuzokhishwa kusukela ku-crossword ngokwayo. Ikholomu yesithathu izobizwa ngokuthi "Ukufaniswa". Kulo, uma iseli lekholomu yokuqala lihambisana neseli elihambelana nekholomu yesibili, inombolo "1" iboniswa, futhi ngaphandle kwalokho - "0". Kukholomu elilodwa elingezansi ungenza iseli inani eliphelele lezimpendulo eziqageliwe.
Manje, kufanele sisebenzise amafomula ukuxhumanisa ithebula kwelinye ishidi elinetafula eshidi lesibini.
Kungaba lula uma umsebenzisi engena igama ngalinye le-puzzle ye-crossword esitokisini esisodwa. Khona-ke sivele sixhumanise amaseli ekholomu "Elingene" namaseli ahambelana nephazili elingenayo i-crossword. Kodwa, njengoba siyazi, akulona igama elilodwa, kodwa incwadi eyodwa ifanelana esitokisini ngasinye sephazili elingenayo. Sizosebenzisa umsebenzi we- "CLUTCH" ukuhlanganisa lezi zincwadi zibe yinye igama.
Ngakho-ke, chofoza esitokisini sokuqala kukholomu "Imvume", bese uchofoza inkinobho ukuze ushayele i-Function Wizard.
Kuwindidi yewindidi yomsebenzi evula, sithola umsebenzi "CLICK", ukhethe, bese uchofoza inkinobho ethi "Kulungile".
Iwindi lempikiswano yokusebenza ivula. Chofoza inkinobho ekhona ngakwesokudla kwenkambu yokufaka idatha.
Iwindi lempikiswano yokusebenza liyanciphisa, futhi siya eshadini nge-puzzle crossword, bese ukhetha iseli lapho incwadi yokuqala yegama itholakala khona, ehambisana nomugqa weshidi lesibini lwedokhumenti. Ngemuva kokuba kukhethwe ukhetho, phinda uchofoze inkinobho ngakwesobunxele kwifomu lokufakwayo ukuze ubuyele ewindini lezingxoxo zomsebenzi.
Senza ukufana okufanayo nencwadi ngayinye yegama. Uma yonke idatha ingenisiwe, chofoza inkinobho ethi "Kulungile" kufasitelana lezinkulumo.
Kodwa, lapho uxazulula umusho ongathintwayo, umsebenzisi angasebenzisa kokubili izinhlamvu ezincane nezinhlamvu zamagama, futhi uhlelo luzobheka njengezinhlamvu ezahlukene. Ukuvimbela lokhu kungenzeki, sichofoza kuseli esiludinga, futhi kulayini lomsebenzi sibhala inani "LINE". Okunye konke okuqukethwe kweseli kuthathwa kubakaki, njengokusithombeni ngezansi.
Manje, kungakhathaliseki ukuthi abasebenzisi bezincwadi bangabhala kuphi esiphambanweni, kukholomu "Engenayo" bazoguqulwa ukuba babe ngaphansi.
Inqubo efanayo nemisebenzi ye- "CLUTCH" ne "LINE" kufanele yenziwe ngeseli ngayinye kukholomu "Lokungenisiwe", futhi nebala elihambelanayo lamaseli ku-crossword ngokwalo.
Manje, ukuze uqhathanise imiphumela ye "Izimpendulo" ne "Ukungena" kwamakholomu, sidinga ukusebenzisa "IF" umsebenzi kukholomu "Matches". Sifika esitokisini esilandelayo sekholomu ye "Matches" bese ufaka umsebenzi walokhu okuqukethwe "= IF (izixhumanisi zekholomu" Izimpendulo "= izixhumanisi zekholomu" Ukungena "; 1; 0). Ngomzekelo wethu, umsebenzi uzobukeka" = IF ( B3 = A3; 1; 0) ". Senza ukufana okufanayo kuwo wonke amaseli wekholomu" Yokufanisa ", ngaphandle kweseli" Lonke ".
Bese ukhetha wonke amaseli kukholomu "Matches", kufaka phakathi iseli "Yonke", bese uchofoza isithonjana se-self-sum kubherebhisi.
Manje kuleli shidi lizohlolwa ukuthi i-puzzle ye-crossword ilungile yini, futhi imiphumela yezimpendulo ezifanele izoboniswa ngesimo samaphuzu aphelele. Esikhathini sethu, uma iphazili ye-crossword ixazululwa ngokuphelele, khona-ke inombolo 9 kufanele ivele esitokisini samanani, ngoba inani lemibuzo lilingana nale nombolo.
Ukuze umphumela wokuqagela ubonakale hhayi kuphela eshidi elifihliwe, kodwa futhi kumuntu owenza iphazili ye-crossword, ungaphinda usebenzise umsebenzi we- "IF". Yiya ekhasini eliqukethe iphazili elingenayo. Sakhetha iseli bese ufaka inani ngokusebenzisa iphethini elilandelayo: "= IF (iShidi 2! Izixhumanisi zeseli ngenani eliphelele = 9;" I-Crossword ixazululwa ";" Cabanga futhi ")". Esikhathini sethu, ifomula inefomu elilandelayo: "= IF (iShidi 2! C12 = 9;" Ukudluliselwa kwe-crossword kuxazululwe ";" Cabanga futhi ")". "
Ngakho, iphazili ye-crossword ku-Microsoft Excel ilungile ngokuphelele. Njengoba ubona, kulolu hlelo lokusebenza, awukwazi nje ukwenza ngokushesha iphazili elingenayo, kodwa futhi wenze i-autocheck kuyo.
