Author Topic: Excel/Numbers Mac query?  (Read 602 times)

slope

  • Ride Fettle Ride
    • Current pedalable joys
Excel/Numbers Mac query?
« on: February 27, 2019, 07:27:56 am »
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

  • The Codfather
  • Formerly known as Jaded
Re: Excel/Numbers Mac query?
« Reply #1 on: February 27, 2019, 07:59:51 am »
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.
If you don't like your democracy, vote against it.

citoyen

  • Cat 6 Racer
Re: Excel/Numbers Mac query?
« Reply #2 on: February 27, 2019, 08:00:39 am »
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

  • Ride Fettle Ride
    • Current pedalable joys
Re: Excel/Numbers Mac query?
« Reply #3 on: February 27, 2019, 08:20:22 am »
Brilliant, many thanks  :thumbsup: 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

  • I kid you not
    • Fuchsiaphile
Re: Excel/Numbers Mac query?
« Reply #4 on: March 01, 2019, 11:04:13 am »
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')
"This is a complex subject, with a need for more than one highlighter pen."

Jaded

  • The Codfather
  • Formerly known as Jaded
Re: Excel/Numbers Mac query?
« Reply #5 on: March 01, 2019, 11:13:42 am »
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.
If you don't like your democracy, vote against it.

Re: Excel/Numbers Mac query?
« Reply #6 on: March 01, 2019, 01:39:11 pm »
=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.
"Yes please" said Squirrel "biscuits are our favourite things."

Woofage

  • Ain't no hooves on my bike.
Re: Excel/Numbers Mac query?
« Reply #7 on: March 01, 2019, 01:46:46 pm »
=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  ;)
Pen Pusher