Muaj ntau tus neeg nyiam kom daws tau cov lus sib tw, tseem muaj cov neeg nyiam ua lawv. Qee zaum, ua kom cov lus sib dhos sib dhos sib dhos tsis yog rau kev lom zem xwb, tabsis, piv txwv, los ntsuam xyuas cov menyuam kawm ntawv txoj kev paub hauv ib txoj kev tsis muaj txuj ci. Tab sis ob peb tus neeg paub tias Microsoft Excel yog ib qho cuab yeej zoo tshaj plaws los tsim txoj kev sib tw lus tshawb nrhiav. Thiab, qhov tseeb, lub hlwb nyob rau hauv daim ntawv ntawm daim ntawv thov no, txhais tau hais tias lawv yeej tsim los nkag rau hauv cov ntawv ntawm cov lus twv. Cia peb paub tias yuav ua li cas kom tsim tau ib txoj kev sib dhos hauv Microsoft Excel.
Tsim kom muaj kev sib dhos sib dhos
Ua ntej txhua yam, koj yuav tsum nrhiav kev npaj puzzle, uas koj yuav ua ib daim qauv hauv Excel, los yog xav txog lub teeb tsa ntawm qhov crossword, yog tias koj txua nws kiag li koj tus kheej.
Rau crossword puzzle xav square cells, qhov tsis sib luag, raws li lub neej nyob Microsoft Excel. Peb yuav tsum hloov lawv cov duab. Ua li no, nyem cov keyboard shortcut Ctrl + A rau cov keyboard. Qhov no peb xaiv tag nrho daim ntawv. Tom qab ntawd, nias lub khawm txoj kev nas, uas ua rau lub ntsiab lus teb lus qhia. Nyob rau hauv peb peb nias qhov khoom "Kab qhov siab".
Ib lub qhov rai me me qhib uas koj xav kom teem rau kab qhov siab. Teem nqi tus nqi rau 18. Nias ntawm "OK" khawm.
Hloov qhov dav, nyem rau ntawm lub vaj huam sib luag nrog txhua lub npe, thiab hauv cov ntawv qhia zaub mov, xaiv qhov khoom "Column width ...".
Xws li hauv cov ntaub ntawv dhau los, ib lub qhov rais pom hauv uas koj xav tau nkag cov ntaub ntawv. Lub sijhawm no nws yuav yog tus najnpawb 3. Nyem ntawm "OK" khawm.
Tom ntej, koj yuav tsum suav cov naj npawb ntawm cov tsiaj ntawv rau cov tsiaj ntawv nyob rau hauv cov lus sib dhos ntawm cov lus sib dhos hauv kab rov tav thiab ntsug. Xaiv qhov tsim nyog ntawm cov hlwb hauv cov ntawv Excel. Thaum nyob hauv "Tsev" tab, nias qhov "Border" khawm, uas nyob rau ntawm daim ntawv sau rau hauv "Font" toolbox. Nyob rau hauv cov ntawv qhia zaub mov uas tshwm, xaiv cov khoom "Txhua thaj tsam".
Raws li koj tau pom, cov ciaj ciam delineating peb cov puzzle crossword yog teeb.
Tam sim no, peb yuav tsum tshem tawm cov ib thaj tsam ntawm qee qhov chaw, kom cov lus sib dhos sib tw siv rau ntawm qhov peb xav tau. Qhov no yuav ua tau los siv lub cuab tam xws li "Clear", nws lub icon tso tawm tau qhov luaj li cas, thiab nyob hauv "Hloov" qhov toolbar ntawm tib lub "Tsev" tab. Xaiv cov ciam teb ntawm lub hlwb uas peb xav lwv thiab nias ntawm no khawm.
Yog li, peb maj mam li kos peb cov ntawv sib dhos, hloov cov ciam teb, thiab peb tau txais qhov kev tshwm sim tiav.
Rau clarity, nyob rau hauv peb cov ntaub ntawv, koj tuaj yeem xaiv kab txoj kab ntawm cov lus sib dhos ntawm cov lus sib dhos nrog cov xim txawv, piv txwv li, daj, siv Puv Xim khawm ntawm txoj kab.
Ntxiv mus, muab cov lus nug nyob rau hauv cov lus nug. Qhov zoo tshaj plaws, ua nws tsis dhau font loj. Hauv peb cov ntaub ntawv, daim ntawv siv yog 8.
Txhawm rau muab cov lus nug txog lawv tus kheej, koj tuaj yeem nias qhov cheeb tsam ntawm lub hlwb tawm ntawm cov lus sib dhos, thiab nias ntawm qhov "Merge cells" khawm, uas nyob rau ntawm daim ntawv sau, tag nrho ntawm qhov qub tab hauv "Alignment" toolbox.
Tsis tas li ntawd, nyob rau hauv ib lub loj sib txuas ntawm tes, koj tuaj yeem sau, lossis luam tawm cov lus nug ntawm crossword.
Tiag tiag, lub ntsiab lus ntawm nws tus kheej yog npaj rau qhov no. Nws tuaj yeem luam tawm lossis daws ncaj qha rau hauv Excel.
Tsim AutCheck
Tab sis npog, Excel tso cai rau koj tsis yog ib qho kev sib tw ntawm cov lus sib dhos, tab sis kuj yog ib qho kev tshawb fawb nrog ib daim tshev, uas tus neeg siv yuav tam sim ntawd cia li ua raws li lo lus los yog tsis.
Rau qhov no, nyob rau tib phau ntawv rau ib daim ntawv tshiab peb ua tau ib lub rooj. Thawj cov npe yuav raug hu ua "Answers", thiab peb yuav sau cov lus teb rau cov lus sib dhos ntawm crossword. Kem thib ob yuav raug hu ua "Entered". Qhov no qhia tau hais tias cov ntaub ntawv nkag los ntawm tus neeg siv, uas yuav tsum tau rub tawm los ntawm cov lus taw qhia nws tus kheej. Peb sab yuav hu ua "Matches". Nyob rau hauv nws, yog hais tias lub xovtooj ntawm tus thawj kem coincides nrog lub xovtooj ntawm sab qauv thib ob, tus naj npawb "1" tshwm, thiab lwm yam - "0". Hauv tib kem hauv qab no koj tuaj yeem ua ib lub xovtooj rau cov nqi ntawm cov lus teb.
Tam sim no, peb yuav tsum tau siv cov qauv los txuas rooj ntawv rau ib daim ntawv nrog lub rooj rau ntawm daim ntawv thib ob.
Nws yuav yooj yim yog tias tus neeg siv nkag txhua lo lus ntawm cov lus sib dhos sib tw hauv ib qho cell. Tom qab ntawd peb yuav tsuas txuas cov hlwb nyob hauv "Nkag Mus" kem nrog lub hlwb cov lus sib dhos. Tab sis, raws li peb paub, tsis yog ib lo lus, tab sis ib daim ntawv fits mus rau txhua lub xov tooj ntawm cov kab lus crossword. Peb yuav siv cov "CLUTCH" los ua ke cov ntawv sau ua ib lo lus.
Yog li, nyem rau ntawm thawj lub xov tooj ntawm kab ntawv "Tso Cai", thiab nias rau ntawm lub pob kom hu rau Function Wizard.
Nyob rau hauv qhov kev ua haujlwm qhov chaw ua haujlwm qhov rais qhib, peb pom qhov kev ua haujlwm "NYUJ", xaiv nws, thiab nias rau ntawm "OK" khawm.
Qhov sib xyaw qhov rooj qhib qhov rooj. Ndliv lub khawm ntawm sab xis ntawm cov ntaub ntawv nkag teb chaws.
Qhov kev sib cav sib cav yog qhov tsawg, thiab peb mus rau ntawm daim ntawv nrog cov lus sib dhos, thiab xaiv lub xovtooj ntawm thawj daim ntawv ntawm lo lus nyob, uas yog mus rau kab ntawv nyob rau hauv daim ntawv thib ob ntawm daim ntawv. Tom qab xaiv tau lawm, nias dua ntawm lub pob mus rau sab laug ntawm daim ntawv xa rov qab tuaj rau cov kev sib tham ntawm cov lus sib tham.
Peb ua haujlwm zoo sib xws nrog txhua tsab ntawv ntawm ib lo lus. Thaum twg tag nrho cov ntaub ntawv nkag, nyem rau ntawm "OK" khawm ntawm qhov kev sib tham ntawm cov lus sib tham.
Tab sis, thaum daws cov lus nug, ib tus neeg siv tau siv ob theem tsiaj ntawv thiab cov ntawv loj, thiab qhov kev zov me nyuam yuav xav txog lawv li cov cim txawv. Yuav kom tiv thaiv tau qhov no ntawm qhov teeb meem, peb nias ntawm lub xov tooj ntawm tes peb xav tau, thiab nyob rau hauv cov kab ua haujlwm peb sau qhov nqi "LINE". Tus so ntawm tus txheem ntawm tus xovtooj yog muab rau hauv nkhaus, raws li nyob hauv daim duab hauv qab no.
Tam sim no, tsis muaj teeb meem dab tsi cov neeg siv cov tsiaj ntawv sau rau hauv qhov crossword, nyob hauv "Nkag Mus" sab lawv yuav hloov dua siab tshiab rau kev txo qis.
Ib qho kev ua zoo sib xws nrog "CLUTCH" thiab "LINE" cov haujlwm yuav tsum tau ua nrog txhua lub cell hauv "Sau", thiab nrog cov sib txawv ntawm cov hlwb nyob rau hauv qhov crossword nws tus kheej.
Tam sim no, xwv kom piv tau cov lus teb ntawm "Lus Teb" thiab "Nkag Mus" txhua txhua, peb yuav tsum siv qhov "YOG" ua haujlwm hauv "Matches". Peb ua qhov ntawm lub pob ntawm cov "Matches" thiab sau cov haujlwm ntawm cov ntsiab lus no "= YOG HAIS TIAS (coordinates ntawm column" Answers "= coordinates ntawm column" Entered "; 1) 0. Rau peb cov piv txwv, qhov kev ua yuav zoo li" B3 = A3; 1; 0) Peb ua haujlwm zoo sib xws rau txhua lub hlwb ntawm kab "Matches", tsuas yog rau "Total" cell.
Tom qab ntawd, xaiv tag nrho cov hlwb hauv "Cov Kev Ntaiv", nrog rau "Total" ntawm tes, thiab nias rau ntawm nws pib-xaus icon ntawm lub xov.
Tam sim no ntawm daim ntawv no yuav raug xyuas qhov tseeb ntawm qhov kev sib tw ntawm cov lus sib dhos, thiab cov lus teb ntawm cov lus teb kom yog yuav pom tshwm rau hauv daim ntawv ntawm tag nrho cov qhab nia. Nyob rau hauv peb cov ntaub ntawv, yog tias cov lus sib dhos lus sib dhos daws tau tag, ces tus naj npawb 9 yuav tsum tshwm sim hauv cov xov tooj ntawm tes, txij thaum tag nrho cov lus nug sib npaug zos no.
Yog li ntawd qhov kev tshwm sim ntawm qhov kev pom zoo tsis pom ntawm cov ntawv xov xwm xwb, tab sis kuj rau tus neeg uas ua qhov kev sib tw ntawm cov lus sib dhos, koj tuaj yeem siv qhov "YOG" ua haujlwm. Mus rau ntawm daim ntawv uas muaj cov puzzle crossword. Peb xaiv ib lub xov tooj thiab sau tus nqi uas siv cov qauv hauv qab no: "= YOG HAIV NEEG (Sheet2!) Kev sib tw ntawm cov xovtooj nrog cov qhabnias tagnrho = 9;" Lo lus "xaus"; Nyob rau hauv peb cov ntaub ntawv, qhov formula muaj cov nram qab no: "= YOG HAIV NEEG (Sheet2! C12 = 9;" Lo lus xaus ";" Xav dua ")".
Yog li, qhov puzzle crossword hauv Microsoft Excel yog npaj txhij txhua. Raws li koj tuaj yeem pom, hauv daim ntawv thov no, koj tuaj yeem tsis tuaj yeem ua sai sai ua cov lus sib dhos, tab sis kuj tsim ib qho autocheck hauv nws.
