Set IP Address using command in Windows

Some times require to set large number of static IP address in your company. Rather than setting it manually we can use batch file using "netsh"  command to set IP. After that you need to change IP address in batch file and run it on another Computer. "netsh" is windows utility which allows local and remote configuration of network devices. You can use below command to set IP address.

ipconfig /flushdns

ipconfig /release

netsh interface ip set address "Local Area Connection" static 10.195.82.113 255.0.0.0 10.195.82.1

netsh interface ip set dns name="Local Area Connection" static 8.8.8.8

netsh interface ip add dns name="Local Area Connection" 8.8.4.4  index=2

netsh interface set interface "Local Area Connection" disable

netsh interface set interface "Local Area Connection" enabled

where IP Address is 10.195.82.113 Subnetmask :255.255.0.0 Gateway:10.195.82.1 Primary DNS:8.8.8.8 and Secondary DNS is : 8.8.4.4

You may download script file from Here

Find Lost Android Cell Phone Easily

Google’s makes easier to find your misplaced cell phone. To use this feature you need to enable location service in your android mobile and add your device to Android Device Manager in Google. You may use Android Device Manager to find mobile. Now Google has introduced new query to find your phone.  You need to just fire a query in Google Search box after login in to google account. The query is Where is my phone?.

With help of google power searching and advanced power searching.

Download YouTube video online

Its very simple to download YouTube video without any video downloading software. To download video follow below step.

• Browse for the video, you want to download.
• Copy full URL of video and paste it in savefrom.net website. Now click on download button and video downloading will start.

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.