LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suzan
 
Posts: n/a
Default Sequential number - adding and deleting rows

Is there a way to squentially number a column so that if you insert or delete
rows in the middle the numbers will readjust? if you use A1+1 and copy it
down, you get a #REF if you delete; and a blank cell if you don't (and then
you have to use the fill handle from above the blank cell to resequence?

Any assistance would be greatly appreciated.

Suzan
 
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
Row counter in formula jjpcpanama Excel Worksheet Functions 5 March 23rd 05 06:20 AM
Help - Automating a file.. Adding Users , Deleting users, Changing Tim Harding Excel Worksheet Functions 0 March 16th 05 01:25 PM
Disable Adding & Deleting Rows/Columns Playa Excel Discussion (Misc queries) 1 February 3rd 05 03:42 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:17 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"