![In excel for mac how do i link a cell from one sheet to another sheet music In excel for mac how do i link a cell from one sheet to another sheet music](http://i.stack.imgur.com/wl8YW.png)
You've got data in one sheet in your spreadsheet, and want to use it in another sheet. You could copy it—but then, when you change the data in one sheet, you'll have to change it in the other sheet, too.
Select a cell in one sheet that you want to create a hyperlink to another sheet, and click Insert > Hyperlink. See screenshot: 2. In the Insert Hyperlink dialog box, please do as follows: (1) Click the Place in This Document button in the Link to box; (2) Select one sheet that you want to hyperlink to in the Or select a place in this document box.
There's a better option—link your spreadsheet cells to keep the same data in each place. Here's how in Google Sheets (and the same trick works in Excel, Numbers, Quip, and other popular spreadsheet apps):
Link Spreadsheet Cells with !
To reference a cell from one sheet in another, all you need to know is the sheet's name and the cell's name. Link them together with an exclamation mark.
Say your sheet's name is 'Names', and you need the data from cell B3. Just enter
=Names!B3
in any cell, and you'll get the data from that cell in your new sheet.Or, there's an easier option. Type
=
in your cell, then click the other sheet and select the cell you want, and press enter. That'll type the function for you.Now, if you change the data in the original
B3
cell in the Names
sheet, the data will update everywhere you've referenced that cell.Need to calculate values from that cell? Just type the rest of your function as normal. If
Names!B3
has the value 3
and you type =Names!B3*3
, you'll get the result 9
in your new cell as you'd expect.Connect Sheets in Different Spreadsheets
Have cells in two different spreadsheets that you want to link? The best option there is to use Zapier's Google Sheets workflows to link your sheets. Zapier can watch for new or updated data in your cell, and copy it over to your other spreadsheet to keep things up-to-date across spreadsheets and accounts.
Now, with your data linked, you'll save time without having to copy and paste data–and will be sure to always have the correct data in every sheet.
Learn more about Google Sheets in Zapier's free eBook, The Ultimate Guide to Google Sheets.
Have another question about Google Sheets or other apps? Ask the Zapier team
Published June 2, 2017
![Another Another](/uploads/1/2/5/8/125884293/954250677.png)
Question asked by Andrea
Answer written by Zapier writer Matthew Guay