Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 can just do B12 to reference a field on the same sheet I'm working on, but how do I reference B12 on another sheet?

share|improve this question

migrated from superuser.com Dec 14 '10 at 6:44

This question came from our site for computer enthusiasts and power users.

Try asking on webapps.stackexchange.com (or wait until this question is closed and migrated there) – Doug Harris Dec 13 '10 at 16:01
up vote 5 down vote accepted

It's the same way as Excel would -


If your sheet name contains spaces, wrap the name in single quotes.

='Sheet Name'!CellNumber
share|improve this answer
I'd select you as the answer, but it won't let me since I just created my account here.... – Webnet Dec 14 '10 at 19:28
@Webnet drop in here ( chat.stackexchange.com/rooms/7 ) & request @rchern for a merge in accounts :) – Sathya Dec 14 '10 at 20:06
What if there's a space in the sheet name? – Webnet Feb 22 '11 at 3:17
@Webnet wrap the name in single quotes. ='Sheet Name'!CellNumber – Sathya Feb 22 '11 at 4:28
What if I want to reference it by a formula? – kappa Dec 7 '12 at 9:32

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.