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.
2. Say, I have a subnet of 255.255.255.242 and I have a known IP within that subnet say 192.168.1.101. Now the way I calculate the range of IPs is this: In the subnet mask, find the first octet that is not a 255. In my example, its the 4th octet, and its 242. So take 256 and subtract 242, which gives us 14. So we now know that these networks, the 192.168.1.x networks, all have a range of 14.