Qee cov dej num tau ua hauv cov ntxhuav xav tau kev txhim kho ntawm ntau yam duab lossis cov duab hauv lawv. Excel muaj cov cuab yeej uas tso cai rau koj los ua ib qho zoo li no. Cia peb xav paub seb yuav ua li cas.
Daim duab Ntxig Ntaus
Yuav kom ntxig tus duab rau hauv Excel rooj, nws yuav tsum xub muab mus rau qhov nyuaj disk ntawm lub computer los yog tshem tau nruab nrab txuas rau nws. Ib qho tseem ceeb ntawm kev siv cov duab yog tias yog vim nws tsis yog khi rau ntawm ib lub xov tooj ntawm tes, tab sis tsuas yog muab tso rau hauv cheeb tsam xaiv ntawm daim ntawv.
Tshooj: Yuav ua li cas mus tau ntxig ib daim duab hauv Microsoft Word
Ntxig duab ntawm daim ntawv
Ua ntej, peb yuav paub tias yuav ua li cas rau hauv daim duab rau ntawm ib daim ntawv, thiab tsuas yog tom qab ntawd peb yuav txiav txim seb yuav muab ib daim duab rau ib hom xovtooj twg.
- Xaiv lub xov tooj ntawm tes uas koj xav tau ntxig rau daim duab. Mus rau lub tab "Ntxig". Ndliv lub khawm "Teeb duab"uas yog nyob hauv qhov chaw thaiv "Cov Ntawv Qhia".
- Cov duab qhov rais qhib opens. Yog vim, nws yeej qhib nyob rau hauv daim nplaub tshev. "Cov duab". Yog li, koj tuaj yeem xa mus rau nws daim duab uas koj tab tom ntxig rau. Thiab koj tuaj yeem ua lwm txoj hauv kev: los ntawm qhov interface ntawm tib lub qhov rai, mus rau lwm phau ntawv ntawm lub hard disk ntawm lub PC los yog cov xov xwm txuas nrog rau nws. Tom qab koj tau xaiv cov duab koj yuav ntxiv rau Excel, nias ntawm lub pob Muab tshuaj txhuam.
Tom qab ntawd, daim duab no tso rau ntawm daim ntawv. Tab sis, raws li hais dhau los, nws tsuas yog lus dag rau ntawm daim ntawv thiab tsis txuas nrog cov zoo siv ntawm tes.
Image editing
Tam sim no koj yuav tsum hloov daim duab, muab nws tsim kom zoo thiab qhov loj.
- Nyem ntawm daim duab nrog txoj kev nas khawm. Cov duab kos yog qhib rau hauv cov ntawv qhia zaub mov. Nias ntawm yam khoom "Qhov loj me thiab lub zog".
- Lub qhov rais qhib nyob rau hauv uas muaj ntau cov cuab yeej rau kev hloov cov khoom ntawm daim duab. Ntawm no koj tuaj yeem hloov nws qhov loj, xim, tshib, ntxiv cov teebmeem thiab ua ntau ntxiv. Txhua yam nws yog nyob ntawm cov duab tshwj xeeb thiab lub hom phiaj uas nws siv.
- Tab sis feem ntau tsis tas yuav qhib qhov rais. "Qhov ntev thiab cov khoom", raws li muaj cov cuab yeej txaus uas muaj nyob rau hauv daim ntawv sau rau hauv qhov thaiv ntxiv ntawm tabs "Ua hauj lwm nrog cov duab".
- Yog tias peb xav muab qhov duab rau hauv ib lub xovtooj, ces qhov tseem ceeb tshaj plaws yog thaum kho ib daim duab yog hloov nws qhov loj kom lawv tsis loj dua qhov loj ntawm tus xovtooj ntawm nws tus kheej. Koj tuaj yeem tsim kho dua tshiab hauv qab no:
- los ntawm cov ntawv qhia zaub mov;
- vaj huam sib luag rau ntawm daim kab xev;
- qhov rais "Qhov ntev thiab cov khoom";
- dragging tus ciam teb ntawm daim duab nrog nas.
Ntxig rau duab
Tab sis, txawm tias tom qab daim duab los ua me dua tus xov tooj ntawm tes thiab muab tso rau hauv nws, nws tseem tseem tsis tau koom ua ke. Qhov ntawd yog, yog tias peb, piv txwv, ua qhov kev faib tawm lossis lwm hom ntaub ntawv hais, lub hlwb yuav hloov chaw, thiab daim duab yuav nyob rau tib qhov chaw hauv daim ntawv. Tab sis, hauv Excel, kuj tseem muaj qee txoj hauv kev xa ib daim duab. Xav txog lawv ntxiv.
Method 1: daim ntawv tiv thaiv
Ib txoj hauv kev xa ib daim duab yog los tiv thaiv daim ntawv tawm tsam kev hloov.
- Kho qhov loj ntawm daim duab mus rau qhov loj ntawm lub xov tooj ntawm tes thiab ntxig nws muaj, raws li tau piav saum toj no.
- Nyem ntawm daim duab thiab xaiv cov khoom hauv cov ntawv qhia zaub mov "Qhov loj me thiab lub zog".
- Daim duab lub qhov rai qhib opens. Hauv tab "Qhov Coj" nco ntsoov tias qhov loj ntawm daim duab tsis loj dua qhov loj ntawm lub xovtooj ntawm. Kuaj xyuas kom rov qab qhia tau "Txheeb rau thawj tus me nyuam" thiab "Txuag proportions" Muaj ticks. Yog tias muaj qhov ntsuas tsis ua raws li cov lus piav qhia saum toj no, ces hloov nws.
- Mus rau lub tab "Cov khoom" tib lub qhov rai. Teem cov checkboxes nyob rau hauv pem hauv ntej tsis "Cov khoom tiv thaiv" thiab "Sau ntawv"yog tias lawv tsis tau ntsia. Muab tus tes hloov hauv cov chaw thaiv "Binding an object rau tom qab" nyob hauv txoj hauj lwm "Tsiv thiab hloov ib qho khoom nrog hlwb". Thaum twg tag nrho cov chaw teev lus teev cia, ua rau ntawm lub pob. "Kaw"nyob rau hauv qis txoj cai kaum ntawm lub qhov rais.
- Xaiv tag nrho daim ntawv los ntawm nias lub khawm shortcut Ctrl + A, thiab mus raws li lub ntsiab lus teb hauv cov xovtooj ntawm hom kev lag luam.
- Hauv tab "Kev Tiv Thaiv" lub qhov rai qhib tshem tawm ntawm daim tshev tawm ntawm qhov parameter "Kev tiv thaiv cell" thiab nyem rau ntawm lub pob "OK".
- Xaiv lub xov tooj ntawm tes uas daim duab yuav tsum tau kho. Qhib cov hom ntawv qhov rai hauv lub tab "Kev Tiv Thaiv" zuam qhov nqi "Kev tiv thaiv cell". Ndliv lub khawm "OK".
- Hauv tab "Kev Tshawb Xyuas" nyob rau hauv lub block ntawm cov cuab yeej "Hloov" nyob rau hauv daim kab xev nyem rau ntawm lub pob "Tiv thaiv daim ntawv".
- Lub qhov rais qhib ntawm qhov uas peb nkag mus rau hauv qhov password kom thiaj tiv thaiv tau daim ntawv. Peb nias lub khawm "OK", thiab nyob rau hauv lub qhov rais ntxiv uas qhib, peb rov qab nkag tus password dua.
Tom qab cov kev ua no, cov sijhawm uas cov duab nyob hauv yog kev tiv thaiv ntawm kev hloov, uas yog, cov duab raug khi rau lawv. Tsis muaj dab tsi hloov hauv cov hlwb no kom txog thaum tiv thaiv raug tshem tawm. Hauv lwm qhov ntawm daim ntawv, raws li ua ntej, koj tuaj yeem hloov tau thiab txuag tau lawv. Nyob rau tib lub sijhawm, tamsim no txawm tias koj txiav txim siab los txheeb cov ntaub ntawv, daim duab tsis mus qhov twg nrog lub xov tooj ntawm tes uas nws nyob.
Tshooj: Yuav ua li cas tiv thaiv lub xovtooj ntawm kev hloov hauv Excel
Txoj kev 2: ntxig tus duab rau hauv ib daim ntawv
Koj tuaj yeem xa ib daim duab los ntawm kev muab tso rau hauv ntawv.
- Peb nyem rau ntawm tes uas peb npaj los ntxig cov duab, nrog rau txoj kev nas khawm. Hauv cov ntawv qhia zaub mov, xaiv cov khoom "Sau Kom Zoo".
- Lub qhov rais qhib me me, tau tsim los sau cov ntawv. Tshem tus cursor rau nws ciam teb thiab nias rau nws. Lwm cov ntsiab lus teb ntsiab lus tshwm. Xaiv cov khoom hauv nws "Nco ntsoov hom ntawv".
- Nyob rau hauv lub qhib hom ntawm sau ntawv, mus rau tab "Xim thiab cov kab". Nyob hauv lub thawv ntawv "Sau" nyem rau ntawm daim teb "Xim". Nyob rau hauv daim ntawv teev lus qhib, pib ntawm lub sij hawm. "Sau ntawv ...".
- Tus sau hom qhib qhov rai. Mus rau lub tab "Teeb duab"thiab nias rau ntawm lub khawm nrog tib lub npe.
- Qhov ntxiv qhov rais qhib opens, raws nraim tib yam li tau piav saum toj no. Xaiv cov duab thiab nyem rau ntawm lub pob Muab tshuaj txhuam.
- Duab ntxiv rau qhov rais "Sau". Teem ib lub zuam ntawm xub ntiag ntawm qhov khoom "Khaws cov feem ntawm daim duab". Peb nias lub khawm "OK".
- Tom qab qhov no, peb rov qab mus rau lub qhov rais "Nco ntsoov hom ntawv". Mus rau lub tab "Kev Tiv Thaiv". Tshem tawm cov tshev ntawm qhov parameter "Cov khoom tiv thaiv".
- Mus rau lub tab "Cov khoom". Teem tus tes hloov mus rau txoj haujlwm "Tsiv thiab hloov ib qho khoom nrog hlwb". Nram qab no, nyem rau ntawm lub pob "OK".
Tom qab ua tiav tag nrho cov saum toj no, cov duab yuav tsis tsuas muab tso rau hauv xov tooj ntawm tes, tab sis kuj txuas rau nws. Ntawm chav kawm, qhov no yog tsis haum rau txhua leej txhua tus, raws li qhov muab tso rau hauv ib daim ntawv imposes ib txhia kev txwv.
Method 3: Tsim Hom
Koj tuaj yeem xa dluab mus rau ib lub xovtooj los ntawm tus tsim tawm hom. Qhov teeb meem yog tias los ntawm qhov kev tsim tawm hom tsis tau qhib. Li ntawd, thawj ntawm tag nrho cov, peb yuav tsum tau pab kom nws.
- Nyob hauv tab "Cov Ntaub Ntawv" mus rau seem "Kev xaiv".
- Hauv qhov tsis muaj qhov rai, txav mus rau seem Ribbon teeb. Teem ib tus zuam ze rau yam khoom ntawd "Tsim tawm" ntawm sab xis ntawm lub qhov rais. Peb nias lub khawm "OK".
- Xaiv cov xov tooj ntawm tes uas peb npaj los ntxig rau daim duab. Txav mus rau tab "Tsim tawm". Nws tshwm sim tom qab peb tau qhib qhov sib thooj. Ndliv lub khawm Muab tshuaj txhuam. Nyob rau hauv cov ntawv qhia zaub mov uas qhib hauv kev thaiv "ActiveX Elements" xaiv ib yam khoom "Duab".
- Lub ActiveX tswj tshwm li ib qho plaub quad. Kho nws qhov ntev los ntawm kev ciav ciam teb thiab muab tso rau hauv lub xov tooj ntawm tes uas koj npaj siab tso tus duab. Peb nias lub pob nyem khawm ntawm lub caij. Hauv cov ntawv qhia zaub mov, xaiv cov khoom "Cov khoom".
- Cov khoom ntiag tug qhib qhov rai. Yam tsis txawv "Kev Tso Kawm" teeb tus naj npawb "1" (yog vim "2"). Nyob hauv txoj hlua parameter "Duab" Ndliv lub khawm, uas pom cov dots.
- Cov duab qhov rais qhib opens. Peb tab tom nrhiav cov duab yam ntxim saib ntxim ua, xaiv nws thiab nyem rau ntawm lub pob. "Qhib".
- Tom qab ntawd, koj tuaj yeem kaw cov khoom qhov rai. Raws li koj tau pom, daim duab no twb tso lawm. Tam sim no peb xav kom khi nws mus rau ntawm tes. Xaiv cov duab thiab mus rau lub tab "Nplooj Layout". Nyob hauv lub thawv ntawv "Tsi" nyob rau hauv daim kab xev nyem rau ntawm lub pob "Dlhos". Ntawm daim ntawv qhia zaub mov nco, xaiv qhov khoom "Snap rau daim phiaj". Tom qab ntawd txauv me ntsis ntawm daim duab.
Tom qab ua cov yeeb yam saum toj no, daim duab yuav tsum muab khi rau kab sib chaws thiab xaiv lub xov tooj.
Raws li koj pom, hauv qhov kev pabcuam Excel muaj ntau txoj kev los ntxig tus duab rau hauv lub xovtooj thiab khi rau nws. Ntawm chav kawm, txoj kev nrog cov ntxig rau hauv daim ntawv no tsis haum rau tag nrho cov neeg siv. Tab sis qhov ob qho kev xaiv yeej muaj ntau yam, thiab txhua tus yuav tsum txiav txim siab rau nws tus kheej ib qho yooj yim dua rau nws thiab feem ntau zoo sib xws ntawm cov hom phiaj ntawm qhov ntxig.
