Hi,
i am trying to write an excel sheet that will contain IP addresses. I
want the sheet to format so that I don't have to type in the address
in every box.

Example.

10.10.10.1
10.10.10.2
10.10.10.3
10.10.10.4

I have seen this before where someone put together a formula that they
either pasted in a ton of cells to fill the range in up to
10.10.10.254 or they just clicked on the next cell and the formula fit
in.

Can anyone help?

Enter the first number........10.10.10.1 in A1

Right-click on the fill handle of A1 and drag down as far as you wish.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Fri, 08 Jun 2007 21:31:06 -0000, wrote:

Hi,
i am trying to write an excel sheet that will contain IP addresses. I
want the sheet to format so that I don't have to type in the address
in every box.

Example.

10.10.10.1
10.10.10.2
10.10.10.3
10.10.10.4

I have seen this before where someone put together a formula that they
either pasted in a ton of cells to fill the range in up to
10.10.10.254 or they just clicked on the next cell and the formula fit
in.

Can anyone help?