Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Javster095
 
Posts: n/a
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.misc
paul
 
Posts: n/a
Default 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,

  #3   Report Post  
Posted to microsoft.public.excel.misc
rsenn
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Numbering Andy JL New Users to Excel 3 November 23rd 05 05:09 AM
Need Help with Excel page numbering uclabennett New Users to Excel 0 October 5th 05 04:55 PM
Page Numbering Pam Coleman Excel Discussion (Misc queries) 1 July 29th 05 08:44 PM
Numbering add in Paul Excel Discussion (Misc queries) 2 March 23rd 05 02:46 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"