Newsroom Update

The redesigned iPad Air and new iPad Pro with Apple silicon are now available. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I link to cells in other sheets?

I’m using Numbers for iOs. How can I get a cell in one sheet of a given spread sheet to reference the value of a cell in another sheet?


I am assuming both sheets are held within the same spread sheet.


In this case one sheet, Office, lists a series of expenses for my office. I want that total to be read by another sheet of expenses, Total Expenses, that takes the totals from other sheets, and summarizes the totals from other, more detailed lists.

iPad mini 4, iOS 10

Posted on Nov 16, 2019 12:12 PM

Reply
Question marked as Best reply

Posted on Nov 18, 2019 10:32 AM

Hi adam,

Tap your desination cell and then tap the keyboard icon.




Tap the circle with the = sign, then navigate to the cell you want the value of and tap.


You are done.


quinn



3 replies

How do I link to cells in other sheets?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.