ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Re numbering the row. (https://www.excelbanter.com/excel-discussion-misc-queries/63756-re-numbering-row.html)

Javster095

Re numbering the row.
 
Is there a way to re number a row, were row number 1 would move down to the
next row to row number 2. Row number 2 would be moved to row number 3 and so
for...

Thanks,

paul

Re numbering the row.
 
insert a new row at the top,or cut the whole sheet and paste one row down?
--
paul
remove nospam for email addy!



"Javster095" wrote:

Is there a way to re number a row, were row number 1 would move down to the
next row to row number 2. Row number 2 would be moved to row number 3 and so
for...

Thanks,


rsenn

Re numbering the row.
 

Your could use the ROW() function in each cell where you want row
numbers.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=499063



All times are GMT +1. The time now is 10:05 PM.

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