Arrow
Back to guides
Google Sheets Tips

How to Reference Another Sheet in Google Sheets

In this article, you will learn how to reference another worksheet in functions in Google Sheets. Learning this tip will help you to build up your Google Sheets effectively and efficiently for your purpose.

How to refer to another sheet in the functions

To refer to another worksheet in a formula, you can use the following format: 'Sheet Name'!Cell Reference. For example, if you wanted to reference cell A1 on a sheet called "Data" in a formula, you would use the following:

='Data'!A1

This tells the formula to look for the value in cell A1 on the sheet called "Data". Remember that sheet names containing spaces or special characters must be surrounded by single quotes (') in the formula.

If you want to refer to a range of cells on another sheet, you can use the same format, but include the range of cells you want to reference. For example, if you want to reference cells A1:B10 on the "Data" sheet, you would use the following:

='Data'!A1:B10

You can also use cell references in the formula to create a dynamic range that will automatically adjust if you add or remove data from the worksheet. For example, if you want to reference all of the cells in column A on the "Data" sheet, starting from cell A1, you could use the following formula:

='Data'!A1:A

This will include all the cells in column A, from A1 down to the last cell containing data.

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below