Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Numbering
I need to automatically number rows in a spreadsheet. I've tried the ROW
function but unless I start at Row 1 and then need to remove a row in the middle of the spreadsheet I get a #REF error. How can I start row numbering in Cell A3 and if I need to delete a row somewhere in the spreadsheet have it automatically adjust? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Numbering
=ROW()-2 ?
Where does your #REF error come from? what formula were you using? -- David Biddulph "Richard" wrote in message ... I need to automatically number rows in a spreadsheet. I've tried the ROW function but unless I start at Row 1 and then need to remove a row in the middle of the spreadsheet I get a #REF error. How can I start row numbering in Cell A3 and if I need to delete a row somewhere in the spreadsheet have it automatically adjust? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Numbering
Use no reference in the function. In A3 enter:
=ROW()-2 and copy down -- Gary''s Student - gsnu200765 "Richard" wrote: I need to automatically number rows in a spreadsheet. I've tried the ROW function but unless I start at Row 1 and then need to remove a row in the middle of the spreadsheet I get a #REF error. How can I start row numbering in Cell A3 and if I need to delete a row somewhere in the spreadsheet have it automatically adjust? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Numbering
It worked....thanks to you both.
"Gary''s Student" wrote: Use no reference in the function. In A3 enter: =ROW()-2 and copy down -- Gary''s Student - gsnu200765 "Richard" wrote: I need to automatically number rows in a spreadsheet. I've tried the ROW function but unless I start at Row 1 and then need to remove a row in the middle of the spreadsheet I get a #REF error. How can I start row numbering in Cell A3 and if I need to delete a row somewhere in the spreadsheet have it automatically adjust? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Numbering | Excel Discussion (Misc queries) | |||
Auto-Numbering | Excel Worksheet Functions | |||
Auto Numbering | Excel Worksheet Functions | |||
Auto Numbering | Excel Worksheet Functions | |||
Auto Numbering | Excel Discussion (Misc queries) |