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 two tabs in one spreadsheet in my Numbers for iPad. Is there a way I can transfer a value between those tabs?

share|improve this question
up vote 4 down vote accepted

There are two ways, depending on what you want to do.

If you just want to copy the current value or formula, make sure you are not in edit mode (i.e. there should be no keyboard or number pad visible). Click once on the cell you want to copy, pause so it doesn't think you are double tapping, and then tap again. A popover menu should appear. Click copy and then go to the other tab. Select the cell where you want to paste and repeat the "slow motion double tap." Then click paste.

If you want a cell to reference a cell from another tab you can do this to. Start by (quickly) double tapping the empty cell where you want the value from the other tab to appear. This should put you into edit mode. Push the equal sign button. Now navigate to the other tab and select the cell with the value you want to reference. Tap the cell once, and push the green check mark.

share|improve this answer
Awesome! Thanks! – Michiel Jan 27 '12 at 7:36

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.