Abantu abaningi bayakuthanda ukuxazulula ama-crosswords, kukhona nabantu abathanda ukuthi bakwenze. Kwesinye isikhathi, igama elithi crossword alidingeka nje ngenxa yezokuzijabulisa, kodwa, ngokwesibonelo, ukubheka ulwazi lwabafundi ngendlela engeyona eyejwayelekile. Kepha, bambalwa abantu abacabanga ukuthi ithuluzi elihle kakhulu lokwakha ama-crosswords uhlelo lwe-Microsoft Excel. Futhi, impela, amaseli eshidi lalolu hlelo lokusebenza, njengokungathi aklanyelwe ngokukhethekile ukulingana nezinhlamvu zamagama aqine lapho. Ake sibheke ukuthi kufanele enze kanjani iphazili ye-Crossword ngohlelo lweMicrosoft Excel.
Ukudala i-crossword
Okokuqala, udinga ukuthola i-crossword eyenziwe ngomumo, lapho uzokwenza ikhophi kuhlelo lwe-Excel, noma ubheke ukwakheka kwegama lesiphambano, uma uqhamuka nawo ngokuphelele.
Nge-Crossword, udinga amaseli esikwele, hhayi unxande, njengezenzakalelayo kuMicrosoft Excel. Sidinga ukushintsha ukwakheka kwabo. Ukuze wenze lokhu, ucindezela ikhibhodi ye-CTRL + kwikhibhodi. Lokhu sigqamisa ishidi lonke. Ngemuva kwalokho, ngokuchofoza inkinobho yegundane efanele, ebiza imenyu yokuqukethwe. Kuyo, chofoza ku-Line "Line Height".
Iwindi elincane livula lapho udinga ukubeka khona ukuphakama kwentambo. Faka inani 18. Sichofoza inkinobho ethi "KULUNGILE".
Ukushintsha ububanzi, chofoza iphaneli ngegama lamakholomu, futhi kumenyu evela, khetha "ububanzi bekholomu ...".
Njengasesimweni esedlule, kuvela iwindi lapho idatha idinga ukungezwa. Kulokhu kuzoba inombolo 3. Chofoza inkinobho ethi "Kulungile".
Okulandelayo, kufanele ubale inani lamaseli wezinhlamvu ngesiphambano endaweni evundlile nangokuqondile. Khetha inani elihambisanayo lamaseli ekhasini le-Excel. Ukuba sethebhu yasekhaya, chofoza inkinobho ethi "Border", etholakala etheyipini ebhlokini lamathuluzi wefonti. Kumenyu evela, khetha into "yonke imingcele".
Njengoba sibona, imingcele echaza igama lethu libekiwe.
Manje, kufanele ususe le mingcele kwezinye izindawo ukuze igama lesiphambano lenze izinhlobo zezilwane zidingeke. Lokhu kungenziwa kusetshenziswa ithuluzi elinjalo, ukuthi "ucace kanjani", isithonjana sokuqala sinefomu lesikhizo, futhi likubha yamathuluzi "wokuhlela", ithebhu efanayo "ekhaya". Sigqamisa imingcele yamangqamuzana esifuna ukuwasusa bese uqhafaza kule nkinobho.
Ngakho-ke, kancane kancane sidweba igama lethu lesigaqa, sisusa ngokuhlukile imingcele, futhi sithola umphumela olungiselelwe.
Ukuze kube ukucacisa, esimweni sethu, ungaqokomisa umucu ovundlile wegama elinomunye umbala, ngokwesibonelo, uphuzi, usebenzisa inkinobho ethi "Fll Color" ethepheni.
Okulandelayo, sibeka inani lemibuzo esigabeni. Kungcono ukwenza le fonti ngokweqile. Endabeni yethu, ifonti isetshenziswa 8.
Ukuze ubeke imibuzo ngokwazo, ungachofoza noma iyiphi indawo yamaseli eceleni kusuka ku-Crossword. Bese uqhafaza kunkinobho ethi "Combine Cells", esethethini konke kuthebhu efanayo yebhokisi lamathuluzi afanayo.
Ngaphezu kwalokho, iseli enkulu ehlanganisiwe, ungaphrinta, noma ukopishe imibuzo kusuka ku-Crossword.
Empeleni, igama elithi crossword ngokwalo likulungele lokhu. Ingaphrintwa, noma ixazulule ngqo kwi-Excel.
Ukudalwa kwe-Auto Check
Kepha, i-Excel ikuvumela ukuthi ungavele wenze igama elithi, kepha futhi nesigamu esiphethe ngesheke lapho kuzokhombisa khona ngokuzenzakalelayo umsebenzisi ofanele oxazululwe ngokushesha noma cha.
Kulokhu, encwadini efanayo eshidini elisha senza itafula. Ikholomu yakhe yokuqala izobizwa ngokuthi "izimpendulo", futhi sizongena ezimpendulweni zegama elithi. Ikholomu yesibili izobizwa ngokuthi "ifakwe". Kunemininingwane ekhonjisiwe efakwe ngumsebenzisi ozodonswa egameni lesiphambano. Ikholomu yesithathu izobizwa ngokuthi "ama-concicinces". Kuyo, uma iseli lekholamu lokuqala lizohlangana ngeseli elihambisanayo lekholamu yesibili, isibalo esithi "1" siyaboniswa, futhi ngenye indlela - "0". Kukholamu efanayo ngezansi, ungenza iseli ngenani eliphelele lezimpendulo ezivumile.
Manje, singaphansi kwetafula ephepheni elilodwa netafula ephepheni lesibili.
Kungaba nje uma igama elithi igama ngalinye lingene esitokisini esisodwa. Ngemuva kwalokho savele sabopha amaseli ekholomu "efakiwe" ngamaseli ahambelana nawo afanayo. Kepha, njengoba sazi, hhayi igama elilodwa elifanelana esitokisini ngasinye segama elithi, kodwa uhlamvu olulodwa. Sisebenzisa umsebenzi we- "Capture" ukuhlanganisa lezi zinhlamvu ngegama elilodwa.
Ngakho-ke, chofoza eseli lokuqala kwikholamu "Efakiwe", bese uqhafaza inkinobho ukubiza i-wizard yemisebenzi.
Emsebenzini wewindows wizard evula, sithola umsebenzi we- "Capture", ukhethe, bese uqhafaza inkinobho ethi "KULUNGILE".
Ukuphikisana nomsebenzi kuyavuleka. Chofoza inkinobho etholakala ngakwesokudla kwenkambu yokungena yedatha.
Umsebenzi wezimpikiswano zomsebenzi udilizwa, futhi sithuthela eshidini elinamagama, bese ukhetha iseli lapho incwadi yokuqala yegama itholakala khona, ehambelana nomugqa ekhasini lesibili ledokhumenti. Ngemuva kokukhethwa kwenziwa, sichofoza inkinobho ngakwesokunxele sefomu lokufaka ukubuyela ewindini lezingxabano.
Ukuhlinzwa okunjalo kwenziwa ngencwadi ngayinye yeZwi. Lapho yonke imininingwane ifakiwe, chofoza inkinobho ethi "Kulungile" ewindini lezimpikiswano.
Kepha, umsebenzisi lapho iphazili ye-Crossword ingasebenzisa zombili izinhlamvu ezincane nezinhlamvu eziphezulu, futhi uhlelo luzobabheka njengezinhlamvu ezahlukene. Ukuze lokhu kungenzeki, siba esitokisini osidingayo, futhi emugqeni wemisebenzi sibeka inani "Strach". Konke okunye okuqukethwe kweseli kuthatha kubakaki, njengasesithombeni esingezansi.
Manje, noma ngabe izinhlamvu azizange zibhale abasebenzisi esigabeni, kwikholamu "efakiwe" zizoguqulwa zibe yindawo encane.
Inqubo enjalo nge "Capture" kanye "nemisebenzi" ye-Strachnic "kufanele yenziwe ngeseli ngalinye kwikholamu" elethulwe ", kanye nohlu oluhambisanayo lwamaseli esigangeni uqobo.
Manje, ukuze uqhathanise imiphumela yekholomu "Izimpendulo" futhi "wethulwa", kudingeka sisebenzise umsebenzi we- "ff uma "kwikholamu. Siba esitokisini esihambisanayo sekholomu "yokuzenzela", futhi sethula umsebenzi wokuqukethwe okunjalo "= Uma (izixhumanisi" ikholomu "yezimpendulo" = izixhumanisi zekholomu "ezingenisiwe"; 1; 0). Esimweni sethu esithile, umsebenzi uzoba nefomu "= uma (b3 = A3; 1; 0)". Ukuhlinzwa okunjalo kwenziwa kuwo wonke amaseli wekholomu "wokuzenzelwa", ngaphandle kweseli "eliphelele".
Ngemuva kwalokho sigqamisa wonke amaseli kukholamu ye- "Comeiregence", kufaka phakathi "isitokisi" seseli, bese uqhafaza kwisithonjana se-autosummy ku-Ribbon.
Manje leli shidi lizobhekwa ukunemba kwegama eliqinile, futhi imiphumela yezimpendulo ezifanele izokhonjiswa njengesikolo esivamile. Kuthu, uma igama lesiphambano lizoqina ngokuphelele, khona-ke inombolo 9 kufanele ivele ngenani lemali, ngoba inani lemibuzo lilingana nale nombolo.
Ukuze umphumela wobuncane ungabonakali hhayi eshidini elifihlekile kuphela, kodwa umuntu oxazulula igama elithi, ungaphinde usebenzise umsebenzi we- "uma". Iya eshidini eliqukethe igama elithi. Sikhetha iseli, bese sifaka inani lethempulethi enjalo: " Esesimweni sethu, ifomula inalolu hlobo: "= Uma (sheet2! C12 = 9;" I-Crossword ixazululiwe ";" Cabanga okuningi ").
Ngakho-ke, igama elithi ku-Microsoft Excel Program lilungele ngokuphelele. Njengoba ubona, kulolu hlelo lokusebenza awukwazi nje ukwenza ngokushesha igama elithi, kepha futhi udale isheke elizenzakalelayo.