Excel – IP Address Formula for ‘Auto fill’

KB ID 0000928 

Problem

I got asked this week if I know how to do this, a colleague was doing a spreadsheet, and needed to quickly put in IP addresses. The Problem is if you use ‘Auto Fill’ to continue your IP addresses, it does not behave quite like you would expect.

Solution

A quick search got me most of the way there, but the solution is different depending on which ‘octet’ of the IP address you want to increase.

So simply change the figures in red below, drop the formula into a cell on your spreadsheet then use the auto fill option.

Excel IP Addresses Increment the First Octet

[box]
=””&ROWS($A$1:A10)&”.1.1.0“[/box]

Excel IP Addresses Increment the Second Octet

[box] =”10.“&ROWS($A$1:A1)&”.1.1“[/box]

Excel IP Addresses Increment the Third Octet

[box] =”10.1.“&ROWS($A$1:A1)&”.1“[/box]

Excel IP Addresses Increment the Fourth Octet

[box] =”10.1.1.“&ROWS($A$1:A1)[/box]

 

 

Related Articles, References, Credits, or External Links

Excel: Calculate Cost, Margin, Sell Price

Excel – Creating a Dropdown Box ‘From data on another sheet’

Google Chrome – AutoFill stopped working

Enabling auto fill for web forms

KB ID 0000326

Problem

A recent update of Chrome (in my case to 6.0.472.59), turned off AutoFill, I use autofill to remember information for web forms a lot, so because I’m lazy I wanted it turned back on again.

Solution

1. From with Chrome, Click the “Spanner” / “Customise and Control Google Chrome” Icon > Options.

2. Select the “Personal Stuff” tab > Form autofill section > AutoFill options.

3. Tick “Enable AutoFill to fill in web forms with a single click” > Close > Close.

 

Related Articles, References, Credits, or External Links

NA