Taimako na Mataki na Excel Watermark Mataki na Mataki

01 na 02

Shigar da Watermark a Excel

Excel Watermark Overview

Excel ba ya hada da alamar ruwa mai gaskiya, amma zaka iya saka fayil din hoto a cikin takewa ko ƙafa don kimanta alamar ruwa mai gani.

A bayyane ruwan sha, bayanin shine yawancin rubutu ko alamar da ke nuna mai shi ko alamar kafofin watsa labarai ta wata hanya.

A cikin hoton da ke sama, an saka fayil din fayil wanda ke dauke da kalmar Draft zuwa rubutun takarda na Excel.

Tun da an nuna maƙallan kai da ƙafafun kowane shafi a kowane shafi na wannan littafi, wannan hanyar yin amfani da ruwa shine hanya mai sauƙi don tabbatar da cewa wani logo ko wasu bayanan da ake bukata a kan dukkan shafuka.

Misali Misalin

Misali na gaba yana rufe matakan da za a bi a cikin Excel wajibi don saka hoton a cikin maɓallin kai da kuma sanya shi a tsakiyar aikin aiki na blank.

Wannan koyawa bai ƙunshi matakai don bi don ƙirƙirar fayil din kanta ba.

Fayil din fayil wanda ke dauke da kalmar Mawalla ko sauran nau'in kama da haka za'a iya ƙirƙirar a kowane shirin zane kamar shirin Paint wanda ya haɗa da tsarin Windows Windows .

Don samun ka fara, fayil din da aka yi amfani dashi a wannan misali yana da halaye masu zuwa:

• Font: Gills Sans MT
• Girma: 72 points
• Launi: Grey - 25%

Note: Windows Paint ba ya hada da wani zaɓi don juyawa rubutu kamar yadda aka gani a cikin hoton da ke sama.

Layout View

Ana ƙara hotunan da ƙafa a cikin takardun aiki a cikin Layout view.

Za a iya ƙara zuwa matakai uku da ƙafa uku zuwa shafi ta amfani da akwatunan rubutun kai da ƙafarku waɗanda suka zama bayyane a cikin Shafin Layout .

Ta hanyar tsoho, an zaɓi akwatin zangon cibiyar - wannan shine inda za'a saka hotunan ruwa a cikin wannan koyo.

Tutorial Steps

1. Danna kan Saka shafin rubutun
2. Danna maɓallin Hanya & Hanya zuwa gefen dama na kintinkiri
3. Danna kan wannan icon yana sauke Excel zuwa Duba Layout Page kuma ya buɗe sabon shafin a kan rubutun da ake kira Rubutun kai & Hoto.
4. A kan wannan sabon shafin danna kan gunkin hoto don buɗe akwatin maganin Hoton
5. A cikin akwatin maganganun ke nema don gano fayil ɗin da za a saka a cikin rubutun
6. Danna kan fayil ɗin fayil don haskaka shi
7. Danna kan Insert button don saka hoton kuma rufe akwatin maganganu
8. Ba'a gani a bayyane ba a bayyane ba amma alamar [Picture} ya kamata ya bayyana a cikin akwatin saiti na harafin aiki
9. Danna kan kowane salula a cikin takardun aiki don barin yankin akwatin Rubutun
10. Ya kamata alamar alamar ta bayyana kusa da saman takardun aiki

Komawa zuwa Duba na al'ada

Da zarar ka kara da alamar ruwan, Excel ya bar ka a cikin Layout view. Duk da yake yana yiwuwa a yi aiki a cikin wannan ra'ayi, za ka iya so ka koma Duba ra'ayi. Don yin haka:

1. Danna kan kowane tantanin halitta a cikin takardun aiki don barin yanki.
2. Danna kan shafin Duba
3. Danna maɓallin al'ada a rubutun

Page 2 na wannan koyo ya haɗa da matakai don:

• Repositioning da watermark a cikin worksheet
• cire hotunan ruwa
• maye gurbin hotunan ruwa
• duba kallon ruwa a cikin rubutun asali

02 na 02

Excel Watermark Tutorial con't

Amincewa da Watermark

Idan ana so, ana iya motsa alamar mai zurfi zuwa tsakiyar aikin aiki kamar yadda aka gani a hoton da ke sama.

Anyi wannan ta ƙara lambobi marar layi a gaban lambar & image [Hoto] ta amfani da maɓallin shigarwa a kan maɓallin kewayawa.

Don sake mayar da alamar ruwa:

1. Idan ya cancanta, danna kan maɓallin BBC da Hanya a kan Saka shafin don shigar da duba Layout Page
2. Danna kan akwatin maɓallin tsakiya don zaɓar shi
3. Dole ne a nuna alama da [Picture} code for imagemarkmark in cikin akwatin
4. Danna gaban gaban lambar & Hoton [Hoton] don share haskaka da kuma sanya wurin sakawa a gaban lambar
5. Latsa maɓallin shigarwa a kan maɓallin rubutu sau da yawa don saka layi marasuka a sama da hoton
6. Dole ne akwatin buƙatar ya fadada kuma lambar [Picture] code zuwa ƙasa a cikin takardun aiki
7. Don bincika sabon matsayi na alamar ruwa, danna kan kowane tantanin halitta a cikin takardun aiki don barin wurin akwatin Rubutun
8. Yanayin hoto ya kamata ya sabunta
9. Ƙara ƙarin layi a cikin layi idan ya cancanta ko amfani da maɓallin Backspace a kan keyboard don cire matakan lalata a gaban gaban [ lambar]

Sauyawa da Watermark

Don maye gurbin ainihin alamar ruwa tare da sabon hoton:

1. Idan ya cancanta, danna kan maɓallin BBC da Hanya a kan Saka shafin don shigar da duba Layout Page
2. Danna kan akwatin maɓallin tsakiya don zaɓar shi
3. Dole ne a nuna alama da [Picture} code for imagemarkmark in cikin akwatin
4. Danna kan gunkin hoto
5. Akwatin sakon za ta bude bayanin cewa za'a iya sanya hoto guda ɗaya a cikin kowane sashe na BBC
6. Danna maɓallin Sauke a cikin akwatin saƙo don buɗe akwatin maganin Hoton
7. A cikin akwatin maganganun ke nemo don neman fayiloli mai sauyawa
8. Danna kan fayil ɗin fayil don haskaka shi
9. Danna kan Insert button don saka sabon image kuma rufe akwatin maganganu

Ana cire Watermark

Don cire alamar ruwa a gaba ɗaya:

1. Idan ya cancanta, danna kan maɓallin BBC da Hanya a kan Saka shafin don shigar da duba Layout Page
2. Danna kan akwatin maɓallin tsakiya don zaɓar shi
3. Danna maballin Share ko Backspace a kan keyboard don cire lambar & Hoton hoto
4. Danna kan kowane salula a cikin takardun aiki don barin yankin akwatin Rubutun
5. Ya kamata a cire hotunan ruwa daga takaddun aiki

Dubi Watermark a Tsarin Print

Tun da ba a bayyane kai ba a bayyane ba a bayyane yake a cikin Excel dole ne ka canza ra'ayoyi domin ganin alamar ruwa.

Bugu da ƙari, ga shafukan Layout na shafin inda aka kara maimaita hoto, ana iya ganin alamar ruwa a cikin Labarin Print :

Lura : Dole ne a shigar da takarda a kan kwamfutarka don amfani da Buga na Talla .

Gyarawa zuwa Buga Jaridar

1. Danna kan File shafin na kintinkiri
2. Danna Print a cikin menu
3. Ya kamata aikinku da alamar ruwa ya bayyana a cikin sashen dubawa a dama na allon

Sauya zuwa Buga Jarida a Excel 2007

1. Danna maɓallin Ofishin
2. Zaɓi Tuga> Shafin Farko daga menu na saukewa
3. Za'a bude allo na Bugawa na nuna nuna aikin aiki da alamar ruwa