Excel/Numbers Mac query?

[slope]

Would be tremendously pleased and very grateful if anyone can help

How does one add incremental numbers 1 to 1000ish to a column of cells?

I want to number all the entries so - in Column A "Name" - see image below

[Jaded]

Excel
Type 1 in the first cell, then 2 in the second one.
Highlight both cells and drag the little corner down all the way to the bottom.

[citoyen]

Type the numbers manually into the first few cells in the range, select those filled cells, then drag the box in the bottom right corner of the selection to the end of the column.

This also works for interval numbering (eg type 3, 6, 9 in the first few boxes and it will complete the range in multiples of 3)

[slope]

Brilliant, many thanks  Much appreciated - would never have figured out how to find that info in the help menus

In Mac Numbers, one has to drag a wee yellow circle in the bottom centre of the cells.

[frankly frankie]

More ways to skin a cat.  If A1 = n, I set A2 to  =A1+1  then select down from there and use Ctrl-D ('fill down')

[Jaded]

More ways to skin a cat.  If A1 = n, I set A2 to  =A1+1  then select down from there and use Ctrl-D ('fill down')

If you are using the numbers to sort/resort the sheet that doesn’t work unless you select them all, copy and paste values. More steps to achieve the same.

[Greenbank]

=ROW()-n

(or equivalent)

Where n is the appropriate number given the row number of the first line, i.e. if you've got one row of headers then row 2 needs to be labelled as 1 so each cell would be:-

=ROW()-1

If the rows are moved around they'll still be in order.

[Woofage]

=ROW()-n

(or equivalent)

Where n is the appropriate number given the row number of the first line, i.e. if you've got one row of headers then row 2 needs to be labelled as 1 so each cell would be:-

=ROW()-1

If the rows are moved around they'll still be in order.

Neat. The inner geek in me likes that approach (it works in LibreOffice too).

However, it suffers the problem that Jaded mentioned above