Add Watermark to an Excel Document

Unfortunately, the printed watermark feature is not available on any version of Excel (including Excel 2007, 2010). However, there are some workaround methods to add text or images into an Excel document that would result something similar to a watermark.



The followings are examples of Excel Documents with text and image "watermark":


Step-by-step to add a watermark to an Excel document (applied for Microsoft Word 97-2010):

A. TEXT WATERMARK: 
The trick is to place a WordArt on the background of the Excel sheet. 
Microsoft Excel 97/2000/XP (2002)/2003:

Open the Excel document that you want to add watermark to.
Select "Insert" from the top menu, then select "Picture" > "WordArt...".
In the "WordArt Gallery" dialog, select a WordArt style that you like then click "OK".
In the "Edit WordArt Text" dialog, type in your desired text, select the font style and size, then click "OK".
Right-click on the newly inserted WordArt on the Excel document, then select "Format WordArt...".
In the "Format WordArt..." dialog, select "No fill" for "Fill"/"Color".
Also select a brighter color (i.e. gray) for "Line"/"Color" then click "OK".
Right-click on the WordArt on the Excel document, then select "Order." > "Send to Back".
Click and drag the WordArt to position it where you like.
Note: The WordArt needs to be manually placed on each page of the document.
Microsoft Excel 2007/2010:

Open the Excel document that you want to add watermark to.
Select the "Insert" tab from the top menu, then in the group "Text", select "WordArt".
Select the WordArt style you want, then type the text for your watermark.
Under "Drawing Tools", select "Format".
In the group "WordArt Styles" change "Text Fill" to "No fill".
Also in the same group "WordArt Styles", change "Text Outline" to "Automatic".
In the group "Arrange" select "Send to Back".
Click and drag the WordArt to your preferred position.
Note: The WordArt needs to be manually placed on each page of the document.


B. IMAGE WATERMARK: 
To insert an image watermark, use the header feature in Excel as follows... 
Microsoft Excel 97/2000/XP (2002)/2003:

Open the Excel document that you want to add watermark to.
Select "View" from the top menu, then select "Header and Footer".
In the "Page Setup" dialog, click on the "Custom Header..." button in the middle of the dialog.
In the "Header" dialog, click on the middle box "Center section"
In the middle of this dialog box, there are some tool buttons. We're going to use the last two buttons to insert and format the image.
Click on the Insert Picture button (the second-to-last button with an image of a mountain)
Navigate to the folder where your watermark image is located. Select the image and click "Insert".
A text "&[Picture]" is now placed in the middle box named "Center section".
Click on the Format Picture button (the last, right-most button).
Adjust the scale and size if you wish, then select the "Picture" tab. Change the "Color" under "Image Control" to "Washout", then click "OK".
At this point, you can click "OK" to finish, and do a "Print Preview" to see your watermark. However, you will notice that the image is placed far on the top of the page, which doesn't look usual for watermarks. To fix this, click on the middle box named "Center section" again and enter a few blank lines before the text "&[Picture]".
Once you're all done, click "OK" to exit and open "Print Preview" to see your watermark. (The watermark will not be displayed in normal view.)
Microsoft Excel 2007/2010:

Open the Excel document that you want to add watermark to.
Select the "Insert" tab from the top menu, then in the group "Text", select "Header & Footer".
Excel will now switch to Page Layout view, and the cursor will be moved to the center top of the page.
On the "Design" Tab, in the group "Header & Footer elements" Select "Picture".
Navigate to the folder where your watermark image is located. Select the image and click "Insert".
A text "&[Picture]" is now placed in the middle box of the header.
To move the picture down on the page, click on the header and place the cursor before the text "&[Picture]", then hit Enter a few times.
To see the watermark, either open the "Print Preview" or click on any cell of the document.

Add Watermark to a Word Document

You can insert a watermark into a Microsoft Word document as either text or image. 
Here is a sample Word Document with text watermark:


And here is an example of picture watermark:
Step-by-step to add a watermark to Word document (applied for Microsoft Word 97-2010):

Microsoft Word 97/2000/XP (2002)/2003:

Open the Word document that you want to add watermark to.
Select "Format" from the top menu, then select "Background", then "Printed Watermark".
In the "Printed Watermark" dialog:

A. To insert a text watermark:
Select the "Text watermark".
Then, either select a pre-defined text from the drop-down, or type in your desire text on the "Text" field.
Customize your watermark with other options in this dialog such as text size, text color, etc, then click "OK".
Watermark is now inserted into your document.

B. To insert an image watermark:
Select the "Picture watermark".
Then click on the button "Select Picture...".
Navigate to the directory where your watermark picture is located. Select it and click "Insert".
Select a customized scale if desired, then click "OK".
The image is now inserted into your document as watermark.


Microsoft Word 2007/2010:

Open the Word document that you want to add watermark to.
Select the "Page Layout" Tab from the top menu
In the "Page Background" group, select "Watermark".
You can now select one of the pre-defined watermarks, or if you wish to use your own text/image, select "Custom Watermark" at the bottom.
At the "Printed Watermark" dialog:

A. To insert a text watermark:
Select the "Text watermark".
Then, either select a pre-defined text from the drop-down, or type in your desire text on the "Text" field.
Customize your watermark with other options in this dialog such as text size, text color, etc, then click "OK".
Watermark is now inserted into your document.

B. To insert an image watermark:
Select the "Picture watermark".
Then click on the button "Select Picture...".
Navigate to the directory where your watermark picture is located. Select it and click "Insert".
Select a customized scale if desired, then click "OK".
The image is now inserted into your document as watermark.

World Trade Center attack see on notepad

World Trade Center attack see on notepad

Do you know the flight number of the plane that had hit the World Trade Center on 9th November. The flight number was Q33NY and this brought it's own future. You may call this as a coincidence or something else because this alphabets has some graphical view in other font style.

See the tricks below :

First open Notepad.
Type Q33N in capital letters into notepad.
Now go to Format -> Font and increase the font size to 72.
Now change the Font to Wingdings and click OK.

Make your personal Diary or Log-book

Make your personal Diary or Log-book

Do you ever use Notepad as a personal Log-book or simple digital diary? Well, if you didn't know how to do this then follow the steps to make one for yourself.

First open notepad.
Now type .LOG in capital letters and press enter. 
Then save it as any name and close it.
Now open it again.

Make text to audio converter

Make text to audio converter

Do you want to listen the speech which was written in text format? Then you have to make a text to audio converter. You can make it easily by writing some commands into notepad. The commands are given below.
Just copy the commands and paste it into notepad. Give the notepad any name.vbs (e.g. Speak.vbs), Save as type: All Files and Save it.

Copy the text below:
Dim message, sapi
message=InputBox("What do you want me to say?","Speak to Me powered by 001 Easy Tricks")
Set sapi=CreateObject("sapi.spvoice")
sapi.Speak message
After saving  it double click on .vbs file and write anything (in English) into the box and click OK.

Open Sites Blocked by College Server

Open Sites Blocked by College Server

Hello friends, today I am going to tell you how a blocked site can open. Some college or other server block some sites ( like facebook, youtube etc.) or some type of files ( .mp3, .iso, torrent etc. ) cannot download.


You can open this sites using proxy server like kproxy.com, bypassfron.info etc. But one or two days you can open the sites and next day you will see the proxy server is blocked. This is not good tricks. The other tricks is make secure authentication that means if youtube or facebook is block then type in url bar https://youtube.com or https://facebook.com (Note: type https:// , not http://). This tricks is batter than previous but it is also not a good tricks. because using this tricks you cannot play the blocked sites video.

You may use "Tor browser" to open any blocked sites. But it decrease your surfing and downloading speed.

Tor Browser software : Download

The best way is change your ip address and use fake ip address. You think how can you change your ip address? Don't worry. Just download a software which can hide your present ip address and use fake ip. You can use Platinum Hide IP software for this purpose. Install this software then hide your ip address. Now you can open any sites and also download.  
IP address hiding software(Platinum Hide IP) : Download

Video tutorial : Hide IP address by software

Increase your internet speed up to 20%

Increase your internet speed up to 20%
Most of the internet user don't know that Microsoft reserved 20% of your available bandwidth. They reserve this for their own purpose like Windows update and interrogating your PC etc. Today I will tell you how to increase your internet speed up to 20%.


Step 1: Click START menu then RUN and type "gpedit.msc". Don't use quotes ( " " ). This opens the Local Group Policy Editor.

Step 2: Then go to Local computer policy and open Computer Configuration folder.

Step 3: In Computer Configuration open Administrative Templates and then open Network.

Step 4: Open QoS Packet Scheduler and double click on Limited reservable bandwidth.

It will say that it is Not Configured, but you will see under Explain tab i.e. By default it reserve 20% of your bandwidth.

You click on Enabled reservable bandwidth then set it to ZERO. This is how you will increase your Internet speed up to 20%.