Yuav ua li cas ntxig ib daim duab rau hauv daim ntawv Excel. Ntxig thiab kho cov duab hauv Excel

Qee qhov haujlwm ua hauv Excel daim ntawv nthuav qhia yuav tsum tau ntxiv ntau yam duab kos thiab duab rau cov ntaub ntawv tabular. Qhov kev zov me nyuam muaj ntau yam cuab yeej uas tso cai rau koj ntxig ib daim duab. Hauv tsab xov xwm, peb yuav txheeb xyuas ntau yam hauv ntau txoj hauv kev rau kev siv cov txheej txheem no: los ntawm kev tiv thaiv daim ntawv ua haujlwm, hom tsim tawm, thiab ntxiv cov ntawv sau rau hauv daim ntawv ua haujlwm.

Nta ntawm inserting duab

Txhawm rau ntxiv cov duab rau hauv daim ntawv ua haujlwm, daim duab nws tus kheej yuav tsum nyob rau ntawm PC lub hard drive lossis ntawm cov xov xwm tshem tau txuas nrog nws.

Ua tib zoo mloog! Thaum xub thawj, daim duab ntxiv tsis yog khi rau ib lub xov tooj tshwj xeeb, tab sis tsuas yog nyob hauv thaj chaw cim ntawm daim ntawv ua haujlwm.

Ntxig ib daim duab rau ntawm daim ntawv

Ua ntej, cia peb txhais li cas cov txheej txheem rau ntxig ib daim duab rau hauv qhov chaw ua haujlwm tshwm sim, thiab tom qab ntawd nrhiav seb yuav ntxiv cov duab rau ib lub xov tooj tshwj xeeb. Txoj kev taug kev zoo li no:

1. Peb ua ib qho kev xaiv ntawm lub xov tooj ntawm tes uas peb npaj yuav muab daim duab. Peb txav mus rau ntu hu ua "Ntxig", uas nyob rau saum toj ntawm daim ntawv nthuav dav. Peb pom qhov thaiv ntawm cov lus txib "Illustrations" thiab hauv nws peb nyem lub caij "Duab".

2. Lub qhov rais hu ua "Insert Picture" tshwm rau ntawm qhov screen. Los ntawm lub neej ntawd, nws ib txwm tshwm nyob rau hauv daim nplaub tshev duab. Nws muaj peev xwm hloov ua ntej mus rau daim nplaub tshev no cov duab uas peb npaj yuav ntxig rau ntawm daim ntawv ua haujlwm. Lwm txoj kev xaiv yog nyob twj ywm hauv tib lub qhov rais thiab mus rau lwm lub nplaub tshev ntawm tus kheej lub khoos phis tawj tsav lossis txuas nrog cov xov xwm tshem tawm. Tom qab ua tiav tag nrho cov manipulations, los ntawm xaiv ib tug duab, nyem rau ntawm lub pob "Insert".

3. Npaj txhij! Cov duab uas xav tau tshwm sim ntawm daim ntawv ua haujlwm. Nws yog ib qho tsim nyog sau cia tias daim duab tam sim no tsis txuas rau ib lub xov tooj ntawm cov ntaub ntawv. Peb yuav tham txog txoj kev khi lus me ntsis tom qab.

Image editing

Cia peb tham txog yuav ua li cas hloov cov duab ntxig kom nws muaj qhov tsim nyog qhov ntev uas zoo sib xws ntawm daim ntawv ua haujlwm. Txoj kev taug kev zoo li no:

1. Peb nyem rau ntawm daim duab ntxig RMB. Ib lub ntsiab lus qhia zaub mov tshwm rau ntawm qhov screen, tso cai rau koj hloov ib lossis lwm yam duab parameter. Xaiv cov khoom hu ua "Size and Properties".

2. Cov zaub qhia ib lub thawv me me hu ua Daim Duab Format. Ntawm no yog ib tug lossis loj tus naj npawb ntawm changeable parameters uas tso cai rau koj mus kho cov khoom ntawm cov duab. Kev teeb tsa yooj yim: qhov loj me, xim, qoob loo, ntau yam teebmeem, thiab lwm yam. Ntau qhov chaw tau tsim los kom tus neeg siv tuaj yeem hloov kho cov duab ntxig rau ntau yam haujlwm.

3. Yog tias tsis xav tau kev kho kom ntxaws ntxaws ntawm cov duab ntxig, ces peb yuav tsis xav tau lub qhov rais "Dimensions thiab Properties". Lwm qhov kev xaiv rau kev hloov daim duab yog mus rau ntu ntxiv "Ua haujlwm nrog cov duab", nyob rau sab saum toj ntawm nplooj ntawv sib txuas.

4. Yog tias peb xav ntxig ib daim duab rau hauv ib lub xovtooj, ces peb yuav tsum tau hloov cov duab kom nws qhov loj me sib npaug ntawm qhov loj ntawm lub xovtooj ntawm tes. Kev kho qhov loj me yog ua los ntawm cov txheej txheem hauv qab no: los ntawm "Dimensions thiab khoom" qhov rai; txav cov ciam teb ntawm daim duab nrog kev pab ntawm LMB; siv cov cuab yeej ntawm cov ribbon, nrog rau cov ntawv qhia zaub mov.

Txuas ib daim duab

Tom qab ua tiav tag nrho cov manipulations tau piav saum toj no, cov duab ntxig rau hauv txhua rooj plaub tseem tsis tau txuas mus rau lub xov tooj ntawm tes. Piv txwv li, yog tias tus neeg siv txheeb cov ntaub ntawv ntawm daim ntawv ua haujlwm, cov hlwb yuav hloov lawv txoj haujlwm, tab sis cov duab tseem yuav nyob rau tib qhov chaw uas nws tau muab tso rau. Daim ntawv nthuav qhia muaj ntau txoj hauv kev uas tso cai rau koj xa cov duab mus rau ib lub xovtooj xaiv hauv ib daim ntawv. Cia peb tham txog qhov no kom ntxaws ntxiv.

Txoj kev 1: daim ntawv tiv thaiv

Tiv thaiv ib daim ntawv ua haujlwm los ntawm ntau yam kev hloov kho yog ib txoj hauv kev rau kev txuas ib daim duab rau hauv lub xov tooj ntawm tes. Txoj kev taug kev zoo li no:

1. Peb siv qhov kev hloov pauv ntawm cov duab loj rau qhov loj ntawm lub xov tooj ntawm tes thiab ntxig nws siv cov kev piav qhia saum toj no.

2. Nyem rau ntawm daim duab ntxig. Cov ntawv qhia zaub mov me me tshwm. Nyem rau ntawm qhov "Size and properties" element.

3. Lub qhov rais "Format Picture" paub tau tshwm sim ntawm qhov screen. Peb txav mus rau ntu "Size" thiab xyuas kom meej tias qhov loj ntawm daim duab tsis tshaj qhov loj ntawm lub xov tooj ntawm tes. Tsis tas li ntawd, xyuas kom meej tias muaj cov zuam nyob ib sab ntawm cov ntsiab lus "Keep proportions" thiab "Relative to original size". Yog tias ib qho khoom tsis sib haum rau ib qho uas tau piav saum toj no, kho nws.

4. Hauv tib lub qhov rais peb pom cov khoom "Properties" thiab txav mus rau nws. Yog tias tsis muaj cov cim kos nyob ib sab ntawm cov khoom "Print object" thiab "Protected object", ces lawv yuav tsum tau kuaj xyuas. Peb pom cov cuab yeej "Snap object rau keeb kwm yav dhau" thiab muab lub cim kos ntawm ib sab ntawm cov ntawv sau "Tsav thiab hloov cov khoom nrog rau cov hlwb." Tom qab ua tiav tag nrho cov manipulations, nyem rau ntawm "Kaw" khawm, uas nyob rau hauv qab ntawm "Format Picture" qhov rais.

5. Siv qhov tseem ceeb ua ke ntawm cov keyboard "Ctrl + A" peb xaiv tag nrho cov ntawv ua haujlwm. Peb hu rau cov ntawv qhia zaub mov thiab nyem rau ntawm lub ntsiab "Format Cells ...".

6. Lub qhov rais hu ua "Format Cells" tshwm rau ntawm qhov screen. Mus rau ntu "Kev Tiv Thaiv" thiab tshem tawm cov khoom "Protected cell" khoom. Tom qab ua tiav tag nrho cov manipulations, nyem rau ntawm lub pob "OK" nyob rau hauv qab ntawm lub qhov rais.

7. Tam sim no peb ua ib qho kev xaiv ntawm lub xov tooj ntawm tes uas cov duab tso rau hauv, uas peb npaj yuav txuas. Nyob rau hauv txoj kev saum toj no, peb rov mus rau "Format Cells" qhov rais siv cov ntsiab lus teb ntawv qhia zaub mov. Ib zaug ntxiv, peb tsiv mus rau ntu "Kev Tiv Thaiv" thiab lub sijhawm no muab lub cim khij ntawm ib sab ntawm "Kev Tiv Thaiv Cell" khoom. Tom qab ua tiav tag nrho cov manipulations, nyem rau ntawm "OK".

8. Mus rau ntu "Tshawb xyuas", nyob rau sab saum toj ntawm nplooj ntawv sib txuas. Peb pom qhov thaiv hu ua "Changes" thiab nyem rau ntawm "Protect Sheet" keeb.

9. Lub qhov rais hu ua "Protect Sheet" tau tshwm sim ntawm qhov screen. Hauv "Password rau lov tes taw kev tiv thaiv daim ntawv", sau tus password. Peb nyem rau ntawm lub pob "OK". Lwm lub qhov rais tshwm rau ntawm cov zaub uas koj yuav tsum rov sau tus password.

10. Npaj txhij! Peb tau tiv thaiv lub xov tooj ntawm tes nrog cov duab ntxig los ntawm kev hloov pauv. Hauv lwm lo lus, daim duab txuas nrog lub xov tooj ntawm tes.

Txog thaum muaj kev tiv thaiv tsis taus, nws yuav tsis tuaj yeem hloov pauv hauv cov ntawv tiv thaiv ntawm daim ntawv ua haujlwm. Txawm hais tias peb txheeb cov ntaub ntawv, cov duab ntxig yuav nyob twj ywm hauv lub xov tooj ntawm tes.

Txoj Kev 2: Ntxig ib daim duab rau hauv ib daim ntawv

Siv daim ntawv, koj tuaj yeem txuas cov duab. Txoj kev taug kev zoo li no:

1. Txoj cai-nias ntawm lub xov tooj ntawm tes uas peb xav ntxig daim duab. Cov ntawv qhia zaub mov me me tau qhib. Nyem rau ntawm qhov khoom hu ua "Insert Note".

2. Lub qhov rais me me tau tshwm sim ntawm qhov screen, tso cai rau koj sau ntawv. Txav lub pointer mus rau lub qhov rais ncej thiab nyem rau ntawm nws. Cov ntawv qhia zaub mov tshiab tau tshwm sim ntawm qhov screen. Nyem rau ntawm "Note Format" element.

3. Lub qhov rais tshiab tau tshwm sim ntawm cov zaub, tsim los teeb tsa cov ntawv. Txav mus rau ntu "Colors and Lines". Peb pom cov cuab yeej "Fill" thiab qhib cov npe ntawm cov duab ntxoov ntxoo hauv "Xim" ntu ntu. Hauv daim ntawv teev npe, nyem rau ntawm cov ntawv sau "Fill method ...".

4. Lub qhov rais yog tso tawm kom pom nyob rau hauv uas koj tuaj yeem xaiv txoj kev sau. Peb txav mus rau ntu "Daim duab", thiab tom qab ntawd nyem rau ntawm "Daim duab ..." caij.

5. Qhov "Insert Picture" qhov rais, paub rau peb los ntawm cov kev piav qhia saum toj no, tau qhib. Peb xaiv cov duab kos. Tom qab ua tiav tag nrho cov manipulations, nyem rau ntawm lub pob "Insert", uas nyob rau hauv qab ntawm lub qhov rais "Insert Picture".

6. Cov duab xaiv tau tso tawm nyob rau hauv "Fill Methods" qhov rai. Muab lub cim khij ntawm ib sab ntawm cov ntawv sau "Kua qhov feem ntawm daim duab." Tom qab ua tiav tag nrho cov kauj ruam, nyem rau ntawm "OK".

7. Peb rov qab mus rau qhov "Note Format" window. Peb tsiv mus rau ntu "Kev Tiv Thaiv". Tshem lub checkmark ntawm ib sab ntawm cov ntawv sau "Protected object".

8. Peb tsiv mus rau ntu "Properties". Hauv "Snap object to background" thaiv, khij lub npov nyob ib sab ntawm lub "Tsav thiab hloov khoom nrog cov hlwb" keeb. Tom qab ua tiav tag nrho cov manipulations, nyem rau ntawm "OK".

9. Npaj txhij! Tom qab peb siv tag nrho cov txheej txheem uas tau piav qhia saum toj no, daim duab tsis yog tsuas yog ntxiv rau hauv daim ntawv, tab sis kuj txuas nrog lub xov tooj ntawm tes. Tau kawg, txoj kev no tsis haum rau tag nrho cov haujlwm uas tau daws los ntawm kev siv cov ntaub ntawv nthuav tawm, vim nws muaj qee yam kev txwv.

Txoj Kev 3: Tus tsim tawm hom

Koj tuaj yeem khi ib daim duab rau hauv lub xov tooj ntawm tes siv qhov tshwj xeeb "Tus tsim tawm" hom kev koom ua ke rau hauv daim ntawv nthuav qhia. Qhov teeb meem tseem ceeb yog tias hom yog nyob rau hauv lub xeev tawm. Cia peb qhib nws ua ntej. Cov kev qhia ib qib zuj zus zoo li no:

1. Mus rau ntu "Cov ntaub ntawv", thiab tom qab ntawd xaiv cov khoom "Options".

2. Hauv qhov rai uas tshwm, mus rau ntu "Ribbon Ntxiv-In". Peb muab ib lub cim ntawm ib sab ntawm cov ntawv sau "Developer". Tom qab ua tiav tag nrho cov manipulations, nyem "OK".

3. Peb ua ib qho kev xaiv ntawm thaj chaw uas peb xav tau ntxig daim duab. Mus rau ntu "Developer" uas tshwm nyob rau sab saum toj ntawm nplooj ntawv sib txuas. Hauv seem "Add-ons", nyem "Insert". Hauv daim ntawv teev npe poob, nyem rau ntawm "Duab" icon, nyob rau hauv "ActiveX Controls" subsection.

4. Lub xovtooj qhia txog qhov me me, khoob-hom duab plaub. Peb hloov kho qhov ntev kom cov duab haum rau hauv lub cell xaiv. Kev hloov kho yog siv los ntawm kev txav ciam teb nrog kev pab los ntawm LMB. Txoj cai-nias rau ntawm daim duab. Ib cov ntawv qhia me me qhib, uas peb nyem "Properties".

5. Lub qhov rais khoom tshwm rau ntawm qhov screen. Tom ntej no mus rau lub inscription "Placement" peb muab ib chav tsev. Hauv kab "Daim duab" peb pom lub cim nyob rau hauv daim ntawv ntawm peb dots thiab nyem rau ntawm nws nrog rau sab laug nas khawm.

6. Lub qhov rais Add Image tshwm. Peb pom daim duab uas peb xav tau ntxig. Xaiv nws, thiab tom qab ntawd nyem rau ntawm "Qhib" khawm nyob hauv qab ntawm lub qhov rais.

7. Thaum tag nrho cov txheej txheem tiav, kaw lub qhov rais khoom. Cov duab xav tau yog muab tso rau hauv lub cell. Tom ntej no, koj yuav tsum ua cov txheej txheem ntawm kev txuas cov duab rau ntawm tes. Peb siv qhov kev xaiv ntawm daim duab ntawm qhov chaw ua haujlwm thiab txav mus rau ntu "Page Layout", nyob rau sab saum toj ntawm daim ntawv nthuav qhia. Nrhiav qhov "Tsim" thaiv thiab xaiv qhov "Align" caij. Nyob rau hauv daim ntawv uas qhib, nyem rau ntawm "Snap rau Grid" thiab me ntsis txav nws sab nraum daim duab ciam teb.

8. Npaj txhij! Tom qab ua raws li cov txheej txheem saum toj no, peb tau khi cov duab rau ntawm tes.

xaus

Hauv Excel spreadsheet, muaj ntau txoj hauv kev rau kev ntxig ib daim duab thiab txuas rau hauv lub xovtooj, tab sis tsis yog txhua txoj kev tsim nyog rau kev daws txhua yam teeb meem. Piv txwv li, cov txheej txheem sau ntawv yog qhov nqaim me ntsis, thaum Tus Tsim Tawm Hom thiab Tiv Thaiv Daim Ntawv yog cov kev xaiv dav dav uas haum rau txhua tus neeg siv.