Hey Excel Pros,

Im having issues with my excel spreadsheet. I cant seem to find how to do what Im looking for.
Normally if i type "1" in A1, "2" in B1, and "3" in C1, grab all 3 boxes and then drag the corner, itll increment the numbers all the way down the column. Im trying to do that same thing with IP addresses but cant figure out how.

Im wanting to do a mixture of /22 /23 /24 and /25s.

What formula do i need to insert into A1 in order to do the following?

10.0.0.0/22 in A1
10.0.4.0/22 in B1
10.0.8.0/22 in C1
And when the corner dragged, it continues on in that fashion?

Also, the same for /25s, since thats going to affect the 3rd and 4th octets.

10.0.0.0/25 in A1


10.0.0.128/25 in B1
10.0.1.0/25 in C1
etc when dragged

Thanks in advance for the help and I look forward to hearing form you.