Home |
Search |
Today's Posts |
#1
|
|||
|
|||
line numbering
I've always made the row numbers formulae like this:
a) Put the number 1 in cell A1 b) Put the formula =a1+1 in cell A2 c) Copy cell A2 down as many rows as you need. d) Insert a row between two rows e) Copy the cell above the blank cell to the blank cell and the cell below the blank cell. "justamailman" wrote: Hi, is it possible to number my line in a way that if in the future I have to add someone in between the rest of the lines will renumber themselves automatically. It is for a mail run . We can do that with field in Word -- XP home , Office 97 any or all responses are gratefully accepted and thank you for your time Running Compaq P3, 500Mhz WIN XP home, Office 97 Dialup (no choice here) |
#2
|
|||
|
|||
thanks it is working fine for my application
"Significent" wrote: I've always made the row numbers formulae like this: a) Put the number 1 in cell A1 b) Put the formula =a1+1 in cell A2 c) Copy cell A2 down as many rows as you need. d) Insert a row between two rows e) Copy the cell above the blank cell to the blank cell and the cell below the blank cell. "justamailman" wrote: Hi, is it possible to number my line in a way that if in the future I have to add someone in between the rest of the lines will renumber themselves automatically. It is for a mail run . We can do that with field in Word -- XP home , Office 97 any or all responses are gratefully accepted and thank you for your time Running Compaq P3, 500Mhz WIN XP home, Office 97 Dialup (no choice here) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Macro - Skipping a line | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel |