01 ntawm 02
Ntxig Watermark hauv Excel
Excel Watermark Txheej txheem cej luam
Excel tsis suav muaj cov qauv muaj tseeb tiag, tiam sis koj tuaj yeem ntxig ib daim duab duab rau hauv ib lub taub hau los yog lub tsho kom pom tau tias yuav muaj qoob loo.
Hauv kev pom cov ntaub ntawv watermarking, cov ntaub ntawv feem ntau yog cov ntawv nyeem lossis ib lub cim uas qhia txog tus tswv lossis kos npe hauv xov xwm hauv qee txoj kev.
Nyob rau hauv daim duab saum toj no, ib daim duab uas muaj cov ntsiab lus uas muaj cov lus Tsab ntawv tau tso rau hauv cov header ntawm tsab ntawv Excel.
Txij li cov hau kev thiab cov ntawv sau tawm hauv txhua nplooj ntawv hauv phau ntawv no, txoj kev no yog ib qho yooj yim los xyuas kom meej tias lub logo lossis lwm yam ntaub ntawv tseem ceeb muaj nyob rau txhua nplooj ntawv.
Watermark Piv txwv
Cov qauv hauv qab no npog cov kauj ruam nram qab no hauv Excel tsim nyog los ntxig ib cov duab rau hauv ib lub hau thiab tso nws nyob hauv nruab nrab ntawm ib daim ntawv ua haujlwm dawb.
Qhov kev nyeem no tsis muaj cov kauj ruam ua raws li kev tsim cov duab ua nws tus kheej.
Ib daim duab uas muaj cov lus uas muaj Lo Lus lossis lwm yam ntawv zoo sib xws tau tsim nyob rau hauv txhua daim phiaj xwm kev kos duab xws li Xim Phiaj Xwm nrog lub Microsoft Windows operating system.
Kom tau koj pib, daim duab cov duab siv hauv tus piv txwv no muaj cov yeeb yam nram qab no:
- Font: Gills Sans MT
- Loj: 72 point
- Xim: Grey - 25%
Lus Cim: Lub Xim Ris Nias tsis muaj qhov xaiv rau tig cov ntawv nyeem raws li pom hauv daim duab saum toj no.
Page Layout Saib
Cov headers thiab footers ntxiv rau daim ntawv ua haujlwm hauv phab Layout view.
Mus txog rau peb lub headers thiab peb lub footers yuav muab ntxiv rau ib daim ntawv uas siv lub hau thiab lub thawv ntawv uas pib pom hauv Page Layout saib.
Yog vim li cas, lub npov nruab nrab ntawm lub npov yog xaiv - qhov no yog qhov chaw duab watermark yuav muab tso rau hauv no nyeem.
Cov Kauj Ruam Tutorial
- Nias rau ntawm daim ntxig ntawm daim ntawv sau
- Nyem ntawm Header & Footer icon ntawm txoj cai kawg ntawm txoj kab
- Txhawm rau ntawm no icon switches Excel rau phab Layout saib thiab opens ib tug tshiab tab ntawm lub npe hu ua Header & Footer Tools
- Ntawm no cov tshiab tab nias rau ntawm daim duab icon qhib lub Thawv Daim Duab Qhia
- Nyob rau hauv lub thawv sib tham tuaj nrhiav cov duab ua ntaub ntawv uas yuav muab tso rau hauv cov header
- Nias ntawm daim duab xa mus rau highlight nws
- Nias ntawm khawm Insert mus ntxig cov duab thiab kaw lub thawv ntawv
- Tus duab watermark tsis pom tshwm tab sis ib qho & [Daim duab} yuav tsum tshwm nyob hauv qhov chaw nruab nrab lub thawv ntawm daim ntawv ua haujlwm
- Nias ntawm ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm tawm sab nraum lub tshav pob
- Tus duab watermark yuav tsum tshwm ze ze ntawm sab saum toj ntawm daim ntawv
Rov qab mus rau Kev Pom Zoo
Thaum koj tau ntxiv lub watermark, Excel tawm koj hauv nplooj Layout saib. Thaum nws tseem tuaj yeem ua haujlwm rau hauv qhov kev pom no, koj yuav xav rov qab mus rau Kev Pom Zoo. Ua li no:
- Nias ntawm ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm tawm hauv cheeb tsam.
- Ndliv lub Saib tab
- Ndliv lub cim thev naus laus zis hauv qhov ribbon
Phab 2 ntawm cov ntawv nyeem no muaj cov kauj ruam rau:
- muab qhov khoom tso rau hauv daim ntawv ua haujlwm
- tshem cov duab thaij duab
- hloov lub vigermark duab
- saib cov khoom nruab ntug hauv kev luam ua ntej
02 ntawm 02
Excel Watermark Tutorial tsis tau
Tso lub Tshem Khoom Tshaj Tawm (Watermark)
Yog tias xav tau, cov duab watermark tuaj yeem txav mus rau hauv nruab nrab ntawm daim ntawv ua hauj lwm raws li pom hauv daim duab saum toj no.
Qhov no yog ua los ntawm kev ntxiv dawb kab nyob rau hauv pem hauv ntej ntawm daim duab & [Daim duab} code siv tus yuam nkag rau ntawm cov keyboard.
Yuav kom haum tus watermark:
- Yog tias tsim nyog, nias ntawm Header & Footer icon ntawm Insert tab kom nkag mus hauv Layout view
- Nias ntawm qhov chaw nruab nrab lub thawv xaiv nws
- Tus & [Duab}} code rau watermark duab nyob rau hauv lub thawv yuav tsum muaj highlighted
- Nyem nyob rau hauv pem hauv ntej ntawm lub & [Duab}} tshem cov ntsiab lus thiab rau txoj hlua ntawm qhov chaw nyob ntawm xub ntiag
- Nias tus yuam sij Nkag rau ntawm tus keyboard ob peb zaug kom ntxig tau kab dawb saum toj no cov duab
- Lub npov qhov taub yuav tsum nthuav dav thiab tus & Duab [Txoj Cai] tsiv mus rau hauv nqe ntawv
- Txheeb xyuas qhov chaw tshiab ntawm cov duab watermark, nyem rau ntawm ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm tawm hauv Header box
- Lub vigermark duab qhov chaw yuav tsum hloov
- Ntxiv cov kab ntxiv yog tias tsim nyog los siv lub Backspace qhov tseem ceeb ntawm cov keyboard kom tshem tau ntau tshaj cov kab ntxiv nyob rau pem hauv ntej ntawm daim duab & [Daim duab} code
Hloov cov Watermark
Los hloov tus qub watermark nrog tus duab tshiab:
- Yog tias tsim nyog, nias ntawm Header & Footer icon ntawm Insert tab kom nkag mus hauv Layout view
- Nias ntawm qhov chaw nruab nrab lub thawv xaiv nws
- Tus & [Duab}} code rau watermark duab nyob rau hauv lub thawv yuav tsum muaj highlighted
- Nyem ntawm daim duab icon
- Lub vev xaib yuav qhib piav qhia tias tsuas yog muab ib daim duab tso rau hauv txhua seem ntawm lub hau
- Nias lub khawm Hloov rau hauv lub thawv ntawv qhib lub thawv Daim Duab Qhia
- Nyob rau hauv lub thawv sib tham tuaj nrhiav cov duab hloov tshiab
- Nias ntawm daim duab xa mus rau highlight nws
- Nias ntawm khawm Insert mus ntxig cov duab tshiab thiab kaw lub thawv ntawv
Tshem qhov Watermark
Tshem tawm ib lub tshav puam:
- Yog tias tsim nyog, nias ntawm Header & Footer icon ntawm Insert tab kom nkag mus hauv Layout view
- Nias ntawm qhov chaw nruab nrab lub thawv xaiv nws
- Nias lub Delete los yog Backspace qhov tseem ceeb ntawm cov keyboard kom tshem tawm cov & [Daim duab} code
- Nias ntawm ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm tawm sab nraum lub tshav pob
- Cov duab watermark yuav tsum tau muab tshem tawm ntawm daim ntawv ua haujlwm
Saib Watermark hauv Print Preview
Vim hais tias headers thiab footers tsis pom nyob rau hauv Kev pom hauv Excel koj yuav tsum hloov views thiaj li pom ib lub watermark.
Ntxiv rau qhov Page Layout saib qhov twg cov duab watermark tau ntxiv, tus watermark kuj tuaj yeem pom hauv sau Preview :
Lus Cim : Koj yuav tsum muaj ib lub tshuab luam ntawv ntsia koj lub computer siv Print Preview .
Hloov Los Saib Ua Ntej
- Nias rau ntawm Daim Ntawv Txheej ntawm txoj kab lus
- Nyem rau Sau hauv daim ntawv qhia zaub mov
- Koj daim ntawv ua haujlwm thiab cov watermark yuav tsum tshwm sim nyob rau ntawm nplooj ntawv saib ua ntej ntawm txoj cai ntawm qhov screen
Hloov mus sau saib ua ntej hauv Excel 2007
- Ndliv qhov Office Button
- Xaiv Print> Print Preview los ntawm txoj kev sau npe rau hauv tshuab raj
- Daim Npog Saib Ua Ntej Print yuav qhib qhov kev ua hauj lwm thiab cov ntaub ntawv watermark