IP address

M

Muzio

Hi,
how I can fill in columns the IP address from 192.168.1.1 to 192.168.1.254

Thank you.
Cheers
 
B

Biff

Enter 192.168.1.1 in your first cell (assume cell A1).

"Grab" the fill handle with the left mouse button and drag down to A254. The
fill handle is the little black square in the lower right of the selected
cell.

Biff
 
M

Muzio

Enter 192.168.1.1 in your first cell (assume cell A1).
"Grab" the fill handle with the left mouse button and drag down to A254. The
fill handle is the little black square in the lower right of the selected
cell.
Click to expand...

Thank you, but are you shure? I have tried withou any result.
It is ok if I want to fill from 192 to 234 but not in dot
format.(192.168.1.1 - 192.168.1.254)

Muzio
 
D

Dave Peterson

And if you really want hyperlinks, you could use:

=HYPERLINK("http:\\192.168.1."&ROW())
(In A1 and drag down)
 
J

joeu2004

Muzio said:
Enter 192.168.1.1 in your first cell (assume cell A1).
"Grab" the fill handle with the left mouse button and drag down to A254.
Click to expand...
[....]
Thank you, but are you shure? I have tried withou any result.
It is ok if I want to fill from 192 to 234 but not in dot
format.(192.168.1.1 - 192.168.1.254)
Click to expand...

Works for me.

What is the format of the initial cell? Mine is General.

Also, how do you enter the initial IP address? I simply typed
192.168.1.1. No initial equal sign ("="). No initial apostrophe (').

Finally, what version of Excel are you using? I am using Office Excel
2003.
 
M

Muzio

Enter 192.168.1.1 in your first cell (assume cell A1).
"Grab" the fill handle with the left mouse button and drag down to A254. The
fill handle is the little black square in the lower right of the selected
cell.
Click to expand...

Thank you, but are you shure? I have tried withou any result.
It is ok if I fill from 192 to 234 but not in dot
format.(192.168.1.1 - 192.168.1.254)

Muzio
 
Top