txheem
Cov ntawv kho mob Excel yog tsim los ua cov ntaub ntawv arrays nthuav tawm hauv daim ntawv ntawm ntau yam txiaj ntsig. Ib qho ntawm feem ntau hom kev ua li no yog kev luam. Piv txwv li, yog tias muaj qee qhov pib cov ntaub ntawv array, thiab koj yuav tsum ua qee qhov kev suav uas xav tau cov kab ntxiv lossis kab, nws tsis yog ib txwm yooj yim ntxiv rau lawv ncaj qha rau lub rooj qub. Nws kuj yuav tsum tau siv rau lwm lub hom phiaj. Yog li ntawd, qhov kev daws teeb meem tsim nyog yuav yog luam tag nrho lossis ib feem ntawm cov ntaub ntawv rau hauv daim ntawv tshiab lossis cov ntaub ntawv, thiab ua txhua qhov kev hloov pauv nrog cov ntawv luam. Ua li no, cov ntaub ntawv qub yuav nyob twj ywm untouched. Qhov no tuaj yeem ua tau li cas?
Yooj yim luam yam tsis muaj kev hloov pauv
Txoj kev no yog qhov yooj yim tshaj plaws rau kev siv, nws yog qhov yooj yim yog tias lub ntsiab lus muaj cov ntaub ntawv yooj yim yam tsis muaj cov qauv thiab cov kev sib txuas.
Ua tib zoo mloog! Kev luam yooj yim tsis hloov dab tsi hauv cov ntaub ntawv qub.
Yog tias cov ntaub ntawv muaj cov qauv, lawv yuav raug theej nrog rau lwm cov ntaub ntawv, thiab koj yuav tsum tau ceev faj ntawm no - thaum luam cov txheeb ze txuas, lawv pib xa mus rau cov hlwb sib txawv uas cov ntaub ntawv tsis raug. Yog li ntawd, tsuas yog luam cov ntaub ntawv nrog cov qauv tsuas yog qhov zoo dua thaum tag nrho cov qauv siv cov ntaub ntawv tau theej tib lub sijhawm. Txoj kev no suav nrog cov kauj ruam hauv qab no.
- Cell xaiv. Raws li txoj cai, txawm hais tias muaj ntau lub hlwb nrog rau sab laug nas khawm, lossis cov keyboard shortcut "Shift + xub" yog siv. Raws li qhov tshwm sim, qee lub hlwb ntawm daim ntawv tau piav qhia nrog lub thav duab dub, thiab lawv tau ntxiv nrog cov xim tsaus nti.
- Luam rau ntawv teev cia. Cov ntawv teev cia yog thaj chaw tshwj xeeb hauv lub computer lub cim xeeb tsim los hloov cov ntaub ntawv hauv ib daim ntawv thov lossis nruab nrab ntawm daim ntawv thov. Luam rau nws yog ua si los ntawm nias lub "Ctrl + C" lossis "Ctrl + Ntxig" (cov kev sib txuas no sib npaug). Nws kuj tseem tuaj yeem siv tau los ntawm cov khoom sib thooj ntawm cov ntawv qhia zaub mov lossis siv qhov program ribbon.
- Qhia qhov chaw rau ntxig. Peb txav mus rau qhov chaw uas peb xav luam cov ntaub ntawv, thiab qhia nrog tus cursor lub xov tooj ntawm tes uas yuav yog sab laug ntawm tes ntawm cov ntaub ntawv yuav tsum tau muab tso rau. Ceev faj yog tias qhov taw tes ntxig twb muaj qee cov ntaub ntawv. Lawv tuaj yeem raug tshem tawm.
- Muab cov ntsiab lus ntawm cov ntawv teev cia rau hauv thaj chaw uas tau teev tseg. Qhov no yog ua tiav nrog cov yuam sij "Ctrl + V" lossis "Shift + Insert" lossis cov khoom sib txuas ntawm cov ntawv qhia zaub mov lossis cov phiaj xwm ribbon.
Yog xav tau qhov tseem ceeb xwb
Feem ntau, cov ntaub ntawv hauv hlwb yog qhov tshwm sim ntawm kev suav uas siv cov ntaub ntawv xa mus rau cov hlwb uas nyob ib sab. Thaum tsuas yog luam cov hlwb, nws yuav ua tiav nrog rau cov qauv, thiab qhov no yuav hloov cov txiaj ntsig xav tau.
Hauv qhov no, tsuas yog cov txiaj ntsig ntawm tes yuav tsum tau theej. Raws li nyob rau hauv lub dhau los version, qhov xav tau ntau yam yog thawj zaug xaiv, tab sis kom luam rau hauv daim ntawv teev lus, peb siv cov "paste xaiv" cov ntsiab lus cov ntawv qhia zaub mov, "tus nqi nkaus xwb" sub-khoom. Koj tuaj yeem siv cov pab pawg sib tham hauv qhov program ribbon. Tus so ntawm cov kauj ruam rau pasting cov ntaub ntawv theej tseem zoo li qub. Yog li ntawd, tsuas yog cov txiaj ntsig ntawm lub hlwb yuav tsum tau tshwm sim hauv qhov chaw tshiab.
Tseem ceeb! Cov qauv thiab cov qauv tsis tau txais kev cawmdim li no.
Qhov no tuaj yeem yog ob qho yooj yim thiab kev cuam tshuam, nyob ntawm qhov xwm txheej. Feem ntau, formatting (tshwj xeeb yog complex) yuav tsum tau sab laug. Hauv qhov no, koj tuaj yeem siv txoj hauv qab no.
Thaum koj xav tau ob qho tseem ceeb thiab cov qauv
Kev xaiv ntawm cov hlwb rau txoj kev theej no tseem zoo ib yam, tab sis nws yog ua los ntawm kev siv cov ntawv qhia zaub mov (Paste Special item) lossis siv qhov program ribbon. Los ntawm txhaj rau ntawm Paste Tshwj Xeeb icon nws tus kheej, koj tuaj yeem qhib tag nrho lub thawv sib tham uas muab kev xaiv ntau dua, thiab koj tuaj yeem muab cov ntaub ntawv siv ua haujlwm. Piv txwv li, koj tuaj yeem tsis tsuas yog ntxig cov ntaub ntawv xa mus rau hauv cov hlwb uas tau teev tseg, tab sis ntxiv rau cov uas twb muaj nyob hauv daim ntawv. Qee zaum qhov no yooj yim heev.
Nws kuj tseem tshwm sim tias lub rooj muaj ntau ntau kab ntawm qhov dav sib txawv, thiab tom qab luam tawm qhov tseem ceeb, ntau qhov kev mob siab ua haujlwm yuav tsum tau teeb tsa qhov xav tau dav. Hauv qhov no, "Paste Special" dialog muaj cov khoom tshwj xeeb "Kem Dav". Insertion yog ua nyob rau hauv ob theem. Muab tshuaj txhuam tsuas yog "kem dav" ua ntej rau "npaj chaw" thiab tom qab ntawd luam cov nqi. Lub rooj yog tib yam li tus thawj, tab sis tsis yog cov qauv, nws muaj qhov tseem ceeb. Qee lub sij hawm nws yooj yim rau luam tawm tsuas yog qhov dav ntawm txhua kab kom lub rooj zoo li tus thawj, thiab nkag mus rau qhov tseem ceeb hauv cov hlwb manually. Tsis tas li ntawd, koj tuaj yeem xaiv cov khoom "daim ntawv theej thaum tswj qhov dav ntawm kab" hauv cov ntawv qhia zaub mov. Yog li ntawd, qhov kev ntxig yuav ua tiav hauv ib kauj ruam.
Luam raws li tus qauv
Qee lub sij hawm, nws yuav tsum tau luam ib feem ntawm lub rooj kom tom qab ntawd nws tuaj yeem tig thiab ntsuas yam tsis muaj kev hloov pauv, tsis muaj kev cuam tshuam rau lwm qhov chaw ntawm lub rooj. Nyob rau hauv cov ntaub ntawv no, nws yog tsim nyog los luam cov ntaub ntawv nyob rau hauv daim ntawv ntawm ib tug tsis tu ncua daim duab.
Cov kauj ruam rau kev theej rau daim ntawv teev cia yog tib yam li cov kev xaiv yav dhau los, tab sis rau pasting, cov khoom "Daim duab" hauv "Paste Special" zaub mov yog siv. Txoj kev no tsis tshua siv vim tias cov ntaub ntawv hauv hlwb tau theej los ntawm txoj kev no tsis tuaj yeem hloov pauv los ntawm kev nkag mus rau qhov tseem ceeb.
Daim ntawv luam ntawm tag nrho daim ntawv
Qee zaum koj yuav tsum luam ib daim ntawv tag nrho thiab muab tso rau hauv tib daim ntawv lossis rau lwm qhov. Hauv qhov no, koj yuav tsum hu rau cov ntawv qhia zaub mov ntawm daim ntawv npe nyob rau sab laug sab ntawm qhov program thiab xaiv cov khoom "tsav lossis theej".
Ib lub vaj huam sib luag qhib nyob rau hauv uas cov txheej txheem luam tau teeb tsa. Tshwj xeeb, koj tuaj yeem hais qhia nyob rau hauv phau ntawv twg koj xav tau ntxig ib daim ntawv tshiab, txav nws lossis luam nws, thiab qhia qhov chaw ntawm cov ntawv uas twb muaj lawm uas yuav hloov mus. Tom qab nyem rau ntawm lub pob "OK", ib daim ntawv tshiab yuav tshwm sim hauv phau ntawv teev tseg nrog tag nrho cov ntsiab lus ntawm daim ntawv theej.
xaus
Kev theej yog ib qho kev thov ntau tshaj plaws hauv Excel. Rau cov ntxhuav yooj yim tsis muaj cov qauv, thawj txoj kev yog qhov yooj yim tshaj plaws, thiab rau cov ntxhuav uas muaj ntau cov qauv thiab cov kev sib txuas, feem ntau nws yog qhov zoo dua los siv txoj kev thib ob - luam tawm cov nqi xwb. Lwm txoj kev siv tsawg dua.