Cross-reference sheets on Google Docs Spreadsheet

Question

I can just do B12 to refere a field on the same sheet I'm working on, but how do I reference B12 on another sheet?

Try asking on webapps.stackexchange.com (or wait until this question is closed and migrated there)

Sathya · Answer 1 · 2011-02-22 04:29:26Z

up vote 2 down vote accepted

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

answered Dec 13 '10 at 16:12

Sathya
4,697729

	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

feedback

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