Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the number of the row
I want to the rows to start at 0 so I can have the default numbering match
the ip addresses of devices on my network Is this possible? Ultimately I want the top row to be just headings like " Device, Make/Model, Serial Number, etc. I just can't have it start at 1 because it takes my 192.168.1.1 address spot. So it doesn't have to be 0 for the first row, I'd settle for a blank row, but I don't think that's possible. Any help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the number of the row
You cannot re-number the rows.
You can simulate a re-numbering. In A1 enter =ROW()-1 and drag/copy down. Why do you have to have the row numbering changed to accommodate your IP addresses? Gord Dibben MS Excel MVP On Tue, 24 Jul 2007 10:40:00 -0700, Tim wrote: I want to the rows to start at 0 so I can have the default numbering match the ip addresses of devices on my network Is this possible? Ultimately I want the top row to be just headings like " Device, Make/Model, Serial Number, etc. I just can't have it start at 1 because it takes my 192.168.1.1 address spot. So it doesn't have to be 0 for the first row, I'd settle for a blank row, but I don't think that's possible. Any help is appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the number of the row
I don't have to I thought it would be more convenient. If you are mapping
your network and want to put headings at the top row. On the left side the numbers can increase with IP address. 1 = 192.168.1.1 2 = 192.168.1.2 .... but by adding headings it takes up row 1 thereby starting you at row 2 for the first IP which would be 192.168.1.1. It's purpose is to eliminate writing out all ip addresses. I can just skip the headings all together - the data that is populating it is pretty self explanatory or I could just stop looking for synergism between excel and my network map. Anyway you answered my question it is not possible although the simulation was helpful. Thank you. "Gord Dibben" wrote: You cannot re-number the rows. You can simulate a re-numbering. In A1 enter =ROW()-1 and drag/copy down. Why do you have to have the row numbering changed to accommodate your IP addresses? Gord Dibben MS Excel MVP On Tue, 24 Jul 2007 10:40:00 -0700, Tim wrote: I want to the rows to start at 0 so I can have the default numbering match the ip addresses of devices on my network Is this possible? Ultimately I want the top row to be just headings like " Device, Make/Model, Serial Number, etc. I just can't have it start at 1 because it takes my 192.168.1.1 address spot. So it doesn't have to be 0 for the first row, I'd settle for a blank row, but I don't think that's possible. Any help is appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing the number of the row
198.168.1.1 entered in any cell and dragged down will increment to
198.168.1.2 198.168.1.3 Gord On Tue, 24 Jul 2007 12:04:02 -0700, Tim wrote: I don't have to I thought it would be more convenient. If you are mapping your network and want to put headings at the top row. On the left side the numbers can increase with IP address. 1 = 192.168.1.1 2 = 192.168.1.2 ... but by adding headings it takes up row 1 thereby starting you at row 2 for the first IP which would be 192.168.1.1. It's purpose is to eliminate writing out all ip addresses. I can just skip the headings all together - the data that is populating it is pretty self explanatory or I could just stop looking for synergism between excel and my network map. Anyway you answered my question it is not possible although the simulation was helpful. Thank you. "Gord Dibben" wrote: You cannot re-number the rows. You can simulate a re-numbering. In A1 enter =ROW()-1 and drag/copy down. Why do you have to have the row numbering changed to accommodate your IP addresses? Gord Dibben MS Excel MVP On Tue, 24 Jul 2007 10:40:00 -0700, Tim wrote: I want to the rows to start at 0 so I can have the default numbering match the ip addresses of devices on my network Is this possible? Ultimately I want the top row to be just headings like " Device, Make/Model, Serial Number, etc. I just can't have it start at 1 because it takes my 192.168.1.1 address spot. So it doesn't have to be 0 for the first row, I'd settle for a blank row, but I don't think that's possible. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round number to the thousands without changing underlying number | Excel Discussion (Misc queries) | |||
Changing a Number to a Name | Excel Discussion (Misc queries) | |||
end number keeps changing to '0' | Excel Worksheet Functions | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
How do I display the number 007? It keeps changing to 7 | Excel Worksheet Functions |