How do I change how the rows in Numbers are numbered. I want the title (Row 1) to be zero. I've not used Numbers much and I did search for info on this and found this link.
But I clearly don't understand it because I get a zero in A1. I want the numbering of the rows to go like so:
0
1
2
3
4
Does that link method work for anyone? If so can you explain it to me?
Thank you,
Susan!
iMac, macOS High Sierra (10.13.1), iphone 6, ipad, Apple TV new imac
You can't change the row numbers built into Numbers. But you can put numbers in the leftmost column starting with 0, using the formula
=ROW()-1
Entered in A1 and filled down the column.
SG
You can't change the row numbers built into Numbers. But you can put numbers in the leftmost column starting with 0, using the formula
=ROW()-1
Entered in A1 and filled down the column.
SG
You circled the row headers which are not mutable (changeable) by you. You can use a column to create a zero-based index using the method SGII suggested.
select cell A1, then type:
=row()-1
the function "row()" returns the row number for the row the formula is in
to fill down, select cell A1, copy
cells A1 thru the end of column A, paste
Start row with 0 in Numbers
