ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   automatic row numbering that adjusts when adding or deleting rows (https://www.excelbanter.com/excel-discussion-misc-queries/220687-automatic-row-numbering-adjusts-when-adding-deleting-rows.html)

Sharon P

automatic row numbering that adjusts when adding or deleting rows
 
how can I make a table that automatically assigns a row number, and adjusts
the row number when I insert or delete rows? I want this information to
print on the worksheet.

Fred Smith[_4_]

automatic row numbering that adjusts when adding or deleting rows
 
You can put
=row()
in column A and copy down.

Regards,
Fred.

"Sharon P" <Sharon wrote in message
...
how can I make a table that automatically assigns a row number, and
adjusts
the row number when I insert or delete rows? I want this information to
print on the worksheet.




All times are GMT +1. The time now is 05:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com