How to fix or freeze header in Microsoft Excel 2007?

In Microsoft Excel 2007, you can freeze the top row of the spreadsheet so that you always see the top headers in the first row at all times. When you are working with a very long spread sheet, Freezing Headers helps to work faster and better.

Steps to freeze header in Microsoft Excel 2007:

1. Open Microsoft Excel 2007 on your computer. At the top of the Office Ribbon, click on the “View” tab.
2. Click the “Freeze Panes” button and you will see a drop down. Now click the “Freeze Top Row” to freeze the top row.

Scroll down your document and the top row is always frozen.

What is Thanksgiving? Why is Thanksgiving Day celebrated?

Thanksgiving Day is a harvest festival celebrated primarily in the United States and Canada. Traditionally, it has been a time to give thanks for a bountiful harvest. While it may have been religious in origin, Thanksgiving is now primarily identified as a secular holiday. Today Thanksgiving is celebrated as a time to get together with family or friends. Turkey is definitely a popular food on Thanksgiving! That's why it is sometimes casually referred to as Turkey Day.

In Canada, Thanksgiving Day is celebrated on the second Monday in October, which is Columbus Day in the United States. In the United States, it falls on the fourth Thursday of November.

History of Thanksgiving:

The event that Americans commonly call the "First Thanksgiving" was celebrated to give thanks to God for helping the Pilgrims of Plymouth Colony survive their first brutal winter in New England. The first Thanksgiving feast lasted three days, providing enough food for 53 pilgrims and 90 Native Americans. The feast consisted of fish (cod, eels, and bass) and shellfish (clams, lobster, and mussels), wild fowl (ducks, geese, swans, and turkey), venison, berries and fruit, vegetables (peas, pumpkin, beetroot and possibly, wild or cultivated onion), harvest grains (barley and wheat), and the beans, dried Indian maize or corn, and squash. The New England colonists were accustomed to regularly celebrating "Thanksgivings"—days of prayer thanking God for blessings such as military victory or the end of a drought.

How to change Blog Article titles to increase traffic

For good web traffic, the Blog Article titles must be attractive with nice keywords. By default, the blog title comes as <Blog title>:<Article Title>. Thus the blog title always comes first.

Better SEO practice is to show article title first. It will increase your search engine rank significantly.

Follow bellow steps to change your Blog Article titles to increase traffic:

1. Go to Design --> Edit HTML
2. In Edit Template box find this code:

<title><data:blog.pageTitle/></title>

3. Now replace the above code with below code:

<!-- Title modified to "Article title | Page title" -->
<b:if cond='data:blog.pageType == "item"'>
<title><data:blog.pageName/> |
<data:blog.title/></title>
<b:else/>
<title><data:blog.pageTitle/></title>
</b:if>
<!-- Title modification ends -->

Now you are done.

It may take few days for Google to re-index your blog. Track your blog to see the increase in traffic.
Click here to see other useful Blogger tips

RockMelt: New web browser with Search and FaceBook integrated

A new web browser named RockMelt is coming in few days (now in Beta Test) to market. RockMelt requires a Facebook log-in in the beginning. It will be a handy tool for those who are very active in social networking sites like facebook and twitter.

Rockmelt is designed to let users share everything they do with the friends on Facebook and Twitter.

Down the side of each web page visited, there is a selection of each user's most-used Facebook Friends and Twitter contacts.

I would love RockMelt as it will be a friendly Browser. Watch the below video to get a clear idea about the new Browser.

How to add Twitter and facebook buttons in your blog or Website?

If you Have a blog or website and you want to share your contents/ articles in social media like facebook, twitter etc, then there are many controls available in the net which will enable you to easily share your contents in the web.

The easiest one I found for sharing web contents is AddThis.

Follow the below steps to create your own account:
1. Just check the website http://www.addthis.com/ to get the Addthis toolbar. 2. Create your account and Customize the ToolBar.
3. Add the gadget to your blog or website.

Now you can attract more and more traffic to your website by easy sharing.

How to remove kontera or text advertisements from websites?

If you are feeling annoyed by Kontera Ads or inline text advertisements, there is a work around to fix it.

Steps to Block Kontera Ads in IE...

1. Go to Tools > Options (Or Internet Options in IE 8) > Security > Restricted sites >
2. Add http//*.kontera.com/ to the restricted sites, and you won't have the annoying popups from this sites anymore.

If you want to block ads from other sources, find out the website the ad belongs to and follow above steps to block that website.