Clear all formatting between the last cell and the data. 1  Do one of the following: To select all columns to the right of the last column that contains data, click the first column heading, hold down CTRL, and then click the column headings of the columns that you want to select.
Find your IP range by examining your subnet mask. Most likely, if you are using a simple home network, your IP address begins with 192.168.0 and your mask is 255.255.255.0. This mask means that the address range 192.168.0.1 to 192.168.0.255 is available for assignment in your subnet. Show Comments.
Most modems have a default ip of 192.168.100.1. However, if you look up your make and model (i.e. Linksys *********) with default ip in Google, you will find the answer. I have done this many, many times. Be careful about static ip addresses too. If that is setup, then Windows will give you a different number than the default.