Numbers, Rows and Columns

rthurston77 · General User Joined: 17 Jun 2010 Posts: 8

Each spreadsheet labels a row 1, 2, 3 etc... column a, b, c etc... I need to in A5 start with #1 and then end in A30 with #26. When I insert or delete a row the numbers do not follow ... I have to manually adjust for correction.

Is there a way to avoid this?

Ed · Super User Joined: 28 May 2003 Posts: 1040

If you enter 1 in A5 and then enter "=OFFSET(A5;-1;0)+1" in A6 and fill down to A30 it should work when you delete rows, but obviously if you insert rows you will have to add the formula to the new rows you inserted.

PS - As I stated in this thread, which you replied to before you posted this, Math is the mathematical typesetting component, not the spreadsheet. Please post in the correct forum in future.

rthurston77 · General User Joined: 17 Jun 2010 Posts: 8

Okay ... How would I then print with the #'s already designated by the spreadsheet?

pitonyak · Posted: Thu Jun 17, 2010 11:10 am Post subject:

I am not aware of a function that returns the number of the current row or column... I can do this based on a reference to a cell, however, which is kind of what Ed is doing in his solution; how far am I from cell A5.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

rthurston77 · General User Joined: 17 Jun 2010 Posts: 8

This is the formula I got to work based on your response ... =OFFSET(A5;-1;0)+2

When I delete a row it deletes every 2nd row in the sequence.