Halkan waxaa ah casharro ku saabsan sida loogu daro watermark gudaha Microsoft Excel . Iyadoo Excel uusan bixineynin wax ikhtiyaar ah oo toos ah oo lagu geli karo calaamadaha biyaha buugaagta shaqada, waxaad weli calaamadin kartaa xaashida Excel . Waxaa jira talaabooyin aad u baahan tahay inaad sameyso si aad sidaas u sameyso. Hagahan, waxaan uga hadli doonaa laba siyaabood oo loogu dari karo calaamadda biyaha ee Excel . Aan bilowno!

Sida loogu daro Watermark gudaha Excel

Waxaa jira laba hab oo lagu geliyo calaamadda biyaha ee Microsoft Excel oo ay ku jiraan:

1. Ku dar Watermark adoo isticmaalaya faylka sawirka
2. Abuur oo ka dibna ku dar watermark

Aynu si faahfaahsan uga hadalno hababkan!

1] Ku dar ^(Add)Watermark adoo isticmaalaya faylka sawirka

Waxaad ku dari kartaa watermark buug - shaqeedka Excel^(Excel) adoo isticmaalaya sawirkaaga. Waxay noqon kartaa shaambad, sawirka astaantaada, ama sawir kasta oo aad rabto inaad isticmaasho si aad u calaamadiso faylka Excel . Aynu eegno tillaabooyinka gelitaanka watermark annagoo isticmaalayna habkan.

Marka hore, fur buuggaaga shaqada oo tag tabka^(Insert) Gelida. Laga bilaabo halkan, dhagsii Text > Header & Footer ikhtiyaarka cagaha.

Hadda, tabka Header & Footer ayaa ka soo muuqan doona ribbon -ka Excel . Tag oo ku dhufo ikhtiyaarka Sawirka .^(Picture)

Marka xigta, baadho oo ka soo deji sawirka watermark PC gaaga, Sawirka Bing^{(Bing Image Search)} , ama kaydinta OneDrive kaaga.

Tani waxay ku dari doontaa koodka &[sawirka]^(&[Picture]) madaxa. Kaliya^(Simply) dhagsii meel kasta oo xaashida ah oo sawirkaaga watermark-ka ayaa ka muuqan doona buugga shaqada.

Hadda, haddii aad rabto inaad dhigto sawirka watermark badhtanka buugga shaqada, si fudud u dhig cursorka ka hor iyo [Sawirka]^(&[Picture]) code oo taabo badhanka Geli si isdaba joog ah.^(Enter)

Hadda, dhagsii xaashida oo waxaad arki doontaa calaamaddaada biyaha oo ka soo baxaysa qiyaastii xarunta buugaaga shaqada ee Excel .

2] Samee^(Create) ka dibna ku dar Watermark gudaha Excel

Waxaad sidoo kale ku abuuri kartaa sawir cusub oo watermark gudaha Excel ka dibna waxaad ku dari kartaa buugga shaqada. Aynu nidhaahno waxaad doonaysaa inaad ku darto shaambad calaamad biyo ah sida Qarsoodi^{(Confidential)} , Qabyo^(Draft) , La ansixiyay^(Approved) , ama shay kale. Waxaad isticmaali kartaa astaanta WordArt^(WordArt) oo aad samaysato calaamad-biyood adiga kuu gaar ah oo aad geli karto xaashida Excel . Aynu aragno hab-raac tallaabo tallaabo ah si sidaas loo sameeyo.

Marka hore, u gudub tabka^{( Insert)} Gelida oo guji badhanka hoos u dhaca qoraalka . ^(Text)Hadda, dhagsii badhanka hoos-u-dhaca ee WordArt oo dooro ^(WordArt)WordArt -ka aad rabto inaad ku darto xaashida Excel .

Intaa ka dib, dhagsii WordArt si aad u geliso oo aad u habayso qoraalkaaga. Waxaad ku celin kartaa isla qoraalka xariiq cusub si aad u xoojiso.

Marka la sameeyo, midig-guji sanduuqa WordArt iyo ka menu macnaha guud, riix Save as Picture doorashada oo ku badbaadi sawirka meel kasta oo ku yaal PC-gaaga. Waxaad ka dooran kartaa qaabka sawirka aad rabto PNG , JPG , SVG , GIF , TIFF , iyo BMP .

Hadda, u gudub tabka^(Insert) Gelida oo ku dar Text > Header & Footer . Kadibna, laga bilaabo Header & Footer tab, dhagsii ikhtiyaarka Sawirka^(Picture) si aad ugu darto sawirka watermark.

Baadh sawirka watermark-ka ee aad hadda abuurtay oo ka soo deji kombuyutarkaaga. Ka dib waxaa lagu dari doonaa madaxa sida watermark.

Sida loo formatting watermark imagein Excel

Haddii aad rabto inaad qaabayso sawirkaaga watermark, dooro sawirka oo aad tabka Header & Footer . Hadda, dhagsii ikhtiyaarka Qaabka Sawirka^{(Format Picture)} si aad u furto xulashooyinka is-beddelka watermark kala duwan. Kuwani waa xulashooyinka:

• Waxaad dib u cabbiri kartaa sawirka watermark .^(resize)
• Waxay kuu ogolaanaysaa inaad gooyso sawirka watermark^(crop)
• Waxa kale oo aad ku dabaqi kartaa dhawr saamayn oo midabaynta^{(colouring effects)} sawirka watermark. Tusaale ahaan, haddii aadan rabin inaad xoogga saarto calaamadda biyaha, waxaad isticmaali kartaa saamaynta dhaqidda . ^(Washout)Sidoo kale, waxaad hagaajin kartaa dhalaalka iyo isbarbardhigga sawirka.
• Waxay kaloo bixisaa ikhtiyaar lagu cadaadiyo^{( compress)} sawirka watermark.

Ka dib markii aad habaynayso doorashooyinka sare, dhagsii badhanka OK oo sawirkaaga watermark waa la qaabayn doonaa.

Sidaas waxaad ku dari kartaa watermark gudaha Microsoft Excel .

Akhri soo socda^{(Read next)} : AutoSave oo aan ka shaqayn Office Excel, Word ama PowerPoint^{(AutoSave not working in Office Excel, Word or PowerPoint)} .

How to Add a Watermark in Excel

Here is a tutoriаl on how to add a watermark in Microsoft Excel. While Excel doesn’t provide any direct option to insert watermarks into your workbooks, you can still watermark an Excel sheet. Therе аre some stepѕ you need to perform in order to do so. In this guide, I am going to discuss two ways tо add a watermark in Εxcel. Let’s get started!

How to Add a Watermark in Excel

There are two methods to insert a watermark in Microsoft Excel including:

1. Add a Watermark using a picture file
2. Create and then add a watermark

Let’s discuss these methods in detail!

1] Add a Watermark using a picture file

You can add a watermark to an Excel workbook using your own picture. It can be a stamp, your logo image, or any image that you want to use to watermark an Excel file. Let’s check out the steps for inserting a watermark using this method.

Firstly, open your workbook and go to the Insert tab. From here, click on the Text > Header & Footer option.

Now, a Header & Footer tab will appear on the Excel ribbon. Go to it and click on the Picture option.

Next, browse and import the watermark image from your PC, Bing Image Search, or your OneDrive storage.

This will add an &[Picture] code to the header. Simply click anywhere on the sheet and your watermark image will appear in the workbook.

Now, if you want to put the watermark image at the centre of the workbook, simply place the cursor before &[Picture] code and press Enter button repeatedly.

Now, click on the sheet and you will see your watermark appearing at about the centre of your Excel workbook.

2] Create and then add a Watermark in Excel

You can also create a new watermark image in Excel and then add it to the workbook. Let’s say you want to add a stamp as a watermark like Confidential, Draft, Approved, or anything else. You can use the WordArt feature and create your own watermark which you can insert into an Excel sheet. Let’s see a step by step procedure to do so.

First, go to the Insert tab and click on the Text drop-down button. Now, click on the WordArt drop-down button and choose the desired WordArt to add to the Excel sheet.

After that, click on the WordArt to enter and customize your text. You can repeat the same text in new lines to emphasize it.

When done, right-click on the WordArt box and from the context menu, press the Save as Picture option and save the picture at any location on your PC. You can choose the desired image format from PNG, JPG, SVG, GIF, TIFF, and BMP.

Now, go to the Insert tab and add Text > Header & Footer. And then, from the Header & Footer tab, click on the Picture option to add a watermark image.

Browse the watermark image that you just created and import it from your PC. It will then be added to the header as a watermark.

How to format watermark imagein Excel

If you want to format your watermark image, select the image and go to the Header & Footer tab. Now, click on the Format Picture option to open up various watermark customization options. These are the options:

• You can resize the watermark image.
• It lets you crop a watermark image.
• You can also apply a few colouring effects to the watermark image. For example, if you don’t want to emphasize the watermark too much, you can use the Washout effect. Similarly, you can adjust the brightness and contrast of the image.
• It also provides an option to compress the watermark image.

After customizing the above options, click on the OK button and your watermark image will be formatted.

Thus you can add a watermark in Microsoft Excel.

Read next: AutoSave not working in Office Excel, Word or PowerPoint.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel