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.
To calculate the Network ID, you simply take any IP address within that subnet and run the AND operator on the subnet mask. Let's take an IP address of 10.20.237.15 and a subnet mask of 255.255.248.0. Note that this can be and often is written in shorthand as 10.20.237.15/21 because the subnet mask length is 21.Figure D and Figure E show the Decimal and Binary versions of the AND operation.n IP address is a unique identifier given to a single device on an IP network. The IP address consists of a 32-bit number that ranges from 0 to 4294967295. This means that theoretically, the Internet can contain approximately 4.3 billion unique objects.