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.
The IP address assigned to the host has a network ID part, which identifies what IP subnet that host is on. This is in the high-order bits of the IP address. How many high-order bits are allocated for this purpose is determined by the netmask. The remaining low-order bits of the IP address are the host ID. So, if your host's IP address is 1.2.3.4, and the netmask is 255.255.255.0, then the network ID part of that IP address is 1.2.3.0/24 (the /24 means that only the high-order 24 bits are significant) and the host ID part of that IP address is the remaining low-order byte .4.