Share via

How do I link cells from one Excel worksheet to another?

Anonymous
2010-01-18T17:25:47+00:00

I want to link the totals of certain columns of several worksheets to a

summary worksheet in the same workbook.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2010-01-18T17:28:14+00:00

    Hi Niranjan

    Type an equals sign in the cell you want the information to end up in, left click over to another worksheet, and left click on the cell you want to reference and then press ENTER. 

    Excel will automatically enter it in.   You will see Excel will add (for example say your second sheet is named Sheet2) Sheet2! preceeding any cell references.  this need not necessarily be in the same workbook either.  You can link to other open workbooks in the same way.  The only extra thing to know about this is that you are creating an "link" to external data.  When you reopen the current workbook, if the workbook containing the source of the linked data is not already open, Excel will ask you if you want to update the linked data.

    400+ people found this answer helpful.
    0 comments

17 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-03T18:42:24+00:00

    Hi Niranjan

    Type an equals sign in the cell you want the information to end up in, left click over to another worksheet, and left click on the cell you want to reference and then press ENTER. 

    Excel will automatically enter it in.   You will see Excel will add (for example say your second sheet is named Sheet2) Sheet2! preceeding any cell references.  this need not necessarily be in the same workbook either.  You can link to other open workbooks in the same way.  The only extra thing to know about this is that you are creating an "link" to external data.  When you reopen the current workbook, if the workbook containing the source of the linked data is not already open, Excel will ask you if you want to update the linked data.

    Not working for me on the Mac. Sends me out of the workbook to a desktop file

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2017-11-15T15:38:54+00:00

    I am on a MacBook and having the same issue. Did you ever figure this out? I'm trying to make a budget sheet and want to link different months totals into one budget sheet. I've been trying unsuccessfully to figure this out. 

    Hello,

    Sorry for the delay. No, there is no resolve it is an issue with the software (one of many in Excel for Macbook- pivot tables, v look ups etc are all problematic and do not function the way it should and does for non apple products) in general and for the life of me, I can not believe that neither Microsoft or Apple will step up and fix or get involved and own this problem. I just can't believe that there are not more complaints. I guess it proves that the financial services community at large will not switch to apple products and good reason.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-11-10T02:26:19+00:00

    I am on a MacBook and having the same issue. Did you ever figure this out? I'm trying to make a budget sheet and want to link different months totals into one budget sheet. I've been trying unsuccessfully to figure this out.

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2017-09-15T17:21:36+00:00

    This is a very old thread that has already been answered. Perhaps start your question as a new one. I don't have a Mac so I don't think I can help you.

    1 person found this answer helpful.
    0 comments