Announcement

Collapse
No announcement yet.

Adding IP Address range within Excel

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Adding IP Address range within Excel

    Folks,

    I want to create a spreadsheet listing all our IP addresses on the network so I have a list of what static IP addresses I have and which are available for distribution.

    Anyone know a formula within Excel to list 10.1.1.1 - 10.1.1.255 without having to enter these manually

    Thanks

    Michael
    Michael Armstrong
    www.m80arm.co.uk
    MCITP: EA, MCTS, MCSE 2003, MCSA 2003: Messaging, CCA, VCP 3.5, 4, 5, VCAP5-DCD, VCAP5-DCA, ITIL, MCP, PGP Certified Technician

    ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

  • #2
    Re: Adding IP Address range within Excel

    If you insert the first number in the first box then drag from the bottom right hand corner down it will auto number for you.

    Comment


    • #3
      Re: Adding IP Address range within Excel

      Never knew that - It worked a treat

      Thanks

      Michael
      Michael Armstrong
      www.m80arm.co.uk
      MCITP: EA, MCTS, MCSE 2003, MCSA 2003: Messaging, CCA, VCP 3.5, 4, 5, VCAP5-DCD, VCAP5-DCA, ITIL, MCP, PGP Certified Technician

      ** Remember to give credit where credit is due and leave reputation points sigpic where appropriate **

      Comment

      Working...
      X