Numbering a spreadsheet

J

Joy

Hello Excel Experts! I have a spreadsheet that is numbered 1-105, but because of column headers the numbers in my spreadsheet do not coincide with the excel row numbers. Oftentimes, I have to delete rows, but I want the original numbering to stay intact. For example, today, if I delete the row I've numbered as 35, I have to go through and re-number rows 36-105. Is there anyway to avoid manually re-entering the information so that it automatically corrects itself when a row is deleted.
 
J

Jim

Look here:
http://j-walk.com/ss/excel/usertips/tip035.htm
--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Joy said:
Hello Excel Experts! I have a spreadsheet that is numbered 1-105, but
Click to expand...
because of column headers the numbers in my spreadsheet do not coincide with
the excel row numbers. Oftentimes, I have to delete rows, but I want the
original numbering to stay intact. For example, today, if I delete the row
I've numbered as 35, I have to go through and re-number rows 36-105. Is
there anyway to avoid manually re-entering the information so that it
automatically corrects itself when a row is deleted.
 
K

Ken Wright

In your first row of data, assuming it is in row 3, put =ROW()-2 and copy down.
That way when you delete a row it should be automatic. If it was row 4, then
=ROW()-3 and copy down, and so on.

Just to explain, on row 4, =ROW() would give you 4, so =ROW()-3 would give 1,
and when copied down you would get:-

5-3 = 2
6-3 = 3
7-3 = 4
etc

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------



Joy said:
Hello Excel Experts! I have a spreadsheet that is numbered 1-105, but because
Click to expand...
of column headers the numbers in my spreadsheet do not coincide with the excel
row numbers. Oftentimes, I have to delete rows, but I want the original
numbering to stay intact. For example, today, if I delete the row I've numbered
as 35, I have to go through and re-number rows 36-105. Is there anyway to avoid
manually re-entering the information so that it automatically corrects itself
when a row is deleted.
 
A

Anders S

Hi joy,

=ROW() returns the row number where =ROW() is entered.

If your numbering begins on row 1, just use =ROW(). If the numbering begins on, say row 15, use =ROW()-14.

HTH
Anders Silven
 
Top