Excel Watermark Step by Step Tutorial

01 ye 02

Isai Watermark mu Excel

Excel Watermark Overview

Excel haisanganisi chechokwadi ye watermark , asi iwe unogona kuisa faira yefaira mumusoro kana kuti nheyo yepamusoro kuti uone yakatarisa watermark.

Mukuona watermarking inowanikwa, ruzivo runowanzoburitsa mavara kana logo iyo inozivisa muridzi wacho kana inotsvaga mhizha mune imwe nzira.

Mumufananidzo uri pamusoro apa, firiji yefaira ine shoko rakanyorwa rakaiswa mu musoro we Excel worksheet .

Sezvo misoro nemakumbo zvinowanzoratidzwa pane peji rimwe nerimwe rebhuku rebhuku, nzira iyi ye watermarking inzira inobatsira yekuvimbisa kuti chinyorwa kana zvimwe zvimwe zvinodiwa zvinowanika pamapeji ose.

Watermark Example

Muenzaniso unotevera unotora matanho ekutevera muExcel anodiwa kuisa mufananidzo mu musoro uye kuisa mukati mehwendefa risina chinhu.

Izvi zvidzidzo hazvirevi matanho ekutevera nekusika iyo faira faira pachayo.

Ifa yefaira rine izwi raDraft kana mamwe mavara akafanana anogona kugadzirwa chero purogiramu ipi zvayo yekuita sePaint program yakabatanidzwa ne Microsoft Windows operating system.

Kuti uite kuti utange, firimu yefaira inoshandiswa mumuenzaniso uyu ine zvinhu zvinotevera:

• Mifananidzo: Gills Sans MT
• Kukura: 72 pfungwa
• Muvara: Gira - 25%

Cherechedza: Windows Paint haina kusarudza sarudzo yekushandura rugwaro sezvinoratidzwa mumufananidzo uri pamusoro.

Peji Yakaona Ona

Musoro uye mabheji zvakawedzerwa pane pepa rekushandurwa kwePairji yekuona.

Kusvikira pamatatu matatu uye zvitatu zvitanhatu zvinogona kuwedzerwa kune peji uchishandisa mabheji uye mabhokisi etsoka anowanikwa muCheta yeCheta .

Nokutadza, iyo central header box inosarudzwa - iyi ndiyo iyo watermark mufananidzo ichaiswa mune iyi tutori.

Tutorial Steps

1. Dzvanya pa Inser tab yebhoni
2. Dzvanya ku Header & Footer icon kusvika kumucheto wekona webhoni
3. Kushandura paiyo icon kushandura Excel kuIndaneti Kuona maziso uye inovhura tende itsva pamabhoni anonzi Header & Footer Tools
4. Pane iyi itsva tab tsvaga pane chinyamato chemufananidzo kuti uzarure Insert Picture dialog box
5. Mubhokisi rebhokisi rinotarisa kuti uwane firiji yefaira iyo ichaiswa mumusoro
6. Dzvanya pamufananidzo wefaira kuti uonekwe
7. Dzvanya paIndaneti bhokisi kuti uise mufananidzo uye uvhare bhokisi rebhokisi
8. Iyo watermark chimiro haicho kuonekwa nokukurumidza asi ne & [Mufananidzo} kodeti inofanira kuonekwa mukati mebhokisi yepamusoro yebhokisi remabasa
9. Dzvanya pane chero sero riri mupeji yebasa kuti usiye bhokisi re Header box
10. Iyo watermark image inofanira kuonekwa pedyo nepamusoro pebasa rebasa

Kudzokera kuNyama Yakatarisa

Paunenge wawedzera watermark, Excel inokusiya iwe paIndaneti Maonero. Kunyange zvazvo zvichikwanisika kushanda mumaonero aya, unogona kudzokera kuZviro zvemazuva ose . Kuita izvi:

1. Dzvanya pane chero sero riri mupeji rekushanda kuti usiye musoro wepamusoro.
2. Dzvanya paIndaneti tab
3. Dzvanya pamufananidzo wakajairika mubhubhoni

Peji 2 yeyikudzidzisa inobatanidza matanho e:

• kudzorerazve watermark mumushandi webasa
• kubvisa watermark image
• kutora nzvimbo ye watermark
• kutarisa watermark in print preview

02 of 02

Excel Watermark Tutorial con't

Kuisa mufananidzo we Watermark

Kana zvichidiwa, iyo watermark image inogona kutamirwa pasi kusvika pakati pebasa rekushanda sezvinoonekwa mumufananidzo uri pamusoro.

Izvi zvinoitwa nekuwedzera mitsetse isina ruvara pamberi pe & [Mufananidzo} kemo kuburikidza neKuisa kwekibhokisi.

Kudzorerazve watermark:

1. Kana zvichidikanwa, chengetera ku Header & Footer icon pane Insert tab kuti upe Peji Yokuona
2. Dzvanya pamusoro webhokisi rebhokisi kuti uisarudze
3. The & [Mufananidzo} kodeji yemufananidzo we watermark mubhokisi inofanira kuiswa pachena
4. Dzvanya pamberi pe & [Mufananidzo} kodeji kuti ubvise zvakasimbiswa uye kuisa iyo insertion point pamberi pekhodi
5. Dhinda pikicha inopinda pakibhodi kakawanda kuti uise mitsetse isina chinhu pamusoro pechifananidzo
6. Musoro webhokisi inofanira kuwedzera uye i & [Mufananidzo} kodeji inofamba ichienda pasi pasi pepaji
7. Kuti uone nzvimbo itsva yewatermark image, chengetera pane chero sero riri mubasa rekushanda kuti usiye bhokisi re Header box
8. Iko watermark yemufananidzo iyo inofanira kuvandudzwa
9. Wedzera mamwe magwaro asina kuvhaka kana zvichidiwa kana shandisa ikakona Backspace pane keyboard kuti ubvise mitsetse yakawandisa isina mberi pamberi pe & [Mufananidzo] code

Kudzorera Watermark

Kuti udzorere watermark yepakutanga nemufananidzo mutsva:

1. Kana zvichidikanwa, chengetera ku Header & Footer icon pane Insert tab kuti upe Peji Yokuona
2. Dzvanya pamusoro webhokisi rebhokisi kuti uisarudze
3. The & [Mufananidzo} kodeji yemufananidzo we watermark mubhokisi inofanira kuiswa pachena
4. Dzvanya pamufananidzo wemifananidzo
5. Mharidzo yebhokisi ichazarura ichitsanangura kuti mufananidzo mumwe chete unogona kuiswa mune chimwe chikamu chemukoko
6. Dzvanya pakudzorera Bhokisi mubhokisi remashoko kuti uzarure Insert Picture dialog box
7. Mubhokisi rebhokisi rega kutsvaga kuti uwane iyo firimu yefaira
8. Dzvanya pamufananidzo wefaira kuti uonekwe
9. Dzvanya paIngeni bhatani kuti uise mufananidzo mutsva uye uvhare bhokisi rebhokisi

Kubvisa Watermark

Kubvisa watermark zvachose:

1. Kana zvichidikanwa, chengetera ku Header & Footer icon pane Insert tab kuti upe Peji Yokuona
2. Dzvanya pamusoro webhokisi rebhokisi kuti uisarudze
3. Dhinda chura kana kuti Backspace key pane keyboard kuti ubvise & [Mufananidzo} code
4. Dzvanya pane chero sero riri mupeji yebasa kuti usiye bhokisi re Header box
5. Izvo watermark chifananidzo chinofanira kubviswa kubva pakushanda

Kuona Watermark muChirangaridzo Chinyorwa

Sezvo misoro nemakumbo zvisingaratidziki muNowanzoona muExcel unofanira kushandura maonero kuti uone watermark.

Mukuwedzera pane Peji Yokuona maonero apo watermark chifananidzo chawedzerwa, watermark inogonawo kuonekwa muChinyorwa chePasita :

Cherechedza : Unofanirwa kuva ne printer yakaiswa pakombiyuta yako kushandisa Printing Preview .

Kuchinja kuChirangaridzo Chinyorwa

1. Dzvanya paIfaira tab yebhoni
2. Dzvanya kuDhinda mu menu
3. Pepa rako rekushandira uye watermark rinofanira kuonekwa pane pepanho rekuona kurudyi kwekona

Kushandura kuChirangaridzo Chinyorwa mu Excel 2007

1. Dzvanya paIfisi Button
2. Sarudza Chinyorwa> Print Preview kubva pakaderera menu
3. Chinyorwa Chekuona Zvinyorwa chichazarura kuisa pepa rekushandira uye watermark