How to enable extending formats and formulas in MS Excel 2007

To apply same formula or format to new raw after the row that contains the formula you must enable "Extend data ranges formats and formula" in excel. To enable this function do following.

• Click on Office Button (1) in Excel. Now click on Excel Options (2).

• In Excel Options click on Advance. 

• In right-pane Check the checkbox "Extend data range formats and formulas"  and Click on "Ok".

With help of Microsoft office website.

Block website using Host file

It`s a simple way to block website using hosts file. In windows 7 it`s located at "C:\Windows\System32\drivers\etc". Hosts file contain ip address and hostname. 

To edit host file you must have administrative privilege.

• Open notepad with  administrative privilege. Click on start > All Programs> Accessories. In Accessories right click on notepad and click on "Run As Administrator".

• In Notepad click on File menu and Click on Open..(Ctrl + O). Now browse for host file with above path and open the "hosts" File. You may also drag and drop hosts file on notepad.

Note : Hosts file contain ip address and hostname. Lines starting with d character are commented line and which is ignore by the system.

• Suppose you want to block website abc.com then add line like "127.0.0.1 abc.com" in hosts file. IP address 127.0.0.1 is IPV4 loopback address. "localhost" resolves to the loopback address. That means you mapped abc.com to your system so you cant access to abc.com.

Google Timer

Google launch timer facility for alert purpose and it will ringing when time limit ends.To use google timer facility do following.

First of all open Google web page and search for Timer. Search result shows following.

Now enter desire value of time limit in HH:MM:SS format. For example if you want timer for 10 second enter value as following, click on start and it will ringing after 10 second.

with Help of Google.

How to Undo ( Ctrl + Z ) Sent mail in Gmail

If by mistake you have sent email to person which is not your receiver or you have make mistake in typing information then don't worry. Gmail has introduce a way to Undo sent mail within specific time limit. Do following to enable this feature on your Gmail account.

• Login into your Gmail Account.
• Now click on icon like Gear which positioned above inbox and then click on Setting.

• Now in Setting menu click on Labs tab.

• Now find for Undo Send under Labs tab and in Undo Send select Enable radio button to enable it and at bottom click on Save Changes button to apply changes.

• Now click on General Tab under setting. And find for Undo Send:, now select check box Enable Undo Send and and select desire send cancellation period from drop down menu as shown in below image and click on Save Changes button to apply changes.

• Now send email and you will find Undo above inbox. Click on Undo to Undo send mail.