Number Field

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

Guest

I want to number my rows. My table is names, addresses, tel numbers, etc. I
would not want the number to be tied to the row because I will be adding new
rows from time to time and the number field would have to adjust accordingly.
Is this possible in excel 2007. Thanks much.
 
Hi Bob,

=ROW() will return the row number.

You can manipulate it. Example =ROW()+5

Regards,

OssieMac
 
Hi Ossie Mac: I am new at excel. Could you explain more. I created a new
field and typed in =ROW( ). Thats not it. Thanks for any further help
 
Hi Bob:

In layman's terms (b/c I am not an expert), you can create a formula in your
first column. For example, if you would like your row numbering to start on
row 3, you would put a 1cell A3, and cell A4 would read =A3+1. Copy that
formula all the way down to your last row. When you add rows all you have to
do is drag the formula down over the new rows. Or an easier way to get your
formula to copy all the way down without dragging is hover your mouse pointer
over the lower right hand corner of cell A4 (be sure cell A4 has it's black
box around it) until you get a plus sign double click. That will send your
formula all the way down to the last row. Keep in mind if you add rows above
your first row, cells A3 always needs to have the 1.

A lot of words for an easy answer but I hope it helped.
 
Back
Top