Ntxig thiab kho cov duab hauv Excel

Qee zaum, txhawm rau ua qee yam haujlwm hauv Excel, koj yuav tsum tau ntxig qee yam duab lossis duab rau hauv lub rooj. Cia saib yuav ua li cas raws nraim qhov no yuav ua tau nyob rau hauv qhov kev pab cuam.

Nco ntsoov: Ua ntej pib ncaj qha mus rau cov txheej txheem rau ntxig ib daim duab rau hauv Excel, koj yuav tsum muaj nws ntawm tes - ntawm lub khoos phis tawj hard drive lossis USB drive uas txuas nrog lub PC.

Ntxig ib daim duab rau ntawm daim ntawv

Txhawm rau pib, peb ua cov haujlwm npaj, uas yog, qhib cov ntaub ntawv xav tau thiab mus rau daim ntawv xav tau. Peb ua raws li txoj kev npaj hauv qab no:

1. Peb sawv hauv lub cell uas peb npaj yuav ntxig daim duab. Hloov mus rau tab “Ntxig”qhov twg peb nyem rau ntawm lub pob “Illustrations”. Hauv cov npe drop-down, xaiv cov khoom “Drawings”.
2. Lub qhov rais yuav tshwm sim ntawm qhov screen uas koj yuav tsum xaiv cov duab xav tau. Txhawm rau ua qhov no, ua ntej mus rau daim nplaub tshev uas muaj cov ntaub ntawv xav tau (los ntawm lub neej ntawd, daim nplaub tshev “Duab”), ces nyem rau ntawm nws thiab nias lub pob "Qhib" (los yog koj tuaj yeem nyem ob npaug rau ntawm cov ntaub ntawv).
3. Yog li ntawd, daim duab xaiv yuav muab tso rau hauv daim ntawv ntawm phau ntawv. Txawm li cas los xij, raws li koj tuaj yeem pom, nws tsuas yog tso rau saum lub hlwb thiab tsis muaj dab tsi ua rau lawv. Yog li cia peb mus rau cov kauj ruam tom ntej.

Kho daim duab

Tam sim no peb yuav tsum tau kho cov duab ntxig los ntawm muab nws qhov xav tau qhov ntev.

1. Nyem rau ntawm daim duab nrog txoj cai nas khawm. Hauv cov npe dropdown, xaiv "Size thiab Properties".
2. Ib daim duab hom qhov rais yuav tshwm sim, qhov twg peb tuaj yeem kho nws cov kev txwv:
   • qhov ntev (qhov siab thiab dav);
   • lub kaum sab xis ntawm kev sib hloov;
   • qhov siab thiab dav raws li feem pua;
   • khaws proportions, thiab lwm yam..
3. Txawm li cas los xij, feem ntau, es tsis txhob mus rau daim duab hom ntawv qhov rais, qhov chaw uas tuaj yeem ua rau hauv tab “Hom ntawv” (hauv qhov no, daim duab nws tus kheej yuav tsum raug xaiv).
4. Cia peb hais tias peb yuav tsum tau kho qhov loj ntawm daim duab kom nws tsis mus dhau ntawm cov ciam teb ntawm cov cell xaiv. Koj tuaj yeem ua qhov no hauv ntau txoj kev:
   • mus rau qhov chaw "Dimensions thiab Properties" los ntawm cov ntawv qhia zaub mov ntawm daim duab thiab kho qhov loj me hauv lub qhov rais uas tshwm.
   • teeb qhov ntev siv cov cuab yeej tsim nyog hauv tab “Hom ntawv” ntawm qhov program ribbon.
   • tuav tus nas laug khawm, luag lub kaum sab xis ntawm daim duab diagonally upwards.

Txuas ib daim duab rau ib lub xovtooj

Yog li, peb ntxig ib daim duab rau ntawm daim ntawv Excel thiab kho nws qhov loj me, uas tso cai rau peb kom haum nws rau hauv ciam teb ntawm cov xov tooj ntawm tes. Tam sim no koj yuav tsum tau txuas ib daim duab rau lub xov tooj ntawm tes. Qhov no yog ua li ntawd nyob rau hauv rooj plaub uas qhov kev hloov ntawm cov qauv ntawm lub rooj ua rau ib tug hloov nyob rau hauv thawj qhov chaw ntawm lub cell, daim duab tsiv nrog nws. Koj tuaj yeem ua qhov no raws li hauv qab no:

1. Peb ntxig ib daim duab thiab kho nws qhov loj kom haum rau cov ciam teb ntawm tes, raws li tau piav qhia saum toj no.
2. Nyem rau ntawm daim duab thiab xaiv los ntawm cov npe "Size thiab Properties".
3. Ua ntej peb, lub qhov rais uas twb paub lawm hom ntawv yuav tshwm. Tom qab ua kom paub tseeb tias qhov ntev sib haum mus rau qhov xav tau qhov tseem ceeb, thiab tseem muaj cov thawv kos “Keep proportions” и "Nco txog qhov loj me", mus к "Khoom".
4. Nyob rau hauv cov khoom ntawm daim duab, muab lub checkboxes nyob rau hauv pem hauv ntej ntawm cov khoom “Protected object” и “Print object”. Tsis tas li, xaiv qhov kev xaiv "Txuag thiab hloov pauv nrog cov cell".

Tiv thaiv ib lub xov tooj nrog cov duab los ntawm kev hloov pauv

Qhov kev ntsuas no, raws li lub npe ntawm header implies, yog xav tau nyob rau hauv thiaj li yuav tiv thaiv lub cell uas muaj cov duab los ntawm kev hloov thiab deleted. Nov yog yam koj yuav tsum ua rau qhov no:

1. Xaiv tag nrho daim ntawv, uas peb xub tshem tawm cov kev xaiv los ntawm cov duab los ntawm txhaj rau lwm lub xovtooj, thiab tom qab ntawd nias qhov tseem ceeb ua ke Ctrl + A. Tom qab ntawd peb hu rau cov ntawv qhia zaub mov ntawm lub hlwb los ntawm txoj cai-nias qhov twg hauv qhov chaw xaiv thiab xaiv cov khoom “Cell Format”.
2. Hauv qhov rai formatting, hloov mus rau tab "Kev tiv thaiv", qhov twg peb uncheck lub thawv opposite cov khoom “Protected Cell” thiab nias OK.
3. Tam sim no nyem rau ntawm lub xov tooj ntawm tes uas daim duab tau muab tso rau. Tom qab ntawd, kuj los ntawm cov ntawv qhia zaub mov, mus rau nws hom, ces mus rau tab "Kev tiv thaiv". Kos lub thawv nyob ib sab ntawm qhov kev xaiv “Protected Cell” thiab nias OK.Nco ntsoov: yog tias daim duab tso rau hauv ib lub xovtooj tag nrho overlaps nws, ces nyem rau ntawm nws nrog cov nas khawm yuav hu rau cov khoom thiab chaw ntawm daim duab nws tus kheej. Yog li ntawd, txhawm rau mus rau lub xov tooj ntawm tes nrog cov duab (xaiv nws), nws yog qhov zoo tshaj plaws los nyem rau ntawm lwm lub xov tooj ntawm tes ntawm nws, thiab tom qab ntawd, siv cov yuam sij navigation ntawm cov keyboard (nce, nqis, sab xis, sab laug), mus rau qhov yuav tsum tau ua. Tsis tas li ntawd, hu rau cov ntawv qhia zaub mov, koj tuaj yeem siv tus yuam sij tshwj xeeb ntawm cov keyboard, uas nyob rau sab laug ntawm Ctrl.
4. Hloov mus rau tab “Saib xyuas”qhov twg nyem rau ntawm lub pob “Protect Sheet” (thaum lub qhov rais qhov ntev yog compressed, koj yuav tsum xub nias lub pob "Kev tiv thaiv", tom qab uas cov khoom xav tau yuav tshwm sim hauv daim ntawv teev npe poob).
5. Lub qhov rais me me yuav tshwm sim qhov twg peb tuaj yeem teeb tus password los tiv thaiv daim ntawv thiab cov npe ntawm cov haujlwm uas cov neeg siv tuaj yeem ua. Nyem thaum npaj OK.
6. Hauv lub qhov rais tom ntej, paub meej tias tus password nkag thiab nyem OKAY.
7. Raws li qhov tshwm sim ntawm qhov ua tau zoo, lub xov tooj ntawm tes uas nyob hauv daim duab yuav raug tiv thaiv los ntawm kev hloov pauv, incl. tshem tawm.Nyob rau tib lub sijhawm, cov hlwb seem ntawm daim ntawv tseem tuaj yeem kho tau, thiab qib ntawm kev ywj pheej ntawm kev ua haujlwm ntawm lawv nyob ntawm seb cov khoom twg peb xaiv thaum daim ntawv tiv thaiv tau qhib.

Ntxig ib daim duab rau hauv xov tooj ntawm tes

Ntxiv rau kev ntxig ib daim duab rau hauv lub rooj ntawm tes, koj tuaj yeem ntxiv nws rau ib daim ntawv. Yuav ua li cas qhov no tau piav qhia hauv qab no:

1. Txoj cai-nias ntawm lub xov tooj ntawm tes uas koj xav tau ntxig cov duab. Hauv cov npe drop-down, xaiv cov lus txib “Insert note”.
2. Ib cheeb tsam me rau nkag mus rau ib daim ntawv yuav tshwm sim. Hover tus cursor hla ciam teb ntawm thaj chaw ceeb toom, right-click rau nws thiab hauv cov npe uas qhib, nyem rau ntawm cov khoom “Note Format”.
3. Cov ntawv ceeb toom qhov rai yuav tshwm rau ntawm qhov screen. Hloov mus rau tab “Colors and Lines”. Hauv cov kev xaiv sau, nyem rau ntawm cov xim tam sim no. Ib daim ntawv teev npe yuav qhib uas peb xaiv cov khoom “Fill Methods”.
4. Hauv cov txheej txheem sau qhov rais, hloov mus rau tab “Daim duab”, qhov twg peb nias lub pob nrog tib lub npe.
5. Lub qhov rais ntxig duab yuav tshwm sim, uas peb xaiv qhov kev xaiv “Los ntawm cov ntaub ntawv”.
6. Tom qab ntawd, lub qhov rai xaiv duab yuav qhib, uas peb twb tau ntsib thaum pib ntawm peb tsab xov xwm. Mus rau lub nplaub tshev uas muaj cov ntaub ntawv nrog cov duab xav tau, ces nias lub pob “Ntxig”.
7. Qhov kev zov me nyuam yuav rov qab peb mus rau lub qhov rais dhau los rau xaiv cov txheej txheem sau nrog cov qauv xaiv. Kos lub thawv rau qhov kev xaiv "Kua qhov proportions ntawm daim duab", ces nias OK.
8. Tom qab ntawd, peb yuav pom peb tus kheej nyob rau hauv lub ntsiab daim ntawv hom qhov rais, qhov twg peb hloov mus rau lub tab "Kev tiv thaiv". Ntawm no, uncheck lub thawv nyob ib sab ntawm cov khoom “Protected Object”.
9. Tom ntej no, mus rau lub tab "Khoom". Xaiv ib qho kev xaiv "Txiv thiab hloov khoom nrog rau cov hlwb". Txhua qhov teeb tsa tau tsim, yog li koj tuaj yeem nias lub pob OK.
10. Raws li qhov tshwm sim ntawm kev ua, peb tswj tsis tau tsuas yog ntxig ib daim duab raws li ib qho kev ceeb toom rau ntawm tes, tab sis kuj txuas rau lub xov tooj ntawm tes.
11. Yog xav tau, daim ntawv tuaj yeem muab zais. Hauv qhov no, nws tsuas yog tshwm sim thaum koj hla lub xov tooj ntawm tes. Txhawm rau ua qhov no, right-click rau ntawm tes nrog ib daim ntawv thiab xaiv cov khoom hauv cov ntawv qhia zaub mov “Hide note”.Yog tias tsim nyog, daim ntawv sau rov qab rau hauv tib txoj kev.

Ntxig duab hauv tus tsim tawm hom

Excel kuj tseem muab lub peev xwm los ntxig ib daim duab rau hauv ib lub xovtooj ntawm qhov hu ua Tsim Hom. Tab sis ua ntej koj yuav tsum qhib nws, vim nws yog neeg xiam oob qhab los ntawm lub neej ntawd.

1. Mus rau cov ntawv qhia zaub mov “File”, qhov twg peb nyem rau ntawm qhov khoom “Parameters”.
2. Lub qhov rais ntawm qhov tsis muaj yuav qhib, qhov twg hauv cov npe ntawm sab laug nyem rau ntawm ntu “Customize Ribbon”. Tom qab ntawd, nyob rau hauv txoj cai ntawm lub qhov rais nyob rau hauv lub ribbon nqis, peb pom cov kab "Tus tsim tawm", khij lub npov ib sab ntawm nws thiab nyem OK.
3. Peb sawv hauv lub xov tooj ntawm tes uas peb xav ntxig cov duab, thiab tom qab ntawd mus rau lub tab "Tus tsim tawm". Hauv seem cov cuab yeej “Controls” nrhiav lub pob “Ntxig” thiab nyem rau ntawm nws. Hauv cov npe uas qhib, nyem rau ntawm lub cim “Duab” hauv pab pawg “Active controls”.
4. Tus cursor yuav hloov mus rau tus ntoo khaub lig. Nrog rau sab laug nas khawm nias, xaiv thaj chaw rau cov duab yav tom ntej. Yog tias tsim nyog, qhov ntev ntawm thaj chaw no tuaj yeem hloov kho lossis qhov chaw ntawm cov duab plaub (square) tuaj yeem hloov pauv kom haum rau hauv lub cell.
5. Right-click rau ntawm daim duab tshwm sim. Hauv cov npe drop-down ntawm cov lus txib, xaiv "Khoom".
6. Peb yuav pom lub qhov rais nrog cov khoom ntawm lub caij:
   • nyob rau hauv tus nqi parameter "Tso" qhia tus lej "1" (tus nqi pib – "2").
   • nyob rau hauv lub teb rau nkag mus rau tus nqi opposite lub parameter “Daim duab” nyem rau ntawm lub pob nrog peb dots.
7. Ib lub qhov rais upload duab yuav tshwm. Peb xaiv cov ntaub ntawv xav tau ntawm no thiab qhib nws los ntawm nias lub pob tsim nyog (nws pom zoo kom xaiv hom ntaub ntawv “Tag nrho cov ntaub ntawv”, vim txwv tsis pub qee qhov txuas ntxiv yuav tsis pom hauv lub qhov rais no).
8. Raws li koj tuaj yeem pom, daim duab tau muab tso rau ntawm daim ntawv, txawm li cas los xij, tsuas yog ib feem ntawm nws tau tshwm sim, yog li yuav tsum tau hloov qhov loj me. Ua li no, nyem rau ntawm lub icon nyob rau hauv daim ntawv ntawm ib daim duab peb sab me me nyob rau hauv lub parameter tus nqi teb “PictureSizeMode”.
9. Hauv daim ntawv teev npe poob, xaiv qhov kev xaiv nrog tus lej "1" thaum pib.
10. Tam sim no tag nrho cov duab haum rau hauv cheeb tsam duab plaub, yog li cov chaw tuaj yeem raug kaw.
11. Nws tseem tsuas yog khi cov duab rau ntawm tes. Txhawm rau ua qhov no, mus rau lub tab “Page layout”, qhov twg peb nias lub pob “Kev txiav txim”. Hauv cov npe drop-down, xaiv cov khoom “Lim”, tiam – "Snap rau Grid".
12. Ua tiav, daim duab txuas mus rau lub cell xaiv. Tsis tas li ntawd, tam sim no nws cov ciam teb yuav "lo" rau ciam teb ntawm tes yog tias peb txav cov duab lossis hloov pauv nws.
13. Qhov no yuav tso cai rau koj kom haum cov duab rau hauv lub xov tooj ntawm tes yam tsis muaj kev siv zog ntau.

xaus

Yog li, muaj ntau txoj hauv kev uas koj tuaj yeem ntxig cov duab rau hauv ib lub xovtooj ntawm daim ntawv Excel. Txoj kev yooj yim tshaj plaws yog siv cov cuab yeej hauv Insert tab, yog li nws tsis xav tsis thoob tias qhov no yog txoj hauv kev nrov tshaj plaws ntawm cov neeg siv. Tsis tas li ntawd, nws muaj peev xwm ntxig cov duab ua cov ntawv sau ntawm tes lossis ntxiv cov duab rau hauv daim ntawv uas siv hom tsim tshwj xeeb.