How to strikethrough selected text in excel using shortcut keys

To draw a line across excel cells or selected text inside a cell, also know as striking through is actually really simple.  This is useful when reviewing excel files where you need another person to see what was deleted. All you need to do is.

Step 1: Select the Cells or text within the cells

Step 2: Press the key combination Ctrl + 5

That’s it. You are done

How to backup and restore skype chat history in Windows 7

Skype is the most popular instant messaging and free calling application out there. Most companies use skype as the official chat service. Its a great service. But there is one problem.
Skype history is available only in the machine you are using and cannot be accessed from other PC's. This is because skype chat history is NOT stored in the server but in your C: drive.


Using the steps mentioned below you can backup skype history from one machine and restore it to use in another machine.


Step 1 - Browse to C:\Users\<UserNameInTheMachine>


Step 2 - Open the AppData folder. If you don't see it, its hidden. To unhide select
Tools > Folder Options > View Tab > select the option "Show hidden files, folders and Drives" and click Apply


Step 3 - From the AppData folder, open up \Roaming\Skype folder


Step 4 - Copy all the contents in this folder and save it in a safe location or USB drive.


Now you have the Skype Chat History backup. Lets restore it in another machine.


Step 5 - Go to the machine which you need to view your skype history in and browse to the same location - C:\Users\<UserNameInTheMachine>\AppData\Roaming\Skype


Step 6 - Paste all the backup files and folders in the Skype folder. Click ‘yes’ to overwrite files and folders.

Your Skype history has been backed up. Enjoy!

How to embed YouTube videos in your Facebook profile

So you want to embed YouTube videos in your Facebook profile? You have come to the correct place. I will show you how to do this using the Application YouTube Box.



Step 1 - In the Facebook search box type in "YouTube Box" and click in the "Go to Application" button (You need to be logged in to Facebook first)

Step 2 - Click on the "Allow" button on the Request for Permission page

Step 3 - Click on the "Remove" button to remove the default videos.

Step 4 - Click on the "Add Video" link in the "All My Items" tab

Step 5 - Enter the Title and the embed code from YouTube and click on the "Add" button

Step 6 - Now go to your profile and click on the "Add new tab" button and search for YouTube Box


You should see something similar to the image below where I have added the video 
Science and the Quran ( WARNING - This video may cause you to ThinK ) - Part 2 of 2

YouTube video embeded in Facebook

Congratulation, You are done..

How to study while you’re on the move with your phone

Are you a student who needs to go through a note multiple times to remember what you studied? Welcome to the club. Here are some ways I found out to go through your notes wherever you are using the device you carry with you all the time, your Mobile.

Step 1 - Take pictures: They say a "picture is worth a thousand words", So use your phone's camera to take pictures of diagrams. Even complex diagrams can be viewed by zooming.

Step 2 - If your phone supports PDF files then download a mobile PDF reader to read your tutorials.

Step 3 - Make short notes of your notes by copying and pasting to notepad and then transfer the .txt file to your phone.

Now that you have got your notes in your mobile, you can study while you are travelling, idling and specially 20mins before the exam begins..

Believe me it helps, especially when you don’t have much time to sit and revise your notes and you are forgetful.

All the best!

How to add a twitter like fixed background image to blogger

Ever wanted to add a fixed background to your blog where your background stays fixed even if you scroll. This could be seen in all Twitter pages You can check out the freesoftware-coolsites.blogspot.com blog for the preview of what you are going to get when you are done after following the steps shown below.


Step 1 - Go to a Twitter Profile page and get the permission of the owner to use this background image OR Find a suitable background image with the optimum resolution to fit the blogger page size.


Step 2 - Right Click on the twitter page and View the Page Source.


Step 3 - Copy the background: element seen after the body { tag.
Ex: From IceTweets profile Copy background: #0099B9 url('http://a3.twimg.com/profile_background_images/33368149/
TwitterBG.jpg') fixed no-repeat top left;

Step 4 - Go to the image by pasting the image URL(Shown within Quotes 
above) in the address bar of the browser and Save the Image in you 
computer.


Step 5 - Upload this image to a free image hosting site and copy the URL 
of the Image you uploaded.

Step 6 - Now replace the new image URL with the one shown in Step 3.
Ex: background: #0099B9 url('newImageURL') fixed no-repeat top left;


Step 7 - Now log in to Blogger and go to Layout > Edit HTML and search for the body { tag.


Step 8 - Now replace the existing background: #; element with the new background: #0099B9 url('newImageURL') fixed no-repeat top left; element in Step 6 and Click on 'Save Template' button and then 'View Blog'.


Thats It.. You got your self a cool Twitter like fixed image background for your blog . Congrats....


I would like to see your blogs ones you are done...

How To Create a Blog

In this post I will give the steps on How To Create a Blog on Blogger.com

Step 1 - Go to http://www.blogger.com

Step 2 - Click on the 'Create a Blog' button

Step 3 - If you already have a Google account click on the sign in first link, and sign in to Google.
Step 3 - If you do not have a Google Account fill in the form and Click on 'Continue' button.

Step 4 - In the Name 'Name your blog' page Enter the Blog Title, Blog Address (You need to check if the blog address is used by someone else by clicking on the Check Availability link) and the Verification code and then click on the 'Continue' button.

Step 5 - Select the Template and your Done.

Thats It.. You got your self a blog. Congrats....

Now all you have to do is Create and Publish your posts. Enjoy..