automatically adjust numbers in a column when data is deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numbers 1 through 17 in cells A264 to A281. I want to be able to
delete information in cell A266 and have the numbers adjust so that instead
of having to retype all of my numbers in again, Excel will automatically
adjust the numbers. Any suggestions?
 
On A264:

=1

On A265:

=OFFSET(A265,-1,0)+1

Fill Drag A265 to A281

Enjoy.

Hope this helps; if it does, rate my post.
 
Hi,

Enter the following formula in cell A265 and then copy it down

COUNT($a$264:a264)+1

Now if you delete any row in between, it will continue numbering from the
previous number ant not from one.

Regards,

Ashish Mathur
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT 3
delete numbers in each cell in same column 4
Hyperlink does not adjust or move as rows are added and deleted 2
Adjust the number of lines when pressing page down 5
how do I get a function formula cell to format as a number? 5
copy an exact formula without changing cell reference 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Enter a number on different cells automatically ? 3

Back
Top