Tsim cov ntawv sau hla hauv Microsoft Excel

Pin
Send
Share
Send

Coob tus neeg nyiam daws cov crosswords, kuj tseem muaj cov neeg nyiam los sau lawv. Qee zaum, sau ntawv sib dhos xav tau tsis yog rau kev lom zem xwb, tab sis, piv txwv, txhawm rau sim cov tub ntxhais kawm kev paub hauv cov qauv tsis yog. Tab sis, ob peb cov neeg paub tias Microsoft Excel yog qhov cuab yeej zoo rau kev tsim crosswords. Thiab, qhov tseeb, lub hlwb ntawm daim ntawv ntawm daim ntawv thov no, zoo li tshwj xeeb tau tsim los sau cov tsiaj ntawv ntawm cov lus twv nyob rau ntawd. Cia peb kawm seb yuav ua li cas tsim cov lus sib dhos luv luv nyob hauv Microsoft Excel.

Kev Sau Dab Qhuas

Ua ntej tshaj plaws, koj yuav tsum nrhiav qhov kev npaj tau ua tiav crossword puzzle los ntawm kev uas koj yuav ua daim ntawv hauv Excel, lossis xav txog cov qauv ntawm qhov crossword puzzle yog tias koj tuaj nrog nws koj tus kheej.

Lub rooj sib tham crossword xav tau cov square hlwb, tsis yog lub sib dhos, raws li los ntawm lub neej ntawd hauv Microsoft Excel. Peb yuav tsum hloov pauv lawv cov duab. Ua li no, ntawm cov keyboard, nias tus yuam sij ua ke Ctrl + A. Qhov no peb xaiv tag nrho cov ntawv. Tom qab ntawd, peb muaj txoj cai nyem, uas coj lub ntsiab lus teb ntawv qhia. Hauv nws, nyem rau ntawm qhov khoom "Kab Qhov Siab".

Lub qhov rais me me qhib uas koj yuav tsum teeb tsa qhov siab ntawm txoj kab. Teev tus nqi rau 18. Nyem rau ntawm "OK" khawm.

Txhawm rau hloov qhov dav, nyem rau ntawm lub vaj huam sib luag nrog lub npe npe ntawm txhua, thiab hauv cov ntawv qhia zaub mov uas tshwm, xaiv cov khoom "Column width ...".

Raws li nyob rau yav dhau los cov ntaub ntawv, lub qhov rais tshwm nyob rau hauv uas koj yuav tsum sau cov ntaub ntawv. Lub sijhawm no nws yuav yog tus lej 3. Nyem rau ntawm "OK" khawm.

Tom ntej no, koj yuav tsum xam tus naj npawb ntawm cov xov tooj rau cov tsiaj ntawv nyob rau hauv qhov sib dhos crossword hauv kab rov tav thiab qhia. Xaiv cov naj npawb tsim nyog ntawm lub hlwb ntawm daim ntawv khom rau Excel. Ua rau hauv "Lub Tsev" tab, nyem rau kab "Ciam Tebchaws", uas yog nyob ntawm pob txhav hauv "Font" toolbox. Hauv cov ntawv qhia zaub mov uas tshwm, xaiv cov khoom "Txhua Ciam Tebchaws".

Raws li koj tuaj yeem pom, cov ciaj ciam uas nthuav dav peb cov lus sib dhos crossword raug teeb tsa.

Tam sim no, koj yuav tsum tau rho tawm cov ciam teb no rau qee qhov chaw kom qhov crossword puzzle yuav tsum saib qhov peb xav tau. Qhov no tuaj yeem ua tiav siv cov cuab yeej xws li "Ntshiab", lub cim qhia tua ntawm uas muaj cov duab ntawm lub lwv, thiab nyob hauv "Editing" cuab yeej thaiv ntawm tib "Main" tab. Xaiv cov ciam teb ntawm lub hlwb uas peb xav kom lwv tawm thiab nyem rau ntawm lub pob no.

Yog li, peb maj mam kos peb cov lus sib dhos, tshem cov ciam teb ib qho dhau ib qho, thiab peb tau txais qhov txiaj ntsig tiav.

Txhawm rau kom pom tseeb, hauv peb qhov xwm txheej, koj tuaj yeem xaiv kab ntawv kab rov tav ntawm crossword nyob rau xim sib txawv, piv txwv li daj, siv khawm "Sau xim" rau ntawm txoj siv.

Tom ntej no, sau cov lej ntawm cov lus nug ntawm kab ntawv sib dhos. Qhov zoo tshaj plaws, ua qhov no tsis yog ib tus font loj dua. Hauv peb li, font 8 siv.

Txhawm rau tso cov lus nug lawv tus kheej, koj tuaj yeem nyem rau txhua qhov chaw ntawm lub hlwb kom deb ntawm kab lus sib dhos, thiab nyem rau ntawm "Merge Cells" khawm, uas nyob rau ntawm txoj hlua ntawm tib lub tab hauv "Alignment" toolbar.

Ntxiv mus, hauv cov chav sib koom ua ke loj, koj tuaj yeem luam tawm, lossis luam ib daim ntawv hla cov lus nug ntawd.

Qhov tseeb, qhov crossword puzzle nws tus kheej yog npaj rau qhov no. Nws tuaj yeem luam tawm, los yog daws ncaj qha hauv Excel.

Tsim AutoCheck

Tab sis, Excel tso cai rau koj tsis yog ua cov lus sib dhos xwb, tab sis tseem muaj qhov sib cav sib txuas nrog daim tshev uas tus neeg siv yuav twv nrawm cov lus kom raug lossis tsis.

Ua li no, hauv tib phau ntawv ntawm ib daim ntawv tshiab ua rooj. Nws thawj kem yuav raug hu ua "Cov lus teb", thiab peb yuav sau cov lus teb rau qhov crossword puzzle nyob ntawd. Ntu ob yuav muaj ntu kev Nkag Mus Saib. Nws qhia txog cov ntaub ntawv nkag los ntawm tus neeg siv khoom, uas yuav raug rub los ntawm crossword puzzle nws tus kheej. Thib peb yuav raug hu ua "Sib Tw." Hauv nws, yog tias lub cell ntawm thawj kem sib phim rau ntawm kab xov tooj ntawm kab ntawv thib ob, tus lej "1" yuav tshwm, txwv tsis pub - "0". Hauv tib kem hauv qab no, koj tuaj yeem ua tus tsim rau lub xov tooj rau tag nrho cov nyiaj ntawm cov lus teb twv.

Tam sim no, dhau los ntawm cov qauv, peb yuav tsum txuas lub rooj rau ntawm ib daim ntawv nrog lub rooj ntawm daim ntawv thib ob.

Nws yuav yooj yim yog tias tus neeg siv sau txhua lo lus ntawm kab ntawv sib dhos sib dhos hauv ib lub xovtooj ntawm. Tom qab ntawd peb yuav cias txuas cov hlwb hauv kem Nkag nrog cov xov tooj sib haum ntawm cov lus sib dhos. Tab sis, raws li peb paub, tsis yog ib lo lus, tab sis ib tsab ntawv haum rau hauv txhua ntawm tes ntawm qhov sib dhos crossword. Peb siv txoj haujlwm "CONNECT" los mus sau cov tsiaj ntawv no rau ib lo lus.

Yog li, nyem rau thawj lub xov tooj ntawm kem "Nkag Mus Nkag", thiab nyem rau ntawm qhov haujlwm hu ua wizard hu khawm.

Hauv kev qhib lub qhov rai ntawm Tus Txheej Txheem Kev Ua Haujlwm, peb pom tus "txuas rau" txoj haujlwm, xaiv nws, thiab nyem rau ntawm "OK".

Lub muaj nuj nqi sib cav qhov rais qhib. Nyem rau ntawm lub pob nyob rau sab xis ntawm cov ntaub ntawv nkag teb.

Qhov ua haujlwm sib cav qhov rai tsawg heev, thiab peb mus rau ntawm nplooj ntawv ua haujlwm nrog lub ntsej muag sib dhos, thiab xaiv lub xov tooj ntawm qhov chaw uas thawj tsab ntawv ntawm lo lus uas ua tau raws li txoj kab ntawm daim ntawv thib ob ntawm daim ntawv nyob. Tom qab xaiv tau tiav lawm, rov nias lub khawm rau sab laug ntawm cov ntawv foos xa rov qab mus rau qhov haujlwm muaj nuj nqi ntawm lub qhov rai.

Peb ua haujlwm zoo sib xws nrog txhua tus tsiaj ntawv ntawm lo lus. Thaum tag nrho cov ntaub ntawv nkag mus, nyem rau qhov "OK" khawm hauv lub luag haujlwm sib cav qhov rai.

Tab sis, thaum daws cov lus sib dhos crossword, tus neeg siv yuav siv ob tus tsiaj ntawv qis thiab ntawv loj, thiab qhov kev zov me nyuam yuav saib lawv raws li cov cim sib txawv. Txhawm rau tiv thaiv qhov no kom tsis txhob tshwm sim, peb sawv ntawm tes uas peb xav tau, thiab hauv kab ua haujlwm peb tau teev tus nqi rau "LINE." Peb coj tus so ntawm cov ntsiab lus ntawm lub xov tooj ua nkhaus, raws li nyob hauv daim duab hauv qab no.

Tam sim no, tsis muaj ntawv sau dab tsi rau cov neeg siv sau hauv kab ntawv sib dhos, hauv kem "Nkag mus" lawv yuav hloov mus ua kab me.

Cov txheej txheem zoo sib xws nrog cov haujlwm "CONNECT" thiab "LINE" yuav tsum tau ua nrog txhua lub xovtooj ntawm kab "Nkag mus", thiab nrog cov kab sib txawv ntawm cov hlwb hauv cov lus sib dhos.

Tam sim no, txhawm rau los sib piv cov txiaj ntsig ntawm kab ntawv "Lus Teb" thiab "Nkag Mus Nkag", peb yuav tsum siv txoj haujlwm "IF" hauv kab "Matches". Peb yuav mus rau ntawm kab xov tooj sib piv hauv kem “Qhov Tseem Ceeb” thiab nkag mus rau lub luag haujlwm ntawm cov ntsiab lus no “= IF (kev sib koom tes ntawm kem“ Cov Lus Teb ”= cov haujlwm ntawm kem“ Nkag mus ”; 1; 0). B3 = A3; 1; 0) ". Peb ua txoj haujlwm zoo sib xws rau txhua lub hlwb hauv kem Matches, tshwj tsis yog rau tagnrho Cell.

Tom qab ntawv xaiv tag nrho cov kem hauv kem "Txoj Haujlwm", suav nrog "Tag Nrho" ntawm tes, thiab nyem rau ntawm lub cim pib-txuas ntawm tus xov.

Tam sim no, ntawm daim ntawv no, qhov tseeb ntawm cov lus sib dhos daws teeb meem yuav raug tshuaj xyuas, thiab cov txiaj ntsig ntawm cov lus teb kom raug yuav tshwm sim ua tag nrho cov qhab nia. Hauv peb qhov xwm txheej, yog tias qhov sib cav sib cav tau daws tau tag, tom qab tus lej 9 yuav tsum tshwm nyob rau hauv lub cell sum, vim tias tag nrho cov lus nug yog sib npaug nrog tus lej no.

Yog li qhov txiaj ntsig ntawm txoj kev daws teeb meem tuaj yeem pom tsis yog rau ntawm daim ntawv zais, tab sis kuj tseem rau tus neeg uas tab tom daws teeb meem sib cav sib ceg, koj tuaj yeem rov qab siv "IF" haujlwm. Txav mus rau daim ntawv muaj cov ntawv sau ua si. Peb xaiv lub xovtooj ntawm, thiab nkag mus rau tus nqi muaj raws li tus qauv no: "= IF (Sheet2! Cell ua haujlwm nrog tag nrho cov qhab nia = 9;" Crossword daws tau ";" Xav rov xav dua ")." Hauv peb li, tus qauv zoo li no: "= IF (Sheet2! C12 = 9;" Crossword puzzle daws ";" Xav rov xav ")."

Yog li, qhov crossword puzzle hauv Microsoft Excel yog npaj tiav. Raws li koj tuaj yeem pom, hauv daim ntawv thov no koj tuaj yeem tsis tau tsuas yog ua kom muaj kev sib cav sai sai, tab sis kuj tsim qhov kev ntsuas tsis siv neeg hauv nws.

Pin
Send
Share
Send