Using Excel to record IP address usage

By peter.stilgoe









Question: I was wondering if it was possible to have the left most pane (the ip address) fill down with addresses (adding 1 to the number above it) ie. 10.10.10.1, then below it 10.10.10.2. etc etc

Answer: Type in 10.10.10.1 in one row and 10.10.10.2 below it. Then select both and drag the black box in the bottom right corner down to continue it to complete your IP range.

Share


categoriaMisc commentoNo Comments dataMay 20th, 2008

About... peter.stilgoe

peter.stilgoeThis author published 482 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant









Share

FacebookTwitterEmailWindows LiveTechnoratiDeliciousDiggStumbleponMyspaceLikedin

No Comments

(Required)
(Required, will not be published)