Yuav Paub
- Xaiv Excel Insert tab. Xaiv Header & Footer > Duab. Xaiv cov duab thiab xaiv Insert los tso saib &[Duabcode.
- Xaiv ib lub xovtooj ntawm daim ntawv ua haujlwm kom tawm hauv lub thawv Header thiab saib cov duab watermark.
Kab lus no piav qhia yuav ua li cas ntxig cov ntawv sau rau ntawm Excel daim ntawv nthuav qhia. Nws suav nrog cov ntaub ntawv hais txog kev hloov pauv, tshem tawm, thiab hloov cov cim dej. Cov lus qhia no siv rau Excel 2019, 2016, 2013, 2010, 2007, Excel 2019 rau Mac thiab Excel 2016 rau Mac.
Yuav ua li cas ntxig tus Watermark rau ntawm Excel Spreadsheet
Excel tsis suav nrog qhov tseeb watermark feature, tab sis koj tuaj yeem ntxig cov duab cov ntaub ntawv rau hauv header lossis footer kom pom raws li pom dej. Rau pom watermarking, cov ntaub ntawv feem ntau yog cov ntawv lossis lub logo uas qhia tus tswv lossis kos cov xov xwm hauv qee txoj kev.
Koj tuaj yeem ntxiv txog peb lub taub hau hauv Excel. Cov headers no, uas pom nyob rau hauv Page Layout lossis Print Preview views, tuaj yeem ua raws li cov ntawv sau rau cov ntawv. Nov yog yuav ua li cas ntxiv cov duab watermark.
- Click the Insert tab ntawm tus ribbon.
-
Click Header & Footer hauv Cov Ntawv Teev-down ntawv qhia zaub mov ntawm kab.
Image -
Click Duab nyob rau hauv pab pawg Header & Footer Elements ntawm Header & Footer Tools tab. Lub Insert Picture dialog box yuav qhib.
Image -
Nav mus rau cov duab cov ntaub ntawv uas koj xav siv raws li koj watermark. Nyem rau ntawm cov ntaub ntawv xaiv thiab tom qab ntawd nyem lub pob Insert txhawm rau ntxiv. Daim duab watermark tsis pom tam sim ntawd tab sis &[Duab} code yuav tsum tshwm nyob rau hauv lub hauv paus header lub thawv ntawm daim ntawv ua hauj lwm.
Image -
nias ib lub xovtooj ntawm daim ntawv ua haujlwm kom tawm hauv lub thawv Header.
Image - Daim duab watermark yuav tsum tam sim no tshwm rau ntawm daim ntawv ua haujlwm.
Txhob Tso Dej Dej
Koj tseem tuaj yeem tshem tawm cov ntawv sau tag nrho.
- mus rau Insert tab ntawm kab.
-
Click Header & Footer nyob rau hauv pawg ntawv ntawm cov ribbon. Excel yuav hloov mus rau nplooj ntawv Layout saib thiab Header & Footer Tools tab yuav qhib rau ntawm kab.
- Nias lub hauv paus header lub thawv xaiv nws.
-
Nias lub Delete lossis Backspace tus yuam sij ntawm cov keyboard kom tshem tawm &[Duab} code.
Image - nias ib lub xovtooj ntawm daim ntawv ua haujlwm kom tawm hauv lub thawv Header.
Repositioning the Watermark
Yog xav tau, koj tuaj yeem txav cov duab watermark mus rau nruab nrab ntawm daim ntawv ua haujlwm, raws li pom hauv daim duab saum toj no.
- mus rau Insert tab ntawm kab.
- Click Header & Footer nyob rau hauv pawg ntawv ntawm lub ribbon.
- Nyem rau ntawm lub hauv paus header lub thawv xaiv nws. Lub &[Duab} code rau cov duab watermark nyob rau hauv lub thawv yuav tsum tau highlighted.
-
Nias rau pem hauv ntej ntawm &[Daim duab} code kom tshem tawm qhov tseem ceeb thiab muab tso rau qhov chaw nkag rau pem hauv ntej ntawm tus lej.
Image - Nias lub Enter tus yuam sij rau ntawm cov keyboard ob peb zaug kom ntxig cov kab dawb paug saum daim duab.
- Lub thawv header yuav tsum nthuav dav thiab [Daim duab} code txav mus rau hauv qab hauv daim ntawv ua haujlwm.
- Nyem rau ntawm ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm kom tawm hauv lub thawv Header thiab kos rau ntawm txoj haujlwm tshiab ntawm cov duab watermark. Daim duab watermark qhov chaw yuav tsum hloov kho
- Ntxiv cov kab dawb ntxiv yog tias tsim nyog lossis siv tus yuam sij Backspace ntawm cov keyboard kom tshem tawm cov kab ntau dhau nyob rau pem hauv ntej ntawm &[Duab} code
Hloov lub Watermark
Koj tuaj yeem hloov pauv cov cim dej uas twb muaj lawm nrog cov duab tshiab, ib yam nkaus.
- mus rau Insert tab ntawm kab.
-
Click Header & Footer nyob rau hauv pawg ntawv ntawm lub ribbon.
- Nyem rau ntawm lub hauv paus header lub thawv xaiv nws. Lub &[Duab} code rau cov duab watermark nyob rau hauv lub thawv yuav tsum tau highlighted
-
Click Duab nyob rau hauv pab pawg Header & Footer Elements ntawm Header & Footer Tools tab. Lub thawv ntawv yuav qhib piav qhia tias tsuas yog ib daim duab tuaj yeem muab tso rau hauv txhua ntu ntawm lub taub hau.
Image - Click on the Replace khawm hauv lub thawv ntawv kom qhib lub Insert Picture dialog box.
- Xaiv kom pom cov duab hloov pauv.
- Nyem rau ntawm daim duab ua kom pom tseeb.
- Click the Insert khawm kom ntxig cov duab tshiab thiab kaw lub dialog box.
- Txuag cov kev hloov pauv rau koj daim ntawv ua haujlwm.
