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

Thanks so much for your speedy response, Dave!

Dave Peterson wrote:
Maybe you can use a formula:

=row()
or
=row()-1
if your numbering starts in row 2.

Then just copy the formula down when you insert any new rows.

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

[quoted text clipped - 15 lines]

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 07:09 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"