Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a price list:


Is there a simple way to divide these cells by a number at once?

share|improve this question
up vote 2 down vote accepted

The "spreadsheet" way to do this is to do the division in another column.

Lets say your data is column A, starts a row 1 and goes to row 10 (that's A1:A10 in spreadsheet reference language).

In a unused column, row 1, you could enter:


And the copy and paste that formula from row 2 down to rows 2 through 10 in that column. Numbers will automatically increment the A1 reference in the pasted cells.

The divisor (10 in this case) can also be a reference if you like. Just make it a fixed reference so it doesn't automatically increment as you copy and paste. Lets say B1 holds the value you want to divide everything in column A by. You'd use:


as the formula and copy and paste. The $ in front of the column name and row number tell Numbers not to auto-adjust those values as you paste the formula around to different cells.

Here is an example Numbers '09 file.

Column A is data
Column B is A divided by 10
Column C is A divided by whatever value is in E2, change E2 and you'll see the values in Column C change.

share|improve this answer
Dear lan, can you please upload me an example file? – Adrian Jun 16 '11 at 17:48
@Adrian: I added an example file. I better not have just done your homework for you. – Ian C. Jun 16 '11 at 17:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.