Yuav ua li cas theej lub rooj los ntawm Excel nyob rau hauv Excel

Rau cov neeg siv zoo tshaj plaws, cov txheej txheem ntawm cov ntawv luam tsis yog qhov nyuaj. Tab sis, tsis yog txhua tus paub qee qhov nuances uas tso cai rau koj kom ua cov txheej txheem no ua tau rau cov ntaub ntawv sib txawv ntawm cov ntaub ntawv thiab ntau hom phiaj. Cia peb xav txog kom meej txog qee cov qauv luam tawm cov ntaub ntawv hauv kev ua haujlwm Excel.

Luam mus rau Excele

Luam tawm lub rooj nyob rau hauv Excel yog kev tsim nws duplicate. Nyob rau hauv cov txheej txheem heev, muaj cov kev sib txawv raws qhov chaw uas koj yuav tso cov ntaub ntawv: mus rau lwm daim ntawv, ntawm daim ntawv tshiab lossis lwm phau ntawv (ua ntawv). Qhov tseem ceeb sib txawv ntawm kev luam tawm yog li cas koj xav kom luam cov ntaub ntawv: ua ke nrog cov qauv lossis tsuas yog nrog cov ntaub ntawv tso tawm.

Zaj Lus Qhia: Luam cov ntxhuav hauv Mirosoft Word

Txoj Kev 1: Luam Ntawv Vim Li Cas

Yooj yim luam los ntawm kev ua kom zoo tshaj cuam tshuam nrog kev tsim ib daim qauv ntawm lub rooj ua ke nrog txhua tus qauv tso rau hauv nws thiab kev ntaus ntawv.

Peb qhia txog thaj chaw uas peb xav kom luam. Nyem rau ntawm qhov chaw faib nrog tus nas nas khawm. Cov ntawv qhia zaub mov tshwm sim. Xaiv nws hauv nws "Luam".

Muaj lwm txoj kev xaiv rau ua cov kauj ruam no. Thawj zaug ntawm lawv muaj nias cov keyboard ntawm Ctrl + C yuam sij tom qab xaiv thaj chaw. Qhov kev xaiv thib ob cuam tshuam nrog nias "MUAB" khawm, uas yog nyob ntawm daim kab xev hauv "Lub Tsev" tab hauv "Toolbu.

Luam cov ntaub ntawv rau Microsoft Excel

Qhib thaj chaw uas peb xav tau ntxig cov ntaub ntawv. Nws tuaj yeem yog daim ntawv tshiab, lwm cov ntaub ntawv Excel lossis lwm thaj chaw ntawm cov hlwb nyob rau tib daim ntawv. Nyem rau ntawm lub xov tooj ntawm tes uas yuav tsum yog lub sab laug sab sauv ntxig rooj. Nyob rau hauv cov ntsiab lus qhia zaub mov nyob rau hauv cov ntxig rau, xaiv "muab tshuaj txhuam".

Tseem muaj cov kev xaiv lwm txoj kev xaiv. Koj tuaj yeem hais txog CTRL + V Keyboard ntawm cov keyboard. Ib qho ntxiv, koj tuaj yeem nyem rau ntawm "khawm" khawm, uas nyob rau sab laug ntawm daim kab xev ntawm daim kab xev ib sab ntawm "IP" khawm.

Ntxig cov ntaub ntawv hauv Microsoft Excel

Tom qab hais tias, cov ntaub ntawv ntxig yuav ua thaum khaws cia formatting thiab qauv.

Cov ntaub ntawv tau muab tso rau hauv Microsoft Excel

Txoj Kev 2: Luam Tawm Cov Nqi

Txoj kev thib ob muab rau kev luam tshwj xeeb cov lus muaj nuj nqis uas tau tshwm sim ntawm lub vijtsam, thiab tsis yog qauv.

Luam cov ntaub ntawv nyob rau hauv ib txoj kev piav qhia saum toj no.
Los ntawm txhaj rau sab xis nas khawm nyob rau hauv qhov chaw uas koj yuav tsum tau sau cov ntaub ntawv. Nyob rau hauv cov ntsiab lus qhia zaub mov nyob rau hauv cov ntxig tsis muaj, xaiv cov "qhov tseem ceeb" khoom.

Ntxig qhov tseem ceeb hauv Microsoft Excel

Tom qab hais tias, lub rooj yuav muab ntxiv rau daim ntawv yam tsis tau khaws cov qauv thiab qauv. Ntawd yog, tsuas yog cov ntaub ntawv tso tawm ntawm qhov screen yuav theej.

Qhov tseem ceeb yog muab tso rau hauv Microsoft Excel

Yog tias koj xav theej cov nqi, tab sis tib lub sijhawm txuag thawj lub tswv yim, ces koj yuav tsum tau mus rau cov ntawv qhia zaub mov "tshwj xeeb ntxig" thaum ntxig. Muaj, hauv "Qhov tseem ceeb" thaiv, koj yuav tsum tau xaiv "qhov tseem ceeb thiab thawj hom kev ua yeeb yam".

Tso cov nqi ntawm kev khaws cia ntawm kev ua haujlwm hauv Microsoft Excel

Tom qab hais tias, lub rooj yuav raug nthuav tawm hauv daim ntawv pib, tab sis tsuas yog hloov cov qauv ntawm lub xovtooj ntawm lub cell yuav sau qhov tseem ceeb.

Formatting qhov tseem ceeb yog muab tso rau Microsoft Excel

Yog tias koj xav ua kev ua haujlwm no tsuas yog ua haujlwm nkaus xwb ntawm kev tawm tswv yim ntawm cov lej, thiab tsis yog tag nrho cov lus tshwj xeeb uas koj xav tau xaiv cov khoom "cov txiaj ntsig ntawm cov lej".

Tso cov nqi uas muaj cov lej hauv Microsoft Excel

Txoj Kev 3: Tsim ib daim ntawv thaum txuag txhua kem dav

Tab sis, hmoov tsis, txawm tias siv cov kev ua qauv siv uas tsis tso cai rau koj kom luam cov ntawv ntawm lub rooj nrog kem thawj qhov dav. Qhov ntawd yog, feem ntau muaj cov xwm txheej thaum cov ntaub ntawv tsis muab tso rau hauv cov hlwb tom qab ntxig. Tab sis nyob rau hauv Excel, nws yog qhov ua tau los tswj hwm tus thawj kem dav siv qee yam kev ua.

Luam lub rooj los ntawm ib txoj hauv kev li ib txwm.
Nyob rau hauv ib qho chaw uas koj yuav tsum tau nkag cov ntaub ntawv, hu rau cov ntsiab lus qhia zaub mov. Peb xwm yeem mus dhau ntawm cov khoom "tshwj xeeb ntxig" thiab "txuag qhov dav ntawm cov thawj."

Koj tuaj yeem tso npe rau lwm txoj kev. Los ntawm cov ntawv qhia zaub mov ob zaug mus rau cov khoom uas muaj tib lub npe "tshwj xeeb intrial ...".

Lub qhov rais qhib. Hauv "ntxig" toolbar, peb rov txuas qhov hloov mus rau txoj hauj lwm "kab dav". Nyem rau ntawm "OK" khawm.

Cov ntxig tshwj xeeb hauv Microsoft Excel

Txawm li cas los xij txoj kev uas koj xaiv los ntawm ob txoj kev xaiv saum toj no, nyob rau hauv txhua rooj plaub no, daim ntawv luam tawm yuav muaj tib kem dav raws li qhov chaw.

Lub rooj yog muab tso nrog thawj qhov dav ntawm cov kab hauv Microsoft Excel

Txoj kev 4: ntxig ua duab

Muaj qee zaum thaum lub rooj yuav tsum tau muab tso rau tsis nyob hauv hom ib txwm, tab sis raws li cov duab. Txoj haujlwm no tseem daws tau siv cov ntawv tshwj xeeb tshwj xeeb.

Ua kom luam tawm cov yam xav tau.
Xaiv ib qho chaw rau ntxig thiab hu rau cov ntsiab lus teb. Mus rau yam khoom "tshwj xeeb nkag". Hauv "lwm cov chaw ntxig" thaiv, xaiv cov "Daim Duab".

Ntxig raws li cov duab hauv Microsoft Excel

Tom qab ntawd, cov ntaub ntawv yuav muab tso rau ntawm daim ntawv ua duab. Lawm, nws yuav tsis yooj yim sua kom hloov xws li lub rooj.

Cov duab rooj yog tso rau hauv Microsoft Excel

Txoj Kev 5: Luam Luam Ntawv

Yog tias koj xav theej tawm tag nrho cov lus ntawm lwm daim ntawv, tab sis tib lub sijhawm txuag nws tau txais qhov tseeb kiag li, nws yog qhov zoo tshaj plaws los luam tag nrho cov ntawv. Hauv qhov no, nws yog ib qho tseem ceeb kom txiav txim siab tias koj yeej xav hloov txhua yam uas yog nyob rau ntawm daim ntawv, txwv tsis pub cov qauv no yuav tsis haum.

Txhawm rau manually mainually faib tag nrho cov hlwb ntawm daim ntawv, thiab qhov no yuav siv sijhawm ntau, nyem rau ntawm plaub kab sib dhos ntawm cov kab rov tav thiab cov kab ke ntsug. Tom qab ntawd, tag nrho cov ntawv yuav qhia txog. Txhawm rau luam cov ntsiab lus, hom Ctrl + C sib txuas ua ke ntawm cov keyboard.

Kev faib tag nrho cov ntawv hauv Microsoft Excel

Txhawm rau ntxig cov ntaub ntawv, qhib daim ntawv tshiab lossis phau ntawv tshiab (cov ntaub ntawv). Ib yam li ntawd, nyem rau ntawm cov duab plaub tso rau ntawm kev sib tshuam ntawm cov vaj huam sib luag. Txhawm rau ntxig cov ntaub ntawv, ntaus CTRL + V khawm sib xyaw.

Tso rau tag nrho cov ntawv hauv Microsoft Excel

Raws li koj tuaj yeem pom, tom qab ua cov yeeb yam no, peb tswj hwm los luam daim ntawv ua ke nrog lub rooj thiab cov txheej txheem. Nws muab tawm kom tau txais kev cawmdim tsis yog thawj hom ntawv, tab sis kuj yog qhov loj me ntawm cov hlwb.

Daim ntawv yog muab tso rau hauv Microsoft Excel

Cov Exel cov lus editor muaj cov khoom xa tuaj ntau los luam cov kab raws nraim li tus neeg siv yuav tsum tau ua. Hmoov tsis zoo, tsis yog txhua tus paub txog lub nuances ntawm kev ua haujlwm nrog rau cov ntawv luam tshwj xeeb thiab lwm cov ntawv luam nthuav dav rau cov ntaub ntawv hloov pauv, thiab siv tau cov neeg siv ua.