txheem
Thaum sau cov lus hauv Excel, feem ntau yuav tsum tau muab ib daim duab tso rau hauv ib lub xov tooj ntawm tes. Muaj ntau ntau txoj hauv kev los ua kom tiav txoj haujlwm ntawm tes. Cov ntsiab lus tseem ceeb yuav tau tham hauv kab lus no.
Nta ntawm kev txuas cov duab
Ua ntej tshaj tawm cov duab hauv Excel, nws yog ib qho tseem ceeb kom kawm ntau yam ntawm cov txheej txheem:
- Cov duab uas tus neeg siv xav tau ntxig yuav tsum yog ntawm lub hard drive lossis tshem tawm cov xov xwm uas txuas nrog lub PC.
- Daim duab tso rau hauv Excel yuav tsis txuas rau ib lub xov tooj ntawm tes tam sim ntawd, tab sis yuav nyob rau ntawm daim ntawv ua haujlwm.
- Qee cov duab yuav poob zoo tom qab muab tso rau ntawm lub phaj.
Yuav ua li cas ntxig ib daim duab hauv Excel
Ua ntej tshaj plaws, koj yuav tsum tau ntxig cov duab xaiv rau hauv qhov chaw ua haujlwm ntawm qhov kev pab cuam, thiab tom qab ntawd khi nws rau ib qho tshwj xeeb ntawm lub rooj. Thaum pib, koj yuav tsum ua cov hauv qab no:
- Txiav txim siab rau ib daim duab thiab tso nws nyob qhov twg hauv koj lub PC.
- Qhib Microsoft Office Excel.
- Nyem LMB ntawm lub caij uas koj xav tso cov duab.
- Mus rau ntu "Insert" thiab nyem rau ntawm lo lus "Daim duab".
- Qhia meej txog txoj hauv kev mus rau qhov chaw ntawm cov duab hauv lub computer los ntawm kev xaiv qhov tsim nyog disk muab faib rau hauv lub qhov rais uas qhib, thiab tom qab ntawd nyem rau ntawm lub pob "Insert".
- Xyuas kom tseeb tias cov duab tau muab tso rau hauv thiab tuav qee qhov chaw ntawm qhov chaw ua haujlwm.
Ua tib zoo mloog! Nyob rau theem no, daim duab yuav tseem tsis tau txuas rau ib lub ntsiab lus ntawm lub rooj array.
Yuav ua li cas kho ib daim duab
Tam sim no koj yuav tsum hloov kho cov duab tso rau hauv Excel, coj mus rau hauv daim ntawv "zoo". Koj yuav tsum ua li no:
- Txoj cai-nias nyob qhov twg ntawm daim duab yav dhau los tso thiab hauv cov ntawv qhia zaub mov, nyem rau ntawm kab "Size thiab properties".
- Nyob rau hauv lub qhov rais uas tshwm, koj muaj peev xwm hloov cov duab tsis, qoob loo, siv ntau yam teebmeem, thiab lwm yam. Ntawm no tus neeg siv ua tej yam ntawm nws tus kheej txiav txim siab.
- Kaw lub qhov rais "Qhov Loj thiab cov khoom" thiab nyem rau ntawm daim ntawv "Ua haujlwm nrog cov duab" nyob rau sab saum toj toolbar ntawm qhov program.
- Tam sim no nws yog ib qho tseem ceeb los txo cov duab tsis zoo kom nws haum rau hauv cov xov tooj ntawm tes ntawm lub rooj array. Rau lub hom phiaj no, ciam teb ntawm daim duab tuaj yeem hloov nrog LMB.
Yuav ua li cas txuas ib daim duab rau hauv lub xov tooj ntawm tes
Tom qab resizing, daim duab yuav tseem tsis tau txuas rau lub rooj array keeb. Txhawm rau txhim kho daim duab, koj yuav tau ua ntau yam ntxiv. Tom ntej no, peb yuav xav txog ntau txoj hauv kev los txuas ib daim duab rau hauv lub xov tooj ntawm tes hauv Microsoft Office Excel.
Tseem ceeb! Txhua txoj kev muaj feem cuam tshuam rau txhua qhov version ntawm qhov program.
Daim Ntawv Tiv Thaiv
Daim ntawv ua haujlwm hauv Excel tuaj yeem tiv thaiv los ntawm kev hloov pauv, thiab tom qab ntawd cov duab yuav raug kho nyob rau hauv qee txoj haujlwm. Txoj kev yog ua raws cov kauj ruam yooj yim:
- Txav cov duab kho kom raug rau lub ntsiab lus nrog LMB.
- Txoj cai-nias rau ntawm daim duab thiab nyem rau ntawm kab "Size and properties".
- Hauv cov ntawv qhia zaub mov "Size", kos cov kev teeb tsa. Lawv qhov tseem ceeb yuav tsum tsis txhob tshaj qhov loj ntawm lub cell. Koj kuj yuav tsum tau kos lub thawv nyob ib sab ntawm cov kab "Cuav proportions" thiab "Relative to the original size".
- Nkag mus rau "Properties" tab. Ntawm no koj yuav tsum tau tso lub toggle hloov ntawm ib sab ntawm kab "Tsav thiab hloov cov khoom nrog rau cov hlwb." Tawm tsam qhov "Protected object" thiab "Print object" parameters, koj yuav tsum khij lub thawv.
- Kaw lub qhov rais, xaiv tag nrho qhov chaw ua haujlwm siv Ctrl + A ua ke ntawm cov nyees khawm thiab mus rau Tshooj Cells los ntawm txhaj rau txhua qhov chaw ntawm daim ntawv RMB.
- Nyob rau hauv lub qhov rais tshiab nyob rau hauv lub "Kev Tiv Thaiv", uncheck lub box "Protected cell", ces xaiv lub cell nrog cov duab tso thiab kos lub thawv no dua.
Cov ntaub ntawv ntxiv! Tom qab ua tiav cov kev tswj hwm zoo li no, cov duab yuav raug kho nyob rau hauv ib qho tshwj xeeb ntawm lub rooj array thiab tiv thaiv los ntawm kev hloov pauv.
Teem ib daim duab hauv ib daim ntawv
Daim duab tso rau hauv daim ntawv Excel yuav cia li pinned rau ntawm tes. Txoj kev yog siv raws li nram no:
- Txoj cai-nias rau ntawm qhov khoom xav tau thiab taw tes rau "Insert Note" kev xaiv hauv cov ntawv qhia zaub mov.
- Nyob rau hauv lub qhov rais sau ntawv, right-click dua thiab taw tes rau kab "Note Format".
- Hauv qhov rai uas tshwm, mus rau ntu "Colors and Lines", tom qab ntawd nthuav cov "xim" tab thiab nyem rau ntawm "Fill Methods" khawm.
- Lwm lub qhov rais yuav qhib nyob rau hauv uas koj yuav tsum tau nyem rau ntawm lub xeem tab nyob rau hauv daim ntawv teev cov cuab yeej nyob rau sab saum toj thiab nyem rau ntawm lo lus "Drawing".
- Qhia txoj hauv kev mus rau qhov chaw ntawm daim duab ntawm lub PC thiab nyem rau ntawm lo lus "Ntxig".
- Tam sim no daim duab yuav muab ntxiv rau "Fill Methods" qhov rai. Tus neeg siv yuav tau kos lub thawv nyob ib sab ntawm cov khoom "Tswj cov proportions ntawm daim duab" thiab nyem "OK".
- Rov qab mus rau lub qhov rais "Note format" thiab nyob rau hauv seem "Kev Tiv Thaiv", tshem tawm cov kab "Cov khoom yuav tsum tau sau tseg".
- Nyob rau hauv tib lub qhov rais, txav mus rau lub "Properties" tab thiab muab lub toggle hloov nyob rau hauv lub "Tsav thiab hloov cov khoom nrog rau cov hlwb" teb, ces nias "OK".
Ua tib zoo mloog! Txoj kev txiav txim siab khi ib daim duab rau ib daim ntawv ntawm ib lub xovtooj ntawm tes, tab sis imposes ib tug xov tooj ntawm kev txwv rau lub caij ntawm lub rooj array.
xaus
Yog li, koj tuaj yeem kho cov duab sai sai hauv Excel hlwb siv cov cuab yeej tsim rau hauv qhov program. Cov txheej txheem ntawm kev sib txuas tau tham saum toj no yuav pab kom tsis txhob muaj teeb meem thaum ua haujlwm.