LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Consecutive No'ing WHEN ADDING/DELETING ROWS

Got a spreadsheet that's consecutively numbered.
Need it to keep consecutively numbering as I add and/or delete rows

Example:

1 Blah-blah-blah
2 Blah-blah-blah
3 Blah-blah-blah
4 Blah-blah-blah
5 Blah-blah-blah

If I delete row 3, I need the numbering to continue consecutively -- as it
stands now, if I delete row 3, it will renumber "1, 2, 4, 5..."

Same thing if I add a row -- I need consecutive numbering to appear in the
new blank row (this sounds stupid/impossible even to me and I'm SO NOT an
Excel head)

Help!

 
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
Multiplying non consecutive rows, than adding it. RF Excel Discussion (Misc queries) 13 July 6th 07 02:32 PM
Multiplying non consecutive rows, then adding it. RF Excel Worksheet Functions 8 July 4th 07 10:46 PM
Adding and deleting rows with formulas ****Need Help**** [email protected] Excel Discussion (Misc queries) 5 May 31st 06 05:42 PM
Sequential number - adding and deleting rows Suzan Excel Discussion (Misc queries) 2 January 4th 06 09:36 PM
Disable Adding or Deleting Rows and Columns Playa Excel Discussion (Misc queries) 1 January 10th 05 10:23 PM


All times are GMT +1. The time now is 08:19 PM.

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

About Us

"It's about Microsoft Excel"