Hloov cov kev txiav txim ntawm cov hlwb feem ntau yuav tsum tau ua thaum hloov cov ntxhuav, formatting ntawv thiab tag nrho cov ntsiab lus ntawm ib daim ntawv hluav taws xob hauv Microsoft Excel tag nrho. Cov pib tshiab qee zaum muaj teeb meem nrog qhov teeb meem no, yog li hauv tsab xov xwm no peb yuav pab tshem tawm cov teeb meem no ntau txoj hauv kev.
Method XNUMX: copy
Txij li tsis muaj kev sib cais tshwj xeeb tsim los hloov cov hlwb ntawm ib feem ntawm daim ntawv mus rau lwm qhov, koj yuav tau siv lwm txoj hauv kev. Yog li thawj tus yog luam tawm. Ua ib kauj ruam raws li hauv qab no:
- Peb muaj lub rooj nrog cov ntaub ntawv khaws tseg. Los ntawm nws, koj yuav tsum tau hloov ntau lub hlwb mus rau ib feem ntawm daim ntawv. Txhawm rau ua qhov no, nyem rau ntawm ib qho ntawm lawv, tom qab ntawd hauv toolbar hauv "Tsev" tab peb pom tus nqi "Copy". Koj tuaj yeem xaiv lub xovtooj ntawm tes, nyem nyem thiab xaiv "Copy" los ntawm cov ntawv qhia zaub mov. Ib txoj hauv kev ceev kom luam cov ntaub ntawv yog ib txhij nias qhov tseem ceeb ua ke "Ctrl + UaC«.
- Xyuas seb tus nqi puas tau theej. Txhawm rau ua qhov no, mus rau "Clipboard". Nws yog nyob rau hauv lub "Tsev" tab nyob rau hauv thawj block. Peb nyem rau ntawm xub xub thiab nyob rau hauv lub qhov rais uas qhib rau sab laug peb pom cov ntawv los yog tus lej cia li theej. Qhov no txhais tau tias kev luam cov ntaub ntawv tau ua tiav.
Ua tib zoo mloog! Yog tias koj nyem "Tshem Tag Nrho", tom qab ntawv luam yuav tsum tau ua dua, vim tias cov ntaub ntawv yuav raug tshem tawm.
- Tam sim no ntawm daim ntawv peb xaiv qhov chaw uas peb xav txav cov ntsiab lus ntawm tes, nias qhov tseem ceeb ua ke "Ctrl + V" lossis hu rau cov ntawv qhia zaub mov uas siv RMB, uas peb nyem rau ntawm cov khoom "Ntxig". Koj tuaj yeem siv lub cuab yeej tshwj xeeb Tab, uas tso cai rau koj los kho qhov muab tso rau ntawm tus nqi theej.
- Ib yam li ntawd, tag nrho cov hlwb seem raug xa mus, yog tias tsim nyog. Txhawm rau hloov tag nrho cov lus tag nrho, koj yuav tsum xaiv tag nrho cov ntau yam. Tom qab tag nrho cov ntsiab lus tau raug xa mus, koj tuaj yeem tsim qhov qub ntawm daim ntawv, uas tseem muaj cov ntaub ntawv qub.
Txoj kev XNUMX: cell hloov
Txwv tsis pub nws yog hu ua luag thiab poob. Nws tsis yog qhov nyuaj rau kev ua nws, qhov tseem ceeb tshaj plaws yog kom paub tseeb tias tag nrho cov ntaub ntawv tau theej, txwv tsis pub kev hloov pauv yuav ua nrog distortion. Xav txog cov ntsiab lus hauv algorithm hauv qab no:
- Peb txav tus nas cursor hla ciam teb ntawm tes uas yuav tsum tau txav mus rau lwm qhov ntawm daim ntawv. Nco ntsoov tias tus cursor yuav tsum tig mus rau hauv ib lub cim ntoo khaub lig. Tom qab ntawd, tuav lub nas khawm thiab luag lub xovtooj mus rau qhov chaw xav tau.
- Koj tuaj yeem txav ib lub xovtooj ob peb kauj ruam nce lossis nqis. Txhawm rau ua qhov no, peb kuj xaiv lub xov tooj ntawm tes, txav mus rau qhov chaw zoo, thiab tom qab ntawd kho qhov kev txiav txim ntawm qhov seem seem uas tau hloov pauv vim qhov hloov pauv.
Nrog rau txoj kev no, cov hlwb raug xaiv txav mus rau lwm qhov chaw, thaum tag nrho cov ntsiab lus hauv lawv tau khaws cia, thiab cov chaw dhau los ua qhov khoob.
Txoj kev thib peb: siv macros
Qhov kev xaiv no tuaj yeem siv tau yog tias macros raug teeb tsa los ntawm lub neej ntawd hauv Excel, txwv tsis pub lawv yuav tsum tau ntxiv los ntawm kev teeb tsa sab hauv. Cia peb txheeb xyuas cov ntsiab lus ntawm txoj kev xaiv:
- Mus rau "Cov ntaub ntawv" ntawv qhia zaub mov, tom qab ntawv hauv qab ntawm daim ntawv, mus rau "Kev Xaiv" yam khoom.
- Lub qhov rais "Excel Options" qhib, ntawm no koj yuav tsum nyem rau ntawm "Customize Ribbon" yam khoom thiab kos lub thawv nyob ib sab ntawm cov khoom "Developer". Peb paub meej tias peb cov kev ua nrog lub pob "OK".
Tam sim ntawd them sai sai rau lub tab bar, ib lub tab hu ua "Developer yuav tsum tshwm sim thaum kawg.
- Tom qab peb hloov mus rau "Developer" tab, hauv nws peb pom "Visual Basic" cuab yeej. Visual Basic yog cov ntaub ntawv kho kom haum. Koj yuav tsum tau tos lub qhov rai ntxiv kom thauj khoom.
- Tom qab qhib qhov kev pabcuam pabcuam pabcuam, peb tab tom nrhiav rau "Code" cov cuab yeej thaiv, peb yuav xav tau nws rau kev kho kom raug. Peb pom cov seem "Saib Code", nyob rau hauv daim teb uas qhib, ntxig ib tug tshwj xeeb code, uas yog qhia hauv qab no:
Sub MoveCells()
Dim ra As Range: Set ra = Xaiv
msg1 = "Xaiv ob qhov ntau ntawm qhov loj tib yam"
msg2 = "Xaiv ob thaj tsam ntawm IDENTICAL loj"
Yog ra.Areas.Count <> 2 Ces MsgBox msg1, vbCritical, “Problem”: Exit Sub
If ra.Areas(1).Count <> ra.Areas(2).Count Then MsgBox msg2, vbCritical, "Problem": Exit Sub
Application.ScreenUpdating = False
arr2 = ra.Areas(2).Value
ra.Areas(2).Value = ra.Areas(1).Value
ra.Areas(1).Value = arr2
End Sub
- Tom ntej no, nias lub pob "Enter" kom txuag tau cov ntaub ntawv. Tom qab txuag, koj tuaj yeem kaw lub qhov rais editor thiab txuas ntxiv kho.
- Tuav tus yuam sij "Ctrl", tom qab ntawd xaiv tib tus lej ntawm kab thiab kab kom tau txais qhov sib txawv ntawm txhua sab. Tam sim no mus rau ntu "Macros" hauv toolbar, nyem rau ntawm nws, lub qhov rai uas muaj nuj nqi qhib. Nyem qhov "Execute" khawm.
- Qhov tshwm sim ntawm cov txheej txheem no yog kev hloov pauv ntawm qhov chaw ntawm cov cell hauv ib daim ntawv.
Ntawm ib daim ntawv! Nws muaj peev xwm hloov tau ib lub hlwb thiab lawv thaj tsam ntawm ib daim ntawv Excel mus rau lwm qhov, thiab tsuas yog ib daim ntawv ntau nplooj ntawv yog siv rau qhov no.
Yuav kom lub ntsiab
Rau cov pib tshiab, thawj ob txoj kev xaiv rau kev hloov cov hlwb yog qhov tsim nyog dua. Lawv tsis tas yuav muaj kev paub tob hauv Microsoft Excel thiab ua haujlwm sib txawv ntawm cov ntawv nthuav qhia. Raws li rau macros, kev siv cov txheej txheem no yog qhov nyuaj heev, nws yog ib qho tseem ceeb heev kom tsis txhob cuam tshuam dab tsi, txwv tsis pub muaj kev pheej hmoo siab ua yuam kev thiab ua tiav formatting tag nrho nplooj ntawv yam tsis tau rov qab cov ntaub ntawv, yog li nws pom zoo kom ceev faj heev. thaum hloov cov cell.