Jump to content

Self numbered rows


Recommended Posts

Self numbered rows

When you print a spreadsheet that has many rows of data, numbering the rows is one thing you can do to be a hero for that report's end users. Row numbers provide an easy point of reference for the people who read and discuss a report, but the question is, what's the best way to number rows?

Manually numbering rows is easy to do, but you'll have to repeat the process every time you insert or delete a row. Instead, use the ROW function to number rows automatically.

When you enter =ROW() in a cell, the function looks at the cell in which it's entered and returns the corresponding row number. You can copy that function to number all of your data rows. When you insert or delete a row, each instance of the ROW function is automatically updated. All you have to do is copy the function into any new rows you add.

There's one catch to numbering your rows using ROW: If you've entered at least one row of column labels, the ROW function will return the physical row number, not the actual row number of the data. To work around this, subtract the offset when you enter the ROW function for the first time. For instance, if your sheet contains one row of column labels, enter =ROW()-1.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...