9

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?

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

It's the same way as Excel would -

=SheetName!CellNumber

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

='Sheet Name'!CellNumber
  • 1
    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
  • 1
    @Webnet drop in here ( chat.stackexchange.com/rooms/7 ) & request @rchern for a merge in accounts :) – Sathyajith Bhat Dec 14 '10 at 20:06
  • 1
    What if there's a space in the sheet name? – Webnet Feb 22 '11 at 3:17
  • 1
    @Webnet wrap the name in single quotes. ='Sheet Name'!CellNumber – Sathyajith Bhat 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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