IP address

[Muzio]

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

Thank you.
Cheers

 

[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

 

[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.

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

 

[Dave Peterson]

And if you really want hyperlinks, you could use:

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

 

[joeu2004]

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.

[....]
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)

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.

 

[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.

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

 

[Muzio]

Now all it is ok

Thanks