Help with a quick formula?

[kmfletch]

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?

 

[Gord Dibben]

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