Wednesday, November 28, 2012

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:

  1. Open the Excel document that you want to add watermark to.

  2. Select "Insert" from the top menu, then select "Picture" > "WordArt...".

  3. In the "WordArt Gallery" dialog, select a WordArt style that you like then click "OK".

  4. In the "Edit WordArt Text" dialog, type in your desired text, select the font style and size, then click "OK".

  5. Right-click on the newly inserted WordArt on the Excel document, then select "Format WordArt...".

  6. 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".

  7. Right-click on the WordArt on the Excel document, then select "Order." > "Send to Back".

  8. 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:

  1. Open the Excel document that you want to add watermark to.

  2. Select the "Insert" tab from the top menu, then in the group "Text", select "WordArt".

  3. Select the WordArt style you want, then type the text for your watermark.

  4. Under "Drawing Tools", select "Format".

  5. In the group "WordArt Styles" change "Text Fill" to "No fill".

  6. Also in the same group "WordArt Styles", change "Text Outline" to "Automatic".

  7. In the group "Arrange" select "Send to Back".

  8. 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:

  1. Open the Excel document that you want to add watermark to.

  2. Select "View" from the top menu, then select "Header and Footer".

  3. In the "Page Setup" dialog, click on the "Custom Header..." button in the middle of the dialog.

  4. In the "Header" dialog, click on the middle box "Center section"

  5. 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.

  6. Click on the Insert Picture button (the second-to-last button with an image of a mountain)

  7. Navigate to the folder where your watermark image is located. Select the image and click "Insert".

  8. A text "&[Picture]" is now placed in the middle box named "Center section".

  9. Click on the Format Picture button (the last, right-most button).

  10. Adjust the scale and size if you wish, then select the "Picture" tab. Change the "Color" under "Image Control" to "Washout", then click "OK".

  11. 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]".

  12. 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:

  1. Open the Excel document that you want to add watermark to.

  2. Select the "Insert" tab from the top menu, then in the group "Text", select "Header & Footer".

  3. Excel will now switch to Page Layout view, and the cursor will be moved to the center top of the page.

  4. On the "Design" Tab, in the group "Header & Footer elements" Select "Picture".

  5. Navigate to the folder where your watermark image is located. Select the image and click "Insert".

  6. A text "&[Picture]" is now placed in the middle box of the header.

  7. 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.

  8. To see the watermark, either open the "Print Preview" or click on any cell of the document.

Tuesday, November 27, 2012

How to add watermark to a Word 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:

  1. Open the Word document that you want to add watermark to.

  2. Select "Format" from the top menu, then select "Background", then "Printed Watermark".

  3. 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:

  1. Open the Word document that you want to add watermark to.

  2. Select the "Page Layout" Tab from the top menu

  3. In the "Page Background" group, select "Watermark".

  4. 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.



Monday, November 26, 2012

Turn your iPhone/iPod 1.01 into remote control of your friends' computers. [TrickMaker ]

Make tricks on your friends' computers from iPhone/iPod.


TrickMaker is the perfect app to make "Tricks" on your friend's computer, in the office or even to your girlfriend, simply from your iPhone/iPod Touch. TrickMaker is the incredible application that turns your iPhone/iPod into a remote control for computer that allows you to take possession of a friend's PC, and remotely administer it by choosing from a large number of "Trick" provides.

Some Tricks available:

- Move the mouse cursor
- Show ScreenSaver
- Open and close the panel programs simulates pressing the Windows Start
- Switch off for two the second monitor
- chat between iPhone/iPod
- Open Close the sliding of the CD or DVD
- Reverse the mouse buttons
- Press the right left mouse
- Get a screenshot from the PC
- Playing sounds nice as Fart, Burp, from pc
- Beep Speaker
- Text to Speeh, convert your text into voice and play it from PC with many voice available, and many others.

The operation is very simple, you download and launch from the computer of your friend TrickMakerclient for PC (no installation required, TrickMaker is a standalone tool), free downloadable from the website http://trickmaker.dyndns.org , and put PinCode provided by the Client Windows into TrickMaker Client for iPhone/iPod. That's it, now you're ready to drive anyone crazy or prove to possess magical qualities.

Requirements for operation:
1. TrickMaker client for Windows (XP, Vista, Seven). Free download from http://trickmaker.dyndns.org

2. TrickMaker client app foriPhone/ iPod Touch with WIFI connection (WiFi)

Not only can you download it and start having fun.

Watch this video to learn more and comment below if you face problem.

http://www.youtube.com/watch?feature=player_embedded&v=mSGM4AC415Y

Disclaimer
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED
WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
INTERRUPTION).

Drive your friend crazy by this simple PC trick

This article of  mine is not for all you tech freaks. Because you all are already aware of this trick. This article is an ice breaking simple and old trick for those people who are not much aware of computer tricks, but aware about my blog.  :-) (Kidding).

Press Ctrl+Alt+Left Arrow on your key board. Something happened? Your desktop screen must flip horizontally and all your mouse should move in completely unintentional direction. But it is also possibility that nothing might happen. {Because this also depends on configuration of your PC } . If its works on your computer, your desktop screen should look like screenshot below



Although, if nothing happens, you can try this. Go to your desktop screen, right click then go to Graphic Options ->Hot Keys ->Enable . If you see "Enable" option already checked there and nothing is happening on pressing Ctrl+Alt+[Any arrow key on keyboard out of four arrow keys]. Then your pc probably does not support this feature of flipping your desktop vertically [Ctrl+Alt+Down Arrow or Up Arrow] or Horizontally [Ctrl+Alt+Down Arrow or Up Arrow] . Desktop can be restored to previous state by pressing the opposite arrow key with Ctrl+Alt sign.

It is quite possible that your friend might already know this trick of flipping desktop but its very rare that he knows enabling or disabling this feature by right clicking on desktop and then going to Graphic Options ->Hot Keys ->Enable/Disable to enable or disable this desktop flipping technique.

So what you can do to drive your friend crazy is,  press Ctrl+Alt+Left arrow while he is away and then go to Graphic Options ->Hot Keys ->Disable and disable this feature. So when he will be back he will not be able to restore his desktop without your help if he does not know about enabling or disabling this feature. :-)

Keep me posted on comment section if something interesting happens on your end.  :-p

Sunday, November 25, 2012

How to check which wordPress theme or plugin a site is using.

Sometime you may like a WordPress site or a feature of plugin being displayed on the site but you may not be sure about which theme that site is using. If you try to ask the owner of site by contacting through contact from, you probably will never get an answer because no one is going to tell you about their secret that you liked.

Well, we have a solution for this. You can check or determine which wordPress theme a site is using. To know this, go to http://whatwpthemeisthat.com , enter the url of wordpress site that you want to check for theme, and you will get the result.

This site also displays a list of most searched themes so you know which theme is most popular. It will also display a list of plugins being used on the wordPress site in some cases. But it cant check the name of a customized WordPress theme.

Friday, November 23, 2012

How to post your Tweets from USA while sitting in India

Yes, this can be done using twitter's random location Geotag feature.

On Twitter, if you do not wish to reveal your geographic location in your tweets, you can either completely disable the location feature from Twitter settings or you can can attach some random (read, fake) location to your tweet.

For instance, here’s a recent tweet that specific my location as the White House in Washington DC though it was written from a place that is at least 8000 miles away.

Fake your geographic location on Twitter

Attach any Location to your Tweets


Now most Twitter mobile clients won’t let you attach random locations to your tweets but there’s a web-based app called PleaseDontStalkMe.com that may come handy here. Here you can pick any location on a Google Map – either drag the marker or use the search box to reach an exact address – and tweet.

Since the Twitter website no longer displays the app name that was used to send that tweet, your followers on Twitter are less likely to know that you faked your location in the tweet. Do remember to limit the length of your tweet to 140 characters else the tweet would fail but without offering an explanation.

You can geotag your tweets from the Twitter.com website as well (click the Location icon near the tweet button) but in that case, you can only attach a city-level location to the tweet and not an exact location.