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.

How to manage your online passwords to be safe Online?

How to manage your online passwords to be safe Online?

All of you are using many websites like Facebook, orkut, gmail, yahoo, msn, youtube, amazon and many more on a daily basis. It's very important to be safe online and stay away from hackers.

The best solution is to create difficult password for different websites and then make them difficult to guess. But, it is hard to maintain so many passwords.

Here is a very good video that illustrates how you can achieve this solution with great ease. This video was produced by Mozilla Security team on public interest.



Here is a summary of the video:

Secure passwords

#Asits9:Amz #Asits9:Ytb #Asits9:Fbk

1. Start with a familiar phrase
2. Add Special characters
3. Customize for each website

Track Your EMS/ Speed Post /Express Parcel Post Article Online

You can easily keep track of your EMS/ Speed Post /Express Parcel Post Article online in Indian Post Official website.

You need following three things before you can use Indian Post website for tracking an article:

1. Article Number
2. Date of Booking
3. A valid email ID to receive delivery Information of your Speed Post on e-mail

Click here to track your EMS/ Speed Post /Express Parcel Post Article

How to track your Speed Post through SMS

You can track your speed post easily by SMS:



The steps involved:
1) You need to send SMS to 55352 in the following format:
For Speed Post:
SP<space>Speed Post number
OR
EMS<space>Speed Post number
For eMO:
MO<space>eMO PNR No
OR
EMO<space>eMO PNR No
2) 'IN' at the end of Speed Post number need not be given. Eg. if the Speed Post number is EK123456789in; you need to send the message as: SP EK123456789 The service is not case sensitive - you may use capitals or lower case or a mix of both.

3) Speed Post data is available from 19 September 2009 onwards.
eMO data is available from 23 September 2009 onwards.
4) The data will be retained upto 3 months from the date of booking for the purpose of SMS tracking.
5) The service is available across all service providers in the country. Rates charged by the service provider are applicable.

Refer http://indiapost.gov.in for more details.

What is a Superbug?

A bacteria which is resistant to all the anti-biotics is called a Super bug. The recently discoveded bacteria NDM-1 is a Superbug.

Information about new rupee symbol

The Indian rupee (code: INR) is the official currency of India. The curent Rupee symbol is:

Origin:

On March 5, 2009 the Indian government announced a contest to create a symbol for the rupee. During the Union Budget 2010, Finance Minister Pranab Mukherjee mentioned that proposed symbol would reflect and capture the Indian ethos and culture. Five symbols had been short listed, and the Cabinet selected the definitive symbol created by D Udaya Kumar on 15 July 2010 as the Rupee Symbol.

The symbol is a taken from the Devanagari ‘र’. The parallel lines at the top (with white space between them) make an allusion to the tricolor Indian flag and also depict an equality sign which symbolizes the nation's desire to reduce economic disparity. The Indian government already adopted the new rupee symbol in the country. It will be adopted globally within 18 to 24 months.

Prior to this, the most commonly used symbols for the rupee have been Rs., Re. or रू.

More info on Indian Rupee at wikipedia.

Google Search made very easier in Google Chrome browser

Google Search made very easier in Google Chrome browser:

Now Google Chrome address bar acts as a search engine. It's very convinient to search directly from the address bar.

Just enter the key word to search in Address bar and press enter. You will see the search results below. See how things became easier now!





By default, the search engine is Google. But you have an option to change it to Yahoo or Bing if you like.

Steps to set up Default search engine in Google Chrome:

1. Click on the Settings Icon at the top right of chrome browser and Select Options from that.
2. A new window will open.
3. Inside the Basics Tab,change the default search option to your desired one.





Get more computer tips at http://expertanswer.blogspot.com/search/label/Computer%20Tips

Images not displaying in gmail in IE

If you are opening gmail in Chrome or Firefox, images load fine. But when you open gmail in Internet Explorer (IE), images don't load at all.

You may get a warning like below:
"Do you want to view only the webpage content that was delivered Securely?"

Even after you allow to show images, still images don't display. Only Text message appears.

It's not a big problem. It's a bug in IE.

Here is the fix:
1. In IE, go to Tools --> Internet Options

2. Go to Security Tab.
3. Select Internet (if not selected by default)
4. Click on custom level

5. Under Miscellaneous, on Display Mixed Content, change from Prompt to Enable.

Click here to know more computer tips.

How to delete facebook account permanently?

Are you fed up or bored with Facebook? Do you want to delete your Facebook account permanently?

Follow the below link to delete Facebook account:
http://www.facebook.com/help/contact.php?show_form=delete_account

Click "Submit" and follow the instructions.

Your account will be deactivated for two weeks, and if you DO NOT USE FACEBOOK IN ANY WAY during that period, your account is permanently deleted.

Note: Don't login to facebook within 14 days after requesting to delete your account. Otherwise, it will again activate the account.

.

how to send exe or dll or application file with gmail

While sending an email with exe, dll, ocx, com or bat file as attachment in gmail, are you getting error message like below:

"This is an executable file. For security reasons, Gmail does not allow you to send this type of file."

Don't worry. Here is a method by which you send any type of file in your gmail.

1. Open your My computer. On the top menu beside file, edit and view, you can find Tools. Now go to Folder Options in it. A window will pop up.

2. In that window, click on the View tab. Now find Hide extensions for known file types and uncheck it. Now click Ok.

3. Go to the folder containing the .exe file or some other file which is to be sent over the Gmail. Change the file extension of the file to other extensions which Gmail allows like .jpeg or .GIF [e.g. If the file program.exe is to be sent, rename it to program.jpeg] and attach and send the file.If you have a large file, do the above steps and then Zip it. You can't send just by zipping, as gmail scans extensions in zip files also.
4. At the recievers end, after downloading the file, ask them to get it renamed again to the original file extension.

It's very simple and helpful tips.

.

How can I speak English fluently and confidently?

How can I talk in English without any fear?

If you are afraid of speaking in English, or you are not able to talk in english fluently, then read below:

Dear Friend, I had a good english writing skill, but I was very much hesitant while speaking. I was afraid of making mistakes. I followed one method which gave me tremendous confidence to speak fluently.

That is, by talking in English as much as possible. Talk with friends, parents (if they are able to talk in english). Forget your mistakes and keep talking. Surely you will get the confidence to speak english soon.

Apart from it, you must do following things to fine tune your english and do proper pronunciation.


1. Read one english news paper daily.
2. Watch one engligh news channel daily.
3. Watch good english movies may be one in a week.
4. Write articles on topics of your interest in your free time.

How to take full snap shot of a scrolling web page?

How to take snap shot of a complete web page?
What is the best Screen capture software available?

Using Print Screen, we can only take a snap shot of the currently visible portion of the website. But there are many tools which allows to scroll till bottom of the page and take a complete snap shot.

I found one very useful tool called snagit which allows me to take snap shot of a web page till bottom of it by scrolling through the web page.

There is a 30 days free trial version to download. Download it and enjoy. http://www.techsmith.com/screen-capture.asp

Snippy is also another nice tool. It’s very small and doesn't require to install it. Just run the exe and use it.
Download at http://www.bhelpuri.net/Snippy/default.htm

How to remove Internet Explorer provided by Dell from IE?

What is the registry key to remove Internet Explorer provided by Dell?

When using Internet Explorer on Dell computer at the top of all web pages, it says Internet Explorer provided by Dell. If you don't like this and want to change it to your own custom message or simply "Internet Explorer", just follow the following steps:

1. "Go to Start --> Run" or "Press Windows Key + R"
2. Type regedit inside Run. Hit Enter.
3. Registry Editor will Open.
4. Go to the following node:
computer\HKEY\CURRENT_USER\Software\Microsoft\Internet Explorer\Main\Window Title
5. Double Click on Window Title and edit the text. Press OK.
6. Open a new IE window. The IE title should have been changed now.

List of States and Union Territories in India

Here is a list of States and Union Territories in India. The list is sorted in alphabetical order.

Andaman and Nicobar Islands
Andhra Pradesh
Arunachal Pradesh
Assam
Bihar
Chandigarh
Chhattisgarh
Dadra and Nagar Haveli
Daman and Diu
Delhi
Goa
Gujarat
Haryana
Himachal Pradesh
Jammu and Kashmir
Jharkhand
Karnataka
Kerala
Lakshadweep
Madhya Pradesh
Maharashtra
Manipur
Meghalaya
Mizoram
Nagaland
Orissa
Pondicherry
Punjab
Rajasthan
Sikkim
Tamil Nadu
Tripura
Uttaranchal
Uttar Pradesh
West Bengal

Best jobportals in India

There are many Job portals in India. But here is a list of the market leaders. They are the best in service and first choice of job seekers as well as employers.

1. Naukri.com - The best and most popular job site in India. Upload your updated resume there. The employers willntact you soon. -
http://www.naukri.com/
2. Monster India - Another best job portal. Very nice site for job seekers and employers. - http://www.monsterindia.com/
3. Times Jobs - A Popular job Site helping Job Seeker find the right job
http://www.timesjobs.com/
4. Freshers World - Very useful Job site for Freshers. It also contains interview guidance, interview questions and experience of freshers who got job.
http://www.freshersworld.com/
5. CareerJet - Careerjet is an employment search engine.
http://www.careerjet.com/
6. Naukri Hub - Perfect website for Jobs in india as well as Abroad
http://www.naukrihub.com/
7. Bixee - Another Popular job site in India
http://www.bixee.com/
8. Career Age - India's complete Job and Career Companion
http://www.careerage.com/
9. Click Jobs - Another Popular job site in India
http://www.clickjobs.com/

Download or watch movies online

Here are few sites where you can download or watch movies online:

http://veoh.com
http://bharatmovies.com
http://freemoviesontheinter.net/
http://www.downloadorwatchonline.com/
http://tvserieshub.com/
http://www.watch-movies.net.in/
http://www.movieberry.com

How to embedd adsense code after title of article in blogger / blogspot blog?

1. First get code for AdSense for Content by logging into your Adsense account.

Code will look similar to below code:
-----------------------
<script type="text/javascript"><!--
google_ad_client = "pub-XXXXXXXXXXXXXXXXX";
/* 300x250, created 4/14/10 */
google_ad_slot = "8008538307";
google_ad_width = 300;
google_ad_height = 250;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
-----------------------

2. Now replace <, > and " with following characters:

< with &lt;
> with &gt;
" with &quot;

3. Now the code should look like below:
-----------------------
&lt;script type=&quot;text/javascript&quot;&gt;&lt;!--
google_ad_client = &quot;pub-XXXXXXXXXXXXXXXXXXXX&quot;;
/* 300x250, created 4/14/10 */
google_ad_slot = &quot;8008538307&quot;;
google_ad_width = 300;
google_ad_height = 250;
//--&gt;
&lt;/script&gt;
&lt;script type=&quot;text/javascript&quot;
src=&quot;http://pagead2.googlesyndication.com/pagead/show_ads.js&quot;&gt;
&lt;/script&gt;
-----------------------

4. Now you need to change your blogger template.
a. Login to blogger, go to Dashboard
b. Click Layout and then Edit HTML
c. Select/Check the Expand Widget Templates check box.
d. Now search for data:post.body
e. Put the below code just before data:post.body

<div style='float: left;'>

</div>
f. Now add the above modified google adsense code in between those two div tags.

<div style=’float: left;’>
google ad here
</div>

You are done now. Save the template. Now the google ad will show just after your title of post.

Click here to see other useful Blogger tips

Read SMS.. Earn money to support your mobile Bill

Who says there are no shortcuts to money making? I have just found one. It's called mGinger. They inform you about the best deals and discounts in the city and also pay you for each incoming SMS. Cool stuff, check it out!

How can I earn maximum through mGinger?

Join using below link:
http://mGinger.com/index.jsp?inviteId=30362

Where can I download NCERT e-Books for class I to class XII?

Where can I read NCERT books online?

What is the address of NCERT website?

National Council of Educational Research and Training (NCERT) website is http://www.ncert.nic.in/index.htm

Here you can find text books starting from class 1 till class 12. A very good site and really very helpful for students.

You can now read and download NCERT e-Books easily at NCERT website http://www.ncert.nic.in/textbooks/testing/Index.htm

SEO Tips: See how your website looks to search engines by Search engine spider simulator

Getting good rank in search engines like Google, Yahoo or MSN is very important rather a dream for any web master. Search engines can read only the text part in your site. If you have lot of images, videos or flash items, those will not be readable by search engines. Thus you need to have a proper balance of Text and (images, videos or flash items) in your site.

You can check how your site looks to search engines at the below search engine spider simulator.

Search Engine Spider Simulator Enter URL to Spider

eShabda - First Odia e-Magazine from eOdissa.com

We have released the first Odia / Oriya e-Magazine named eShabda. eShabda is a complete Odia magazine with all types of content like Stories, Poems, Paintings, Recipe, Tours and travels, Children special and many more. Hope you will enjoy reading eShabda. Here is it for you.

eShabda-jan2010

Follow below link if you are not able to read in above Scribd window.
Click Here to read eShabda

Also, you can read at Scribd if you are not able to read at the above link. Please send your feedback to improve our next issue. Also send your content at eshabda@eodissa.com or eodissa@gmail.com

Aishwarya Rai Wedding Pics

Here are the Aishwarya Rai and Abhishek Bachhan Wedding Pictures.

Where can I find Free Dotnet Projects and Interview questions

You can find Free Dotnet Projects at http://dotnetprojectninterviewquestions.blogspot.com/

Also, there are lot of Dotnet Interview Questions with hints / answers.

What is Vedic Mathematics? How to learn Vedic maths?

Vedic Mathematics is very much essential to boost your knowledge and increase your speed and accuracy of mathematics. Through Vedic mathematics you can calculate many calculations in mind. Vedic maths is very much helpful for students to score more marks in exams and also for job aspirants to score more marks in competitive exams.

Learn vedic maths at http://vedic-maths-fun.blogspot.com/

Engineering campus interview preparation through online test

Campus interview preparation for Engineering and MCA students in Online Test format

http://engg-campus-onlinetest.blogspot.com/ is a good site containing previous question paper of recruiting companies in Online Test format. It is designed to make you learn easily.

So, start preparing for Campus interview through Online test at http://engg-campus-onlinetest.blogspot.com/

Bank PO Clerical Exam - Preparation through Online Test

Bank PO Clerical Exam Online Test

http://allbankexam.blogspot.com/ is a good site containing all previous year Bank PO and Clerical Jobs question paper in Online Test format. It is designed to make your practice enjoyable.

So, start taking bank PO and clerical exam Online test at http://allbankexam.blogspot.com/

Where can I find Odia / Oriya Calender for year 2010?

Odia / Oriya Calender (Panjika) download for year 2010

You can find Odia calender at the premiere Odia web site www.eodissa.com

Calender link for view and download.


You can find many more things at www.eodissa.com like Odia poems, Poetry, Travel info, tourism, jobs, news, videos, game, forum, e-cards, wallpapers etc etc. Join the site and help improve Odia community.