Rau feem ntau cov neeg siv Excel, txoj kev luam cov ntxhuav tsis yooj yim. Tab sis tsis yog txhua leej txhua tus paub ib co ntawm cov nuances uas ua qhov txheej txheem no kom zoo npaum li ntau tau rau ntau hom ntaub ntawv thiab ntau lub hom phiaj. Cia wb mus ze saib ntawm qee cov nta ntawm kev luam cov ntaub ntawv hauv Excel.
Luam nyob hauv Excel
Luam ib lub rooj rau Excel yog qhov tsim ntawm nws cov kev sib tw. Nyob hauv tus txheej txheem nws tus kheej, tsis muaj kev txawv txav nyob ntawm qhov chaw koj yuav nkag mus rau cov ntaub ntawv: nyob rau lwm qhov ntawm tib daim ntawv, ntawm ib daim ntawv tshiab lossis lwm phau ntawv (cov ntaub ntawv). Lub ntsiab qhov sib txawv ntawm txoj kev luam qauv yog li cas koj xav luam cov ntaub ntawv: nrog cov qauv los yog tsuas yog cov ntaub ntawv qhia tawm.
Tshooj: Luam cov ntxhuav hauv Mirosoft Lo Lus
Txoj kev cai 1: Luam los ntawm lub neej
Yooj yim luam los ntawm lub neej nyob hauv Excel muab tsim ib daim qauv ntawm lub rooj nrog rau tag nrho cov qauv thiab kev muab tso rau hauv.
- Xaiv lub cheeb tsam peb xav luam. Nias rau ntawm thaj chaw xaiv nrog rau txoj kev nas khawm. Ib lub ntsiab lus qhia zaub mov tshwm. Xaiv cov khoom hauv nws "Daim qauv".
Muaj lwm txoj hau kev xaiv ua cov kauj ruam no. Thawj yog mus nias tus keyboard shortcut rau ntawm tus keyboard. Ctrl + C tom qab xaiv qhov chaw ntawd. Qhov thib ob xaiv tau nias lub khawm. "Daim qauv"uas yog nyob rau ntawm txoj hlua hauv qhov tab "Tsev" nyob rau hauv ib pawg ntawm cov cuab yeej "Ntawv Teev Npe".
- Qhib qhov chaw uas peb xav sau cov ntaub ntawv. Qhov no yuav yog ib daim ntawv tshiab, lwm daim Excel, lossis lwm cheeb tsam ntawm cov hlwb nyob rau tib daim ntawv. Nias rau ntawm tes, uas yuav tsum yog sab saum toj ntawm lub xov tooj ntawm lub rooj nkag. Nyob rau hauv cov ntawv qhia zaub mov hauv cov lus xaiv, xaiv qhov "Insert".
Nws tseem muaj lwm cov kev xaiv rau kev nqis tes ua. Koj tuaj yeem xaiv ib lub xov tooj ntawm tes thiab nias ua ke ntawm cov keyboard Ctrl + V. Xwb, koj tuaj yeem nias ntawm khawm. Muab tshuaj txhuamuas yog nyob ntawm ntug kev sab laug ntawm daim kab xev tom ntej rau lub pob "Daim qauv".
Tom qab ntawd, cov ntaub ntawv yuav muab tso nrog thaum khaws cov qauv thiab cov qauv.
Txoj Cai 2: Luam Qhov Tseem Ceeb
Qhov thib ob txoj kev yuav luam tawm qhov tseem ceeb ntawm lub rooj uas muaj nyob rau ntawm qhov screen, thiab tsis yog cov qauv.
- Luam cov ntaub ntawv nyob rau hauv ib ntawm cov hauv kev piav qhia saum toj no.
- Nias lub pob nyem khawm ntawm qhov chaw uas koj xav tau ntxig cov ntaub ntawv. Nyob rau hauv cov ntawv qhia zaub mov hauv cov lus xaiv, xaiv cov khoom "Qhov tseem ceeb".
Tom qab ntawd, lub rooj yuav muab ntxiv rau daim ntawv tsis tas yuav txuag formatting thiab cov qauv. Ntawd yog, tsuas yog cov ntaub ntawv teev rau ntawm qhov screen xwb yuav theej.
Yog hais tias koj xav luam daim ntawv qhov tseem ceeb, tab sis khaws cov ntawv tseem ceeb, koj yuav tsum tau mus rau lub tshuab raj thaum lub sij hawm tso "Muab Tshuaj Rau Tshwj Xeeb". Muaj nyob rau hauv lub block "Ntxig rau qhov tseem ceeb" yuav tsum xaiv ib yam khoom "Qhov tseem ceeb thiab qub qauv".
Tom qab ntawd, lub rooj yuav nthuav tawm nyob rau hauv nws thawj daim ntawv, tab sis tsis muaj cov qauv, cov qoob loo yuav tsum ua qhov tseem ceeb.
Yog tias koj xav ua txoj hauj lwm no tsuas yog khaws cia cov zauv ntawm cov zauv, thiab tsis tag nrho cov lus, ces nyob rau hauv qhov tshwj xeeb ntxig koj yuav tsum xaiv yam khoom ntawd "Tus Nqi thiab Tus Naj Npawb Teeb Meem".
Method 3: Tsim ib daim qauv thaum tswj qhov dav ntawm txhua kab
Tab sis, hmoov tsis, txawm siv cov qauv ntawv tseem tsis tso cai ua ib daim qauv ntawm lub rooj nrog daim tseem dav ntawm txhua kab ntawv. Ntawd yog, feem ntau kuj muaj cov neeg mob thaum tom qab hnia cov ntaub ntawv tsis haum rau hauv lub hlwb. Tab sis nyob rau hauv Excel nws yog ua tau kom khaws thawj qhov dav ntawm txhua kab uas siv qee cov yeeb yam.
- Luam lub rooj hauv ib qho ntawm txoj kev niaj hnub.
- Nyob rau hauv qhov chaw uas koj xav tau kom ntxig cov ntaub ntawv, hu rau lub ntsiab lus teb lus qhia. Raws li peb mus tshaj lub ntsiab lus "Muab Tshuaj Rau Tshwj Xeeb" thiab "Txuag lub dav ntawm thawj kab".
Koj tuaj yeem ua lwm txoj kev. Los ntawm cov ntawv qhia zaub mov, mus rau qhov khoom nrog tib lub npe ob zaug. "Tshwj xeeb ntxig rau ...".
Lub qhov rais qhib. Hauv qhov "Insert" tool block, txav mus rau txoj haujlwm "Kem dav". Peb nias lub khawm "OK".
Ntaus twg yog qhov koj xaiv los ntawm cov kev xaiv saum toj saud, nyob rau hauv txhua rooj plaub, lub rooj ntawv theej yuav muaj qhov dav dav li qhov chaw.
Method 4: Ntxig li duab
Muaj qee zaum thaum lub rooj yuav tsum tau muab tso rau hauv tsis yog hom qauv, tab sis raws li tus duab. Qhov teeb meem no kuj daws tau nrog kev pab ntawm ib qho tshwj xeeb ntxig rau.
- Peb luam qhov ntau yam.
- Xaiv ib qho chaw ntxig rau thiab hu lub ntsiab lus teb lus qhia. Mus rau kis "Muab Tshuaj Rau Tshwj Xeeb". Hauv kev thaiv "Lwm qhov kev xaiv" xaiv ib yam khoom "Teeb duab".
Tom qab ntawd, cov ntaub ntawv yuav muab tso rau hauv daim ntawv ua tus duab. Lawm, nws yuav tsis tau hloov tej lub rooj.
Txoj kev 5: Daim Ntawv Txuas Lus
Yog tias koj xav luam daim ntawv tag nrho mus rau lwm daim ntawv, tab sis tib lub sij hawm cia nws zoo tib yam rau qhov chaws, ces qhov no, nws yog qhov zoo tshaj plaws los luam daim ntawv tag nrho. Hauv qhov no, nws yog ib qho tseem ceeb los txiav txim tias koj yeej xav hloov txhua yam uas yog nyob rau ntawm daim ntawv los, txwv tsis pub ua li no yuav tsis ua haujlwm.
- Hauv kev txiav txim siab tsis txhob xaiv txhua lub hlwb ntawm daim ntawv, uas yuav siv sij hawm ntau, nyem rau ntawm daim duab uas nyob nruab nrab ntawm txoj kab kev sib koom ua ke thiab kab ntsig. Tom qab ntawd, tag nrho cov nplooj ntawv yuav muaj kev ceeb toom. Los luam cov ntsiab lus, sau ua ke ntawm cov keyboard Ctrl + C.
- Mus sau cov ntaub ntawv, qhib ib daim ntawv tshiab los sis ib phau ntawv tshiab (cov ntaub ntawv). Zoo tib yam, nyem rau ntawm daim duab uas nyob ntawm qhov kev sib tshuam ntawm lub panels. Mus nkag rau cov ntaub ntawv, sau ua ke ntawm cov nyees khawm Ctrl + V.
Raws li koj tau pom, tom qab ua yeeb yam no, peb muaj peev xwm luam daim ntawv nrog lub rooj thiab tas nws cov ntsiab lus. Nyob rau tib lub sij hawm nws muab tawm los khaws cia tsis tsuas yog tus thawj formatting, tab sis kuj qhov loj ntawm lub hlwb.
Spreadsheet Editor Excel muaj cov cuab yeej kim heev rau kev luam cov ntxhuav raws nraim daim ntawv uas tus neeg siv. Hmoov tsis, tsis yog txhua leej txhua tus paub txog lub luag hauj lwm ntawm kev ua hauj lwm nrog cov khoom siv tshwj xeeb thiab lwm yam cuab yeej kev luam uas muaj peev xwm nthuav dav rau cov ntaub ntawv xa mus, nrog rau kev siv automate neeg ua.
