Hi,
Im using excel 2007. I have a table that i was 1 column to autonumber down the left side, which if you insert a row rejigs the numbers accordingly.
Is this possible.
Many Thanks in advance.
Hi,
Im using excel 2007. I have a table that i was 1 column to autonumber down the left side, which if you insert a row rejigs the numbers accordingly.
Is this possible.
Many Thanks in advance.
If you want the number 1 to appear in the first row of the spreadsheet, =row() and copy down.
If you want 1 to appear on, say, row 5, then =row() - 4 and copy down.
This worked great, although its now extended further. When i inserted a row it automatically autonumbered. Great.. but i now need it to insert a letter next to the number. i.e...
rows 1-10 numbered 1-10. If i insert a row at line 5, i need it to call it row 4a then 4b etc.
Is this possible?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks